By whitwhoa
-
How is read scaling performed? For example if an existing architecture utilizes one master and two slaves for reads, how does this translate into an equivalent digital ocean managed mysql package?
-
Where are backup data stored? How do we access backups when necessary?
-
Are standby nodes geographically dispersed or hosted in the same datacenter as the primary nodes?
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!
Hello, @whitwhoa
I will recommend you to check their official documentation as you can answer more of your questions by checking it:
https://www.digitalocean.com/docs/databases/mysql/ https://www.digitalocean.com/community/tutorials/understanding-managed-databases
Regarding the backups you can also use automation for backups so this can be really handy. You can check this tutorial on how to restore a MySQL cluster from Backups:
https://www.digitalocean.com/docs/databases/mysql/how-to/restore-from-backups/
I hope this helps!
So I spun a few Managed databases (1/2/4 GB RAM) to run some tests in the context of Wordpress, and noticed that it is currently not possible for the user to tune MySQL performance by changing various cache sizes to fit the workload.
Support has kindly said that they could make some of these changes upon request but that would make the iteration cycles VERY SLOW if we have to go to them every time we want to try a new setting.
Ideally, we would be able to have access to key elements of the configurations either from the GUI, or from a command-line.
Even if I over-provision a relative large Managed DB (4GB RAM), things like innodb_buffer_pool_size seems to remain at 16MB by default, and not accessible for tweaking.
Finally, when running load tests, the current insights are a good start, but still very vague when compared to AWS RDS Insights.
Hope this can evolve soon, but without solid options to tune performance, we’re not ready to use it. Love the concept, but it needs a few more things.
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and AI-native businesses
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.