MySQL Forums
Forum List  »  Router & Proxy

ver 0.6.1 failover does not work
Posted by: Bernard T
Date: March 29, 2008 05:40AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
ver 0.6.1 failover does not work
10390
March 29, 2008 05:40AM
3883
April 20, 2008 09:09AM
3634
July 24, 2008 02:59AM
2985
January 08, 2009 12:12AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.