本文實(shí)例講述了centos7環(huán)境下創(chuàng)建mysql5.6多實(shí)例的方法。分享給大家供大家參考，具體如下：
一、mysql安裝目錄說明
mysql5.6以二進(jìn)制安裝包安裝在/data/mysql56下
數(shù)據(jù)目錄為/data/mysql56/data下
配置文件為/etc/my.cnf下
二、多實(shí)例目錄說明
/mysql-instance
|-- 3308
|-- data #3308實(shí)例數(shù)據(jù)目錄
|-- 3309
|-- data #3309實(shí)例數(shù)據(jù)目錄
> mkdir -p /mysql-instance/3308/data
> mkdir -p /mysql-instance/3309/data
三、復(fù)制配置文件到實(shí)例目錄下
> 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
四、修改配置文件
> vi /mysql-instance/3308/my.cnf
> vi /mysql-instance/3309/my.cnf
[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
五、創(chuàng)建mysql多實(shí)例啟動(dòng)文件
> vi /mysql-instance/3308/mysql
> vi /mysql-instance/3309/mysql
#!/bin/sh
port=3308
mysql_user="root"
#請(qǐng)?zhí)顚懽砸褦?shù)據(jù)庫密碼
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
六、授權(quán)mysql用戶目錄權(quán)限
> chown -R mysql.mysql /mysql-instance
> chmod 700 /mysql-instance/3308/mysql
> chmod 700 /mysql-instance/3309/mysql
七、初始化mysql多實(shí)例數(shù)據(jù)庫文件
> 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
八、啟動(dòng)mysql多實(shí)例
> /mysql-instance/3308/mysql start
> /mysql-instance/3309/mysql start
> netstat -lntup|grep 330
九、登陸mysql實(shí)例
> mysql -uroot -p -S /mysql-instance/3308/mysql.sock
更多關(guān)于MySQL相關(guān)內(nèi)容感興趣的讀者可查看本站專題：《MySQL查詢技巧大全》、《MySQL常用函數(shù)大匯總》、《MySQL日志操作技巧大全》、《MySQL事務(wù)操作技巧匯總》、《MySQL存儲(chǔ)過程技巧大全》及《MySQL數(shù)據(jù)庫鎖相關(guān)技巧匯總》
希望本文所述對(duì)大家MySQL數(shù)據(jù)庫計(jì)有所幫助。
您可能感興趣的文章:- MySQL多實(shí)例配置方案
- CentOS6.5 上部署 MySQL5.7.17 二進(jìn)制安裝以及多實(shí)例配置
- mysql使用mysqld_multi部署單機(jī)多實(shí)例的方法教程
- 快速實(shí)現(xiàn)MySQL的部署以及一機(jī)多實(shí)例部署
- Linux下安裝Mysql多實(shí)例作為數(shù)據(jù)備份服務(wù)器實(shí)現(xiàn)多主到一從多實(shí)例的備份
- 基于mysql多實(shí)例安裝的深入解析
- shell使用mysqld_multi自動(dòng)做多實(shí)例從庫腳本
- CentOS7.5使用mysql_multi方式安裝MySQL5.7.28多實(shí)例(詳解)
- MySQL數(shù)據(jù)庫入門之多實(shí)例配置方法詳解
