mysqldatabaseinnodblvm

How to setting up MySQL Master-Slave Replication with LVM snapshots


There are multiple ways to take a MySQL replication, or rebuilding it. How can we build master-slave replications via LVM snapshot?

And also which is the most effective way among below 4 choices & why ??


Solution

  • Since setting up LVM requires major surgery at the filesystem level, that approach could be a challenge. However, once it is done, the rest is relatively painless.

    XtraBackup is an improvement on mysqldump.

    rsync is good for copying files that are not being modified. When MySQL is running, it is modifying files, and caching unwritten stuff in ram. Sounds sketchy.