Second, installation configuration MYSQL5.6 Multi-instance - shared configuration file Methods
1, if you have already run a single instance of the database, please first stop the library
[Email protected] ~]# mysqladmin shutdown-u root-p
Enter Password:
2. Create data directory for each instance
[Email protected] ~]# mkdir/home/mysql/data3307
[Email protected] ~]# mkdir/home/mysql/data3308
3, modify the owner of each instance data directory
[Email protected] ~]# chown-r mysql.mysql/home/mysql/data3307
[Email protected] ~]# chown-r mysql.mysql/home/mysql/data3308
4. Verifying Data Catalog
[Email protected] ~]# cd/home/mysql/
[email protected] mysql]# LL
Total 12
Drwxr-xr-x 5 mysql mysql 4096 Nov 5 23:44 data
Drwxr-xr-x 2 mysql mysql 4096 Nov 5 23:58 data3307
Drwxr-xr-x 2 mysql mysql 4096 Nov 5 23:58 data3308
[Email protected] mysql]#
5. Modify The my.cnf master configuration file
[[email protected] MySQL] #cp/etc/my.cnf/etc/my.cnf.bak
[[email protected] MySQL] #vim/etc/my.cnf
[Mysqld]
#basedir =/usr/local/mysql
#datadir =/home/mysql/data
#socket =/usr/local/mysql/mysqld.sock
#port =3306
#server_id =100
user = MySQL
Join_buffer_size = 128M
Sort_buffer_size = 2M
Read_rnd_buffer_size = 2M
Default_storage_engine = InnoDB
Join_buffer_size = 128M
max_allowed_packet= 1M
Net_buffer_length= 8K
[Mysqld_multi]
Mysqld =/usr/local/mysql/bin/mysqld_safe
Mysqladmin=/usr/local/mysql/bin/mysqladmin
[mysqld3306]
Port =3306
Basedir =/usr/local/mysql
DataDir =/home/mysql/data
Socket =/home/mysql/data/mysqld.sock
server_id =1
[mysqld3307]
Port =3307
Basedir =/usr/local/mysql
DataDir =/home/mysql/data3307
Socket =/home/mysql/data3307/mysql.sock3307
server_id=2
[mysqld3308]
Port =3308
Basedir =/usr/local/mysql
DataDir =/home/mysql/data3308
Socket =/home/mysql/data3308/mysql.sock3308
Server_id=3
6. Initializing the database instance
[Email protected] mysql]#/usr/local/mysql/scripts/mysql_install_db--basedir=/usr/local/mysql--datadir=/home/ mysql/data3307--user=mysql
[Email protected] mysql]#/usr/local/mysql/scripts/mysql_install_db--basedir=/usr/local/mysql--datadir=/home/ mysql/data3308--user=mysql
7. Start the database
[Email protected] ~]# Ps-ef|grep Mysql|grep-vgrep
[[email protected] ~]# Mysqld_multi start 3306
[[email protected] ~]# Mysqld_multi start 3307
[[email protected] ~]# Mysqld_multi start 3308
8. Verifying the instance process
[Email protected] ~]# Ps-ef|grep Mysql|grep-vgrep
Root 60854 1 0 00:31 pts/0 00:00:00/bin/sh/usr/local/mysql/bin/mysqld_safe--port=3306--basedir=/usr/local/my Sql--datadir=/home/mysql/data--socket=/home/mysql/data/mysqld.sock--server_id=1
MySQL 61316 60854 0 00:31 pts/0 00:00:00/usr/local/mysql/bin/mysqld--basedir=/usr/local/mysql--datadir=/home/mysql /data--plugin-dir=/usr/local/mysql/lib/plugin--user=mysql--server-id=1--log-error=/home/mysql/data/ mysql-error.log--open-files-limit=65535--pid-file=/home/mysql/data/mysql.pid--socket=/home/mysql/data/ Mysqld.sock--port=3306
Root 61348 1 0 00:31 pts/0 00:00:00/bin/sh/usr/local/mysql/bin/mysqld_safe--port=3307--basedir=/usr/local/my sql--datadir=/home/mysql/data3307--socket=/home/mysql/data3307/mysql.sock3307--server_id=2
MySQL 61810 61348 0 00:31 pts/0 00:00:00/usr/local/mysql/bin/mysqld--basedir=/usr/local/mysql--datadir=/home/mysql /data3307--plugin-dir=/usr/local/mysql/lib/plugin--user=mysql--server-id=2--log-error=/home/mysql/data/ mysql-error.log--open-files-limit=65535--pid-file=/home/mysql/data3307/mysql.pid--socket=/home/mysql/data3307/ mysql.sock3307--port=3307
Root 61841 1 0 00:31 pts/0 00:00:00/bin/sh/usr/local/mysql/bin/mysqld_safe--port=3308--basedir=/usr/local/my sql--datadir=/home/mysql/data3308--socket=/home/mysql/data3308/mysql.sock3308--server_id=3
MySQL 62303 61841 0 00:31 pts/0 00:00:00/usr/local/mysql/bin/mysqld--basedir=/usr/local/mysql--datadir=/home/mysql /data3308--plugin-dir=/usr/local/mysql/lib/plugin--user=mysql--server-id=3--log-error=/home/mysql/data/ Mysql-error.log--open-files-limit=65535--pid-file=/home/mysql/data3308/mysql.pid--socket=/home/mysql/data3308/ mysql.sock3308--port=3308
[Email protected] ~]#
9. Verify the Port
[Email protected] ~]# Netstat-tunlp|grep 330
TCP 0 0::: 3307:::* LISTEN 61810/mysqld
TCP 0 0::: 3308:::* LISTEN 62303/mysqld
TCP 0 0::: 3306:::* LISTEN 61316/mysqld
[Email protected] ~]# Ss-tunlp|grep 330
TCP LISTEN 0::: 3307:::* Users: (("mysqld", 61810,12))
TCP LISTEN 0::: 3308:::* Users: (("mysqld", 62303,12))
TCP LISTEN 0::: 3306:::* Users: (("mysqld", 61316,12))
[Email protected] ~]#
9, login 3306,3307,3308 instances
Mysql-uroot-p-s/home/mysql/data/mysqld.sock
mysql-s/home/mysql/data3307/mysql.sock3307
Mysql-s/home/mysql/data3307/mysql.sock3308
mysql> status;
8. Stop the database
[[email protected] ~]# Mysqld_multi stop 3306
[[email protected] ~]# Mysqld_multi stop 3307
[[email protected] ~]# Mysqld_multi stop 3308
[Email protected] ~]# Ps-ef|grep Mysql|grep-vgrep
Root 57734 1 0 00:23 pts/0 00:00:00/bin/sh/usr/local/mysql/bin/mysqld_safe--port=3306--basedir=/usr/local/my SQL--datadir=/home/mysql/data--socket=/usr/local/mysql/mysqld.sock--server_id=100
MySQL 58196 57734 0 00:23 pts/0 00:00:00/usr/local/mysql/bin/mysqld--basedir=/usr/local/mysql--datadir=/home/mysql /data--plugin-dir=/usr/local/mysql/lib/plugin--user=mysql--server-id=100--log-error=/home/mysql/data/ mysql-error.log--open-files-limit=65535--pid-file=/home/mysql/data/mysql.pid--socket=/usr/local/mysql/ Mysqld.sock--port=3306
[Email protected] ~]#
We found 3306 The instance has not stopped, this is because 3306 database is configured with [email protected] the password is 123456 , you must use Root user and password to stop
[Email protected] ~]# Mysqld_multi stop 3306--user=root--password=123456
Note: 3307 , 3308 The instance does not have a password login, and the empty password account is not deleted, not secure, to configure password login and delete the empty password account
This article is from "David's operation and maintenance of private cuisine" blog, please be sure to keep this source http://dawei2015.blog.51cto.com/140637/1710078
Second, installation configuration MYSQL5.6 multi-instance-shared profile method