Python code used to monitor the status of MySQLMasterSlave. if you need it, refer to the following code:
Import OS
Import sys
Import MySQLdb
Def getStatus (conn ):
Query = "show slave status"
# Print query
Cursor = conn. cursor ()
Cursor.exe cute (query)
Result = cursor. fetchall ()
Return result [0]
Def resolve (conn ):
Cursor = conn. cursor ()
Query1 = "set global SQL _slave_skip_counter = 1"
Query2 = "start slave"
Query3 = "show slave status"
Cursor.exe cute (query1)
Cursor.exe cute (query2)
Cursor.exe cute (query3)
Conn. commit ()
If _ name _ = '_ main __':
Conn = MySQLdb. connect (read_default_file = "~ /. My. cnf ", db =" ", port = 3306, charset =" utf8 ")
Status = getStatus (conn)
Print "Master_Log_File: % s" % status [5]
Print "Read_Master_Log_Pos: % s" % status [6]
Print "Seconds_Behind_Master: % s" % status [-1]
If status [32] is None:
Resolve (conn)
Else:
Print 'refreshed'