MySQL incremental backup and recovery-- experiment

1. Create a complete set

Innobackupex-defaults-file=/etc/my.cnf-user=root-password=root-socket=/home/mysql/3306/data/mysql.sock-no-timestamp / home/mysql/backup

Existing data

2. Add data

Insert into leo values (7, "wanger"); insert into leo values (8, "xiaofang")

3. The first incremental backup

Innobackupex-defaults-file=/etc/my.cnf-user=root-password=root-socket=/home/mysql/3306/data/mysql.sock-no-timestamp-incremental-basedir=/home/mysql/backup-incremental / home/mysql/backup/zengliang1/

4. Add data

Insert into leo values (9, "wanger"); insert into leo values (10, "xiaofang")

5. The second increment

Innobackupex-defaults-file=/etc/my.cnf-user=root-password=root-socket=/home/mysql/3306/data/mysql.sock-no-timestamp-parallel=3-incremental-basedir=/home/mysql/backup/zengliang1/-incremental / home/mysql/backup/zengliang2/

6. Restore incremental data

Innobackupex-apply-log-use-memory=32M-redo-only / home/mysql/backup/

7. Merge increments to the full directory

Merge the first increment: innobackupex-apply-log-use-memory=32M-redo-only-incremental-dir=/home/mysql/backup/zengliang1 / home/mysql/backup/ merge the second increment: innobackupex-apply-log-use-memory=32M-redo-only-incremental-dir=/home/mysql/backup/zengliang2 / home/mysql/backup/

8. Apply redo,undo to roll back data

Innobackupex-apply-log-use-memory=32M / home/mysql/backup

9. Formal recovery of data

/ usr/local/mysql/bin/mysqladmin-uroot-p-P3306-S / home/mysql/3306/data/mysql.sock shutdown backup data directory: mv / home/mysql/3306/data/ / tmp/databakinnobackupex-- defaults-file=/etc/my.cnf-- copy-back-- rsync / home/mysql/backup/ # same as mv effect chown-R mysql:mysql / home/mysql/3306/data/usr/local/mysql/bin/mysqld_safe- -defaults-file=/etc/my.cnf-- user=mysql &

It's over!