mysql 多实例启动脚本

#!/bin/bash

# 定义实例目录和配置文件路径
INSTANCES=("instance1" "instance2")
CONFIG_FILES=("/etc/mysql1.cnf" "/etc/mysql2.cnf")

# 启动实例
start_instances() {
    for i in "${!INSTANCES[@]}"; do
        echo "Starting MySQL instance ${INSTANCES[$i]}..."
        mysqld_safe --defaults-file="${CONFIG_FILES[$i]}" &
    done
}

# 停止实例
stop_instances() {
    for i in "${!INSTANCES[@]}"; do
        echo "Stopping MySQL instance ${INSTANCES[$i]}..."
        mysqladmin -S /var/run/mysqld/${INSTANCES[$i]}.sock shutdown
    done
}

# 根据参数执行相应操作
case "$1" in
    start)
        start_instances
        ;;
    stop)
        stop_instances
        ;;
    restart)
        stop_instances
        start_instances
        ;;
    *)
        echo "Usage: $0 {start|stop|restart}"
        exit 1
        ;;
esac

exit 0