mysql5.7 centos7 xtrabackup步骤 wget https://downloads.percona.com/downloads/Percona-XtraBackup-2.4/Percona-XtraBackup-2.4.28/binary/redhat/7/x86_64/percona-xtrabackup-24-2.4.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
脚本
#!/bin/bash TODAY=`date +%Y%m%d` last_week=`date --date="$d3-7 day" +%Y-%m-%d` #cd /home/bak cd /airflow/mysqlbak #nohup innobackupex --defaults-file=/data/mysql_3306_bi/my.cnf --user=root --password=*** /home/bak 2>&1 & nohup innobackupex --defaults-file=/etc/my.cnf --user=root --password="0" /airflow/mysqlbak 2>&1 & mv nohup.out ${TODAY}.out rm -rf /home/bak/${last_week}*
0 2 * * * source /etc/profile ; /bin/bash -x /root/scripts/bak.sh >> /tmp/bak.log