1、全备份

备份输出

xtrabackup: The latest check point (for incremental): '1048637327'
xtrabackup: Stopping log copying thread.
.>> log scanned up to (1048637327)
xtrabackup: Creating suspend file '/backup/2015-08-02_10-23-40/xtrabackup_log_copied' with pid '29849'
xtrabackup: Transaction log of lsn (1048637327) to (1048637327) was copied.
150802 10:23:49 innobackupex: Executing UNLOCK BINLOG
150802 10:23:49 innobackupex: Executing UNLOCK TABLES
150802 10:23:49 innobackupex: All tables unlocked
innobackupex: Backup created in directory '/backup/2015-08-02_10-23-40'
innobackupex: MySQL binlog position: filename 'pm1-bin.000005', position 206328934
150802 10:23:49 innobackupex: Connection to database server closed
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

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

备份类型为full-backuped

root@pm1:/backup/2015-08-02_10-23-40# cat xtrabackup_info
uuid = 829b4fff-38bd-11e5-ac42-08002760d8fe
name =
tool_name = innobackupex
tool_command = --user=root --password=... --database=test /backup
tool_version = 1.5.1-xtrabackup
ibbackup_version = xtrabackup version 2.2.11 based on MySQL server 5.6.24 Linux (x86_64) (revision id: )
server_version = 5.6.25-73.0-log
start_time = 2015-08-02 10:23:40
end_time = 2015-08-02 10:23:49
lock_time = 1
binlog_pos = filename 'pm1-bin.000005', position 206328934
innodb_from_lsn = 0
innodb_to_lsn = 1048637327
partial = Y
incremental = N
format = file
compact = N
compressed = N
encrypted = N

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

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

查看prepare之后的检查点信息

现在的备份类型full-prepared

ITPub博客

percona-xtrabackup：全备份