监控mysql服务脚本

#!/bin/bash
PORT=`netstat -lnt|grep 3306|awk -F '[ :]+' ' [print $5]
if [ $PORT -eq 3306] ; then
echo " db is running"
else
/data/3306/mysql restart
fi

#!/bin/bash
PORT=`netstat -lnt|grep 3306|wc -l
if [ $PORT -eq 1] ; then
echo " db is running"
else
/data/3306/mysql restart
fi

#!/bin/bash
 MYSQL=/data/3306/mysql
 LogPath=/tmp/mysql.log
 portNum=`netstat -lnt|grep 3306|wc -l

 mysqlProcessNum=`ps -ef|grep mysqldl|grep -v grep|wc -l`

    
  if [ $portNum -eq 1 ] && [ $my sqlProcessNum -eq 2 ] ; then

      echo "db is running'else .

      $MYSQL start > $LogPath
      sleep 10

      portNum=`netstat -lnt|grep 3306|wc- l`

      mysqlProcessNum=`ps -ef|grep mysqld|grep -v grep|wc -l
      if [ $portNum -ne 1 ] && [ $my sqlProcessNum -ne 2 ] ; then
      while true
      do
         killall mysqld >/dev/null 2>&1
         [ $? ne 0] && break
          sleep 1
     done
     $MYSQL start >>&$LogPath &&  status="successful" || status="failure'



# !/bin/sh

mysqlStatus=`mysql -uroot -p'test' -S /data/3306/mysql.sock -e "select version();" >&/dev/null
if[ $?-eq 0 ];then
 echo "db is running'
 else
/data/ 3306/mysql start
fi