percona-xtrabackup：全备份

1、全备份

1. root@pm1:/root# innobackupex --user=root --password=111 --database=test /backup

备份输出

1. xtrabackup: The latest check point (for incremental): '1048637327'
   
2. xtrabackup: Stopping log copying thread.
   
3. .>> log scanned up to (1048637327)
   
4. 
   
5. xtrabackup: Creating suspend file '/backup/2015-08-02_10-23-40/xtrabackup_log_copied' with pid '29849'
   
6. xtrabackup: Transaction log of lsn (1048637327) to (1048637327) was copied.
   
7. 150802 10:23:49 innobackupex: Executing UNLOCK BINLOG
   
8. 150802 10:23:49 innobackupex: Executing UNLOCK TABLES
   
9. 150802 10:23:49 innobackupex: All tables unlocked
   
10. 
    
11. innobackupex: Backup created in directory '/backup/2015-08-02_10-23-40'
    
12. innobackupex: MySQL binlog position: filename 'pm1-bin.000005', position 206328934
    
13. 150802 10:23:49 innobackupex: Connection to database server closed
    
14. 150802 10:23:49 innobackupex: completed

1.1、latest chenk point是 1048637327
1.2、事物日志lsn是 1048637327
1.3、unlock all tables
1.4、MySQL binlog的文件是pm1-bin.00005，pos是 206328934
2、查看master status

1. [root@localhost:test][10:32:24am] MySQL-> show master status\G
   
2. *************************** 1. row ***************************
   
3.              File: pm1-bin.000005
   
4.          Position: 206328934
   
5.      Binlog_Do_DB:
   
6.  Binlog_Ignore_DB:
   
7. Executed_Gtid_Set:
   
8. 1 row in set (0.00 sec)

与备份的file和pos一致
3、查看备份的信息

1. root@pm1:/backup/2015-08-02_10-23-40# cat xtrabackup_checkpoints
   
2. backup_type = full-backuped
   
3. from_lsn = 0
   
4. to_lsn = 1048637327
   
5. last_lsn = 1048637327
   
6. compact = 0

备份类型为 full - backuped

1. root@pm1:/backup/2015-08-02_10-23-40# cat xtrabackup_info
   
2. uuid = 829b4fff-38bd-11e5-ac42-08002760d8fe
   
3. name =
   
4. tool_name = innobackupex
   
5. tool_command = --user=root --password=... --database=test /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 10:23:40
   
10. end_time = 2015-08-02 10:23:49
    
11. lock_time = 1
    
12. binlog_pos = filename 'pm1-bin.000005', position 206328934
    
13. innodb_from_lsn = 0
    
14. innodb_to_lsn = 1048637327
    
15. partial = Y
    
16. incremental = N
    
17. format = file
    
18. compact = N
    
19. compressed = N
    
20. encrypted = N

xtrabackup_info文件中记录了备份时间、binlog_pos、format、compressed等等信息。
4、prepare backup

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

查看prepare之后的检查点信息

1. root@pm1:/backup/2015-08-02_10-23-40# cat xtrabackup_checkpoints
   
2. backup_type = full-prepared
   
3. from_lsn = 0
   
4. to_lsn = 1048637327
   
5. last_lsn = 1048637327
   
6. compact = 0

现在的备份类型 full - prepared

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

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