MySQL Backup with Incremental Levels
The script is written to take backup of MySQL Database using Percona Xtrabackup. The innobackupex tool is a Perl script that acts as a wrapper for the xtrabackup C program. It allows us to take backup of Innodb without any locking and also takes backup of other engines like MyISAM with minimum locking. To read more about innobackupex, read the following links. Innobackupex Script How Innobackupex Works? You can download full script here . Innobackupex provides 2 types of backups:- Full : Which will take the full backup of the given database from start to end. Incremental : It will only take the backup of changed blocks since last base backup or LSN(Log Sequence Number). The script will take setting from the variables defined and take backups accordingly. I have currently set it up as below. Every Sunday, it will take full backup of the DB provided. Every day at 0000 hours, it will take an incremental backup since last full backup ( Figure 1 ). It is going to t...