1、编辑my.cnf文件增加相关参数如下
[mysqld_multi]
user=root
pass=123
mysqld = /usr/local/mysql/bin/mysqld_safe
mysqladmin=/usr/local/mysql/bin/mysqladmin
log = /usr/local/mysql/multi.log
[mysqld1]
datadir=/data1
socket=/tmp/mysql.sock1
port=3306
#user=root
#skip-grant-tables
#password=123
performance_schema=off
innodb_buffer_pool_size=32M
bind_address=0.0.0.0
skip_name_resolve
[mysqld2]
datadir=/data2
socket=/tmp/mysql.sock2
port=3307
#user=root
#skip-grant-tables
#password="123"
performance_schema=off
innodb_buffer_pool_size=32M
bind_address=0.0.0.0
skip_name_resolve
[mysqld_multi]
user=root
pass=123
mysqld = /usr/local/mysql/bin/mysqld_safe
mysqladmin=/usr/local/mysql/bin/mysqladmin
log = /usr/local/mysql/multi.log
[mysqld1]
datadir=/data1
socket=/tmp/mysql.sock1
port=3306
#user=root
#skip-grant-tables
#password=123
performance_schema=off
innodb_buffer_pool_size=32M
bind_address=0.0.0.0
skip_name_resolve
[mysqld2]
datadir=/data2
socket=/tmp/mysql.sock2
port=3307
#user=root
#skip-grant-tables
#password="123"
performance_schema=off
innodb_buffer_pool_size=32M
bind_address=0.0.0.0
skip_name_resolve
2、初始化数据文件
[root@host1 mysql]# bin/mysqld --initialize --user=mysql --datadir=/data1
[root@host1 mysql]# bin/mysqld --initialize --user=mysql --datadir=/data2
3、启动多实例
[root@host1 mysql]# mysqld_multi start
4、查看实例启动情况
[root@host1 mysql]# mysqld_multi report
Reporting MySQL servers
MySQL server from group: mysqld1 is running
MySQL server from group: mysqld2 is running
MySQL server from group: mysqld3 is running
MySQL server from group: mysqld4 is running
5、停止多实例库(如果在参数文件中没有增加红色标注部分则用下列命令停止多实例)
[root@host1 mysql]# mysqld_multi stop 1 -u root -p 123
[root@host1 mysql]# mysqld_multi report
Reporting MySQL servers
MySQL server from group: mysqld1 is not running
MySQL server from group: mysqld2 is running
MySQL server from group: mysqld3 is running
MySQL server from group: mysqld4 is running
[root@host1 mysql]#
(如果增加了红色标注部分则可直接使用 mysqd_multi stop 1)
至此多实例安装完成(注意添加的参数是在已有的单实例库参数文件中添加)
[root@host1 mysql]# bin/mysqld --initialize --user=mysql --datadir=/data1
[root@host1 mysql]# bin/mysqld --initialize --user=mysql --datadir=/data2
3、启动多实例
[root@host1 mysql]# mysqld_multi start
4、查看实例启动情况
[root@host1 mysql]# mysqld_multi report
Reporting MySQL servers
MySQL server from group: mysqld1 is running
MySQL server from group: mysqld2 is running
MySQL server from group: mysqld3 is running
MySQL server from group: mysqld4 is running
5、停止多实例库(如果在参数文件中没有增加红色标注部分则用下列命令停止多实例)
[root@host1 mysql]# mysqld_multi stop 1 -u root -p 123
[root@host1 mysql]# mysqld_multi report
Reporting MySQL servers
MySQL server from group: mysqld1 is not running
MySQL server from group: mysqld2 is running
MySQL server from group: mysqld3 is running
MySQL server from group: mysqld4 is running
[root@host1 mysql]#
(如果增加了红色标注部分则可直接使用 mysqd_multi stop 1)
至此多实例安装完成(注意添加的参数是在已有的单实例库参数文件中添加)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30317998/viewspace-2134951/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/30317998/viewspace-2134951/