Zabbix monitors the Master/Slave status of MySQL (Python script)

1. Place the check script on the monitored machine (Mysql Slave:

/Usr/local/zabbix/bin/check_mysql_repl.py

1. #! /Usr/bin/python
2. # Coding: UTF-8
4. Import MySQLdb
5. Import sys
7. Class check_mysql_repl ():
8. Def _ init _ (self ):
9. Self. dbhost = 'localhost'
10. Self. dbuser = 'root'
11. Self. dbpass = 'wisp888'
12. Self. dbport = 3306
13. Self. sock = "/data/db_misc/mysql_3306.sock"
15. Self. conn = MySQLdb. connect (unix_socket = self. sock) # connect based on the actual situation
16. Self. cursor = self. conn. cursor (cursorclass = MySQLdb. cursors. DictCursor)
17. Self. SQL = 'show slave status'
18. Self.cursor.exe cute (self. SQL)
19. Self. data = self. cursor. fetchall ()
20. Self. io = self. data [0] ['slave _ io_running']
21. Self. SQL = self. data [0] ['slave _ SQL _running']
22. Self. conn. close ()
24. Def get_io_status (self ):
25. Ifself. io = 'yes ':
26. Return1
27. Else:
28. Return0
30. Def get_ SQL _status (self ):
31. Ifself. io = 'yes ':
32. Return1
33. Else:
34. Return0
37. If _ name _ = "_ main __":
38. If len (sys. argv )! = 2:
39. Print "Usage: % s [io | SQL]" % sys. argv [0]
40. Sys. exit (1)
41. Mysql = check_mysql_repl ()
42. If sys. argv [1] = "io ":
43. Print mysql. get_io_status ()
44. Elif sys. argv [1] = "SQL ":
45. Print mysql. get_ SQL _status ()

2. Configure zabbix_agent.conf and add the Key and monitoring script:

Vi/usr/local/zabbix/etc/zabbix_agentd.conf. Add the following two lines at the end of the file:

UserParameter = mysql. repl_io,/usr/local/zabbix/bin/check_mysql_repl.py io UserParameter = mysql. repl_ SQL,/usr/local/zabbix/bin/check_mysql_repl.py SQL

UserParameter is fixed

Mysql. repl_io is the custom Key, which is used when the metric item is added below

/Usr/local/zabbix/bin/check_mysql_repl.py io is the above script and Parameter

Restart zabbix_agentd

3. Add metric items:

4. Add a trigger:

This trigger is used to trigger an alarm if the returned value of the script is not 1.

This is a simple master-slave monitoring configuration !~~