mysql主从同步监控代码

以下是一个用Python编写的MySQL主从同步监控脚本：

import pymysql
import time

# 主库信息
master_host = 'master_host'
master_port = 3306
master_user = 'master_user'
master_password = 'master_password'

# 从库信息
slave_host = 'slave_host'
slave_port = 3306
slave_user = 'slave_user'
slave_password = 'slave_password'

# 连接主库和从库
master_conn = pymysql.connect(
    host=master_host,
    port=master_port,
    user=master_user,
    password=master_password
)
slave_conn = pymysql.connect(
    host=slave_host,
    port=slave_port,
    user=slave_user,
    password=slave_password
)

while True:
    try:
        # 获取主库和从库的binlog位置
        with master_conn.cursor() as master_cursor:
            master_cursor.execute('SHOW MASTER STATUS')
            master_result = master_cursor.fetchone()
            master_file = master_result[0]
            master_pos = master_result[1]
        with slave_conn.cursor() as slave_cursor:
            slave_cursor.execute('SHOW SLAVE STATUS')
            slave_result = slave_cursor.fetchone()
            slave_file = slave_result[5]
            slave_pos = slave_result[6]
        # 检查主从同步是否正常
        if master_file == slave_file and master_pos == slave_pos:
            print('MySQL主从同步正常')
        else:
            print('MySQL主从同步异常')
        # 每10秒检查一次主从同步状态
        time.sleep(10)
    except Exception as e:
        print('MySQL主从同步监控异常：', e)

运行这个脚本后，它会每隔10秒检查一次MySQL主从同步状态，如果发现同步异常，就会打印出异常信息。可以根据需要将异常信息发送到指定的管理人员手机或电子邮箱中，以便及时处理。