June 18, 2013

Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker

… 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… conflicts All slaves are in read_only mode Simple administrative commands can remove master role from a node Pacemaker stonith devices…

Post: Using MMM to ALTER huge tables

… 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…: load the sql scripts $ mysql -u root db < changes.sql At this step we load sql commands from changes.sql though of…

Post: MySQL Master-Master replication manager released

…-passive mode) is popular pattern used by many companies using MySQL for scale out. Most of the companies would have some… it will not. MMM will detect this situation and will hold the server for administrator to decide. One command LVM based sync… your feedback and suggestions. You can learn some more about MMM here, download the tool here and have your questions answered…

Post: When should you store serialized objects in the database?

…explaining how they changed from storing data in MySQL columns to serializing data and just storing it… pro for this technique is that ALTER TABLE commands are no longer required. Until 5.1-plugin…able to emulate online index adds. Projects like MMM and Flipper make this even easier. In Friendfeed…