Re: Mysql Failover Recommendations

2011-06-13 Thread Mike Diehl
I received a recommendation to look at MySQL-MMM http://mysql-mmm.org/. However, my two servers are in different parts of the country, so I can't use any IP-based fail over solution. I truly need a proxy that listens on 127.0.0.1 and forwards to either the "local" server, of if needed, to anot

Re: Mysql Failover Recommendations

2011-06-13 Thread Johan De Meersman
- Original Message - > From: "Mike Diehl" > > I'm about to set master-master replication and would like to get > recommendations as to the best method for getting my applications to > failover when needed. I should already be in bed, but as a very brief reply: I find automatic failove

Mysql Failover Recommendations

2011-06-13 Thread Mike Diehl
Hi all, I'm about to set master-master replication and would like to get recommendations as to the best method for getting my applications to failover when needed. Here are my options, so far: MySQL Proxy http://forge.mysql.com/wiki/MySQL_Proxy This seems like the obvious choice, but I've not