物理备份MySQL8.0
2021-08-05 本文已影响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/
