proxy with mysql-cluster

[Toru Inoko]

Hi all,

I use mysql-proxy with mysql-cluster as a load-balancer. there are 3 sqlnodes as backends on mysql-proxy.

When I reboot 2 nodes of sqlnodes, mysql-pxoxy doesn't allocate connection for 3 nodes(only 2 or 1 nodes).

Anyone knows this odd behavior?
Please help.

followings are mysql-proxy conf & log.

- mysql-proxy.cnf

[mysql-proxy]
daemon=true
pid-file = /var/run/mysql-proxy.pid
log-file = /var/log/mysql-proxy/mysql-proxy.log
log-level = debug
proxy-backend-addresses=192.168.128.35:3306,192.168.128.36:3306,192.168.128.37:3306
keepalive=true

- mysql-proxy.log

2012-04-17 18:01:48: (message) Initiating shutdown, requested from signal handler
2012-04-17 18:01:48: (message) shutting down normally, exit code is: 0
2012-04-17 18:01:48: (debug) chassis-unix-daemon.c:167: 3868 returned: 3868
2012-04-17 18:01:48: (message) chassis-unix-daemon.c:176: [angel] PID=3868 exited normally with exit-code = 0 (it used 2 kBytes max)
2012-04-17 18:01:48: (message) Initiating shutdown, requested from mysql-proxy-cli.c:604
2012-04-17 18:01:48: (message) shutting down normally, exit code is: 0
2012-04-17 18:01:49: (message) chassis-unix-daemon.c:136: [angel] we try to keep PID=4287 alive
2012-04-17 18:01:49: (debug) chassis-unix-daemon.c:157: waiting for 4287
2012-04-17 18:01:49: (debug) chassis-unix-daemon.c:121: we are the child: 4287
2012-04-17 18:01:49: (message) mysql-proxy 0.8.2 started
2012-04-17 18:01:49: (debug) max open file-descriptors = 1024
2012-04-17 18:01:49: (message) proxy listening on port :4040
2012-04-17 18:01:49: (message) added read/write backend: 192.168.128.35:3306
2012-04-17 18:01:49: (message) added read/write backend: 192.168.128.36:3306
2012-04-17 18:01:49: (message) added read/write backend: 192.168.128.37:3306
2012-04-17 18:04:39: (message) proxy-plugin.c.1508: connect(192.168.128.35:3306) failed: Connection refused. Retrying with different backend.
2012-04-17 18:04:44: (debug) network-backend.c.184: backend 192.168.128.35:3306 was down for more than 4 sec, waking it up
2012-04-17 18:07:39: (message) proxy-plugin.c.1508: connect(192.168.128.36:3306) failed: Connection refused. Retrying with different backend.
2012-04-17 18:08:09: (debug) network-backend.c.184: backend 192.168.128.36:3306 was down for more than 4 sec, waking it up
2012-04-17 18:10:22: (message) proxy-plugin.c.1508: connect(192.168.128.35:3306) failed: Connection refused. Retrying with different backend.
2012-04-17 18:10:22: (message) proxy-plugin.c.1508: connect(192.168.128.36:3306) failed: Connection refused. Retrying with different backend.
2012-04-17 18:10:39: (debug) network-backend.c.184: backend 192.168.128.35:3306 was down for more than 4 sec, waking it up
2012-04-17 18:10:39: (debug) network-backend.c.184: backend 192.168.128.36:3306 was down for more than 4 sec, waking it up