xtarbackup的安装
下载
wget https://www.percona.com/downloads/Percona-XtraBackup-2.4/Percona-XtraBackup-2.4.15/binary/redhat/7/x86_64/percona-xtrabackup-24-2.4.15-1.el7.x86_64.rpm
安装
yum -y install percona-xtrabackup-24-2.4.15-1.el7.x86_64.rpm
检测
ps -aux |grep xtrabackup
完整备份
备份
创建备份目录:
mkdir -p /xtrabackup/full
备份:
innobackupex --user=root --password='NEW-password123' /xtrabackup/full
恢复
- 停止数据库
systemctl stop mysqld
- 清理环境
rm -rf /var/lib/mysql/*
rm -rf /var/log/mysqld.log
rm -rf /var/log/mysql-slow/slow.log (有则删除,无则不需要操作)
- 重演回滚--> 恢复数据
innobackupex --apply-log /xtrabackup/full/2019-09-23_01-21-24/
确认数据库目录:
恢复之前需要确认配置文件内有数据库目录指定,不然xtrabackup不知道恢复到哪里
cat /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
- 恢复数据
innobackupex --copy-back /xtrabackup/full/2019-09-23_01-21-24/
- 修改权限
chown mysql.mysql /var/lib/mysql -R
- 启动数据库
systemctl start mysqld
- 验证数据
mysql -u root -pNEW-password123
show databases;
use jiajia
select * from tt;