MySQL数据库-分库分表备份(邮件推送通知)

公司新项目上线，今天建立全网备份，现在这记录的是mysql部分
备份方式：全备+binlog
备份地点：本地+异地
备份时间：每日0点，切割binlog日志

1、环境介绍

[root@db01 ~]# cat /etc/redhat-release 
CentOS Linux release 7.5.1804 (Core) 

2、脚本存放目录

[root@db01 ~]# mkdir -p /server/scripts

[root@db01 ~]# vim /server/scripts/mysqlbackup.sh

3、编写脚本内容

#!/bin/bash
#---------------------------------------------------------
# $Name:         mysqlbackup.sh
# $Version:      v1.0
# $Create Date:  2018-11-25
# $Description:  Mysql backup script
#---------------------------------------------------------

#source /etc/init.d/functions
DAY=`date +%Y-%m-%d\-%H-%M`
BACK_DIR="/data/backup/mysql/dump"
DBUSER="root"
DBPASSWD="123456"
BIN_PATH="/usr/local/mysql/bin"
LOG="/var/log/mysqlback.log"
CKLOG="/var/log/bkmd5-"$DAY".log"

ntpdate asia.pool.ntp.org

## Close all tables and refresh log ####
"$BIN_PATH"/mysql -u "$DBUSER" -p"$DBPASSWD" -e "fl