innobackupex 增量备份(incremental)案例

1.删掉原来备份

rm -rf /data/backup/*
mysql [(none)]>show master status \G
mysql [(none)]>restart master;
mysql [(none)]>show master status;

2.模拟数据变化（全备之前）

mysql [(none)]>create database test charset utf8;
mysql [(none)]>use test;
mysql [test]>create table t1(id int);
mysql [test]>insert into t1 values(1),(2),(3);
mysql [test]>commit;

3.全备（周日）

innobackupex --user=root --password=123456 --no-timestamp /data/backup/full 
>&/tmp/xbk_full.log

4.模拟周一数据变化

use test;
create table t2(id int);
insert into t2 values(1),(2),(3);
commit;

5.第一次增量备份（周一）

innobackupex --user=root --password=123456 --no-timestamp --incremental /data/backup/inc1 
--incremental-basedir=/data/backup/full &>/tmp/inc1.log
检查备份日志
cat /tmp/inc1.log
对比全备lsn号
[root@xiaoyong backup]# cat full/xtrabackup_checkpoints
backup_type = full-backuped
to_lsn = 299557468
last_lsn = 299557477-9=增量备份的from_lsn
[root@xiaoyong backup]# cat inc1/xtrabackup_checkpoints
backup_type = incremental
from_lsn = 299557468
last_lsn = 299563113

6.模拟周二数据

use test;
create table t3(id int);
insert into t3 values(1),(2),(3);commit;

7.周二增量备份

innobackupex --user=root --password=123456 --no-timestamp --incremental /data/backup/inc2 
--incremental-basedir=/data/backup/inc1 &>/tmp/inc2.log

8.模拟周三数据变化

use test;
create table t4(id int);
insert into t4 values(1),(2),(3);
commit;
drop database test;

恢复方案