Hi list,
I'm trying to installing HAProxy for make load balancing between
several MySQL Nodes in a MySQL Cluster.
I've configured the haproxy.conf like this:
listen mysql 0.0.0.0:3306
mode tcp
balance roundrobin
maxconn 4096
server mysqlnode1 192.168.1.1 check weight 50
server mysqlnode2 192.168.1.2 check weight 50
The problem comes when I try to make a request to the haproxy:
mysql -uuser -ppass -h 192.168.1.3 test -e "select * from test1;"
It works well but if I reboot the service (haproxy) the request
doesn't work; I obtain the next error:
"Host is blocked because of many connection errors"
However if I make the same request but for the mysqlnode1 directly, it
works well. I must reboot the mysql service in both host to be solved.
It seems that the haproxy doesn't relay correctly the request to the servers.
Maybe I forgot another option in the haproxy.conf? Has anyone
configured haproxy for balancing several mysql servers?
Thanks,
David
