1.mysql_config_editor set --login-path=cdh-mysql --user=root --host=192.168.100.200 --port=3306 --password创建用户
2.crontab 调用/home/mysql_backup/scripts/mysql_backup.sh cdh-mysql 35(保存天数)
#!/bin/bash
# name : alldb.sh
DIR="/home/mysql_backup/scripts"
LOG="/home/mysql_backup/alldb.log"
BAK_DIR="/home/mysql_backup/dbbackup"
mysql_local=$1
day_num=$2
echo "################################$(date +%F_%T) start backup #############################" >>$LOG
[[ ! -d $DIR ]] && mkdir -p $DIR
[[ ! -d $BAK_DIR ]] && mkdir -p $BAK_DIR
[[ ! -f $LOG ]] && touch $LOG
/usr/local/mysql/bin/mysqldump --login-path=$mysql_local --ssl-mode=disabled --master-data=2 --opt --quick -R --single-transaction --set-gtid-purged=off --column-statistics=0 --all-databases > ${BAK_DIR}/alldb$(date +%Y%m%d_%H%M%S)_$mysql_local.sql 2>>$LOG
if [ $? -eq 0 ];then
echo "$(date +%F_%T) $mysql_local mysql backup ok" >> $LOG
else
echo "$(date +%F_%T) $mysql_local mysql backup fail" >> $LOG
fi
#clean
find /home/mysql_backup/dbbackup -type f -mtime +$day_num -name "*$mysql_local.sql" -print0 | xargs -0 rm -f