mysqlreport 主从切换

#!/bin/bash

# 定义主从数据库的连接信息
MASTER_HOST="master_host"
SLAVE_HOST="slave_host"
USER="replication_user"
PASSWORD="password"

# 检查主数据库状态
echo "Checking master status..."
mysql -h $MASTER_HOST -u $USER -p$PASSWORD -e "SHOW MASTER STATUS" > /dev/null 2>&1
if [ $? -ne 0 ]; then
    echo "Master is down, initiating failover..."
    
    # 停止从数据库的复制
    mysql -h $SLAVE_HOST -u $USER -p$PASSWORD -e "STOP SLAVE;"
    
    # 将从数据库提升为主数据库
    mysql -h $SLAVE_HOST -u $USER -p$PASSWORD -e "RESET MASTER;"
    mysql -h $SLAVE_HOST -u $USER -p$PASSWORD -e "CHANGE MASTER TO MASTER_HOST='$SLAVE_HOST', MASTER_USER='$USER', MASTER_PASSWORD='$PASSWORD', MASTER_AUTO_POSITION=1;"
    mysql -h $SLAVE_HOST -u $USER -p$PASSWORD -e "START SLAVE;"
    
    echo "Failover completed, $SLAVE_HOST is now the new master."
else
    echo "Master is up and running."
fi