… operations to a high level. Using the slaves for reads cause a second interesting side…MySQL, altering a table means recreating the whole table and it is a blocking operations. Altering a large table … The architecture of a highly available setup using MMM and Master-Master replication is presented …
Post: Estimating Undo Space needed for LVM Snapshot
June 9, 2008 By 5 Comments
… using LVM are pretty cool (check out mylvmbackup) or MMM though it is quite …ALTER TABLE or OPTIMIZE TABLE will cause table rebuild and use a lot of space. Batch jobs such as recounting rating summary tables…and you would like to setup replication for large database with little no – connect USB hard…
Post: When should you store serialized objects in the database?
January 21, 2010 By 42 Comments
… full blob for 1 change, it is expensive. Another potential pro for this technique is that ALTER TABLE commands are …. Projects like MMM and Flipper make this even easier. In Friendfeed’s case, they also used the serialization … to one piece of data in a very large blob, the effort MySQL has to go to …
Post: Onsite and Remote - getting best of both worlds
July 2, 2009 By 1 Comment
…use drawing board. It also often allows the best focus both for consultant and for… Monitoring, High Availability with MMM or DRBD are …ALTER TABLE, load testing – all of these things take time and make consultant to wait for… optimizations but architecture redesigns, large scale deployment, migrations…
