(轉) centos7下建立mysql5.6多執行個體

標籤：index   client   ...   使用者   base   sock   二進位安裝   ber   lsp   

原文：http://blog.csdn.net/a1010256340/article/details/77483504

一、mysql安裝目錄說明
mysql5.6以二進位安裝包安裝在/data/mysql56下
資料目錄為/data/mysql56/data下
設定檔為/etc/my.cnf下

二、多執行個體目錄說明
/mysql-instance
         |-- 3308
                  |-- data  #3308執行個體資料目錄
         |-- 3309
                  |-- data  #3309執行個體資料目錄

 

12	> mkdir -p /mysql-instance/3308/data> mkdir -p /mysql-instance/3309/data

                  
三、複製設定檔到執行個體目錄下

 

12	> 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

四、修改設定檔

 

12	> vi /mysql-instance/3308/my.cnf> vi /mysql-instance/3309/my.cnf

 

123456789101112131415161718

[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多執行個體開機檔案

 

12	> vi /mysql-instance/3308/mysql> vi /mysql-instance/3309/mysql

 

123456789101112131415161718192021222324252627282930313233343536373839404142

#!/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使用者目錄許可權

 

123	> chown -R mysql.mysql /mysql-instance> chmod 700 /mysql-instance/3308/mysql> chmod 700 /mysql-instance/3309/mysql

 
七、初始化mysql多執行個體資料庫檔案

 

123	> 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多執行個體

 

123	> /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

(轉) centos7下建立mysql5.6多執行個體