客服电话
APP下载
迪恩网络APP
随时随地掌握行业动态
官方微信
扫描二维码
关注迪恩网络微信公众号
|
本文实例讲述了centos7环境下创建mysql5.6多实例的方法。分享给大家供大家参考，具体如下： 一、mysql安装目录说明 mysql5.6以二进制安装包安装在/data/mysql56下 二、多实例目录说明
> mkdir -p /mysql-instance/3308/data > mkdir -p /mysql-instance/3309/data 三、复制配置文件到实例目录下 > 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 五、创建mysql多实例启动文件 > vi /mysql-instance/3308/mysql > vi /mysql-instance/3309/mysql
#!/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用户目录权限 > chown -R mysql.mysql /mysql-instance > chmod 700 /mysql-instance/3308/mysql > chmod 700 /mysql-instance/3309/mysql 七、初始化mysql多实例数据库文件 > 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多实例 > /mysql-instance/3308/mysql start > /mysql-instance/3309/mysql start > netstat -lntup|grep 330 九、登陆mysql实例 > mysql -uroot -p -S /mysql-instance/3308/mysql.sock 更多关于MySQL相关内容感兴趣的读者可查看本站专题：《MySQL查询技巧大全》、《MySQL常用函数大汇总》、《MySQL日志操作技巧大全》、《MySQL事务操作技巧汇总》、《MySQL存储过程技巧大全》及《MySQL数据库锁相关技巧汇总》 希望本文所述对大家MySQL数据库计有所帮助。 |
请发表评论