Hello dear experts.
I’m new here (and new in general to MySQL), so please be gentle.
For testing purposes, I have setup a 3-Node XtraDB cluster in a lab environment using the documentation here. Everything is working great.
I then installed the application (in this case it is Zabbix) on all 3 nodes, and using Pacemaker+Corosync I set up a simple HA for the application (one node is active, two others are standby in case it fails).
I’m now missing the final step: I need to point my application to a database. Obviously I’m gonna need some sort of floating IP address that represents all 3 nodes, and some way to perform load-balancing. I’ve looked at several solutions for this, but I’ve only become more confused. What is the simplest way to achieve this, preferably one with a good step-by-step guide for the scared newbie?