[best practice] Dedicated MySQL servers or managed database?
We’re using DigitalOcean for a couple of years now, running about 35 droplets and very happy with the results so far.
The ‘problem’ is that one of our SAAS products is growing very quickly and the software makes heavy use of MySQL. At first (2018) we installed a dedicated 8GB/4CPU MySQL server which functioned fine, but with heavy loads we decided last year to add 2 (read-only) slaves behind a load balancer. That was a big improvement, the software now does all SELECTS from the slaves and writes to the master. But a year later, the loads on the slaves are almost always above 2.0 and when there are a lot of customers online, you can notice it becomes slow.
I’ve been testing with managed databases, but our big concern; are the managed databases powerful (and scaleable) enough to make the switch? Or should we just resize the master to more CPU’s and add more slaves?
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.×