The mylvmbackup software is a Perl program that enables speedy creation of backups for data files on servers running MySQL.
Mylvmbackup is a Perl script that is designed to simplify the creation of backups for MySQL server's data files. This software works by obtaining a read lock on all the tables and flushing all the server caches to the disk for backup. It then proceeds to make an LVM snapshot of the volume, which contains the MySQL data directory and unlocks the tables. The snapshot process is concluded quickly, allowing the server to continue operations while the file backup sequence is ongoing.
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.
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.
What's New
Version 0.13: N/A