当前位置：首页 -> AI编程基础 -> 数据库编程

MySQL binlog 自动清理脚本(二)

2015-11-10 12:16:30 · 作者: · 浏览: 7
标签: MySQL binlog 自动 清理 脚本
LOG2}" && "${SLAVE_BINLOG1}" = "${MASTER_BINLOG}" ]]; then
? ? CURR_BINLOG="${SLAVE_BINLOG2}"
? ? ? ?
else
? ? echo Has noknown error at：`date +%F" "%H-%M-%S` >> ${LOGFILE}
? ? exit 1
fi
? ? ?
mysql -uroot -e "purge binary logs to '${CURR_BINLOG}';"
if [[ $? -eq 0 ]]; then
? ? echo Clear MySQL binlog is ok at: `date +%F" "%H-%M-%S` >> ${LOGFILE}
fi


# crontab -e


30 05 * * * /data/scripts/delete_mysql_binlog.sh >/dev/null 2>&1