摘要:本文主要向大家介绍了MySQL数据库之centos7 mysql cluster集群搭建基于docker ,通过具体的内容向大家展现,希望对大家学习MySQL数据库有所帮助。
本文主要向大家介绍了MySQL数据库之centos7 mysql cluster集群搭建基于docker ,通过具体的内容向大家展现,希望对大家学习MySQL数据库有所帮助。
1.准备
mn:集群管理服务器用于管理集群的其他节点。我们可以从管理节点创建和配置集群上的新节点、重新启动、删除或备份节点。
db2/db3:这是节点间同步和数据复制的过程发生的层。
db4/db5:应用程序使用的接口服务器连接到数据库集群。
[root@java1 ~]# docker inspect -f ‘{{.Name}} - {{range .NetworkSettings.Networks}}{{.IPAddress}}{{end}}‘ $(docker ps -aq)/db5 - 172.17.0.6/db4 - 172.17.0.5/db3 - 172.17.0.4/db2 - 172.17.0.3/mn - 172.17.0.2[root@java1 ~]#
2.mn安装
cd ~wget //dev.mysql.com/get/Downloads/MySQL-Cluster-7.4/MySQL-Cluster-gpl-7.4.10-1.el7.x86_64.rpm-bundle.tartar -xvf MySQL-Cluster-gpl-7.4.10-1.el7.x86_64.rpm-bundle.tar
yum -y install perl-Data-Dumperyum -y remove mariadb-libs
cd ~rpm -Uvh MySQL-Cluster-client-gpl-7.4.10-1.el7.x86_64.rpmrpm -Uvh MySQL-Cluster-server-gpl-7.4.10-1.el7.x86_64.rpmrpm -Uvh MySQL-Cluster-shared-gpl-7.4.10-1.el7.x86_64.rpm
Make sure there is no error.
配置mn:
mkdir -p /var/lib/mysql-cluster
cd /var/lib/mysql-clustervi config.ini
[ndb_mgmd default]# Directory for MGM node log filesDataDir=/var/lib/mysql-cluster [ndb_mgmd]#Management Node db1HostName=192.168.1.120 [ndbd default]NoOfReplicas=2 # Number of replicasDataMemory=256M # Memory allocate for data storageIndexMemory=128M # Memory allocate for index storage#Directory for Data NodeDataDir=/var/lib/mysql-cluster [ndbd]#Data Node db2HostName=192.168.1.121 [ndbd]#Data Node db3HostName=192.168.1.122 [mysqld]#SQL Node db4HostName=192.168.1.123 [mysqld]#SQL Node db5HostName=192.168.1.124
start mn:
ndb_mgmd --config-file=/var/lib/mysql-cluster/config.ini
MySQL Cluster Management Server mysql-5.6.28 ndb-7.4.102016-03-22 19:26:08 [MgmtSrvr] INFO -- The default config directory ‘/usr/mysql-cluster‘ does not exist. Trying to create it...2016-03-22 19:26:08 [MgmtSrvr] INFO -- Successfully created config directory
ndb_mgmshow
db2/db3配置数据节点:
cd ~wget //dev.mysql.com/get/Downloads/MySQL-Cluster-7.4/MySQL-Cluster-gpl-7.4.10-1.el7.x86_64.rpm-bundle.tartar -xvf MySQL-Cluster-gpl-7.4.10-1.el7.x86_64.rpm-bundle.tar
yum -y install perl-Data-Dumperyum -y remove mariadb-libs
cd ~rpm -Uvh MySQL-Cluster-client-gpl-7.4.10-1.el7.x86_64.rpmrpm -Uvh MySQL-Cluster-server-gpl-7.4.10-1.el7.x86_64.rpmrpm -Uvh MySQL-Cluster-shared-gpl-7.4.10-1.el7.x86_64.rpm
vi /etc/my.cnf
[mysqld]ndbclusterndb-connectstring=192.168.1.120 # IP address of Management Node [mysql_cluster]ndb-connectstring=192.168.1.120 # IP address of Management Node
mkdir -p /var/lib/mysql-cluster
ndbd
results:
2016-03-22 19:35:56 [ndbd] INFO -- Angel connected to ‘192.168.1.120:1186‘2016-03-22 19:35:56 [ndbd] INFO -- Angel allocated nodeid: 2
db4/db5配置:
cd ~wget //dev.mysql.com/get/Downloads/MySQL-Cluster-7.4/MySQL-Cluster-gpl-7.4.10-1.el7.x86_64.rpm-bundle.tartar -xvf MySQL-Cluster-gpl-7.4.10-1.el7.x86_64.rpm-bundle.tar
yum -y install perl-Data-Dumperyum -y remove mariadb-libs
cd ~rpm -Uvh MySQL-Cluster-client-gpl-7.4.10-1.el7.x86_64.rpmrpm -Uvh MySQL-Cluster-server-gpl-7.4.10-1.el7.x86_64.rpmrpm -Uvh MySQL-Cluster-shared-gpl-7.4.10-1.el7.x86_64.rpm
vi /etc/my.cnf
[mysqld]ndbclusterndb-connectstring=192.168.1.120 # IP address for server management nodedefault_storage_engine=ndbcluster # Define default Storage Engine used by MySQL [mysql_cluster]ndb-connectstring=192.168.1.120 # IP address for server management node
service mysql start
集群监控:
ndb_mgmndb_mgm> show
ndb_mgm -e "all status"ndb_mgm -e "all report memory"
在db4或者在db5 测试集群:
mysql -u root -p
CREATE USER ‘root‘@‘%‘ IDENTIFIED BY ‘aqwe123‘;
select user, host, password from mysql.user;
GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘%‘ IDENTIFIED BY PASSWORD ‘*94CC7BF027327993D738E11...(Encrypted PASSWORD)‘ WITH GRANT OPTION;
最后的结果:
db5上也出现结果:
本文由职坐标整理并发布,希望对同学们学习MySQL有所帮助,更多内容请关注职坐标数据库MySQL数据库频道!
您输入的评论内容中包含违禁敏感词
我知道了
请输入正确的手机号码
请输入正确的验证码
您今天的短信下发次数太多了,明天再试试吧!
我们会在第一时间安排职业规划师联系您!
您也可以联系我们的职业规划师咨询:
版权所有 职坐标-一站式IT培训就业服务领导者 沪ICP备13042190号-4
上海海同信息科技有限公司 Copyright ©2015 www.zhizuobiao.com,All Rights Reserved.
沪公网安备 31011502005948号