… different character set – MySQL master-master replication especially accompanied by MMM can be very handy to do the changes with virtually… schema. We deployed and used MySQL Master-Master replication manager (MMM) ever since we started working so doing all the schema… not virtual MMM IP as all virtual IPs are assigned to db1 at this stage. If you’re altering gigabyte size tables…
Post: Finding your MySQL High-Availability solution – Replication
November 13, 2009 By 6 Comments
… recreating the whole table and it is a blocking operations. Altering a large table may takes many hours. The trick here… table schema, we failover to the slave and repeat the alter table on the other server. Those online schema change are…. Here, I will quickly describe the most popular one, MMM. With MMM, you need to add a separate server, the Manager that…
Comment: Is DRBD the right choice for me?
July 8, 2009 By 17 Comments
… to failures but also minimizing scheduling downtime needed. MMM allows much more here – ALTER TABLEs, MySQL Upgrades, Storage Engine changes etc. 2… on it or simply reclone it from the slave using MMM. You also may resolve the changes at the same time…
Post: When should you store serialized objects in the database?
January 21, 2010 By 42 Comments
… is expensive. Another potential pro for this technique is that ALTER TABLE commands are no longer required. Until 5.1-plugin… always been able to emulate online index adds. Projects like MMM and Flipper make this even easier. In Friendfeed’s case…
Post: Onsite and Remote - getting best of both worlds
July 2, 2009 By 1 Comment
…), hands on setting up MySQL, Replication, Monitoring, High Availability with MMM or DRBD are good examples. Another good example of efficient… – waiting on database (or other) operations to complete – backup, restore, ALTER TABLE, load testing – all of these things take time and…
Post: Estimating Undo Space needed for LVM Snapshot
June 9, 2008 By 5 Comments
… Backups using LVM are pretty cool (check out mylvmbackup) or MMM though it is quite typical LVM is not configurable properly…, which well may require a lot of undo space. Running ALTER TABLE or OPTIMIZE TABLE will cause table rebuild and use…
Comment: Using MMM to ALTER huge tables
April 4, 2008 By 11 Comments
[...] huge queries to huge tables. On the MySQL performance blog, Aurimas Mikalauskas walks us through using MMM to ALTER huge tables. He writes, “When it comes to changes that really require table to be rebuilt – [...]
