… issues with MMM has grown to a level where we started looking at other ways of achieving higher availability using MySQL replication. One of the weakness of MMM is its communication layer, so instead of… existing MySQL Pacemaker resource agent in a way that it survived our replication tests and offered a behavior pretty similar to MMM…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
Post: Keep your MySQL backend online no matter what + TGIF Contest!
October 7, 2011 By 2 Comments
…. 25th I will be presenting my conference session “Keep your MySQL backend online no matter what” at the Percona Live London Conference. Considering their is a variety of highly knowledgeable MySQL experts speaking at this event I wanted to give my… of different technologies working together. This architecture is built on MMM, HeartBeat, LVS, ldirectord and some custom scripts. As a real…
Post: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
… type, converting data to different character set – MySQL master-master replication especially accompanied by MMM can be very handy to do the… our MySQL support customers as they were upgrading their application and mysql schema. We deployed and used MySQL Master-Master replication manager (MMM) ever…
Post: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
…, MMM. With MMM, you need to add a separate server, the Manager that, like the name imply, manages the availability of the MySQL service. A high availability solution based on MMM requires at the 2 MySQL servers configured in a Master to Master topology. Additional slaves can also be added. A MMM agent runs on all the MySQL…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
… table below. Expertise level MySQL replication Typical, average MySQL DBA + some Sysadmin skills Master-Master with MMM manager Good, average MySQL DBA + good Sysadmin skills Heartbeat/SAN (depends on SAN) High, Good MySQL DBA + strong Sysadmin…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
… and this method won’t work. Example on MMM: 1. check the mmm mode and put it to passive to disable any… the passive master (get position from show master status\G on mysql 4) Illustration of the recommended solution : Server 1 is the… wrong server-id are performed on the two slaves (mysql 3 and mysql 4) and the new events (with server-id 1…
Post: MySQL Master-Master replication manager released
April 5, 2007 By 27 Comments
…-passive mode) is popular pattern used by many companies using MySQL for scale out. Most of the companies would have some… an errors but for some query pattern it will not. MMM will detect this situation and will hold the server for… your feedback and suggestions. You can learn some more about MMM here, download the tool here and have your questions answered…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… managing a lot of relatively small MySQL installations or managed hosting provider. For large MySQL web MySQL installations using Sharding or replication IO… premium anyway. Yet another approach is to use MySQL replication with something as MMM or Flipper. I think this actually works best for most cases (unless async nature of MySQL replication is…
Post: MongoDB Approach to database synchronization
April 30, 2010 By 5 Comments
… problem and how MongoDB solves it. If you’re using MySQL Replication when your master goes down it is possible for… to be inconsistent with data on the new Master. In MySQL world we can chose to either ignore this problem (or… to apply the same concept to MySQL Replication, possibly with help of some tools like MMM. Row level Replication makes it possible…
Post: Three key things to know about moving MySQL into the cloud.
July 13, 2009 By 11 Comments
… are no Virtual IP addresses. Most High Availability tools (like MMM or DRBD+Heartbeat) work on the principal of having a…
