python3 mysql同步_Python : 检查MySQL服务主从同步状态

#!/bin/python2.7

# -*- coding: UTF-8 -*-

#coding:utf-8

# created by : caiweicheng

import sys

#reload(sys)

#sys.setdefaultencoding('utf8')

from os import popen as get

# login-path 配置方式详情 : http://mp.weixin.qq.com/s?timestamp=1519973776&src=3&ver=1&signature=r1Tda4MrTdJ0iWRMCJWpqtPM0GaqsbFN0C8NM7JgQBmJQ9MfAmk7EkUvpJac7l*Rt5znamIiMt-1eJ7K7**-ugTcPz7bNRsI0ND0r3q1rBwR299sxvD5gA8chHGLKF9ZtPZcA0rcVxFptc9Yzzf1N5nrb*JE4EgEntznwUf34hc=

# 对比如下信息 是否符合规定

# Master_Log_File == Relay_Master_Log_File

# Read_Master_Log_Pos == Exec_Master_Log_Pos

# Slave_IO_Running == Yes

# Slave_SQL_Running == Yes

# 状态码描述 status : { 0:OK , 1 : WARN , 2 :CRITICAL , 3: UNKOWN }

def main(login_path) :

result=get("mysql --login-path=%s -e 'show slave status \G'"%(login_path)).read().split("\n")

slave_status = {}

for row in result :

# print row

# row = row.strip()

if ":" not in row :

continue

k , v = row.split(":" ,1)

k = k.strip()

v = v.strip()

# print( "key is " , k , "value is " , v)

slave_status[k]=v

status = 3

try :

if slave_status["Master_Log_File"] == slave_status["Relay_Master_Log_File"] and slave_status["Read_Master_Log_Pos"] == slave_status["Exec_Master_Log_Pos"] and slave_status["Slave_IO_Running"] == "Yes" and slave_status["Slave_SQL_Running"] == "Yes" :

# OK

status = 0

elif slave_status["Slave_IO_Running"] != "Yes" and slave_status["Slave_SQL_Running"] != "Yes" :

# replace slave Error

status = 2

elif slave_status["Master_Log_File"] == slave_status["Relay_Master_Log_File"] and slave_status["Read_Master_Log_Pos"] != slave_status["Exec_Master_Log_Pos"] and slave_status["Slave_IO_Running"] == "Yes" and slave_status["Slave_SQL_Running"] == "Yes" :

if int(slave_status["Read_Master_Log_Pos"]) < int(slave_status["Exec_Master_Log_Pos"])+10000 :

# OK

status = 0

else :

#Slow_Exec_Master_Log

status = 1

elif slave_status["Master_Log_File"] != slave_status["Relay_Master_Log_File"] :

#Slow_Exec_Master_Log

status = 2

except :

pass

return status

if __name__ == '__main__':

print main( sys.argv[1] )