Fast InnoDB snapshot

from the Artful MySQL Tips List

1. rsync on the master while it runs local.

2. Stop the master.

3. rsync a 2nd time to get a fast diff-sync.

4. Stop the slave.

5. rsync the master-backup to the slave.

6. Start replication.

Return to the Artful MySQL Tips page