使用python寫一個監(jiān)控mysql的腳本，在zabbix web上加上模板：

##先使用MySQLdb的接口關聯(lián)數(shù)據(jù)庫。

[root@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)

假如執(zhí)行測試時報以下錯誤：

[root@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)")

執(zhí)行以下命令可以解決：

[root@cml python]# mkdir /var/lib/mysql

[root@cml python]# ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock

##測試一下腳本：

[root@cml python]# python check_Mysql_custom.py processlist

3

[root@cml python]# python check_Mysql_custom.py Connections

55876

##測試顯示所有在mysql中show status的都可以輸出信息出來：

##寫一個模板配置文件（自定義key值）：

[root@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值：

總結

以上是生活随笔為你收集整理的python写mysql脚本_使用python写一个监控mysql的脚本，在zabbix web上加上模板的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內容還不錯，歡迎將生活随笔推薦給好友。