Develop scripts to monitor MySQL database

Operating system: CentOS release 6.8 (Final)

[Email protected] chapter7]# VI mysql_method.sh

Echo method1------------

if [' lsof-i tcp:3306|wc-l '-gt 0] #通过过虑端口号来取值判断

Then

echo "MySQL is Running."

Else

echo "MySQL is Stopped."

/etc/init.d/mysqld start

Fi

Echo Method2----------------------

If [' Netstat-lntup|grep mysqld|wc-l '-gt 0] #通过过滤进程名来取值判断

Then

echo "MySQL is Running."

Else

echo "MySQL is Stopped."

/etc/init.d/mysqld start

Fi

Echo method3-------------------------

if [' Ps-ef|grep-v grep|grep mysql|wc-l '-gt 0] #通过传统的方式来判断

Then

echo "MySQL is Running."

Else

echo "MySQL is Stopped."

/etc/init.d/mysqld start

Fi

This article is from the "sky9890" blog, make sure to keep this source http://sky9896.blog.51cto.com/2330653/1946270

Develop scripts to monitor MySQL database