使用python写一个监控mysql的脚本，在zabbix web上自定义模板

terte

                                                

##先使用MySQLdb的接口关联数据库。

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48

[iyunv@cml python]# cat check_Mysql_custom.py #!/usr/local/bin/python '''author = chenmingle''' '''Description:get mysql status''' import os import sys try:     import MySQLdb as mysql except Exception, e:     print e     print "pip install MySQL-python"     sys.exit(1) con = mysql.connect(host='localhost',user='root',passwd='passwd',) def processlist(): cur = con.cursor() sql1 = 'show processlist' a = str(cur.execute(sql1)) print a def slave_status():         cur = con.cursor()         sql2 = cur.execute('show status like "%Slave_running%";')         status2 = str(cur.fetchall())         check2 = status2.split("'")[3]         if check2 == 'ON':                 print 0         else:                 print 1 def show_status(type): cur = con.cursor() b = cur.execute('show status like "%s";' %(type)) for i in cur.fetchall(): cat = str(i) check = str(cat.split("'")[3]) print check def main(type):    if type == 'processlist': processlist()    elif type == 'slave_status': slave_status()    else: show_status(type) if __name__ == '__main__':     try:         type = sys.argv[1]     except Exception, e:         print "Usage: python %s type" % sys.argv[0]         sys.exit(1)     main(type)

假如执行测试时报以下错误：

[iyunv@cml python]# python check_Mysql_custom.py slave_status

Traceback (most recent call last):

  File "test.py", line 14, in

    con = mysql.connect(user='zabbix',passwd='',port=3306)

  File "/usr/local/lib/python2.7/site-packages/MySQLdb/__init__.py", line 81, in Connect

    return Connection(*args, **kwargs)

  File "/usr/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 193, in __init__

    super(Connection, self).__init__(*args, **kwargs2)

_mysql_exceptions.OperationalError: (2002, "Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)")

1 2	[iyunv@cml python]# mkdir /var/lib/mysql [iyunv@cml python]# ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock

##测试一下脚本：

1 2 3 4

[iyunv@cml python]# python check_Mysql_custom.py processlist 3 [iyunv@cml python]# python check_Mysql_custom.py Connections 55876

##测试显示所有在mysql中show status的都可以输出信息出来：

##写一个模板配置文件（自定义key值）：

1 2	[iyunv@cml zabbix_agentd.d]# cat Mysql_Custom.conf UserParameter=mysql.Custom,/usr/local/bin/python /home/python/check_Mysql_custom.py $1

##在zabbix web界面上加入模板：

##增加一个Appaliactions:

##加入item值：