mysqld_multi创建管理多实例

#配置文件
cat >/etc/my.cnf<<EOF
[client]
socket=/tmp/mysql.sock

[mysql]
prompt=(\u@\h) [\d]>\_
no-auto-rehash

[mysqld]
basedir=/usr/local/mysql
port=3306
user=mysql
binlog_format=row
skip-name-resolve
server-id=6
gtid-mode=on
enforce-gtid-consistency=true
log_error = mysql.err
log-slave-updates=1

[mysqld_multi]
mysqld=/usr/local/mysql/bin/mysqld_safe
mysqladmin=/usr/local/mysql/bin/mysqladmin
log=/usr/local/mysql/mysqld_multi.log

[mysqld7]
port=3307
server-id=7
datadir=/data/3307/data
socket=/data/3307/mysql.sock
log_bin=/data/3307/mysql-bin

[mysqld8]
port=3308
server-id=8
datadir=/data/3308/data
socket=/data/3308/mysql.sock
log_bin=/data/3308/mysql-bin

[mysqld9]
port=3309
server-id=9
datadir=/data/3309/data
socket=/data/3309/mysql.sock
log_bin=/data/3309/mysql-bin

[mysqld10]
port=3310
server-id=10
datadir=/data/3310/data
socket=/data/3310/mysql.sock
log_bin=/data/3310/mysql-bin
EOF

#创建目录和授权
mkdir -p /data/3306/data
mkdir -p /data/3307/data
mkdir -p /data/3308/data
mkdir -p /data/3309/data
mkdir -p /data/3310/data

chown -R mysql.mysql /data/3306
chown -R mysql.mysql /data/3307
chown -R mysql.mysql /data/3308
chown -R mysql.mysql /data/3309
chown -R mysql.mysql /data/3310

#初始化
/usr/local/mysql/bin/mysqld --initialize-insecure --basedir=/usr/local/mysql/ --datadir=/data/3306/data
/usr/local/mysql/bin/mysqld --initialize-insecure --basedir=/usr/local/mysql/ --datadir=/data/3307/data
/usr/local/mysql/bin/mysqld --initialize-insecure --basedir=/usr/local/mysql/ --datadir=/data/3308/data
/usr/local/mysql/bin/mysqld --initialize-insecure --basedir=/usr/local/mysql/ --datadir=/data/3309/data
/usr/local/mysql/bin/mysqld --initialize-insecure --basedir=/usr/local/mysql/ --datadir=/data/3310/data

#启动多实例
mysqld_multi start 7,8,9,10

#验证
mysql -S /data/3307/mysql.sock -e "show variables like 'server_id'"
mysql -S /data/3308/mysql.sock -e "show variables like 'server_id'"
mysql -S /data/3309/mysql.sock -e "show variables like 'server_id'"
mysql -S /data/3310/mysql.sock -e "show variables like 'server_id'"