Skip navigation links

MySQL Forums :: Proxy :: Failover on Master-Master replication setup.


Advanced Search

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
Failover on Master-Master replication setup. 3364 youngwoo kim 02/21/2008 10:18AM
Re: Failover on Master-Master replication setup. 3871 Cory Meyer 03/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.