本文来自我的github pages博客http://galengao.github.io/ 即www.gaohuirong.cn
Xtrabackup有两个主要的工具:xtrabackup、innobackupex
(1)xtrabackup只能备份InnoDB和XtraDB两种数据表,而不能备份MyISAM数据表
(2)innobackupex-1.5.1则封装了xtrabackup,是一个脚本封装,所以能同时备份处理innodb和myisam,但在处理myisam时需要加一个读锁
安装percona-xtrabackup
1、安装依赖包
yum -y install cmake gcc gcc-c++ libaio libaio-devel automake autoconf bison libtool ncurses-devel libgcrypt-devel libev-devel libcurl*
yum -y install perl-Time-HiRes
yum -y install perl-DBI
yum -y install perl-DBD-MySQL
yum install perl-IO-Socket-SSL
cd /usr/local
wget http://dist.schmorp.de/libev/libev-4.22.tar.gz
tar xvzf libev-4.22.tar.gz
cd libev-4.22
./configure
make
make install
2、编译安装percona-xtrabackup
此处要注意xtrabackup的版本支持mysql哪个版本,可以到xtrabackup官网查看文档,我此处的版本支持mysql5.7.11
cd /usr/local
wget https://www.percona.com/downloads/XtraBackup/Percona-XtraBackup-2.4.2/source/tarball/percona-xtrabackup-2.4.2.tar.gz
tar -zxvf percona-xtrabackup-2.2.13.tar.gz
cd percona-xtrabackup-2.2.13/
cmake -DBUILD_CONFIG=xtrabackup_release -DWITH_MAN_PAGES=OFF && make -j4 --DINSTALL_LAYOUT=/usr/local/xtrabackup
make
make install
这样是默认装到/usr/local/xtrabackup目录下的。
3、加入环境变量
# vi ~/.bash_profile
export PATH=/usr/local/xtrabackup/bin:$PATH
# source ~/.bash_profile
4、备份测试
在Master和Slave上安装xtrabackup:
在Master和Slave上创建一个用于备份的用户backup-user:
mysql> CREATE USER 'backup-user'@'localhost' IDENTIFIED BY 'backup-pass';
mysql> GRANT SUPER, RELOAD, LOCK TABLES, REPLICATION CLIENT ON *.* TO 'backup-user'@'localhost';
mysql> FLUSH PRIVILEGES;
mysql> EXIT;
在Master上备份