MySQL master-slave synchronization, monitoring slave database running status scripts

Add a script to monitor the slave database running status in the MYSQL master-slave synchronization configuration.

The Code is as follows:

1. #! /Bin/bash
2. # Check MySQL Slave's Runnning Status
3. # Crontab time00:10
5. MYSQLPORT = 'netstat-na | grep"LISTEN"| Grep"3306"| Awk-F [:""] +'{Print $5 }''
6. MYSQLIP = 'ifconfig eth0 | grep"Inet addr"| Awk-F [:""] +'{Print $4 }''
7. STATUS = $ (/usr/bin/mysql-uroot-p11111-S/var/lib/mysql. sock-e"Show slave status \ G"| Grep-I"Running")
8. IO_env = 'echo $ STATUS | grep IO | awk'{Print $2 }''
9. SQL _env = 'echo $ STATUS | grep SQL | awk'{Print $2 }''
10. DATA = 'date +"% Y-% m-% d % H: % M: % S"'
12. Function checkMysqlStatus (){
13. If["$ MYSQLPORT"="3306"]
14. Then
15. /Usr/bin/mysql-uroot-p11111 -- connect_timeout =5-E"Show databases ;"&>/Dev/Null 2> &1
16. If[$? -Ne0]
17. Then
18. Echo"Server: $ MYSQLIP mysql is down, please try to restart mysql by manual! ">/Var/log/mysqlerr
19. Mail-s"WARN! Server: $ MYSQLIP mysql is down ."Admin@ Yourdomain. Com </var/log/mysqlerr
20. Else
21. Echo"Mysql is running ..."
22. Fi
23. Else
24. Mail-s"WARN! Server: $ MYSQLIP mysql is down ."Admin@ Yourdomain. Com
25. Fi
26. }
28. CheckMysqlStatus
30. If["$ IO_env"="Yes"-"$ SQL _env"="Yes"]
31. Then
32. Echo"MySQL Slave is running! "
33. Else
34. Echo"######## $ DATA #########">/Data/mysql/mysql_slave_status.log
35. Echo"MySQL Slave is not running! ">/Data/mysql/mysql_slave_status.log
36. Echo"MySQL Slave is not running! "| Mail-s"WARN! $ MYSQLIP MySQL Slave is not running ."Admin@ Yourdomain. Com
37. Fi

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

Principle:

1) Monitor the running status of MYSQL;
2) The IO and SQL statuses of the Server Load balancer must be YES;

Note: use it in combination with your actual environment.