The mylvmbackup software is a Perl program that enables speedy creation of backups for data files on servers running MySQL.
Furthermore, this software mounts the LVM snapshot to a temporary directory, where it backs up all the data using the tar program. Afterwards, the software creates an archive file named backup-YYYYMMDD_hhmmss_mysql.tar.gz, where the date and time information corresponds with the backup occurrence. It is noteworthy that the prefix 'backup' and date format can be modified to suit the user's preference.
The use of timestamped archive names is an ingenious way of preventing overwriting of old archive files, making it easy to run Mylvmbackup multiple times without the risk of data loss. However, it is essential to run the backup sequence on the same host as the MySQL server. If the MySQL daemon is not listening on localhost, or the default socket location is not in use, then the user must specify --host or --socket.
Furthermore, Mylvmbackup works by communicating with the server through a normal client connection to obtain the read lock and flush data, but the backup process involves accessing the file system directly. This software requires that the MySQL server data directory resides on an LVM volume, although it is advisable to perform the LVM backup on a different partition than that of the data directory. This is because an LVM snapshot maintenance could run out of undo space without adequate backing up if both are on the same partition.
Finally, the user who invokes Mylvmbackup must have sufficient file system permissions to create the LVM snapshot and mount it. This includes a read/write access to the backup directory. Besides, for proper operation, Mylvmbackup requires Perl, as well as the DBI and DBD::mysql modules, and several other programs like /bin/date, tar, LVM utilities, mount, and umount.
Version 0.13: N/A