VIP for XtraDB Cluster

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

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?

Thanks!

2

Take a look at maxscale: [url]https://mariadb.com/products/mariadb-maxscale[/url]
Dead simple to setup: [url]https://severalnines.com/blog/deploy-and-configure-maxscale-sql-load-balancing[/url]

3

MaxScale looks great, but I’m not seeing anything there about creation of a floating IP…

4

I haven’t really tested this setup but this looks promising:
[url]https://mariadb.com/resources/blog/how-make-maxscale-high-available-corosyncpacemaker[/url]

5

Maybe you can use keepalived to
have a floating IP.
[url]https://www.percona.com/blog/2013/10/15/using-keepalived-ha-top-percona-xtradb-cluster/[/url]