miles_wong 2015-12-04 694浏览量
多实例部署优势:
1 部署好mysql软件
[root@miles ~]# ps -ef |grep mysqld
root 3083 1 0 Dec03 ? 00:00:00 /bin/sh /usr/local/mysql5.6.27/bin/mysqld_safe --defaults-file=/data/my.cnf
mysql 3431 3083 0 Dec03 ? 00:00:47 /usr/local/mysql5.6.27/bin/mysqld --defaults-file=/data/my.cnf --basedir=/usr/local/mysql5.6.27 --datadir=/data/mysql/ --plugin-dir=/usr/local/mysql5.6.27/lib/plugin --user=mysql --log-error=/data/mysql/error.log --pid-file=/data/mysql//miles.pid --socket=/data/mysql.sock --port=3333
实例初始化
[root@miles ~]# mkdir /data/mysql2
[root@miles ~]# /usr/local/mysql5.6.27/scripts/mysql_install_db --user=mysql --datadir=/data/mysql2 --basedir=/usr/local/mysql5.6.27
2 编辑多个配置文件,初始化多个实例
[mysql@miles data]$ cp my.cnf my1.cnf
[mysql@miles data]$ pwd
/data
[mysql@miles data]$ vi my1.cnf
修改相关文件路径
:%s#data/mysql#data/mysql2#g
修改端口号
:%s#3334#data/3334#g
3 启动mysql实例
[root@miles ~]# /usr/local/mysql5.6.27/bin/mysqld_safe --defaults-file=/data/my1.cnf &
[root@miles ~]# ps -ef |grep mysqld
root 3083 1 0 Dec03 ? 00:00:00 /bin/sh /usr/local/mysql5.6.27/bin/mysqld_safe --defaults-file=/data/my.cnf
mysql 3431 3083 0 Dec03 ? 00:00:53 /usr/local/mysql5.6.27/bin/mysqld --defaults-file=/data/my.cnf --basedir=/usr/local/mysql5.6.27 --datadir=/data/mysql/ --plugin-dir=/usr/local/mysql5.6.27/lib/plugin --user=mysql --log-error=/data/mysql/error.log --pid-file=/data/mysql//miles.pid --socket=/data/mysql.sock --port=3333
root 13531 11356 0 15:17 pts/0 00:00:00 /bin/sh /usr/local/mysql5.6.27/bin/mysqld_safe --defaults-file=/data/my1.cnf
mysql 13881 13531 43 15:17 pts/0 00:00:03 /usr/local/mysql5.6.27/bin/mysqld --defaults-file=/data/my1.cnf --basedir=/usr/local/mysql5.6.27 --datadir=/data/mysql2/ --plugin-dir=/usr/local/mysql5.6.27/lib/plugin --user=mysql --log-error=/data/mysql2/error.log --pid-file=/data/mysql2//miles.pid --socket=/data/mysql2.sock --port=3334
账户安全设置
[root@miles ~]# mysql -uroot --socket=/data/mysql2.sock
mysql> select user,host,password from mysql.user;
+------+-----------+----------+
| user | host | password |
+------+-----------+----------+
| root | localhost | |
| root | miles | |
| root | 127.0.0.1 | |
| root | ::1 | |
| | localhost | |
| | miles | |
+------+-----------+----------+
6 rows in set (0.00 sec)
mysql> delete from user where user='';
ERROR 1046 (3D000): No database selected
mysql> delete from mysql.user where user='';
Query OK, 2 rows affected (0.01 sec)
mysql> delete from mysql.user where host<>'localhost';
Query OK, 3 rows affected (0.01 sec)
mysql> set password for root@localhost = password('beijing');
Query OK, 0 rows affected (0.00 sec)
mysql> delete from mysql.db;
Query OK, 2 rows affected (0.01 sec)
mysql> drop database test;
Query OK, 0 rows affected (0.02 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
5 mysqld_multi的配置
配置多实例启动脚本
[root@miles support-files]# pwd
/usr/local/mysql5.6.27/support-files
You have new mail in /var/spool/mail/root
[root@miles support-files]# cp mysqld_multi.server /etc/init.d/mysqld_multi.server
[root@miles support-files]# vi /etc/init.d/mysqld_multi.server
basedir=/usr/local/mysql5.6.27
bindir=/usr/local/mysql5.6.27/bin
配置多实例数据库配置文件
用mysqld_multi工具查看该配置文件的模板方法,命令为:mysqld_multi --example
在/etc/目录下创建创建文件/etc/mysqld_multi.cnf,把mysqld_multi --example产生的文件粘进去,修改相应属性,如:mysqld,mysqladmin,socket,port,pid-file,datadir,user等。
[root@miles ~]# more /data/mysqld_multi.cnf
[mysqld_multi]
mysqld = /usr/local/mysql5.6.27/bin/mysqld_safe
mysqladmin = /usr/local/mysql5.6.27/bin/mysqladmin
user =root
password =beijing
[mysqld1]
defaults-file = /data/my.cnf
socket = /data/mysql.sock
port = 3333
#pid-file = /data/mysql/mysql.pid
datadir = /data/mysql
#language = /usr/local/mysql5.6.27/share/mysql/english
user = mysql
[mysqld2]
defaults-file = /data/my1.cnf
socket = /data/mysql2.sock
port = 3334
#pid-file = /data/mysql2/mysql.pid
datadir = /data/mysql2
#language = /usr/local/mysql5.6.27/share/mysql/english
user = mysql
查看数据库状态
[root@miles ~]# mysqld_multi --defaults-extra-file=/data/mysqld_multi.cnf report
Reporting MySQL servers
MySQL server from group: mysqld1 is running
MySQL server from group: mysqld2 is running
启动数据库实例1,2
[root@miles ~]# mysqld_multi --defaults-extra-file=/data/mysqld_multi.cnf start 1,2
关闭数据库实例1,2
[root@miles ~]# mysqld_multi --defaults-extra-file=/data/mysqld_multi.cnf stop 1,2 -p beijing
启动数据库实例1
[root@miles ~]# mysqld_multi --defaults-extra-file=/data/mysqld_multi.cnf start 1
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。
分享数据库前沿,解构实战干货,推动数据库技术变革