#!/bin/bash#check mysql_slave status#crontab time 09:00mysqlport= ' Netstat -na|grep "LISTEN" |grep "3306" |awk ' {print $4} ' |awk -f: ' {print $2} ' mysqlip= ' ifconfig|awk ' nr==2{print $2} ' |awk -f: ' {print $2} ' status=$ (mysql -hxxx - uxxx -pxxx -s /tmp/mysql.sock -e "Show slave status\g" | grep -i "Running") io_env= ' echo $STATUS | grep IO | awk ' { print $2} ' sql_env= ' echo $STATUS | grep SQL | awk ' {print $ 2} ' data= ' date + "%y-%m-%d %h:%m:%s" ' if [ "$MYSQLPORT" == "3306" ]then echo "mysql is running" else echo $MYSQLIP mysql is down " | mail -s "warn!server: $MYSQLIP mysql is down" [email protected]fiif [ "$IO_env " = yes" -a "$SQL _env" = "yes" ]then echo "Slave is running! " elseecho "slave is not running!" | mail -s "warn! $DATA $MYSQLIP MySQL Slave is not Running " [email protected]fi
This article is from the "Eight Miles" blog, so be sure to keep this source http://5921271.blog.51cto.com/5911271/1749149
MySQL Monitor from library status