Skip navigation links

MySQL Forums :: Proxy :: ver 0.6.1 failover does not work


Advanced Search

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 8190 Bernard T 03/29/2008 05:40AM
Re: ver 0.6.1 failover does not work 3540 Jason Madar 04/04/2008 05:41PM
Re: ver 0.6.1 failover does not work 3571 Matthew Boehm 04/07/2008 02:53PM
Re: ver 0.6.1 failover does not work 3478 Maxim Volkov 04/10/2008 07:20AM
Re: ver 0.6.1 failover does not work 3358 Matthias Kellermann 04/14/2008 07:17AM
Re: ver 0.6.1 failover does not work 3261 Paul Freeman 06/04/2008 02:48AM
Re: ver 0.6.1 failover does not work 3345 Cong Liu 04/20/2008 09:09AM
Re: ver 0.6.1 failover does not work 3266 frederic sidler 05/19/2008 09:40AM
Re: ver 0.6.1 failover does not work 3214 frederic sidler 05/19/2008 09:42AM
Re: ver 0.6.1 failover does not work 3091 Sam Morrison 06/12/2008 11:11PM
Re: ver 0.6.1 failover does not work 2990 manish prajapati 07/22/2008 06:49AM
Re: ver 0.6.1 failover does not work 3055 Liu Lizhi 07/24/2008 02:59AM
Re: ver 0.6.1 failover does not work 2476 ren jw 01/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.