本文實例講述了centos7環境下創建mysql5.6多實例的方法。分享給大家供大家參考，具體如下：
一、mysql安裝目錄說明
mysql5.6以二進制安裝包安裝在/data/mysql56下
數據目錄為/data/mysql56/data下
配置文件為/etc/my.cnf下
二、多實例目錄說明
/mysql-instance
|-- 3308
|-- data #3308實例數據目錄
|-- 3309
|-- data #3309實例數據目錄
|
1
2
|
> mkdir -p /mysql-instance/3308/data> mkdir -p /mysql-instance/3309/data |
三、復制配置文件到實例目錄下
|
1
2
|
> cp /data/mysql56/support-files/my-default.cnf /mysql-instance/3308/my.cnf> cp /data/mysql56/support-files/my-default.cnf /mysql-instance/3309/my.cnf |
四、修改配置文件
|
1
2
|
> vi /mysql-instance/3308/my.cnf> vi /mysql-instance/3309/my.cnf |
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
[client]port = 3308socket = /mysql-instance/3308/mysql.sock[mysql]no-auto-rehash[mysqld]user = mysqlport = 3308socket = /mysql-instance/3308/mysql.sockbasedir = /data/mysql56datadir = /mysql-instance/3308/datapid-file = /mysql-instance/3308/mysql.pidrelay-log = /mysql-instance/3308/relay-binrelay-log-info-file = /mysql-instance/3308/relay-log.infoserver-id = 12[mysqld_safe]log-error = /mysql-instance/3308/mysql.errpid-file = /mysql-instance/3308/mysql.pid |
3309的配置同上，只需把3308的地方換成3309
五、創建mysql多實例啟動文件
|
1
2
|
> vi /mysql-instance/3308/mysql> vi /mysql-instance/3309/mysql |
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
|
#!/bin/shport=3308mysql_user="root"#請填寫自已數據庫密碼mysql_pwd="123456"cmd_path="/data/mysql56/bin"mysql_sock="/mysql-instance/${port}/mysql.sock"mysql_start() { if [ ! -e "$mysql_sock" ];then printf "mysql start ... \n" /bin/sh ${cmd_path}/mysqld_safe --defaults-file=/mysql-instance/${port}/my.cnf 2>&1 > /dev/null & else printf "mysql is running ... \n" exit fi}mysql_stop() { if [ ! -e "$mysql_sock" ];then printf "mysql is stopped ... \n" exit else printf "mysql stop ... \n" ${cmd_path}/mysqladmin -u ${mysql_user} -p${mysql_pwd} -S /mysql-instance/${port}/mysql.sock shutdown fi}mysql_restart() { printf "mysql restart ... \n" mysql_stop sleep 2 mysql_start}case $1 in start) mysql_start ;; stop) mysql_stop ;; restart) mysql_restart ;;*)printf "usage: /data/${port}/mysql {start|stop|restart}\n"esac |
六、授權mysql用戶目錄權限
|
1
2
3
|
> chown -R mysql.mysql /mysql-instance> chmod 700 /mysql-instance/3308/mysql> chmod 700 /mysql-instance/3309/mysql |
七、初始化mysql多實例數據庫文件
|
1
2
3
|
> cd /daa/mysql56/scripts> ./mysql_install_db --basedir=/data/mysql56 --datadir=/mysql-instance/3308/data --user=mysql> ./mysql_install_db --basedir=/data/mysql56 --datadir=/mysql-instance/3309/data --user=mysql |
八、啟動mysql多實例
|
1
2
3
|
> /mysql-instance/3308/mysql start> /mysql-instance/3309/mysql start> netstat -lntup|grep 330 |
九、登陸mysql實例
|
1
|
> mysql -uroot -p -S /mysql-instance/3308/mysql.sock |
希望本文所述對大家MySQL數據庫計有所幫助。
原文鏈接：https://www.cnblogs.com/jkko123/p/6358925.html
