mysql_multi管理多实例



mysql_multi 管理多实例,废话不多说，直接上操作！

1.把以下内容添加到/my.cnf 文件里面

[mysqld_multi]

mysqld = /usr/local/mysql/bin/mysqld_safe

mysqladmin = /usr/local/mysql/bin/mysqladmin

log = /opt/mysql/mysqld_multi.log

user = admin

password = admin

[mysqld3306]

port = 3306

#指定本实例相应版本的basedir和datadir

#basedir= /usr/local/mysql

datadir = /data/mysql/mysql_3306/data 

tmpdir = /data/mysql/mysql_3306/tmp/

log-bin = /data/mysql/mysql_3306/logs/mysql-bin

server-id = 23306

socket = /tmp/mysql3306.sock

 

[mysqld3307]

port = 3307

#指定本实例相应版本的basedir和datadir

#basedir= /usr/local/mysql

datadir = /data/mysql/mysql_3307/data 

tmpdir = /data/mysql/mysql_3307/tmp/

log-bin = /data/mysql/mysql_3307/logs/mysql-bin

server-id = 23307

socket = /tmp/mysql3307.sock