大江 小舍
jiang_ocean
全部博文(26)
mail service(1)
2010年(26)
分类:
2010-02-22 10:16:22
#!/bin/bash######################################################### FILE:slave_db_bak.sh# DATE:2010-02-07# SUMMARY:backup local DB with mysqldump# CREATOR:########################################################CMDPATH=/usr/local/mysql/binL_DATE=$(date +%F)HOST=$(cat /proc/sys/kernel/hostname)DATA_PATH=/data/backupLOG=$DATA_PATH/${HOST}-mysql-backup.logPASSWD='#!'COM="$CMDPATH/mysqldump -uroot -p${PASSWD} --single-transaction --hex-blob --all-database"#Check DATA_PATH ,if not exist then make it.[[ -d $DATA_PATH ]] || mkdir -p $DATA_PATH#Check slave status.STATUS1=$($CMDPATH/mysql -uroot -p${PASSWD} -e "show slave status\G" | grep -E -c 'Slave_IO_Running: Yes')STATUS2=$($CMDPATH/mysql -uroot -p${PASSWD} -e "show slave status\G" | grep -E -c 'Slave_SQL_Running: Yes')if [[ $STATUS1 -eq 1 ]] && [[ $STATUS2 -eq 1 ]]then echo "Slave is ok,wait seconds......" ($COM > $DATA_PATH/${HOST}-all-${L_DATE}-$(date +%H%M%S).sql && echo "$L_DATE $(date +%T) Backup is ok!" >> $LOG || echo "$L_DATE $(date +%T) Backup error!" >> $LOG) echo "Mysql Backup complete."else [[ $STATUS1 -eq 0 ]] && [[ $STATUS2 -eq 1 ]] && echo "$L_DATE $(date +%T) Slave IO Running error!" >> $LOG [[ $STATUS1 -eq 1 ]] && [[ $STATUS2 -eq 0 ]] && echo "$L_DATE $(date +%T) Slave SQL Running error!" >> $LOG [[ $STATUS1 -eq 0 ]] && [[ $STATUS2 -eq 0 ]] && echo "$L_DATE $(date +%T) Slave SQL & IO Running error!" >> $LOGfi
上一篇:初试 perl mysql DBI
下一篇:/proc/stat 的解释
登录 注册