The above was due to hardware changes for the site. I migrated to:

- 10th gen CPU, i9-10900X
- 128GB memory
- 8TB NVMe drive

As I mentioned many pages back as something I wanted to do... I left Google Cloud Compute and reverted back to something far simpler. Instead of a triple node MariaDB Galera replication system, with multiple physical nodes for the application servers, I reverted back to something that served us well for years. A single node setup.

Just like trading, you have to always be learning. The reason I went with GCP in the first place was because of rolling hardware upgrades and reliability, both having been the weak point of our old setup (aging hardware).

However, that aging hardware was mostly because we owned it and we co-lo'd into a datacenter. If I didn't own the hardware, I would have been more willing to ditch it earlier and upgrade in between Intel release cycles.

But GCP added complexity that proved to not solve problems for us, but create them, and it was also noticeably slower due to optimization for mutli-core deployments but at slower clock rates.

So I searched and found a high-clock rate replacement better suited for our workload. Less cores, but higher clock. I went with an i9-10900X for its stability, in a server class motherboard. Sure, we give up ECC ram but my experience tells me it's not important in real-world, where higher clock certainly is.

I also upgraded to an 8TB NVMe, specifically the HGST SN200. It can do 1.2M IOPS and 6GB/sec transfer, a significant improvement over anything we've had before.

When you look at our biggest threads, like the SP500 Spoonalysis thread, it was taking 2.5-3.0 seconds to load per page on the GCP hardware. Now we are down to less than 1 second, a massive improvement.

You should also see similar performance gains when creating a new post, as that was one of the slower aspects of the old system as well. The current bottleneck in that regard is related to the number of Followers in the thread, as notifications are processed in real-time when you submit the post (architecture of vb 3.8).

Since we gave up triple node redundancy with Galera, I am instead doing real-time hot backups of the databases using mydumper, combined with real-time file system sync using lsyncd. We have a much smaller backup node on a private VLAN at the same datacenter, to hold our backups and with the ability to step in at any time to replace the master in an emergency.

Anyway, having moved to Dockerized containers a while back, there is no real issue migrating from one host to another any longer. But please do report any problems, nonetheless.

Mike

Yep, there seems to be a problem with some of the downloads

Alright, I've duplicated the problem. Let me see what is causing it...

Mike

Hello i'm new user from Barcelona..i trade futures on NT8..some good idea,indicators,strategy qnd VPS..i need some help..Thanks EveryBody.

Alright, should be solved @xplorer and @evevee please confirm.

I can download, but there is nothing being replayed. Time progresses with no data.

Branderton, I had read this and meant to ask: did you solve this problem?