High availability MySQL with two droplets
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?