1、编辑my.cnf文件增加相关参数如下
[mysqld_multi]
user=root
pass=123
mysqld = /usr/local/mysql/bin/mysqld_safe
mysqladmin=/usr/local/mysql/bin/mysqladmin
log = /usr/local/mysql/multi.log

[mysqld1]
datadir=/data1
socket=/tmp/mysql.sock1
port=3306
#user=root
#skip-grant-tables
#password=123
performance_schema=off
innodb_buffer_pool_size=32M
bind_address=0.0.0.0
skip_name_resolve

[mysqld2]
datadir=/data2
socket=/tmp/mysql.sock2
port=3307
#user=root
#skip-grant-tables
#password="123"
performance_schema=off
innodb_buffer_pool_size=32M
bind_address=0.0.0.0
skip_name_resolve

2、初始化数据文件
[root@host1 mysql]# bin/mysqld --initialize --user=mysql --datadir=/data1
[root@host1 mysql]# bin/mysqld --initialize --user=mysql --datadir=/data2
3、启动多实例
[root@host1 mysql]# mysqld_multi start
4、查看实例启动情况
[root@host1 mysql]# mysqld_multi report
Reporting MySQL servers
MySQL server from group: mysqld1 is running
MySQL server from group: mysqld2 is running
MySQL server from group: mysqld3 is running
MySQL server from group: mysqld4 is running

5、停止多实例库(如果在参数文件中没有增加红色标注部分则用下列命令停止多实例)
[root@host1 mysql]# mysqld_multi stop 1 -u root -p 123
[root@host1 mysql]# mysqld_multi report
Reporting MySQL servers
MySQL server from group: mysqld1 is not running
MySQL server from group: mysqld2 is running
MySQL server from group: mysqld3 is running
MySQL server from group: mysqld4 is running
[root@host1 mysql]#
（如果增加了红色标注部分则可直接使用 mysqd_multi stop 1）
至此多实例安装完成（注意添加的参数是在已有的单实例库参数文件中添加）

ITPub博客

mysql多实例安装

最新文章