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 ...

Get High Availability MySQL Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.