MySQL Forums :: MySQL Proxy :: Failover on Master-Master replication setup.
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
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
| Subject | Views | Written By | Posted |
|---|---|---|---|
| Failover on Master-Master replication setup. | 3223 | youngwoo kim | 02/21/2008 10:18AM |
| Re: Failover on Master-Master replication setup. | 3492 | 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.
© 2013, Oracle Corporation and/or its affiliates