Mysql Failover Recommendations
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 been able to find a cookbook recipe to simply pick the closest server and fail over to the next server if the first one dies. I think I'm missing something. Ha Proxy http://haproxy.1wt.eu/#fiab Seems like much more than I need... Pen http://siag.nu/pen/ This one might be too http-centric. Would it work for Mysql? Any comments/pointers would be most appreciated. -- Take care and have fun, Mike Diehl. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Mysql Failover Recommendations
- Original Message - From: Mike Diehl mdi...@diehlnet.com 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 failover of MySQL servers to be a thoroughly bad idea. Stick to manual failover, regardless of what mechanism you implement. If you absolutely must go automatic, be damn sure the supposedly failed node is dead and buried before switching - kill it yourself if you have to (think IP-enabled power switches). MySQL Proxy http://forge.mysql.com/wiki/MySQL_Proxy I've seen many people rave, but my experience is close to yours: if you want something, figure it out yourself. Ha Proxy http://haproxy.1wt.eu/#fiab Works very well as a general solution, but may be a bit of overkill. Have a look at Ultramonkey for good documentation and setups. Pen http://siag.nu/pen/ Unknown to me. People also rave about MMM, haven't much looked at it, yet. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Mysql Failover Recommendations
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 another remote server. My system isn't under heavy load, but it simply can not be down... if at all possible. That said, Mysql Proxy and HA Proxy seem to be the front-runners. Any additional comments are certainly welcome. Mike. On Monday 13 June 2011 3:16:26 pm Johan De Meersman wrote: - Original Message - From: Mike Diehl mdi...@diehlnet.com 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 failover of MySQL servers to be a thoroughly bad idea. Stick to manual failover, regardless of what mechanism you implement. If you absolutely must go automatic, be damn sure the supposedly failed node is dead and buried before switching - kill it yourself if you have to (think IP-enabled power switches). MySQL Proxy http://forge.mysql.com/wiki/MySQL_Proxy I've seen many people rave, but my experience is close to yours: if you want something, figure it out yourself. Ha Proxy http://haproxy.1wt.eu/#fiab Works very well as a general solution, but may be a bit of overkill. Have a look at Ultramonkey for good documentation and setups. Pen http://siag.nu/pen/ Unknown to me. People also rave about MMM, haven't much looked at it, yet. -- Take care and have fun, Mike Diehl. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org