• 安装percona软件包
• innobackupex完整备份、增量备份操作。
• 恢复数据
步骤一:安装XtraBackup软件包
1)了解软件包描述信息
[root@zhangyx ~]# rpm -qpi percona-xtrabackup-24-2.4.7-1.el7.x86_64.rpm //这里版本写自己的版本
warning: percona-xtrabackup-24-2.4.7-1.el7.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY
Name : percona-xtrabackup-24
Version : 2.4.7
Release : 1.el7
Architecture: x86_64
Install Date: (not installed)
Group : Applications/Databases
Size : 32462102
License : GPLv2
Signature : DSA/SHA1, Mon 17 Apr 2017 10:19:23 PM CST, Key ID 1c4cbdcdcd2efd2a
Source RPM : percona-xtrabackup-24-2.4.7-1.el7.src.rpm
Build Date : Mon 17 Apr 2017 10:18:13 PM CST
Build Host : v-centos-7-x64-01.ci.percona.com
Relocations : (not relocatable)
URL : http://www.percona.com/software/percona-xtrabackup
Summary : XtraBackup online backup for MySQL / InnoDB
Description :
Percona XtraBackup is OpenSource online (non-blockable) backup solution for InnoDB and XtraDB engines
2)安装依赖包perl-DBD-MySQL perl-Digest-MD5 libev
使用RHEL 7自带的即可,yum方式安装:
[root@zhangyx ~]# yum -y install perl-DBD-MySQL perl-Digest-MD5
[root@zhangyx ~]#rpm –ivh libev-4.15-1.el6.rf.x86_64.rpm
如果未安装这些依赖包,则直接安装percona-xtrabackup时会报错:
解决办法:
[root@zhangyx ~]# yum -y install rsync perl l perl-Digest-MD5
3)安装percona-xtrabackup
[root@zhangyx ~]# rpm -ivh percona-xtrabackup-*.rpm
warning: percona-xtrabackup-24-2.4.7-1.el7.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID cd2efd2a: NOKEY
Preparing... ################################# [100%]
Updating / installing...
1:percona-xtrabackup-24-2.4.7-1.el7################################# [100%]
4)确认安装的主要程序/脚本
[root@zhangyx ~]# rpm -ql percona-xtrabackup-24-2.4.7-1.el7.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.7
/usr/share/doc/percona-xtrabackup-24-2.4.7/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
步骤二:innobackupex完整备份、增量备份操作
–host 主机名
–port 3306
–user 用户名
–password 密码
–databases=“库名”
–databases=“库1 库2”
–databases=“库.表”
–no-timestamp 不用日期命名备份文件存储的子目录,使用备份的数据库名做备份目录名
–no-timestmap 不使用日期命名备份目录名
1)做一个完整备份
默认情况下,备份文件存储的子目录会用日期命名,
innobackupex作为客户端工具,以mysql协议连入mysqld,将数据备份到/backup文件夹: