innobackupex 备份实验

[root@localhost ~]# xtrabackup -v
xtrabackup version 2.3.5 based on MySQL server 5.6.24 Linux (x86_64) (revision id: 45cda89)

[root@localhost ~]# /usr/bin/innobackupex -v
innobackupex version 2.3.5 Linux (x86_64) (revision id: 45cda89)

wget https://www.percona.com/downloads/XtraBackup/Percona-XtraBackup-2.3.5/binary/redhat/5/x86_64/percona-xtrabackup-2.3.5-1.el5.x86_64.rpm

 

全备：

指定的备份目录：/data/backups

[root@localhost backups]# innobackupex --backup /data/backups

[root@localhost backups]# ll
总用量 24
drwx------ 8 root root 4096 Jul 20 09:39 2016-07-20_09-39-28

[root@localhost 2016-07-20_09-39-28]# cat xtrabackup_checkpoints
backup_type = full-backuped
from_lsn = 0
to_lsn = 506262661
last_lsn = 506262661
compact = 0
recover_binlog_info = 0

 

增量备份：

[root@localhost backups]# innobackupex --incremental /data/backups/incbackup --incremental-basedir=/data/backups/2016-07-20_09-39-28

[root@localhost backups]# pwd
/data/backups
[root@localhost backups]# ll
总用量 28
drwx------ 8 root root 4096 Jul 20 09:39 2016-07-20_09-39-28
drwx------ 3 root root 4096 Jul 20 09:53 incbackup

[root@localhost backups]# cd incbackup
[root@localhost incbackup]# ll
总用量 4
drwx------ 8 root root 4096 Jul 20 09:53 2016-07-20_09-53-35

 

[root@localhost 2016-07-20_09-39-28]# cat xtrabackup_checkpoints
backup_type = incremental
from_lsn = 506262370
to_lsn = 506262661
last_lsn = 506262661
compact = 0
recover_binlog_info = 0