1.创建多实例目录并授权
mkdir /data/{3306,3307} -p chown -R mysql.mysql /data
2.创建mysql配置文件my.cnf
3306实例:
[root@DB02 ~]# cat /data/3306/my.cnf [client] port = 3306 socket = /data/3306/mysql.sock [mysqld] user = mysql port = 3306 socket = /data/3306/mysql.sock basedir = /application/mysql datadir = /data/3306/data log-bin = /data/3306/mysql-bin server-id = 6 [mysqld_safe] log-error=/data/3306/3306.err pid-file=/data/3306/mysqld.pid
3307实例:
[root@DB02 ~]# cat /data/3307/my.cnf [client] port = 3307 socket = /data/3307/mysql.sock [mysqld] user = mysql port = 3307 socket = /data/3307/mysql.sock basedir = /application/mysql datadir = /data/3307/data log-bin = /data/3307/mysql-bin server-id = 6 [mysqld_safe] log-error=/data/3307/3307.err pid-file=/data/3307/mysqld.pid
3.执行初始化脚本(部分版本会生成随机密码,请注意)
/application/mysql/scripts/mysql_install_db --defaults-file=/data/3306/my.cnf --basedir=/application/mysql --datadir=/data/3306/data --user=mysql /application/mysql/scripts/mysql_install_db --defaults-file=/data/3307/my.cnf --basedir=/application/mysql --datadir=/data/3307/data --user=mysql
4.创建错误日志文件并授权(部分版本可能需要)
touch /data/3306/3306.err touch /data/3307/3307.err chown -R mysql.mysql /data/3306/3306.err chown -R mysq.mysql /data/3307/3307.err
5.启动多实例
/application/mysql/bin/mysqld_safe --defaults-file=/data/3306/my.cnf --pid-file=/data/3306/3306.pid & /application/mysql/bin/mysqld_safe --defaults-file=/data/3307/my.cnf --pid-file=/data/3307/3307.pid &
6.多实例的登陆
mysql -S /data/3306/mysql.sock mysql -S /data/3307/mysql.sock
7.多实例停止方法
mysqladmin shutdown -S /data/3306/mysql.sock mysqladmin shutdown -S /data/3307/mysql.sock