ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0
My Haproxy conf file,
global
log 127.0.0.1 local0
log 127.0.0.1 local1 notice
chroot /var/lib/haproxy
daemon
group haproxy
maxconn 4000
pidfile /var/run/haproxy.pid
user haproxy
defaults
log global
maxconn 4000
option redispatch
retries 3
option redispatch
mode http
#option tcplog
option dontlognull
timeout http-request 10s
timeout queue 1m
timeout connect 1000s
timeout client 10m
timeout server 10m
timeout check 100s
listen galera-cluster 192.168.1.11:3306
#bind 192.168.1.11:3306
balance roundrobin
mode tcp
option tcpka
option httpchk mysql-check user haproxy
server master 192.168.1.8:3306 check port 9200 inter 2000 rise 2 fall 5
server slave1 192.168.1.9:3306 backup check port 9200 inter 2000 rise 2 fall 5
server slave2 192.168.1.10:3306 backup check port 9200 inter 2000 rise 2 fall 5
I am able to connect my DB from other nodes as well as from haproxy node but not able to connect via my VIP.
ubuntu@haproxy:~$ mysql -h 192.168.1.8 -P 3306 -u root -proot
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 30
ubuntu@haproxy:~$ mysql -h 192.168.1.9 -P 3306 -u root -proot
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 30
ubuntu@haproxy:~$ mysql -h 192.168.1.10 -P 3306 -u root -proot
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 30
ubuntu@haproxy:~$ mysql -h 192.168.1.11 -P 3306 -u root -proot
ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0
- the port is active listening at 3306 from all nodes.
- privileges has been given for the DB to access using haproxy,
- port 9200 is been added in all node /etc/ssh/sshd_config file,
- mysqld:ALL has been appended in all node /etc/hosts.allow files.
Need help to find the root cause. Thanks for all your brain in advance.