使用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