Appendix B. LVM and MySQL
The default installation of RedHat Enterprise Linux and CentOS 5 will create all mount points (including the root mount point,
/) on Logical Volume Manager's (LVM) Logical Volumes (LVs).
LVM brings about many benefits. With particular relevance for MySQL high availability is the snapshot feature. This allows you to take a consistent snapshot of a logical volume (for example, the logical volume with the
ext3 filesystem mounted on
/var/lib/mysql) without affecting the currently mounted volume.
LVM then allows for this snapshot to be mounted somewhere else (
/mnt/mysql-3pmtoday) and a backup can then be run against this snapshot without affecting the MySQL instance running on the original logical volume.
The actual process ...