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;
恢复方案
恢复过程
评论前必须登录!
注册