mysql 多实例安装（单配置文件）

环境基于linux安装mysql源码进行配置：

Linux 源码安装mysql：http://blog.youkuaiyun.com/yang_xu_1987/article/details/77648225

1、初始化实例数据库

/usr/local/mysql/scripts/mysql_install_db --user=mysql --datadir=/usr/local/var/mysql1 --basedir=/usr/local/mysql
/usr/local/mysql/scripts/mysql_install_db --user=mysql --datadir=/usr/local/var/mysql2 --basedir=/usr/local/mysql

2、对相应文件授权

chown -R mysql:mysql /usr/local/var/mysql1    
chown -R mysql:mysql /usr/local/var/mysql2  

3、修改配置文件

cd /tmp/mysql-5.5.24/support-files/
mysqld_multi --example > /etc/mysqld_multi.cnf

vi /etc/mysqld_multi.cnf

--------------------

[mysqld_multi]
mysqld     = /usr/local/mysql/bin/mysqld_safe
mysqladmin = /usr/local/mysql/bin/mysqladmin 
user       = mysql


[mysqld1]
socket     = /usr/local/var/mysql1/mysql1.sock
port       = 3307
pid-file   = /usr/local/var/mysql1/mysql1.pid 
datadir    = /usr/local/var/mysql1
user       = mysql


[mysqld2]
socket     = /usr/local/var/mysql2/mysql2.sock
port       = 3308
pid-file   = /usr/local/var/mysql2/mysql2.pid
datadir    = /usr/local/var/mysql2
user       = mysql

--------------------

启动多实例数据库（可指定1，2，3。。。）：
mysqld_multi --defaults-extra-file=/etc/mysqld_multi.cnf start

停止：通过指定sock，输入密码
mysqladmin -uroot --socket=/usr/local/var/mysql1/mysql1.sock -p shutdown

查看数据库状态
mysqld_multi --defaults-extra-file=/etc/mysqld_multi.cnf report

通过sock文件登录对应数据库：
mysql -uroot -p -S /usr/local/var/mysql1/mysql1.sock