xtrabackup 的全备和恢复

下载

地址：（如果是MySQL8.0，建议选择8.0版本）
https://www.percona.com/downloads/Percona-XtraBackup-2.4/LATEST/

由于是rhel7，选择rpm包安装

安装

yum install -y libev*
rpm -ivh percona-xtrabackup-24-2.4.15-1.el6.x86_64.rpm

全备

1. xtrabackup —defaults-file=/etc/my.cnf —user=root —password=’root1234’ —parallel=4 —backup —target-dir=/backup/date "+%Y-%m-%d" 2>>/backup/backupdate "+%Y-%m-%d".log
2. xtrabackup —prepare —target-dir=/backup/date "+%Y-%m-%d" 2>>/backup/backupdate "+%Y-%m-%d".log

监控备份：
grep ‘completed OK!’ /backup/backupdate "+%Y-%m-%d".log |wc -l
等于2就好了

还原

将备份文件拷贝到目标端,清空数据和日志目录

xtrabackup —defaults-file=/etc/my.cnf —copy-back —target-dir=/backup/date "+%Y-%m-%d" 2>>/backup/restoredate "+%Y-%m-%d".log