Comments on: Problems with MMM for MySQL https://shlomi-noach.github.io/blog/mysql/problems-with-mmm-for-mysql Blog by Shlomi Noach Mon, 13 Feb 2012 15:44:41 +0000 hourly 1 https://wordpress.org/?v=5.3.3 By: MySQL高可用性大杀器之MHA | OurMySQL | 我们致力于一个MySQL知识的分享网站 https://shlomi-noach.github.io/blog/mysql/problems-with-mmm-for-mysql/comment-page-1#comment-69773 Mon, 13 Feb 2012 15:44:41 +0000 https://shlomi-noach.github.io/blog/?p=3625#comment-69773 […] 提到MySQL高可用性，很多人会想到MySQL Cluster，亦或者Heartbeat+DRBD，不过这些方案的复杂性常常让人望而却步，与之相对，利用MySQL复制实现高可用性则显得容易很多，目前大致有MMM，PRM，MHA等方案可供选择：MMM是最常见的方案，可惜它问题太多（What’s wrong with MMM，Problems with MMM for MySQL）；至于PRM，它还是个新项目，暂时不推荐用于产品环境，不过作为Percona的作品，它值得期待；如此看来目前只能选MHA了，好在经过DeNA大规模的实践应用证明它是个靠谱的工具。 […]

]]> By: The State of High Availability | MySQL Fanboy https://shlomi-noach.github.io/blog/mysql/problems-with-mmm-for-mysql/comment-page-1#comment-67231 Wed, 25 Jan 2012 16:55:49 +0000 https://shlomi-noach.github.io/blog/?p=3625#comment-67231 […] Noach and Brian Aker have public discussed problems with MMM show just how hard this problem is. ( SH / BA ) Even Alexey Kovyrin said in a reply to Brian “…Every time I try to add HA to my […]

]]> By: MySQL高可用性大杀器之MHA-传播、沟通、分享-一直“有你” https://shlomi-noach.github.io/blog/mysql/problems-with-mmm-for-mysql/comment-page-1#comment-64236 Sun, 25 Dec 2011 06:14:12 +0000 https://shlomi-noach.github.io/blog/?p=3625#comment-64236 […] 提到MySQL高可用性，很多人会想到MySQL Cluster，亦或者Heartbeat+DRBD，不过这些方案的复杂性常常让人望而却步，与之相对，利用MySQL复制实现高可用性则显得容易很多，目前大致有MMM，PRM，MHA等方案可供选择：MMM是最常见的方案，可惜它问题太多（What’s wrong with MMM，Problems with MMM for MySQL）；至于PRM，它还是个新项目，暂时不推荐用于产品环境，不过作为Percona的作品，它值得期待；如此看来目前只能选MHA了，好在经过DeNA大规模的实践应用证明它是个靠谱的工具。 […]

]]> By: MySQL高可用性大杀器之MHA | 火丁笔记 https://shlomi-noach.github.io/blog/mysql/problems-with-mmm-for-mysql/comment-page-1#comment-63541 Mon, 19 Dec 2011 11:24:17 +0000 https://shlomi-noach.github.io/blog/?p=3625#comment-63541 […] 提到MySQL高可用性，很多人会想到MySQL Cluster，亦或者Heartbeat+DRBD，不过这些方案的复杂性常常让人望而却步，与之相对，利用MySQL复制实现高可用性则显得容易很多，目前大致有MMM，PRM，MHA等方案可供选择：MMM是最常见的方案，可惜它问题太多（What’s wrong with MMM，Problems with MMM for MySQL）；至于PRM，它还是个新项目，暂时不推荐用于产品环境，不过作为Percona的作品，它值得期待；如此看来目前只能选MHA了，好在经过DeNA大规模的实践应用证明它是个靠谱的工具。 […]

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/problems-with-mmm-for-mysql/comment-page-1#comment-39985 Tue, 17 May 2011 09:02:09 +0000 https://shlomi-noach.github.io/blog/?p=3625#comment-39985 @Steven,
I did not realize it was possible to use VIPs on amazon EC2; I thought it was not possible.

I haven’t used tungsten as yet (*ashamed*).

]]> By: Steven Roussey https://shlomi-noach.github.io/blog/mysql/problems-with-mmm-for-mysql/comment-page-1#comment-39980 Tue, 17 May 2011 07:03:31 +0000 https://shlomi-noach.github.io/blog/?p=3625#comment-39980 https://silverline.librato.com/blog/main/EC2_Users_Should_be_Cautious_When_Booting_Ubuntu_10_04_AMIs

I haven’t heard of many people using mmm on EC2, but just in case, they should look at the above link about process stalls. A mysql sever should have a different scheduler anyhow…

On another note, what is your experience with tungsten?

]]> By: Patrick https://shlomi-noach.github.io/blog/mysql/problems-with-mmm-for-mysql/comment-page-1#comment-39909 Mon, 16 May 2011 13:30:11 +0000 https://shlomi-noach.github.io/blog/?p=3625#comment-39909 Hi Shlomi,

Thank you for the information – MMM was on my To-Do list for evaluation.

Have spent the past week trying to get Pacemaker + Corosync configured to support a VIP in front of a Master/Master replication configuration. Works if one of the hosts goes down but can’t get it the VIP to swing if the “Active” Master MySQL db goes down.

Good luck with your testing of Pacemaker – and hope you will document your efforts 😉

Cheers
Patrick

]]> By: Cédric https://shlomi-noach.github.io/blog/mysql/problems-with-mmm-for-mysql/comment-page-1#comment-39904 Mon, 16 May 2011 12:25:45 +0000 https://shlomi-noach.github.io/blog/?p=3625#comment-39904 My own “french” experience about MMM : http://www.mysqlplus.fr/2011/03/pourquoi-mmm-ne-fait-pas-ce-que-jaimerais-quil-fasse/

]]> By: Log Buffer #220, A Carnival of the Vanities for DBAs | The Pythian Blog https://shlomi-noach.github.io/blog/mysql/problems-with-mmm-for-mysql/comment-page-1#comment-39891 Mon, 16 May 2011 09:11:57 +0000 https://shlomi-noach.github.io/blog/?p=3625#comment-39891 […] Shlomi Noach encountered troubling issues with MMM for MySQL deployments, leading me to the decision to cease using it on production, and hence blog about it. […]

]]> By: shlomi https://shlomi-noach.github.io/blog/mysql/problems-with-mmm-for-mysql/comment-page-1#comment-39887 Mon, 16 May 2011 07:32:51 +0000 https://shlomi-noach.github.io/blog/?p=3625#comment-39887 @Oli,
I’ll be testing Pacemaker in the next few weeks, with manual failover. I’ll let you know my conclusions.

I’ve had good customer experience with Heartbeat before.

]]>