I setup a cluster of 3 MariaDB servers in a multi-master setup which is working fine. I added a 4th server for HaProxy to load balance and round robin so that we can have a little redundancy which is also working, except for 1 issue.
I am logged into the MySQL client on the HaProxy server running the following query:
show variables like 'server_id';
I am getting the results, but if I wait for a period of 5 or more seconds and run the query again, i get the following error:
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 52
Current database: *** NONE ***
Right after that i get the result with a different server_id which indicates that the load balancing is working. The problem that this is causing is that when i try to connect from my Spring/Java app, I can run queries for that short period of time and the connection drops. I figure if I can solve it on the HaProxy server, that would solve the other issues that I am having.
EDIT: ADDED HAPROXY.CFG
log 127.0.0.1 local0 notice
timeout connect 3000
timeout server 5000
timeout client 5000
option mysql-check user haproxy_check
server mysql-1 192.168.10.241:3306 check inter 1000 rise 3 fall 1
server mysql-2 192.168.10.242:3306 check inter 1000 rise 3 fall 1
server mysql-3 192.168.10.243:3306 check inter 1000 rise 3 fall 1
stats uri /
stats realm Strictly\ Private
stats auth USER:PASSWORD