监控mysql的端口脚本

root@mysql ~]# vi checkmysql.sh

#!/bin/sh

#create by mingongge at 2016-11-11

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

if [ $port -ne 1 ];then

   echo "mysql is stop"

   /etc/init.d/mysqld start

else

   echo "mysql is starting"

fi

[root@mysql ~]# sh checkmysql.sh

mysql is starting

[root@mysql ~]# pkill mysqld

[root@mysql ~]# lsof -i :3306

[root@mysql ~]# sh checkmysql.sh

mysql is stop

Starting MySQL.                                 [  OK  ]

[root@mysql ~]# lsof -i :3306  

COMMAND  PID  USER   FD   TYPE DEVICE SIZE/OFF NODE NAME

mysqld  1601 mysql   10u  IPv4  13690      0t0  TCP *:mysql (LISTEN)