MySQL多实例创建及配置的步骤

下文主要给大家带来MySQL多实例创建及配置的步骤，希望这些内容能够带给大家实际用处，这也是我编辑MySQL多实例创建及配置的步骤这篇文章的主要目的。好了，废话不多说，大家直接看下文吧。3306 3307 3308多个mysqld进程（mysqld_safe）多个配置文件（port、server_id datadir log-error log-bin socket）管理多套数据（多个数据目录，分别初始化数据）创建mkdir -p /data/{3306,3307,3308}多实例：
330633073308

多个mysqld进程（mysqld_safe）
多个配置文件(portserver_iddatadirlog-errorlog-binsocket)
管理多套数据（多个数据目录，分别初始化数据）

mkdir -p {3306,3307,3308}vim/data/3306/my.cnf

[mysqld]
basedir=/application/mysql
datadir=/data/3306/data
server-id=3306
port=3306
log-bin=/data/3306/mysql-bin
socket=/data/3306/mysql.sock
log-error=/data/3306/mysql.log

vim/data/3307/my.cnf

[mysqld]
basedir=/application/mysql
datadir=/data/3307/data
server-id=3307
port=3307
log-bin=/data/3307/mysql-bin
socket=/data/3307/mysql.sock
log-error=/data/3307/mysql.log

vim/data/3308/my.cnf
[mysqld]
basedir=/application/mysql
datadir=/data/3308/data
server-id=3308
port=3308
log-bin=/data/3308/mysql-bin
socket=/data/3308/mysql.sock
log-error=/data/3308/mysql.logcd /application/mysql/scripts./mysql_install_db –defaults-file=/data/3306/my.cnf –basedir=/application/mysql –datadir=/data/3306/data –user=mysql./mysql_install_db –defaults-file=/data/3307/my.cnf –basedir=/application/mysql –datadir=/data/3307/data –user=mysql./mysql_install_db –defaults-file=/data/3308/my.cnf –basedir=/application/mysql –datadir=/data/3308/data –user=mysql/application/mysql/bin/mysqld_safe –defaults-file=/data/3306/my.cnf &/application/mysql/bin/mysqld_safe –defaults-file=/data/3307/my.cnf &/application/mysql/bin/mysqld_safe –defaults-file=/data/3308/my.cnf &[root@db02 /data/3307/data]$netstat -lnp|grep 330tcp 0 0 :::3306 :::* LISTEN 3877/mysqldtcp 0 0 :::3307 :::* LISTEN 4048/mysqldtcp 0 0 :::3308 :::* LISTEN 4219/mysqldunix 2 [ ACC ] STREAM LISTENING 18009 3877/mysqld /data/3306/mysql.sockunix 2 [ ACC ] STREAM LISTENING 18137 4048/mysqld /data/3307/mysql.sockunix 2 [ ACC ] STREAM LISTENING 18265 4219/mysqld /data/3308/mysql.sock说明：登录可以输入下面的命令或者是[root@db02 ~]$mysql -S /data/3306/mysql.sockWelcome to the MySQL monitor. Commands end with ; or g.Your MySQL connection id is 2Server version: 5.6.36-log Source distributionCopyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type ‘help;’ or ‘h’ for help. Type ‘c’ to clear the current input statement.mysql> show databases;+——————–+| Database |+——————–+| information_schema || mysql || performance_schema || test |+——————–+4 rows in set (0.18 sec)说明：以下命令也可操作：mysql -uroot -p -P3308mysql -uroot -p -S /tmp/mysql3307.sock说明：在多实例关闭的时候指定关闭的端口即可。[root@db02 /]$mysqladmin shutdown -S /data/3306/mysql.sock[root@db02 /]$ps -ef|grep 330root 1330 1 0 08:49 ? 00:00:00 /usr/sbin/acpidroot 2520 2088 0 22:25 pts/1 00:00:00 /bin/sh /application/mysql/bin/mysqld_safe –defaults-file=/data/3307/my.cnfmysql 2815 2520 0 22:25 pts/1 00:00:12 /application/mysql/bin/mysqld –defaults-file=/data/3307/my.cnf –basedir=/application/mysql –datadir=/data/3开发云主机域名307/data –plugin-dir=/application/mysql/lib/plugin –user=mysql –log-error=/data/3307/mysql.log –pid-file=/data/3307/data/db02.pid –socket=/data/3307/mysql.sock –port=3307root 2879 2088 0 22:25 pts/1 00:00:00 /bin/sh /application/mysql/bin/mysqld_safe –defaults-file=/data/3308/my.cnfmysql 3028 2879 0 22:25 pts/1 00:00:10 /application/mysql/bin/mysqld –defaults-file=/data/3308/my.cnf –basedir=/application/mysql –datadir=/data/3308/data –plugin-dir=/application/mysql/lib/plugin –user=mysql –log-error=/data/3308/mysql.log –pid-file=/data/3308/data/db02.pid –socket=/data/3308/mysql.sock –port=3308root 3288 3146 0 23:14 pts/2 00:00:00 grep 330备注：以下命令关闭MySQL数据库# mysqld_multi stop 3306# mysqld_multi stop 3307,3308,3309# ps -ef | grep mysqldroot 30822 12043 0 23:04 pts/0 00:00:00 grep mysqld对于以上关于MySQL多实例创建及配置的步骤，大家是不是觉得非常有帮助。如果需要了解更多内容，请继续关注我们的行业资讯，相信你会喜欢上这些内容的。

相关推荐: 使用GROUP_CONCAT()函数意义

下文内容主要给大家带来使用GROUP_CONCAT()函数意义，所讲到的知识，与书籍略有不同，都是开发云专业技术人员在与用户接触过程中，总结出来的，具有一定的经验分享价值，希望给广开发云主机域名大读者带来帮助。使用之前使用之后注意：GROUP_CONCAT()…