单机启动多个MySQL实例

2017-11-22

一：利用mysql_install_db生成数据库

mysql_install_db --datadir=/var/db/my3307/data --user=mysql
mysql_install_db --datadir=/var/db/my3308/data --user=mysql

二：配置文件

vi /etc/my_multi.conf

[mysqld_multi]
[mysqld3307] 
server-id = 3307
datadir  = /var/db/my3307/data
socket = /var/db/my3307/mysql.sock
pid-file  = /var/db/my3307/mysqld.pid
log-bin	= /var/db/my3307/logs/mysql-bin.log
log-error = /var/db/my3307/logs/mysqld.log

[mysqld3308]
server-id = 3308
datadir   = /var/db/my3308/data
socket    = /var/db/my3308/mysql.sock
pid-file  = /var/db/my3308/mysqld.pid
log-bin   = /var/db/my3308/logs/mysql-bin.log
log-error = /var/db/my3308/logs/mysqld.log

三：启动

/usr/local/bin/mysqld_multi --defaults-extra-file=/etc/my_multi.cnf stop|start|report

遇到的问题：

FATAL ERROR: Could not find ./bin/my_print_defaults If you compiled from source, you need to run make install to copy the software into the correct location ready for operation. If you are using a binary release, you must either be at the top level of the extracted archive, or pass the basedir option

解决方案：

在/usr/local下执行或者指定basedir。

/usr/local/bin/mysql_install_db
--user=mysql
--basedir=/usr/local
--datadir=/var/db/my3307/data
--defaults-file=/etc/my.cnf