MySQL定时同步数据库脚本_定时检测mysql同步状态的shell脚本

实时检测mysql同步状态的shell脚本：

复制代码 代码示例:

#!/bin/sh

#check MySQL_Slave Status

#crontab time 00:10

MYSQL_USER="root"

MYSQL_PWD="123456"

MYSQL_SLAVE_LOG="/tmp/check_mysql_slave.log"

EMAIL="1351010****@139.com"

MYSQL_PORT=`netstat -na|grep "LISTEN"|grep "3306"|awk -F[:" "]+ '{print $5}'`

MYSQL_IP=`ifconfig eth0|grep "inet addr" | awk -F[:" "]+ '{print $4}'`

MYSQL_SLAVE_STATUS=$(/usr/local/webserver/mysql/bin/mysql -u root -psylc23hua -S /tmp/mysql.sock -e "show slave status\G" | grep -i "running")

IO_ENV=`echo $MYSQL_SLAVE_STATUS | grep IO | awk ' {print $2}'`

SQL_ENV=`echo $MYSQL_SLAVE_STATUS | grep SQL | awk '{print $2}'`

NOW=$(date -d today +'%Y-%m-%d %H:%M:%S')

if [ "$MYSQL_PORT" = "3306" ];then

echo "mysql is running!"

else

mail -s "warn!server: $MYSQL_IP mysql is down" "$EMAIL"

fi

if [ "$IO_ENV" = "Yes" -a "$SQL_ENV" = "Yes" ];then

echo "Slave is running!"

else

echo "[ $NOW ] Slave is not running!" >> "$MYSQL_SLAVE_LOG"

cat "$MYSQL_SLAVE_LOG" | mail -s "WARN! ${MySQL_IP}_replicate_error" "$EMAIL"

fi

exit 0