mysql主从同步与清理过期的备份数据

备份数据库
#!/bin/sh
# Database 因为数据主从同步的账户与备份的账户不同 所以需要设定两个账户 一个负责备份 一个负责开关主从
DB_NAME="database1"
DB_USER="backup_username"
DB_PASS="backup_password"
# slave user
SLAVE_USER="slave_username"
SLAVE_PASS="slave_password"
# Others vars
# whereis mysqldump
# IS ` but not '
BIN_DIR="/usr/local/mysql/bin/"
BCK_DIR="/data/backup/mysqlbackup/"
#DATE=`date +%Y%m%d_%H%M%S`
#stop slave 停止主从同步
#$BIN_DIR/mysql -u$SLAVE_USER -p$SLAVE_PASS -e "stop slave"
DATE=`date +%Y%m%d`
# TODO
mkdir -p $BCK_DIR
$BIN_DIR/mysqldump --opt -u$DB_USER -p$DB_PASS $DB_NAME \
 > $BCK_DIR/db1__$DATE.sql

#start slave 开启主从
#$BIN_DIR/mysql -u$SLAVE_USER -p$SLAVE_PASS -e "start slave"

删除前两天的备份

#!/bin/sh
find /data/backup/mysqlbackup -mtime +1 -name "db1__*" -exec rm -f {} \;
find /data/backup/mysqlbackup -mtime +1 -name "db2__*" -exec rm -f {} \;