Check LVM availability

Question

A tool that I am trying to install says:

MySQL server data directory needs to reside on an LVM volume

How do I check if my data directory is on LVM?

Solution 1

If you installed the OS then you would have chosen this option as part of the partitioning during installation. I assume you are looking to set up LVM snapshots (mylvmbackup) for MySQL?

If your seeing that message then i'm just guessing but you may not have an LVM volume, or at least MySQL data files aren't on it.

http://www.debian-administration.org/articles/410 is a guide for setting up with debian.

Try running lvdisplay on command line and is should display any LVM volumes if they exist.

Solution 2

Run df on the MySQL data directory; this will return the device where the directory resides. Then run lvs or lvdisplay to check if the device is an LVM one.

In my system:

perez:~ #df  /var/symdb/SYMDB
Filesystem                  1K-blocks     Used Available Use% Mounted on
/dev/mapper/OpenScapeUC-UC1  41284928 21346244  17841532  55% /

perez:~ # lvs /dev/mapper/OpenScapeUC-UC1
  LV   VG          Attr   LSize  Origin Snap%  Move Log Copy%  Convert
  UC1  OpenScapeUC -wi-ao 40.00g