ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0

asked 2015-10-24 04:47:29 -0600

mkrish004c gravatar image

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.

edit retag flag offensive close merge delete