利用python来检查mysql的主从复制，
有一个注意点是，cur.execute(“show slave status;”) 不能用cur.execute(“show slave status\g;”)
result = cur.fetchall()
返回的是个二元数组
result[0] 返回时整个show slave status 状态信息。
result[0][n] 返回具体的某一项。
python代码如下：
#!/usr/bin/env python
#-*- coding: utf-8 -*-
import mysqldb, socket, paramiko,sys, os,datetime
def final_check_mysql ():
status = true
try:
conn=mysqldb.connect(host=’192.168.3.10′,user=’root’,passwd=’xp29at5f37′,db=’test’)
cur=conn.cursor()
cur.execute(“show slave status;”)
result = cur.fetchall()
io_thread= result[0][10]
sql_thread= result[0][11]
print io_thread,sql_thread
cur.close()
conn.close()
except exception,e:
print exception,”:”,e
status = true
try:
if io_thread == “yes” and sql_thread == “yes”:
print ‘mysql master/slave replication status is successfully’
else:
print ‘mysql master/slave replication fail,please check it’
status = false
except exception,e:
print exception,”:”,e
#return status
go=final_check_mysql()
以上就是使用python监控mysql的主从复制的方法的详细内容，更多请关注 第一php社区 其它相关文章！