From: Andrew Moore Date: June 13 2011 9:33pm Subject: Re: Mysql Failover Recommendations List-Archive: http://lists.mysql.com/mysql/225243 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=20cf303dd2fa081dc904a59ead2a --20cf303dd2fa081dc904a59ead2a Content-Type: text/plain; charset=ISO-8859-1 On the contrary; people say less then good things about MMM even it's creator; http://openlife.cc/blogs/2011/may/different-ways-doing-ha-mysql http://www.xaprb.com/blog/2011/05/04/whats-wrong-with-mmm/ If you want to use master<->master replication consider that you're likely to have to manage failover manually. I utilise VIP relocation to avoid making app changes. You will also need to ensure what you have on each master is the right data. Maatkit tools will allow you to keep your tables sync'd so that should you need to perform a failover your data is consistent. As Johan mentions automatic failover can cause it's own issues. MySQL Proxy (if I'm not mistaken) remains in Alpha version so not always a great idea for a production system unless you're happy pulling Lua code apart? I have also seen MySQL 5.5's semi-synchronous replication used to get closer to a consistent dataset `out of the box`. It's a good solution but not without maintenance overhead. On Mon, Jun 13, 2011 at 10:16 PM, Johan De Meersman wrote: > > > ----- 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 > 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=eroomydna@stripped > > --20cf303dd2fa081dc904a59ead2a--