mysql 双机切换

#!/bin/bash

# 主服务器地址
MASTER_IP="192.168.1.1"
# 从服务器地址
SLAVE_IP="192.168.1.2"

# 检查主服务器状态
check_master() {
    mysql -h $MASTER_IP -e "SHOW STATUS LIKE 'Slave_IO_Running'" | grep -q "Yes"
    if [ $? -ne 0 ]; then
        echo "Master server is down, initiating failover..."
        promote_slave
    fi
}

# 提升从服务器为主服务器
promote_slave() {
    mysql -h $SLAVE_IP -e "STOP SLAVE;"
    mysql -h $SLAVE_IP -e "RESET SLAVE ALL;"
    mysql -h $SLAVE_IP -e "CHANGE MASTER TO MASTER_HOST='$MASTER_IP', MASTER_USER='replication_user', MASTER_PASSWORD='password', MASTER_AUTO_POSITION=1;"
    mysql -h $SLAVE_IP -e "START SLAVE;"
    echo "Slave server promoted to master."
}

# 主循环
while true; do
    check_master
    sleep 10
done