判断mysql主从延迟的脚本

#!/bin/bash

# 配置参数
MASTER_HOST="master_host"
SLAVE_HOST="slave_host"
MYSQL_USER="mysql_user"
MYSQL_PASS="mysql_pass"

# 获取主库的最新二进制日志文件名和位置
MASTER_LOG_FILE=$(mysql -h$MASTER_HOST -u$MYSQL_USER -p$MYSQL_PASS -e "SHOW MASTER STATUS" | awk '/File/ {print $2}')
MASTER_LOG_POS=$(mysql -h$MASTER_HOST -u$MYSQL_USER -p$MYSQL_PASS -e "SHOW MASTER STATUS" | awk '/Position/ {print $2}')

# 获取从库的复制状态
SLAVE_STATUS=$(mysql -h$SLAVE_HOST -u$MYSQL_USER -p$MYSQL_PASS -e "SHOW SLAVE STATUS\G" | grep -i "Exec_Master_Log_Pos")

# 提取从库的执行位置
SLAVE_LOG_POS=$(echo $SLAVE_STATUS | awk -F: '{print $2}' | tr -d ' ')

# 计算延迟
if [ "$SLAVE_LOG_POS" != "" ] && [ "$MASTER_LOG_POS" != "" ]; then
    DELAY=$((MASTER_LOG_POS - SLAVE_LOG_POS))
else
    DELAY="N/A"
fi

echo "Master Log File: $MASTER_LOG_FILE"
echo "Master Log Pos: $MASTER_LOG_POS"
echo "Slave Log Pos: $SLAVE_LOG_POS"
echo "Replication Delay: $DELAY"