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.
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.