1.准备环境
安装数据库
[root@localhost ~]# yum-y install mysql mysql-server
[root@localhost ~]# systemctl start mysqld
[root@localhost ~]# grep pass /var/log/mysql.log
[root@localhost ~]# mysqladmin -uroot -p'old-passwd' password "new-passwd"
email配置
[root@localhost ~]# yum -y install mailx
[root@localhost ~]# vi /etc/mail.rc #将下面信息填入到文件中
set from=********@qq.com
set smtp=smtp.qq.com
set smtp-auth-user=**********@qq.com
set smtp-auth-password=************ #第三方登录码
set smtp-auth=login
2.脚本解析
#!/bin/bash
#校验时间
ntpdate ntp.aliyun.com >> /dev/null
#检查是否创建目录
find /xtrabackup/ -name '*' >> /dev/null
if [[ $? -ne 0 ]];then
mkdir /xtrabackup/
fi
find /xtrabackup/log/ -name '*' >> /dev/null
if [[ $? -ne 0 ]];then
mkdir -p /xtrabackup/log
fi
#定义变量
User=root
Password=QianFeng@123
Email_num=2756375538@qq.com
#完全备份
backup_full(){
innobackupex --user=$User --password=$Password /xtrabackup/ >> /xtrabackup/log/backup.log 2>&1
}
#增量备份
backup_incremental(){
#获取前一天时间
before=$(date -d "yesterday" +%Y-%m-%d_%H)
Before_path=`find /xtrabackup/ -name "${before}*"`
innobackupex --user=$User --password=$Password --incremental /xtrabackup/ --incremental-basedir=$Before_path >> /xtrabackup/log/backup.log 2>&1
}
#差异备份
backup_differential(){
date_times=$(date +%u)
if [[ $date_times -eq 4 ]];then
before_3_days=$(date -d "3 days ago" +%Y-%m-%d_%H)
Full_path=`find /xtrabackup/ -name "${before_3_days}*"`
innobackupex --user=$User --password=$Password --incremental /xtrabackup --incremental-basedir=$Full_path >> /xtrabackup/log/backup.log 2>&1
else
before_6_days=$(date -d "6 days ago" +%Y-%m-%d_%H)
Full_path=`find /xtrabackup/ -name "${before_3_days}*"`
innobackupex --user=$User --password=$Password --incremental /xtrabackup --incremental-basedir=$Full_path >> /xtrabackup/log/backup.log 2>&1
fi
}
#定义邮件
email_worker(){
echo "数据备份失败" | mail -s "数据库备份失败" $Email_num
}
#主函数
date_time=$(date +%u)
case $date_time in
1)
backup_full
;;
2|3|5|6)
backup_incremental
;;
4|7)
backup_differential
;;
esac
if [[ $? -ne 0 ]];then
email_worker
fi