Monitoring the MySQL service is working

1 , processes, and ports are successful MySQL Service OK

#!/bin/bash

Port= ' netstat-ntl |grep 3306 |wc-l '

process= ' ps-ef |grep mysql |grep-v grep |wc-l '

If [$port-eq 1] && [$process-eq 2]

Then

echo "MySQL is running"

Else

/etc/init.d/mysqld start

Fi

2 , using Client login MySQL execute the command to see if the test service is started, in theory this method is the most reliable.

#!/bin/bash

Mysql-uroot-p123456-e "Selectversion ();" &>/dev/null

If [$?-ne 0]

Then

/etc/init.d/mysqld start

Else

echo "MySQL is running"

Fi

Monitoring the MySQL service is working