Load balance and fail over for MySQL droplets
I'm looking for recommendations on how I could load balance two MySQL droplets. I have multiple droplets that will connect to these two droplets and there may be more than two eventually. Data replication is already setup but I'm unsure of how I could get my droplets to send the load between the two and have fail over. By the way, I'm using the Percona XtraDB Cluster. Thanks for any help.