… whole table and it is a blocking operations. Altering a large table may takes many hours. The trick here is to run the alter table… with the master using the new table schema, we failover to the slave and repeat the alter table on the other server. Those…. Here, I will quickly describe the most popular one, MMM. With MMM, you need to add a separate server, the Manager that…
Post: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
… ENUM values. When it comes to changes that really require table to be rebuilt – adding/dropping columns or indexes, changing data… not virtual MMM IP as all virtual IPs are assigned to db1 at this stage. If you’re altering gigabyte size tables, this… and rebuild its tables. When replication on db1 has caught-up: 6.2 on monitor: set db1 on-line $ mmm_control @C1…
Comment: Is DRBD the right choice for me?
July 8, 2009 By 18 Comments
… to failures but also minimizing scheduling downtime needed. MMM allows much more here – ALTER TABLEs, MySQL Upgrades, Storage Engine changes etc. 2) Anders… to run mk-table-checksum before putting traffic back on it or simply reclone it from the slave using MMM. You also… be in place as well as regular checks with mk-table-checksum. In general for most applications replication can run rather…
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… from batch updates updating pretty much every page in 10GB table you can account for that as well. If you want…. Running ALTER TABLE or OPTIMIZE TABLE will cause table rebuild and use a lot of space. Batch jobs such as recounting rating summary tables recreation…
Post: When should you store serialized objects in the database?
January 21, 2010 By 47 Comments
… that ALTER TABLE commands are no longer required. Until 5.1-plugin simple operations like adding a secondary index on an InnoDB table require the whole table to be rebuilt (now just the index is… 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 make…
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 – [...]
