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