mysql监控slave脚本

#!/bin/bash

# MySQL连接信息
MYSQL_USER="your_mysql_user"
MYSQL_PASS="your_mysql_password"
MYSQL_HOST="your_mysql_host"
MYSQL_PORT="your_mysql_port"

# 获取slave状态
STATUS=$(mysql -u$MYSQL_USER -p$MYSQL_PASS -h$MYSQL_HOST -P$MYSQL_PORT -e "SHOW SLAVE STATUS\G" | grep -i "Slave_IO_Running" | awk '{print $2}')
if [ "$STATUS" == "Yes" ]; then
    echo "Slave_IO_Running: Yes"
else
    echo "Slave_IO_Running: No"
    # 发送警报
    echo "Slave_IO_Running is down. Please check the MySQL slave status." | mail -s "MySQL Slave Alert" your_email@example.com
fi

STATUS=$(mysql -u$MYSQL_USER -p$MYSQL_PASS -h$MYSQL_HOST -P$MYSQL_PORT -e "SHOW SLAVE STATUS\G" | grep -i "Slave_SQL_Running" | awk '{print $2}')
if [ "$STATUS" == "Yes" ]; then
    echo "Slave_SQL_Running: Yes"
else
    echo "Slave_SQL_Running: No"
    # 发送警报
    echo "Slave_SQL_Running is down. Please check the MySQL slave status." | mail -s "MySQL Slave Alert" your_email@example.com
fi