Hi,
We are running mysql-proxy version 0.6.1 on 3 CentOS 5.0 machines.
/usr/local/sbin/mysql-proxy --proxy-backend-addresses=192.168.10.140:3306 --proxy-backend-addresses=192.168.10.139:3306
When we stop the mysqld on 140, the proxy prompts
network-mysqld-proxy.c.3709: connect(192.168.10.140:3306) failed: Connection refused
and we are unable to continue to access the actual mysqld running on 139
This behaviour is different for mysql-proxy 0.5, it works as shown in
http://forge.mysql.com/wiki/MySQL_Proxy#Load_Balancing_.26_Failover
the following msg was shown instead
network-mysqld.c.367: connect(192.168.10.140:3306) failed: Connection refused
network-mysqld-proxy.c.2405: connecting to backend (192.168.10.140:3306) failed, marking it as down for ...
Is there anyone who experience the same issue and whether ver 0.6.1 does the failover differently, if so could you share with us how to oversome this issue?
Best Regards