mysql启动多实例_mysqld_multi启动多个mysql实例

可以管理多个帧听不同Unix套接字文件和TCP/IP端口的连接的mysqld进程。它可以启动或停止服务器，或报告它们的当前状态。

即可以管理多个实例。

之前使用mysql_safe启用多实例的方法，启动和关闭都指定配置文件，实例间是对立的，互不影响。成功的部署了多个实例主从Replication

mysql_multi多实例管理，配置简单，方便管理。

说明

实战

1.配置my.cnf文件

~]# cat /etc/my.cnf

[mysqld_multi]

mysqld = /usr/bin/mysqld_safe#根据自己的mysql目录配置，使用which command可以查询路径

mysqladmin = /usr/bin/mysqladmin

[mysqld]#之前已经正常使用的mysql实例

basedir=/usr

datadir = /data/mysql

port = 3306

server_id = 2

socket = /tmp/mysql3306.sock

skip-host-cache

skip-name-resolve

character-set-server=utf8

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

[client]

socket=/tmp/mysql3306.sock#配置client默认使用的scoket文件

#mysqld1和mysqld2是使用mysqld_multi启动的多个实例

[mysqld1]

basedir=/usr

datadir = /data/mysql1

port = 3307

server_id = 3

socket = /tmp/mysql3307.sock

skip-host-cache

skip-name-resolve

character-set-server=utf8

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

[mysqld2]

basedir=/usr

datadir = /data/mysql2

port = 3308

server_id = 3

socket = /tmp/mysql3308.sock

skip-host-cache

skip-name-resolve

character-set-server=utf8

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

注：配置文件中其他的参数跟正常的mysqld下一样根据实际需要设置即可

2.拷贝mysqld的文件到mysqld1和mysqld2对应的datadir

~]# cp -pr /data/mysql /data/mysql1

~]# cp -pr /data/mysql /data/mysql2

3.启动mysqld1和mysqld2实例--使用mysqld_multi

~]# mysqld_multi start 1

~]# mysqld_multi start 2

Usage: mysqld_multi [OPTIONS] {start|reload|stop|report} [GNR,GNR,GNR...]

ormysqld_multi [OPTIONS] {start|reload|stop|report} [GNR-GNR,GNR,GNR-GNR,...]

4.启动默认的mysql实例--使用/etc/init.d/mysql start

~]# /etc/init.d/mysql start

Starting MySQL.[OK]

5.查看已经启动的mysql实例

~]# netstat -ntpl|grep 330

tcp00 :::3306:::*LISTEN6643/mysqld

tcp00 :::3307:::*LISTEN5667/mysqld

tcp00 :::3308:::*LISTEN5666/mysqld

至此可以看到在一台机器上启动了3个实例

6.连接不同的实例，用port区分

~]# mysql -uroot -p

Enter password:

Welcome to the MySQL monitor.Commands end with ; or \g.

Your MySQL connection id is 6

Server version: 5.6.11 MySQL Community Server (GPL)

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> Ctrl-C -- exit!

Aborted

~]# mysql -uroot -p -P3307

Enter password:

Welcome to the MySQL monitor.Commands end with ; or \g.

Your MySQL connection id is 7

Server version: 5.6.11 MySQL Community Server (GPL)

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> Ctrl-C -- exit!

Aborted

~]# mysql -uroot -p -P3308

Enter password:

Welcome to the MySQL monitor.Commands end with ; or \g.

Your MySQL connection id is 8

Server version: 5.6.11 MySQL Community Server (GPL)

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>