1.下载 8.0版本,移除了innobackupex命令且只能备份8.0版本的mysql
https://www.percona.com/downloads
percona-xtrabackup-80-8.0.28-21.1.el7.x86_64.rpm
2.安装
rpm -ivh percona-xtrabackup-80-8.0.28-21.1.el7.x86_64.rpm
缺少依赖:libev.so.4(需手动下载),perl(DBD::mysql),perl(Digest::MD5)
yum install -y perl-DBD-MySQL
yum install -y perl-Digest-MD5
rpm -ivh libev-4.15-3.el7.x86_64.rpm
3.验证
whereis xtrabackup
xtrabackup -v
4.备份(全备)
xtrabackup --defaults-file=/etc/my.cnf --user=root --password=b8Ak1yR7 --port=3306 -S /var/lib/mysql/mysql.sock --parallel=4 --backup --target-dir=/mnt/backup/mysql_xtra
5.备份(增量)
xtrabackup --defaults-file=/etc/my.cnf --user=root --password=abc123 --port=3306 --backup --target-dir=/backup/mysql/incrdb --incremental-basedir=/backup/mysql/fulldb
6.恢复
停止mysql: systemctl stop mysql
删除data下所有文件:rm -rf data/*
全备份准备(应用redo):xtrabackup --defaults-file=/etc/my.cnf --prepare --target-dir=/mnt/backup/mysql_xtra
恢复数据:xtrabackup --defaults-file=/etc/my.cnf --user=root --password=b8Ak1yR7 --port=3306 --datadir=/usr/local/mysql/data --copy-back --target-dir=/mnt/backup/mysql_xtra
7.启动mysql
data目录授权:chown -R mysql:mysql data/
systemctl start mysql




