High availability MySQL with two droplets

February 3, 2016 720 views
MySQL Networking

I have three droplets:

  • droplet A (main application)
  • droplet B (database)
  • droplet C (database)

Droplet B and C they are replication mode master/master, that way I can read/write in both databases. I use this tutorial with some adjustments (MySQL in place of Nginx) to check if my MySQL this healthy and thus assign a floating IP.

This works, but requires me to have a floating IP and expose the database server on the Internet, also will increase latency connection to the database. Is there any way to have the same result but use the private local network?

1 comment
  • Pardon my ignorance, but doesn't applying the 'change master' command allow you to use your private network IP addresses of your db droplets instead of the floating IP address or FQDN?

Be the first one to answer this question.