Do data center regions offer redundancy using Master to Master mySQL?

January 21, 2016 846 views
DigitalOcean MySQL Scaling High Availability LAMP Stack Getting Started Ubuntu

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:

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.

2 Answers

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.


  • Great. I'll give it a shot with the two droplets. I'll make a test DB and see how it goes.

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.

Have another answer? Share your knowledge.