使用xtrabackup实现mysql备份

[root@node1 ~]# yum install percona-xtrabackup

[root@node1 ~]# vim /etc/my.cnf
[mysqld]
innodb_file_per_table=ON

[root@node1 ~]# mkdir /backpus/

[root@node1 ~]# innobackupex --user=root /backpus/

[root@node1 ~]# scp -r /backpus/2016-07-13_20-27-04 192.168.1.114:/root/

[root@node2 ~]# yum install percona-xtrabackup

[root@node2 ~]# mkdir /backups/
[root@node2 ~]# mv 2016-07-13_20-27-04/ /backups/

[root@node2 ~]# innobackupex --apply-log /backups/2016-07-13_20-27-04/

[root@node2 ~]# innobackupex --copy-back /backups/2016-07-13_20-27-04/

[root@node2 ~]# chown -R mysql:mysql /var/lib/mysql/*

[root@node1 ~]# mysql
MariaDB [(none)]> use hellodb;
MariaDB [hellodb]> create table xxoo2 (id int);
MariaDB [hellodb]> insert into xxoo2 values (1),(10),(83);

[root@node1 ~]# less /backpus/2016-07-13_23-13-25/xtrabackup_checkpoints 
backup_type = incremental
from_lsn = 1642047
to_lsn = 1646912
last_lsn = 1646912
compact = 0

[root@node1 ~]# less /backpus/2016-07-13_20-27-04/xtrabackup_checkpoints
backup_type = full-prepared
from_lsn = 0
to_lsn = 1646912
last_lsn = 1646912
compact = 0