Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

I have seen two causes for this error in your setup.

  1. Please comment out the "bind-address" statment in your my.cnf configs for your mariadb servers and restart them (one at a time, wait for them to rejoin the cluster)

  2. In HAproxy, you need to use a special options to allow haproxy to mark the server as up. A standard tcpchk will not work for an extended period of time for a number of reasons.

option mysql-check user haproxy" to the haproxy config. Don't use httpchk. tcpka is ok. Feb 21 '14 commented answer HA MySQL Galera -- Keystone failed to connect

I had "Lost connection to MySQL server at 'reading initial communication packet" due to the

I have seen two causes for this error in your setup.

  1. Please comment out the "bind-address" statment in your my.cnf configs for your mariadb servers and restart them (one at a time, wait for them to rejoin the cluster)

  2. In HAproxy, you need to use a special options to allow haproxy to mark the server as up. A standard tcpchk will not work for an extended period of time for a number of reasons.

option mysql-check user haproxy" to the haproxy config. Don't use httpchk. tcpka is ok. Feb 21 '14 commented answer HA MySQL Galera -- Keystone failed to connect

I had "Lost connection to MySQL server at 'reading initial communication packet" due to the

I have seen two causes for this error in your setup.

  1. Please comment out the "bind-address" statment in your my.cnf configs for your mariadb servers and restart them (one at a time, wait for them to rejoin the cluster)

  2. In HAproxy, you need to use a special options to allow haproxy to mark the server as up. A standard tcpchk will not work for an extended period of time for a number of reasons. reasons.

    a. Create an "haproxy" user in your database, no password. You can lock down its permissions later.

    b. Add "option mysql-check user haproxy" to your haproxy.cfg under your Maria/Galera section

    c. Restart Haproxy

That should solve your issue. A quick telnet to your virtual ip address should show you that it is working.