Do data center regions offer redundancy using Master to Master mySQL?
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.