Balance source wirh Galera Cluster

Help!
1

Hello,

In my configuration i have one apache server with galera that connect to 3 mariadb servers.

Please, with source as balance, it’s possible to use the 3 servers ?

If it yes, must i make another configuration ?

Thanks in advance.

2

Hi,

Yes, you can use TCP mode and source balance for MariaDB Galera.

Here is a basic example:

frontend listen_to_mariadb
bind IP:PORT
mode tcp
default_backend servers_of_mariadb

backend servers_of_mariadb
mode tcp
balance source
server galeracluster_server1 IP:PORT check
server galeracluster_server2 IP:PORT check
server galeracluster_server3 IP:PORT check

Add other health check methods and configurations as you need.