xtrabackup自动全备份脚本

原创

于 2018-06-15 16:30:24 发布 · 1.2k 阅读

CC 4.0 BY-SA版权

xtrabackup自动全备份脚本,具有发送邮件和主从判断功能.
##set environment##
. ~/.bash_profile
BASEDIR="/data_bak"
SPACE_RATE=95 #space rate 95
SPACE_ROOM=10485760 #10GB
WORKPATH=/data_bak/mysqlbackup/percona
DATETIME=`date '+%Y%m%d%H%M'`
INNOBACKUPEX="/usr/bin/innobackupex-1.5.1"
MYSQL="/home/mysqlapp/product/bin/mysql"
BACKUP_USER="root"
BACKUP_PASSWD="******"
BACKUP_HOST="localhost"
BACKUP_PORT="3306"
DEFAULTS_FILE="/home/mysqlapp/config/my.cnf"
SOCKET="/home/mysqlapp/dbdata/mysqld.sock"
DATE_VAR=`date +%F_%H-%M-%S`

MAIL_LIST="xianyezhao@richinfo.cn"
MAIL_BIN="/home/crond/bsmtp"
MAIL_IP="*****"

#sent mail:0 error backup; 1 success backup
my_sentmail()
{
if [ $1 == 1 ]; then
echo " " | ${MAIL_BIN} -f `hostname`@139.com -h smtp.api.localdomain -s "${MAIL_IP}:Succes Innobackupex backup" ${MAIL_LIST} < ${WORKPATH}/maillog