Zabbix监控mysql Master Slave主从同步（复制）状态，附脚本
#!/usr/bin/python#coding:utf-8
import MySQLdb
import sys
class check_mysql_repl():
def __init__(self):
self.dbhost = 'localhost'
self.dbuser = 'root'
self.dbpass = 'wisp888'
self.dbport = 3306
self.sock = "/data/db_misc/mysql_3306.sock"
self.conn = MySQLdb.connect(unix_socket=self.sock) #根据实际情况连接
self.cursor = self.conn.cursor(cursorclass = MySQLdb.cursors.DictCursor)
self.sql = 'show slave status'
self.cursor.execute(self.sql)
self.data = self.cursor.fetchall()
self.io = self.data['Slave_IO_Running']
self.sql = self.data['Slave_SQL_Running']
self.conn.close()
def get_io_status(self):
if self.io == 'Yes':
return 1
else:
return 0
def get_sql_status(self):
if self.io == 'Yes':
return 1
else:
return 0
if __name__ == "__main__":
if len(sys.argv) != 2:
print "Usage: %s " % sys.argv
sys.exit(1)
mysql = check_mysql_repl()
if sys.argv == "io":
print mysql.get_io_status()
elif sys.argv == "sql":
print mysql.get_sql_status()
页:
[1]