XtraBackup提供了增量备份和恢复的功能
背景:
实验是在原博客的基础上做的!http://blog.itpub.net/7607759/viewspace-700064/
tom库下面有张t1表
- mysql> create table t1(id int(10));
Query OK, 0 rows affected (0.03 sec)
mysql>
mysql> insert into t1 values(1);
Query OK, 1 row affected (0.01 sec)
mysql> select * from t1;
+------+
| id |
+------+
| 1 |
+------+
1 row in set (0.00 sec)
+------+
| id |
+------+
| 1 |
+------+
1 row in set (0.00 sec)
做个全备
- [root@node2 tom]# innobackupex --defaults-file=/etc/my.cnf --user=root --password=ESBecs00 /xback/full/
- [root@node2 xback]# ls full/
2015-10-20_21-04-43
-----用来备份的用户只需要这些权限即可,可不用root:grant reload,lock tables,replication client on *.*
tom下新建表t2
- mysql> create table t2(id int(10));
Query OK, 0 rows affected (0.06 sec)
mysql> insert into t1 values(1);
Query OK, 1 row affected (0.00 sec)
mysql> insert into t2 values(1);
Query OK, 1 row affected (0.00 sec)
mysql> select * from t1;
+------+
| id |
+------+
| 1 |
| 1 |
+------+
2 rows in set (0.00 sec)
mysql> select * from t2;
+------+
| id |
+------+
| 1 |
+------+
1 row in set (0.00 sec)
- [root@node2 xback]# innobackupex --defaults-file=/etc/my.cnf --user=root --password=ESBecs00 --incremental --incremental-basedir=/xback/full/2015-10-20_21-04-43/ /xback/inc/
- [root@node2 xback]# ls inc
2015-10-20_21-06-04
--以全备为基础做一次增量备份
- 关库,创造恢复环境
- [root@node2 mysql]# /etc/init.d/mysqld stop
- [root@node2 lib]# mv mysql mysql_bak4
- [root@node2 lib]# mkdir mysql
两个实验都是在以上背景的基础上做的!
实验一:全量恢复(此时只是恢复到了t,而t2表示还没有恢复的)
Prepare完整备份集: