MySQL Forums
Forum List  »  Router & Proxy

Stateful Failover possible?
Posted by: Pascal Baumgartner
Date: April 21, 2011 04:13AM

I'm currently testing the 0.8.1 version of mysql-proxy and I ask myself whether it's possible to configure stateful failover with mysql-proxy. I have two mySQL DB's with Master2Master Replication and I need stateful failover for this.

Is it possible to get stateful failover with mysql-proxy alone or do I need additional tools?

If it is possible, how should I do it?

So far when I run mysqlslap for testing the failover mechanism, and then I stop one mySQL instance, I always get the following error: ERROR : Lost connection to MySQL server during query. With stateful failover the query should just continue as nothing ever happened.

Any help appreciated.

Options: ReplyQuote

Written By
Stateful Failover possible?
April 21, 2011 04:13AM

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.