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?
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
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.
Join our DigitalOcean community of over a million developers for free! Get help and share knowledge in Q&A, subscribe to topics of interest, and get courses and tools that will help you grow as a developer and scale your project or business.
Click below to sign up and get $200 of credit to try our products over 60 days!