centos7环境下创建mysql5.6多实例的方法详解

本文实例讲述了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 = 3308 socket = /mysql-instance/3308/mysql .sock [mysql] no-auto-rehash [mysqld] user = mysql port = 3308 socket = /mysql-instance/3308/mysql .sock basedir = /data/mysql56 datadir = /mysql-instance/3308/data pid- file = /mysql-instance/3308/mysql .pid relay-log = /mysql-instance/3308/relay-bin relay-log-info- file = /mysql-instance/3308/relay-log .info server- id = 12 [mysqld_safe] log-error = /mysql-instance/3308/mysql .err pid- 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/sh port=3308 mysql_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