MySQL Forums
Forum List  »  Router & Proxy

Re: Failover on Master-Master replication setup.
Posted by: Cory Meyer
Date: March 05, 2008 09:41AM

So far with my setup I've been having to configure fail-over within the application itself. Since these are low CPU applications with H-A requirements these are also the application servers.

I've been testing with mysql-proxy running on port 3306 and running the Mysql servers on port 3307. Mysql-Proxy removes the need for configuring application level fail-over.

My mysql-proxy configuration certainly follows the KISS requirements.

/usr/local/sbin/mysql-proxy --daemon \
--proxy-address=127.0.0.1:3306 \
--proxy-backend-addresses=mysql_primary:3307 \
--proxy-backend-addresses=mysql_secondary:3307

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Failover on Master-Master replication setup.
4185
March 05, 2008 09:41AM


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.