…catch up quickly. So the question becomes how can we estimate replication capacity, so we can deal with replication load before slave is unable to catch up…when see how long it takes to catch up. If you paused replication for 10 minutes and it took 5 minutes to catch up your replication capacity will…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…is hard to estimate when it is hot and when it is not…backup is consistent. Backing up database which was already…long running queries. The catch here is FLUSH TABLES…enough snapshot will get invalidated and backup will be aborted….) Run SLAVE START to restart replication. With slightly modified process…
