![](https://csdnimg.cn/release/download_crawler_static/87598075/bg2.jpg)
目录
1、前言 ............................................................................................................................................3
1、部署 sql 节点 ..............................................................................................................................3
1、环境信息:...............................................................................................................................4
2、下载 MySQL NDB Cluster 软件; .............................................................................................4
3、安装 SQL 节点,在每个 SQL 节点都执行如下操作;...........................................................4
1)创建 mysql 用户和组,如果该用户和组不存在:................................................................4
2)解压缩 mysql-cluster 软件; ..................................................................................................5
3)安装数据库系统;...................................................................................................................5
4)拷贝 MySQL 启动脚本;..........................................................................................................7
5)进入数据库检查;...................................................................................................................8
2、部署数据节点 .............................................................................................................................9
vi /etc/profile 在最下方加上 .........................................................................................................10
3、部署管理节点 ...........................................................................................................................10
4、启动 Cluster ..............................................................................................................................15
4.1、启动管理节点......................................................................................................................15
4.2、启动数据节点......................................................................................................................15
4.3、启动 SQL 节点......................................................................................................................16
7、节点全部成功启动后,在管理节点查看集群状态;...............................................................16
1)集群的管理服务端口是 1186;............................................................................................17
2)集群的数据节点有 2 个; .....................................................................................................17
3)管理节点有一个;.................................................................................................................17
4)SQL 节点有 4 个,且处于连接状态;..................................................................................17
5、Cluster 的关闭;.......................................................................................................................17
5.1、关闭管理节点和数据节点..................................................................................................17
5.2、关闭 sql 节点 .......................................................................................................................18