percona-xtrabackup：增量备份

1、插入数据，并查看pos值

1. [root@localhost:test][10:53:30am] MySQL-> insert into t1 select null,'mysql';
   
2. Query OK, 1 row affected (0.03 sec)
   
3. Records: 1 Duplicates: 0 Warnings: 0
   
4. 
   
5. [root@localhost:test][10:53:39am] MySQL-> show master status\G
   
6. *************************** 1. row ***************************
   
7.              File: pm1-bin.000005
   
8.          Position: 206329194
   
9.      Binlog_Do_DB:
   
10.  Binlog_Ignore_DB:
    
11. Executed_Gtid_Set:
    
12. 1 row in set (0.00 sec)

插入数据之后，pos值增加到 206329194
2、增量备份

1. root@pm1:/root# innobackupex --user=root --password=111 --database=test --incremental --incremental-basedir=/backup/2015-08-02_10-23-40 /backup

增量备份输出

1. innobackupex: Backup created in directory '/backup/2015-08-02_11-05-13'
   
2. innobackupex: MySQL binlog position: filename 'pm1-bin.000005', position 206329194
   
3. 150802 11:05:20 innobackupex: Connection to database server closed
   
4. 150802 11:05:20 innobackupex: completed

3、查看备份信息

1. root@pm1:/backup/2015-08-02_11-05-13# cat xtrabackup_checkpoints
   
2. backup_type = incremental
   
3. from_lsn = 1048637327
   
4. to_lsn = 1048637674
   
5. last_lsn = 1048637674
   
6. compact = 0

备份类型为 incremental，而lsn从 1048637327到 1048637674

1. root@pm1:/backup/2015-08-02_11-05-13# cat xtrabackup_info
   
2. uuid = 4f3988e3-38c3-11e5-ac42-08002760d8fe
   
3. name =
   
4. tool_name = innobackupex
   
5. tool_command = --user=root --password=... --database=test --incremental --incremental-basedir=/backup/2015-08-02_10-23-40 /backup
   
6. tool_version = 1.5.1-xtrabackup
   
7. ibbackup_version = xtrabackup version 2.2.11 based on MySQL server 5.6.24 Linux (x86_64) (revision id: )
   
8. server_version = 5.6.25-73.0-log
   
9. start_time = 2015-08-02 11:05:13
   
10. end_time = 2015-08-02 11:05:20
    
11. lock_time = 1
    
12. binlog_pos = filename 'pm1-bin.000005', position 206329194
    
13. innodb_from_lsn = 1048637327
    
14. innodb_to_lsn = 1048637674
    
15. partial = Y
    
16. incremental = Y
    
17. format = file
    
18. compact = N
    
19. compressed = N
    
20. encrypted = N

这里的信息与全备份除备份时间和lsn有区别，其他基本一致

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/12219480/viewspace-1763390/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/12219480/viewspace-1763390/