利用shell脚本监控MySQL进程-西瓜社

#!/bin/bash
 #/usr/bin/nmap localhost | grep 3306
 #lsof -i:3306
 MYSQLPORT=`netstat -na|grep "LISTEN"|grep "3306"|awk -F[:" "]+ '{print $5}'`

function checkMysqlStatus(){
 /usr/bin/mysql -uroot -p11111 --connect_timeout=5 -e "show databases;" &>/dev/null 2>&1
 if [ $? -ne 0 ]
 then
 restartMysqlService
 if [ "$MYSQLPORT" == "3306" ];then
 echo "mysql restart successful......"
 else
 echo "mysql restart failure......"
 echo "Server: $MYSQLIP mysql is down, please try to restart mysql by manual!" > /var/log/mysqlerr
 #mail -s "WARN! server: $MYSQLIP mysql is down" sys@t667.com < /var/log/mysqlerr
 fi
 else
 echo "mysql is running..."
 fi
 }

function restartMysqlService(){
 echo "try to restart the mysql service......"
 /bin/ps aux |grep mysql |grep -v grep | awk '{print $2}' | xargs kill -9
 service mysql start
 }

if [ "$MYSQLPORT" == "3306" ]
 then
 checkMysqlStatus
 else
 restartMysqlService
 fi

#!/bin/bash

#/usr/bin/nmap localhost | grep 3306

#lsof -i:3306

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

function checkMysqlStatus(){

/usr/bin/mysql -uroot -p11111 --connect_timeout=5 -e "show databases;" &>/dev/null 2>&1

if [ $? -ne 0 ]

then

restartMysqlService

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

echo "mysql restart successful......"

else

echo "mysql restart failure......"

echo "Server: $MYSQLIP mysql is down, please try to restart mysql by manual!" > /var/log/mysqlerr

#mail -s "WARN! server: $MYSQLIP mysql is down" sys@t667.com < /var/log/mysqlerr

else

echo "mysql is running..."

}

function restartMysqlService(){

echo "try to restart the mysql service......"

/bin/ps aux |grep mysql |grep -v grep | awk '{print $2}' | xargs kill -9

service mysql start

}

if [ "$MYSQLPORT" == "3306" ]

then

checkMysqlStatus

else

restartMysqlService

然后配置crontab任务即可
示例：

 */10 * * * * root /bin/sh /root/mysql.sh

1	/10 * * * root /bin/sh /root/mysql.sh

文章版权归作者所有，未经允许请勿转载。

THE END

干货分享
# mysql # shell