Monitors the script of the MySQL process, restarts if the fault occurs, and sends an Email notification if the MySQL process cannot be started.

I have contributed a script to monitor the MYSQL process. I hope it will be helpful to you.

Function:

Monitors the MYSQL process and restarts upon failure. If the MYSQL process fails to be started, an Email notification is sent.

The Code is as follows:

1. #! /Bin/bash
2. #/Usr/bin/nmap localhost | grep3306
3. # Lsof-I:3306
4. MYSQLPORT = 'netstat-na | grep"LISTEN"| Grep"3306"| Awk-F [:""] +'{Print $5 }''
6. Function checkMysqlStatus (){
7. /Usr/bin/mysql-uroot-p11111 -- connect_timeout =5-E"Show databases ;"&>/Dev/Null 2> &1
8. If[$? -Ne0]
9. Then
10. RestartMysqlService
11. If["$ MYSQLPORT"="3306"]; Then
12. Echo"Mysql restart successful ......"
13. Else
14. Echo"Mysql restart failure ......"
15. Echo"Server: $ MYSQLIP mysql is down, please try to restart mysql by manual! ">/Var/log/mysqlerr
16. # Mail-s"WARN! Server: $ MYSQLIP mysql is down"Admin@ Yourdomain. Com </var/log/mysqlerr
17. Fi
18. Else
19. Echo"Mysql is running ..."
20. Fi
21. }
23. Function restartMysqlService (){
24. Echo"Try to restart the mysql service ......"
25. /Bin/ps aux | grep mysql | grep-v grep | awk'{Print $2 }'| Xargs kill-9
26. Service mysql start
27. }
29. If["$ MYSQLPORT"="3306"]
30. Then
31. CheckMysqlStatus
32. Else
33. RestartMysqlService
34. Fi

We recommend that you run the task every 10 minutes.
*/10 * root/bin/sh/root/mysql_status.sh

Principle:

1) Check whether port 3306 of MYSQL is normal;

2) use the account to connect to the database and execute the show databases command;

3) if the above two points work properly, the database is running normally.

In addition, you can monitor the MYAQL port in three ways:

1)/usr/bin/nmap localhost | grep 3306

2) lsof-I: 3306

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

The third type is used here. Note: The operating systems '{print $5}' may be different. Please test them on your own. If you use the first method, you need to install nmap.