June 19, 2013

Post: Using MMM to ALTER huge tables

… step. If this happens, you’ll have to clone db2 from current db1 (mmm_clone), fix the application and start from the beginning…. If mmm_clone is configured to do mysql snapshots, this could be a better way to achieve the same: Alternative 6. Clone db1 from db2 On db1 execute: $ mmm_clone –host db2 –clone-mode master-master There are several different methods to clone a master…

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

… our replication tests and offered a behavior pretty similar to MMM regarding Virtual IP addresses, VIPs, management. We decided to call…_mysql \ meta master-max=”1″ master-node-max=”1″ clone-max=”3″ clone-node-max=”1″ notify=”true” globally-unique=”false” target… and slaves. The only thing that may change here is clone-max=”3″ which should match the number of database nodes…

Post: Master-Master or Master with Many Slaves

… becomes important. More time to clone If replication breaks you may need more time to re-clone it (or restore database from… all data on the same server. The customer for which MMM cluster was implemented has about 600GB per node and some other installations have similar sizes. MMM Cluster support Master with multiple slaves configuration as well, this…

Post: MySQL Master-Master replication manager released

… internal scripts to handle things as automatic fallback and slave cloning but no Open Source solution was made available. Few months… restoring broken replication safe way becomes very easy. Besides simple “cloning” of the nodes you can use same tool to create… your feedback and suggestions. You can learn some more about MMM here, download the tool here and have your questions answered…

Post: MongoDB Approach to database synchronization

… those changes on slaves and hope it works out), re-clone it from the slave or use mk-table-checksum to… to MySQL Replication, possibly with help of some tools like MMM. Row level Replication makes it possible to identify the objects…