物理备份MySQL8.0

https://www.percona.com/downloads

wget https://downloads.percona.com/downloads/Percona-XtraBackup-LATEST/Percona-XtraBackup-8.0.25-17/binary/redhat/7/x86_64/percona-xtrabackup-80-8.0.25-17.1.el7.x86_64.rpm

yum localinstall percona-xtrabackup-80-8.0.25-17.1.el7.x86_64.rpm
#yum install libdbi-dbd-mysql

rpm -qa | grep xtrabackup
rpm -ql percona-xtrabackup-80-8.0.25-17.1.el7.x86_64

xtrabackup --version

yum provides pigz
rpm -qf which pigz

备份恢复流程

xtrabackup --defaults-file=/data/mysql/mysql3308/my3308.cnf -S /tmp/mysql3308.sock --backup--target-dir=/data/backup/db3308_full
xtrabackup --prepare --target-dir=/data/backup/db3308_full
还原到当前位置需要保持datadir ,logs下为空
xtrabackup --defaults-file=/data/mysql/mysql3308/my3308.cnf --copy-back --target-dir=/data/backup/db3308_full/