… snapshot of many volumes. Lets speak a bit about how LVM and snapshotting in general works. Really there are different implementations… START to restart replication. With slightly modified process you can clone slaves from the slaves without stopping them – you just need… appropriate binary log position. Be careful however – cloning slave from the slave also clones inconsistences in data which slave could have accomulated…
Post: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
…. If this happens, you’ll have to clone db2 from current db1 (mmm_clone), fix the application and start from the beginning… though if you can’t use mmm_clone i.e. you don’t have lvm or another way to create snapshots, this… 6. Clone db1 from db2 On db1 execute: $ mmm_clone –host db2 –clone-mode master-master There are several different methods to clone a…
Post: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
… course) Another way this functionality was usable is cloning Slave->Slave by use of LVM without pausing replication (so you can get… cases – for example when you’re taking LVM snapshot (for backup or to clone slave from the master) and can’t do… stall if this lock is used. You can just take LVM Snapshot (assuming you’re only using Innodb tables and not…
Post: MySQL Master-Master replication manager released
April 5, 2007 By 27 Comments
… internal scripts to handle things as automatic fallback and slave cloning but no Open Source solution was made available. Few months… it is implemented based on Linux IP management tools and LVM for snapshot creation but we hope support for other operation…. One command LVM based sync is also implemented so restoring broken replication safe way becomes very easy. Besides simple “cloning” of the…
Post: Troubleshooting Relay Log Corruption in MySQL
August 2, 2008 By 7 Comments
… likely to be affected in this case you can’t clone another slave. You also can’t use classical method of… are corrupted. You can either re-clone the data from Master. (This is where LVM or similar techniques can help you a…
Post: How SHOW SLAVE STATUS relates to CHANGE MASTER TO
July 7, 2008 By 21 Comments
… the “snapshot” – shutting down MySQL Server and copying data, using LVM, Using Innodb Hot Backup Tool, Using another Slave, using backup… you’re backing up from the Slave or you’re cloning the Slave to make another one you need to use… fact VERY typical. I’ve seen multiple “internal instructions” for cloning the slave or slave recovery from backup using this value…
Comment: Disaster: LVM Performance in Snapshot Mode
February 8, 2009 By 55 Comments
This is our experience with LVM…. It can be DOG slow when a snapshot is live. … warmup when the DB starts up. When we need to clone a new slave reading the snapshot and COW operations can… use the linux page cache. Transferring the snapshot from the LVM image would come from the cache without having to touch…
Comment: Why you can't rely on a replica for disaster recovery
August 2, 2010 By 25 Comments
… elsewhere, and run a recovery all the time both via LVM and storage snaps (netapp). In point of fact, I can…’t recover), but as a general case tool to quickly clone databases, I think its phenomenally useful and infinitely faster than…
Post: Recovery beyond data restore
August 2, 2008 By 11 Comments
… still operate normally), have LVM setup if you want to avoid shutting off slave or master to clone the data and making…
Post: Figuring out what limits MySQL Replication
March 7, 2007 By Leave a Comment
Today I was cloning the master using LVM Snapshot and found it was taking quite a while to …
