By michaelf
If I create two droplets, one in a New York data center and another in San Francisco and then create a Master to Master replication of a mySQL database (using this DO Community article: https://www.digitalocean.com/community/tutorials/how-to-set-up-mysql-master-master-replication) will that provide redundancy should one of the data center go down/offline? Or if my one droplet is down in NY the one in SanFran will also be down? I would think not, but would like confirmation.
I’m on a shared hosting plan now with another provider and need redundancy with my database.
I’m looking to use a fail over solution as explained in this article: http://www.howto-expert.com/how-to-create-a-server-failover-solution/
DO seems like a good option but want to make sure this is how it would function. Any other suggestions on how to make mySQL DB redundant? It’s not a large database but critical for my clients to have access.
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!
Hey there,
If you created a Master-Master replication across two datacenters and one datacenter went down, that would not affect the other droplet in the other datacenter. Using your example, if the NYC droplet went down, the SFO1 would continue to operate. In this scenario, you would just have to switch over to using the SFO1 droplet for your DB access.
–Andrew
Whilst this will work as you expect in terms of redundancy you have not taken into consideration the latency between the two DC’s. I’m not sure what the latency between the two of them but it could cause issues in a master-master config even with Semisynchronous Replication enabled and configured correctly. Just something to consider.
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.