(MySQL集群)MySQLCluster在Linux上的安装（RedHat5.6）

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了(MySQL集群)MySQLCluster在Linux上的安装（RedHat5.6），小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含4350字，纯文字阅读大概需要7分钟。

内容图文

(MySQL 集群) MySQL Cluster在Linux上的安装（RedHat 5.6）

一、环境介绍

IP_Address

Port_No

Node_name

Service_name

Desc

192.168.56.101

3306

SQL node(API Node)

mysqld

SQL节点(API节点)

192.168.56.101

2202

Data Node

ndbd

数据节点

192.168.56.102

3306

SQL node(API Node)

mysqld

SQL节点(API节点)

192.168.56.102

2202

Data Node

ndbd

数据节点

192.168.56.103

1186

Mgmt Node

ndb_mgmd

管理节点

二、准备工作

1)关闭防火墙(在三台服务器上操作)

[root@localhost ~]# service iptables stop

Flushing firewall rules: [ OK ]

Setting chains to policy ACCEPT: filter [ OK ]

Unloading iptables modules: [ OK ]

[root@localhost local]# chkconfig iptables off

2)默认不启动防火墙(在三台服务器上操作)

[root@localhost ~]# chkconfig iptables off

3)添加mysql用户和组(在三台服务器上操作)

[root@localhost ~]# groupadd mysql

[root@localhost ~]# useradd -g mysql mysql

4)上传安装文件(只需要在192.168.56.101上操作即可)

可以使用FileZilla软件来上传安装文件，比如上传到Linux 上的/tmp目录。我使用的安装文件是：mysql-cluster-gpl-7.1.10-linux-i686-glibc23.tar.gz

三、安装Mysql Cluster

1.安装数据节点和SQL节点(只需要在192.168.56.101上操作即可)

1)安装tar包

[root@localhost ~]# cd /tmp

[root@localhost tmp]# tar -C /usr/local -zxvf mysql-cluster-gpl-7.1.10-linux-i686-glibc23.tar.gz

[root@localhost tmp]# ln -s /usr/local/mysql-cluster-gpl-7.1.10-linux-i686-glibc23/ /usr/local/mysql

[root@localhost tmp]# cd /usr/local/mysql

[root@localhost mysql]# scripts/mysql_install_db --usr=mysql

2)授权

[root@localhost mysql]# cd ..

[root@localhost local]# chown -R mysql mysql

[root@localhost local]# chgrp -R mysql mysql

3)创建编辑my.cnf,键入下面内容

[mysqld]

ndbcluster

ndb-connectstring=192.168.56.103

[mysql_cluster]

ndb-connectstring=192.168.56.103

2.将/usr/local/mysql文件夹和/etc/my.cnf拷贝到192.168.56.102上

[root@localhost local]# scp -r ./mysql/* root@192.168.56.102:/usr/local/mysql

The authenticity of host '192.168.56.102 (192.168.56.102)' can't be established.

RSA key fingerprint is 1f:26:d9:20:d1:77:47:bf:3c:7b:64:6d:68:0f:bb:76.

Are you sure you want to continue connecting (yes/no)? yes

Warning: Permanently added '192.168.56.102' (RSA) to the list of known hosts.

root@192.168.56.102's password:

...........

[root@localhost local]# scp -r /etc/my.cnf root@192.168.56.102:/etc/

3.将/usr/local/mysql文件夹Copy到192.168.56.103(使用scp命令)

[root@localhost local]# scp -r ./mysql/* root@192.168.56.103:/usr/local/mysql

The authenticity of host '192.168.56.103 (192.168.56.103)' can't be established.

RSA key fingerprint is 1f:26:d9:20:d1:77:47:bf:3c:7b:64:6d:68:0f:bb:76.

Are you sure you want to continue connecting (yes/no)? yes

Warning: Permanently added '192.168.56.103' (RSA) to the list of known hosts.

root@192.168.56.103's password:

4.在102 & 103授权

[root@localhost ~]# cd /usr/local

[root@localhost local]# chown -R mysql mysql

[root@localhost local]# chgrp -R mysql mysql

5.配置管理节点(在192.168.56.103上操作)

[root@localhost mysql]# mkdir /var/lib/mysql-cluster

[root@localhost mysql]# chown -R mysql /var/lib/mysql-cluster

[root@localhost mysql]# chgrp -R mysql /var/lib/mysql-cluster

[root@localhost mysql]# cd /usr/local/mysql/

[root@localhost mysql]# vim config.ini

键入下面内容到config.ini中

[ndbd default]

NoOfReplicas=2 # Number of replicas

DataMemory=80M # How much memory to allocate for data storage

IndexMemory=18M # How much memory to allocate for index storage

[tcp default]

portnumber=2202 # This the default; however, you can use any

[ndb_mgmd]

hostname=192.168.56.103 # Hostname or IP address of MGM node

datadir=/var/lib/mysql-cluster # Directory for MGM node log files

[ndbd]

hostname=192.168.56.101 # Hostname or IP address

datadir=/usr/local/mysql/data # Directory for this data node's data files

[ndbd]

hostname=192.168.56.102 # Hostname or IP address

datadir=/usr/local/mysql/data # Directory for this data node's data files

[mysqld]

hostname=192.168.56.101 # Hostname or IP address

[mysqld]

hostname=192.168.56.102 # Hostname or IP address

四、启动Mysql Cluster

1.启动管理节点后台服务(在192.168.56.103上操作)

[root@localhost mysql]# /usr/local/mysql/bin/ndb_mgmd -f /usr/local/mysql/config.ini

2.启动管理节点管理服务(在192.168.56.103上操作)

[root@localhost mysql]# /usr/local/mysql/bin/ndb_mgm

3.查看Mysql Cluster配置信息(在192.168.56.103上操作)

内容总结

以上是互联网集市为您收集整理的(MySQL集群)MySQLCluster在Linux上的安装（RedHat5.6）全部内容，希望文章能够帮你解决(MySQL集群)MySQLCluster在Linux上的安装（RedHat5.6）所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

---