使用mysqld_multi实现单系统中配置多个MySQL服务器实例(3)

cp /usr/local/src/mysql-5.1.60/support-files/mysqld_multi.server /etc/init.d/mysqld_multi.server 
 
#修改basedir和bindir为安装路径 
basedir=/usr/local/mysql 
bindir=/usr/local/mysql/bin 

6、配置多实例数据库配置文件

用mysqld_multi工具查看该配置文件的模板方法，命令为：mysqld_multi --example
在/etc/目录下创建创建文件/etc/mysqld_multi.cnf，把mysqld_multi --example产生的文件粘进去，修改相应属性，如：mysqld,mysqladmin,socket,port,pid-file,datadir,user等。

复制代码 代码如下:

[mysqld_multi] 
mysqld     = /usr/local/mysql/bin/mysqld_safe 
mysqladmin = /usr/local/mysql/bin/mysqladmin 
#user       = mysql 
#password   = my_password 
 
[mysqld1] 
socket     = /usr/local/var/mysql1/mysql1.sock 
port       = 3306 
pid-file   = /usr/local/var/mysql1/mysql1.pid 
datadir    = /usr/local/var/mysql1 
#language   = /usr/local/mysql/share/mysql/english 
user       = mysql 
 
[mysqld2] 
socket     = /usr/local/var/mysql2/mysql2.sock 
port       = 3307 
pid-file   = /usr/local/var/mysql2/mysql2.pid 
datadir    = /usr/local/var/mysql2 
#language   = /usr/local/mysql/share/mysql/english 
user       = mysql 
 
[mysqld3] 
socket     = /usr/local/var/mysql3/mysql3.sock 
port       = 3308 
pid-file   = /usr/local/var/mysql3/mysql3.pid 
datadir    = /usr/local/var/mysql3 
#language   = /usr/local/mysql/share/mysql/english 
user       = mysql 
 
[mysqld4] 
socket     = /usr/local/var/mysql4/mysql4.sock 
port       = 3309 
pid-file   = /usr/local/var/mysql4/mysql4.pid 
datadir    = /usr/local/var/mysql4 
#language   = /usr/local/mysql/share/mysql/english 
user       = mysql 

7、启动多实例数据库

复制代码 代码如下: