[backcolor=white !important]#!/usr/bin/python2.7 nagios安装
[backcolor=white !important]# -*- coding:utf-8 -*-
[backcolor=white !important]from __future__ import division
[backcolor=white !important]from optparse import OptionParser
[backcolor=white !important]import commands,sys,jastme,re
[backcolor=white !important]from datetime import datetime
[backcolor=white !important]"""
[backcolor=white !important] Nagios plugin to report the mysql TPS 开源监控软件
[backcolor=white !important] author jastme
[backcolor=white !important]"""
[backcolor=white !important]parser = OptionParser(usage="%prog -w <warning threshold> -c <critical threshold> [ -h ]\n\nBefore use the script,please execute 'grant usage on *.* to monitor@'127.0.0.1' identified by 'monitor';\nflush privileges",version="%prog ")
[backcolor=white !important]
[backcolor=white !important]parser.add_option("-w", "--warning",action="store", type="string", dest="warn_threshold", help="Warning threshold in percentage")
[backcolor=white !important]
[backcolor=white !important]parser.add_option("-c", "--critical",action="store", type="string", dest="crit_threshold", help="Critical threshold in percentage")
[backcolor=white !important] nagios配置
[backcolor=white !important](options, args) = parser.parse_args()
[backcolor=white !important]try:
[backcolor=white !important] f=open('/tmp/Com_commit.txt')
[backcolor=white !important]except IOError:
[backcolor=white !important] f=open('/tmp/Com_commit.txt','w')
[backcolor=white !important] print 'wait next check,initialize the date time.txt'
[backcolor=white !important]finally:
[backcolor=white !important] f.close()
[backcolor=white !important]try:
[backcolor=white !important] f=open('/tmp/Com_rollback.txt')
[backcolor=white !important]except IOError:
[backcolor=white !important] f=open('/tmp/Com_rollback.txt','w')
[backcolor=white !important] print 'wait next check,initialize the date time.txt' 监控软件
[backcolor=white !important]finally:
[backcolor=white !important] f.close()
[backcolor=white !important]try:
[backcolor=white !important] f=open('/tmp/tpstime.txt')
[backcolor=white !important]except IOError:
[backcolor=white !important] f=open('/tmp/tpstime.txt','w')
[backcolor=white !important] print 'wait next check,initialize the date time.txt'
[backcolor=white !important]finally:
[backcolor=white !important] f.close()
[backcolor=white !important]class Monitor:
[backcolor=white !important] def __init__(self,username,password,hostname,port):
[backcolor=white !important] """ you can call sam var here """
[backcolor=white !important] self.username = username
[backcolor=white !important] self.password = password nagios实施
[backcolor=white !important] self.port = port
[backcolor=white !important] self.hostname = hostname
[backcolor=white !important] def __Com_commit(self):
[backcolor=white !important] now=commands.getoutput(''' mysql -u%s -p%s -h%s -P%s -e "show global status like 'Com_commit'" | grep -Po "\d+" ''' %(self.username,self.password,self.hostname,self.port))
[backcolor=white !important] now=re.findall(r'\d+',now)[0]
[backcolor=white !important] f=open('/tmp/Com_commit.txt','r')
[backcolor=white !important] before=f.readlines()
[backcolor=white !important] f.close()
[backcolor=white !important] if before == []:
[backcolor=white !important] ff=open('/tmp/Com_commit.txt','w')
[backcolor=white !important] ff.write(now)
[backcolor=white !important] ff.close()
[backcolor=white !important] else:
[backcolor=white !important] before=before[-1]
[backcolor=white !important] N = int(now)-int(before)
[backcolor=white !important] ff=open('/tmp/Com_commit.txt','w')
[backcolor=white !important] ff.write(now)
[backcolor=white !important] ff.close()
[backcolor=white !important] return N
[backcolor=white !important] def __Com_rollback(self):
[backcolor=white !important] now=commands.getoutput(''' mysql -u%s -p%s -h%s -P%s -e "show global status like 'Com_rollback'" | grep -Po "\d+" ''' %(self.username,self.password,self.hostname,self.port))
[backcolor=white !important] now=re.findall(r'\d+',now)[0] nagios培训
[backcolor=white !important] f=open('/tmp/Com_rollback.txt','r')
[backcolor=white !important] before=f.readlines()
[backcolor=white !important] f.close()
[backcolor=white !important] if before == []:
[backcolor=white !important] ff=open('/tmp/Com_rollback.txt','w')
[backcolor=white !important] ff.write(now)
[backcolor=white !important] ff.close()
[backcolor=white !important] else:
[backcolor=white !important] before=before[-1]
[backcolor=white !important] ff=open('/tmp/Com_rollback.txt','w')
[backcolor=white !important] ff.write(now)
[backcolor=white !important] ff.close()
[backcolor=white !important] N = int(now)-int(before)
[backcolor=white !important] return N
[backcolor=white !important] def __Uptime(self):
[backcolor=white !important] time_now=datetime.now()
[backcolor=white !important] ff=open('/tmp/tpstime.txt','r')
[backcolor=white !important] time_before_str=ff.read()
[backcolor=white !important] ff.close()
[backcolor=white !important] if time_before_str=='':
[backcolor=white !important] ffw=open('/tmp/tpstime.txt','w')
[backcolor=white !important] ffw.write(str(time_now))
[backcolor=white !important] ffw.close()
[backcolor=white !important] else:
[backcolor=white !important] time_before=datetime.strptime(time_before_str,"%Y-%m-%d %H:%M:%S.%f")
[backcolor=white !important] delay=(time_now-time_before).seconds
[backcolor=white !important] ffw=open('/tmp/tpstime.txt','w')
[backcolor=white !important] ffw.write(str(time_now))
[backcolor=white !important] ffw.close()
[backcolor=white !important] return delay
[backcolor=white !important] def doit(self):
[backcolor=white !important] _Com_commit = int(self.__Com_commit())
[backcolor=white !important] _Com_rollback = int(self.__Com_rollback())
[backcolor=white !important] _Uptime = int(self.__Uptime())
[backcolor=white !important] R = ( _Com_rollback + _Com_commit) / _Uptime
[backcolor=white !important] print "TPS is %.1f | TPS=%.1f" %(R,R)
[backcolor=white !important]if __name__ == "__main__":
[backcolor=white !important] username = "monitor"
[backcolor=white !important] password = str(jastme.decrypt(119,u'NALBOBJBCBHAGBOA'))
[backcolor=white !important] hostname = "127.0.0.1"
[backcolor=white !important] port = "3369"
[backcolor=white !important] Monitor(username,password,hostname,port).doit()
转播
分享
淘帖
()