percona-xtrabackup
percona-xtrabackup
https://www.percona.com/ 官网地址
##安装
-
安装YUM仓库
安装percona需要的mysql包
-
mysql官方源
yum install -y https://repo.mysql.com//mysql80-community-release-el7-3.noarch.rpm
-
yum工具:
yum install -y yum-utils
-
查看mysql可用版本
yum repolist all | grep mysql
-
禁用80
yum-config-manager --disable mysql80-community
-
启用57
yum-config-manager --enable mysql57-community yum install mysql-community-libs-compat -y yum install https://repo.percona.com/yum/percona-release-latest.noarch.rpm (percona源)
-
YUM安装percona-xtrabackup
yum -y install percona-xtrabackup-24.x86_64
-
查询安装结果
rpm -ql percona-xtrabackup-24
完整备份流程
innobackupex --user=root --password='liweiqiang@123' /xtrabackup/full
ls /xtrabackup/full/ (查看备份目录。数据库,配置文件,日志文件)
ls /xtrabackup/full/2017-08-01_00-00-02/
cat /xtrabackup/full/2017-08-01_00-00-18/xtrabackup_binlog_info (查看二进制文件)
完整恢复:
systemctl stop mysqld (关闭)
- 清理环境(模拟损坏)
rm -rf /var/lib/mysql/*
rm -rf /var/log/mysqld.log
innobackupex --apply-log /xtrabackup/full/2017-08-01_00-00-18/ (回滚日志)
innobackupex --copy-back /xtrabackup/full/2017-08-01_00-00-18/ (恢复数据)(恢复数据数据文件夹必须是空的)
- 登录验证
ls /var/lib/mysql (查看恢复的目录)
chown -R mysql.mysql /var/lib/mysql (因为数据恢复之后数据库的文件属主属组都是root mysql用户没有权限访问会
数据库服务启动不成功)
systemctl restart mysqld (建议重启 启动可能不行)
mysql -uroot -p'liweiqiang@123' (登录查看数据是否还在)!!!!!!!!!!!!!!