xtrabackup的安装使用

一、安装percona-xtrabackup

yum安装

1、下载yum源

wget http://www.percona.com/downloads/percona-release/redhat/0.1-3/percona-release-0.1-3.noarch.rpm

2、安装yum源

rpm -ivH percona-release-0.1-3.noarch.rpm

3、确认安装的包

yum list | grep percona

[root@mysql_test1 ~]# yum list | grep xtrabackup
percona-xtrabackup-24.x86_64               2.4.2-1.el6                 @percona-release-x86_64
percona-xtrabackup.x86_64                  2.3.4-1.el6                 percona-release-x86_64
percona-xtrabackup-20.x86_64               2.0.8-587.rhel6             percona-release-x86_64
percona-xtrabackup-20-debuginfo.x86_64     2.0.8-587.rhel6             percona-release-x86_64
percona-xtrabackup-20-test.x86_64          2.0.8-587.rhel6             percona-release-x86_64
percona-xtrabackup-21.x86_64               2.1.9-746.rhel6             percona-release-x86_64
percona-xtrabackup-21-debuginfo.x86_64     2.1.9-746.rhel6             percona-release-x86_64
percona-xtrabackup-22.x86_64               2.2.13-1.el6                percona-release-x86_64
percona-xtrabackup-22-debuginfo.x86_64     2.2.13-1.el6                percona-release-x86_64
percona-xtrabackup-24-debuginfo.x86_64     2.4.2-1.el6                 percona-release-x86_64
percona-xtrabackup-debuginfo.x86_64        2.3.4-1.el6                 percona-release-x86_64
percona-xtrabackup-test.x86_64             2.3.4-1.el6                 percona-release-x86_64
percona-xtrabackup-test-21.x86_64          2.1.9-746.rhel6             percona-release-x86_64
percona-xtrabackup-test-22.x86_64          2.2.13-1.el6                percona-release-x86_64
percona-xtrabackup-test-24.x86_64          2.4.2-1.el6                 percona-release-x86_64

4、安装

yum install percona-xtrabackup-24

源码包安装，或者直接检查 find / -name 'libev.so*'

如果报错如下

LIBEV_INCLUDE_DIRS  
  
CMake Error: The following variables are used in this project, but they are set to NOTFOUND.  
Please set them or make sure they are set and tested correctly in the CMake files:  
LIBEV_INCLUDE_DIRS (ADVANCED)  

 wget http://dist.schmorp.de/libev/libev-4.22.tar.gz
  tar zxvf libev-4.22.tar.gz 
   cd libev-4.22
./configure
make && make install

[root@mysql_test2 libev-4.22]# find / -name 'libev.so*'
/usr/local/lib/libev.so.4
/usr/local/lib/libev.so.4.0.0
/usr/local/lib/libev.so

编译语句

cmake -DWITH_BOOST=/usr/local/boost/ -DBUILD_CONFIG=xtrabackup_release -DWITH_MAN_PAGES=OFF && make -j 10 && make install

[root@mysql_test2 bin]# pwd
/usr/local/xtrabackup/bin
[root@mysql_test2 bin]# ls
innobackupex  xbcloud  xbcloud_osenv  xbcrypt  xbstream  xtrabackup

就可以使用innobackupex进行备份恢复了

5、查看位置

[root@mysql_test1 ~]# rpm -qa|grep xtrabackup
percona-xtrabackup-24-2.4.2-1.el6.x86_64
[root@mysql_test1 ~]# rpm -ql percona-xtrabackup-24-2.4.2-1.el6.x86_64
/usr/bin/innobackupex
/usr/bin/xbcloud
/usr/bin/xbcloud_osenv
/usr/bin/xbcrypt
/usr/bin/xbstream
/usr/bin/xtrabackup
/usr/share/doc/percona-xtrabackup-24-2.4.2
/usr/share/doc/percona-xtrabackup-24-2.4.2/COPYING
/usr/share/man/man1/innobackupex.1.gz
/usr/share/man/man1/xbcrypt.1.gz
/usr/share/man/man1/xbstream.1.gz
/usr/share/man/man1/xtrabackup.1.gz

二、使用xtrabackup

1、全备

/usr/bin/xtrabackup --defaults-file=/etc/my.cnf  --user=root --password=123456 --port=38141 --backup

备份文件夹在当前目录的xtrabackup_backupfiles下

2、增量备份

/usr/bin/xtrabackup --defaults-file=/etc/my.cnf  --user=root --password=123456 --port=38141 --backup  --target-dir=/www/xtrabackup/20160425/ --incremental-basedir=/root/xtrabackup_backupfiles/

备注：--incremental-basedir=/root/xtrabackup_backupfiles/  全备的路径

           --incremental-basedir=/root/xtrabackup_backupfiles/  增量备份的路径

3、还原

    1、恢复全备

     /usr/bin/xtrabackup --defaults-file=/etc/my.cnf --prepare --apply-log-only --target-dir=/root/xtrabackup_backupfiles/

    2、恢复增量备份

    /usr/bin/xtrabackup --defaults-file=/etc/my.cnf --prepare --apply-log-only --target-dir=/root/xtrabackup_backupfiles/  --incremental-dir=/www/xtrabackup/20160425/

   3、拷贝回数据库目录

     /usr/bin/xtrabackup --defaults-file=/etc/my.cnf  --copy-back  --target-dir=/root/xtrabackup_backupfiles

    chown -R mysql.mysql /opt/mydata

查看恢复文件的备份还原信息

[root@mysql_test1 mydata]# more xtrabackup_binlog_pos_innodb 
mysql-bin.000001        1703

全恢复+增量恢复到的日志点

[root@mysql_test1 mydata]# more xtrabackup_info 
uuid = 30c44619-0aa8-11e6-8473-0050568a04a3
name = 
tool_name = xtrabackup
tool_command = --defaults-file=/etc/my.cnf --user=root --password=... --port=38141 --backup --target-dir=/www/xtrabackup/20160425/ --incremental-basedir=/root/xtrab
ackup_backupfiles/
tool_version = 2.4.2
ibbackup_version = 2.4.2
server_version = 5.7.10-log
start_time = 2016-04-25 13:40:12
end_time = 2016-04-25 13:40:17
lock_time = 0
binlog_pos = filename 'mysql-bin.000001', position '1703', GTID of the last change '57307619-0838-11e6-880a-0050568a04a3:1-216324,
d8281349-0a96-11e6-8473-0050568a04a3:1-7'
innodb_from_lsn = 2528854
innodb_to_lsn = 2531899
partial = N
incremental = Y
format = file
compact = N
compressed = N
encrypted = N

备份的一些操作