On Tue, Sep 16, 2014 at 3:52 PM, Hoggins! <fucks...@wheres5.com> wrote: > Wow. First post, first mistake, I hit the button twice after having > corrected. > Sorry, *this* is the current config I have problems with. > > Le 16/09/2014 15:48, Hoggins! a écrit : >> Hello list, >> >> This is my first post. I checked a bit online to find a solution to my >> problem, but it seems that not many people are having the same issues. >> >> I use a very simple loadbalancing between two synchronized (Galera) >> MariaDB nodes. Here is the HAProxy config file : >> >> >> -------- SNIP ----------- >> global >> log 127.0.0.1 local0 notice >> user haproxy >> group haproxy >> >> defaults >> log global >> retries 3 >> option dontlognull >> option redispatch >> maxconn 1024 >> timeout connect 5000 >> timeout server 50000 >> timeout client 50000 >> >> listen mysql-cluster >> bind 127.0.0.1:3306 >> mode tcp >> option tcpka >> option mysql-check user haproxy_check >> balance roundrobin >> server db-1 db-1.network.hoggins.fr:3306 check >> server db-2 db-2.network.hoggins.fr:3306 check >> >> listen httpstats >> bind 127.0.0.1:8080 >> mode http >> stats enable >> stats uri / >> >> ------------------------------- >> >> When I connect to HAProxy as a MySQL host, and perform a simple request, >> everything is fine : >> >> MariaDB [(none)]> show variables like '%wsrep_node_name%'; >> +-----------------+-------+ >> | Variable_name | Value | >> +-----------------+-------+ >> | wsrep_node_name | db1 | >> +-----------------+-------+ >> 1 row in set (0.00 sec) >> >> If I issue the same command after a few seconds, here is what I get : >> >> MariaDB [(none)]> show variables like '%wsrep_node_name%'; >> ERROR 2006 (HY000): MySQL server has gone away >> No connection. Trying to reconnect... >> Connection id: 743181 >> Current database: *** NONE *** >> >> +-----------------+-------+ >> | Variable_name | Value | >> +-----------------+-------+ >> | wsrep_node_name | db1 | >> +-----------------+-------+ >> 1 row in set (0.00 sec) >> >> Does it have something to do with my MariaDB setup ? Connecting directly >> to any of my nodes is normal, I can stay "connected" as long as I wish >> without having the "MySQL server has gone away" message. >> >> >> >> If someone has a lead to a solution... >> >> Thanks in advance ! >> >> >> > >
Hi, Are you able to reproduce the behavior in a test environment? If so, please turn log level to 'info' then report here the logs of the sequence you ran above. Baptiste