使用mysqld_multi管理多实例

编辑配置文件 /etc/my.cnf

[client]
port=3306
socket=/tmp/mysql.sock

[mysqld_multi]
log = /data/mysql/mysqld_multi.log

[mysqld]
user=mysql
basedir=/usr/local/mysql

[mysqld3306]
datadir=/data/mysql/3306
port=3306
server_id=3306
mysqlx_port=33061
socket=/data/mysql/3306/mysql.sock
log-error = /data/mysql/3306/error.log

[mysqld3307]
datadir=/data/mysql/3307
port=3307
server_id=3307
mysqlx_port=33062
socket=/data/mysql/3307/mysql.sock
log-error = /data/mysql/3307/error.log



初始化3306数据库 
/usr/local/mysql/bin/mysqld  --defaults-file=/etc/my.cnf  --datadir=/data/mysql/3306  --initialize --user=mysql --initialize-insecure
 
初始化3307数据库
/usr/local/mysql/bin/mysqld  --defaults-file=/etc/my.cnf  --datadir=/data/mysql/3307  --initialize --user=mysql --initialize-insecure
 
启动全部实例
mysqld_multi start
 
启动单个实例
mysqld_multi start 3306
停止单个实例
mysqld_multi stop 3306
 
查看全部实例状态
mysqld_multi report
 
查看单个实例状态
mysqld_multi report 3306