mysql8.0 centos7 xtrabackup步骤
wget https://downloads.percona.com/downloads/Percona-XtraBackup-8.0/Percona-XtraBackup-8.0.33-28/binary/redhat/7/x86_64/percona-xtrabackup-80-8.0.33-28.1.el7.x86_64.rpm
yum install cmake gcc gcc-c++ libaio libaio-devel automake autoconf bzr
yum -y install perl perl-devel libaio libaio-devel perl-Time-HiRes perl-DBD-MySQL perl-Digest-MD5
yum -y install libev
grant BACKUP_ADMIN on *.* to 'root'@'%';
flush privileges;
xtrabackup --user=root --host=10.5.250.58 --password='***' --backup --export --history --compress --parallel=4 --compress-threads=4 --target-dir=/home/bak/tmp/full
xtrabackup --user=root --password=0Pk(8FiiJYNBA --backup --target-dir=/home/bak
#!/bin/bash
TODAY=`date +%Y%m%d`
last_week=`date --date="$d3-7 day" +%Y-%m-%d`
cd /home/bak
nohup xtrabackup --user=root --password="***" --backup --target-dir=/home/bak/$TODAY 2>&1 &
mv nohup.out ${TODAY}.out
rm -rf /home/bak/${last_week}*
