运行环境：centos6.1Mysql版本：MySQL-cluster-gpl-7.2.6-linux2.6-x86_6下载地址：/Downloads/MySQL-Cluster-7.2/mysql-cluster-gpl-7.2.6-linux2. 6-x86_64.tar.gz对于这第一个MySQL数据库的集群，它由1个单一的MySQL服务引擎（mysqlds）、两个数据节点（ndbd）和一个单一的管理节点（ndb_mgmd）共同组成，所有的节点都运行在同一台主机上。

为配置文件和数据文件创建必要的存储文件夹，分别要建立如下几个文件夹：① /home/mysql/my_cluster② /home/mysql/my_cluster/ndb_data③ /home/mysql/my_cluster/mysqld_data④ /home/mysql/my_cluster/mysqld_data/mysql⑤ /home/mysql/my_cluster/mysqld_data/ndbinfo⑥ /home/mysql/my_cluster/conf具体安装步骤：1. 添用加户与组mysql[plain]view plaincopy1.shell> groupadd mysql2.shell> useradd -r -d /home/mysql -g mysql mysql[plain]view plain copy1.shell> groupadd mysql2.shell> useradd -r -d /home/mysql -g mysql mysql2. 切换到mysql用户权限下[plain]view plaincopy1.shell> su - mysql[plain]view plain copy1.shell> su - mysql3. 下载mysql cluster[plain]view plaincopy1.shell> wget /Downloads/MySQL-Cluster-7.2/mysql-cluster-gpl-7.2.6-linux2.6-x86_64.tar.gz2.shell> tar -zxvf mysql-cluster-gpl-7.2.6-linux2.6-x86_64.tar.gz3.shell> ln -s mysql-cluster-gpl-7.2.6-linux2.6-x86_64 mysqlc[plain]view plain copy1.shell> wget /Downloads/MySQL-Cluster-7.2/mysql-cluster-gpl-7.2.6-linux2.6-x86_64.tar.gz2.shell> tar -zxvf mysql-cluster-gpl-7.2.6-linux2.6-x86_64.tar.gz3.shell> ln -s mysql-cluster-gpl-7.2.6-linux2.6-x86_64 mysqlc4. 安装mysql cluster[plain]view plaincopy1.shell> cd /home/mysql2.shell> mkdir my_cluster my_cluster/ndb_data my_cluster/mysqld_data my_cluster/conf3.在conf目录添加以下2个配置文件（注意：“/home/mysql”需要替换为你自己的用户目录）4.f:6.[mysqld]7.ndbcluster8.datadir=/home/mysql/my_cluster/mysqld_data9.basedir=/home/mysql/mysqlc10.port=500011.12.config.ini:13.[ndb_mgmd]14.hostname=localhost15.datadir=/home/mysql/my_cluster/ndb_data16.NodeId=117.[ndbd default]18.noofreplicas=219.datadir=/home/mysql/my_cluster/ndb_data20.[ndbd]21.hostname=localhost22.NodeId=323.[ndbd]24.hostname=localhost25.NodeId=426.[mysqld]27.NodeId=5028.29.安装30.shell> cd /home/mysql/mysqlc31.shell> scripts/mysql_install_db --no-defaults --datadir=/home/mysql/my_cluster/mysqld_data/[plain]view plain copy1.shell> cd /home/mysql2.shell> mkdir my_cluster my_cluster/ndb_data my_cluster/mysqld_data my_cluster/conf3.在conf目录添加以下2个配置文件（注意：“/home/mysql”需要替换为你自己的用户目录）4.f:6.[mysqld]7.ndbcluster8.datadir=/home/mysql/my_cluster/mysqld_data9.basedir=/home/mysql/mysqlc10.port=500011.12.config.ini:13.[ndb_mgmd]14.hostname=localhost15.datadir=/home/mysql/my_cluster/ndb_data16.NodeId=117.[ndbd default]18.noofreplicas=219.datadir=/home/mysql/my_cluster/ndb_data20.[ndbd]21.hostname=localhost22.NodeId=323.[ndbd]24.hostname=localhost25.NodeId=426.[mysqld]27.NodeId=5028.29.安装30.shell> cd /home/mysql/mysqlc31.shell> scripts/mysql_install_db --no-defaults --datadir=/home/mysql/my_cluster/mysqld_data/5. 运行进程需要启动management node, data nodes 与MySQL Server[plain]view plaincopy1.shell> cd ../my_cluster/2.①最先启动的是管理节点（ndb_mgmd）3.shell> /home/mysql/mysqlc/bin/ndb_mgmd -f conf/config.ini --initial --configdir=/home/mysql/my_cluster/conf/4.②启动第一个数据节点（ndbd）5.shell> /home/mysql/mysqlc/bin/ndbd -c localhost:11866.③启动第二个数据节点（ndbd）7.shell> /home/mysql/mysqlc/bin/ndbd -c localhost:11868.9.在启动MySQL服务引擎（mysqld）之前，一定要等到所有的数据节点全部启动完毕，然后才能启动MySQL服务引擎。

查看数据节点是否启动完毕的命令语句如下：10.shell> /home/mysql/mysqlc/bin/ndb_mgm -e show11.显示结果：12.Connected to Management Server at: localhost:118613.Cluster Configuration14.---------------------15.[ndbd(NDB)] 2 node(s)16.id=3 @127.0.0.1 (mysql-5.5.22 ndb-7.2.6, Nodegroup: 0, Master)17.id=4 @127.0.0.1 (mysql-5.5.22 ndb-7.2.6, Nodegroup: 0)18.19.20.[ndb_mgmd(MGM)] 1 node(s)21.id=1 @127.0.0.1 (mysql-5.5.22 ndb-7.2.6)22.23.24.[mysqld(API)] 1 node(s)25.id=50 (not connected, accepting connect from any host)26.27.④启动MySQL服务引擎28.shell> /home/mysql/mysqlc/bin/mysqld --defaults-file=conf/f &[plain]view plain copy1.shell> cd ../my_cluster/2.①最先启动的是管理节点（ndb_mgmd）3.shell> /home/mysql/mysqlc/bin/ndb_mgmd -f conf/config.ini --initial --configdir=/home/mysql/my_cluster/conf/4.②启动第一个数据节点（ndbd）5.shell> /home/mysql/mysqlc/bin/ndbd -c localhost:11866.③启动第二个数据节点（ndbd）7.shell> /home/mysql/mysqlc/bin/ndbd -c localhost:11868.9.在启动MySQL服务引擎（mysqld）之前，一定要等到所有的数据节点全部启动完毕，然后才能启动MySQL服务引擎。

查看数据节点是否启动完毕的命令语句如下：10.shell> /home/mysql/mysqlc/bin/ndb_mgm -e show11.显示结果：12.Connected to Management Server at: localhost:118613.Cluster Configuration14.---------------------15.[ndbd(NDB)] 2 node(s)16.id=3 @127.0.0.1 (mysql-5.5.22 ndb-7.2.6, Nodegroup: 0, Master)17.id=4 @127.0.0.1 (mysql-5.5.22 ndb-7.2.6, Nodegroup: 0)18.19.20.[ndb_mgmd(MGM)] 1 node(s)21.id=1 @127.0.0.1 (mysql-5.5.22 ndb-7.2.6)22.23.24.[mysqld(API)] 1 node(s)25.id=50 (not connected, accepting connect from any host)26.27.④启动MySQL服务引擎28.shell> /home/mysql/mysqlc/bin/mysqld --defaults-file=conf/f &启动成功后的进程如下：[plain]view plaincopy1.mysql 1738 0.1 0.5 575408 5752 ? Ssl 00:58 0:14 /home/mysql/mysqlc/bin/ndb_mgmd -f conf/config.ini --initial --configdir=/home/mysql/my_ cluster/conf/2.mysql 1751 0.0 0.0 101116 660 ? Ss 00:58 0:00 /home/mysql/mysqlc/bin/ndbd -c localhost:11863.mysql 1752 0.3 31.5 1048328 320704 ? Sl 00:58 0:41 /home/mysql/mysqlc/bin/ndbd -c localhost:11864.mysql 1790 0.0 0.0 101116 708 ? Ss 00:58 0:00 /home/mysql/mysqlc/bin/ndbd -c localhost:11865.mysql 1791 0.3 40.9 1048328 417228 ? Sl 00:58 0:38 /home/mysql/mysqlc/bin/ndbd -c localhost:11866.mysql 1835 0.0 5.4 886712 55296 pts/0 Sl 00:59 0:11 /home/mysql/mysqlc/bin/mysqld --defaults-file=conf/f7.mysql 1897 0.0 0.1 198204 2032 pts/1 S+ 01:00 0:00 /home/mysql/mysqlc/bin/mysql -h 127.0.0.1 -P 5000 -u root[plain]view plain copy1.mysql 1738 0.1 0.5 575408 5752 ? Ssl 00:58 0:14 /home/mysql/mysqlc/bin/ndb_mgmd -f conf/config.ini --initial --configdir=/home/mysql/my_ cluster/conf/2.mysql 1751 0.0 0.0 101116 660 ? Ss 00:58 0:00 /home/mysql/mysqlc/bin/ndbd -c localhost:11863.mysql 1752 0.3 31.5 1048328 320704 ? Sl 00:58 0:41 /home/mysql/mysqlc/bin/ndbd -c localhost:11864.mysql 1790 0.0 0.0 101116 708 ? Ss 00:58 0:00 /home/mysql/mysqlc/bin/ndbd -c localhost:11865.mysql 1791 0.3 40.9 1048328 417228 ? Sl 00:58 0:38 /home/mysql/mysqlc/bin/ndbd -c localhost:11866.mysql 1835 0.0 5.4 886712 55296 pts/0 Sl 00:59 0:11 /home/mysql/mysqlc/bin/mysqld --defaults-file=conf/f7.mysql 1897 0.0 0.1 198204 2032 pts/1 S+ 01:00 0:00 /home/mysql/mysqlc/bin/mysql -h 127.0.0.1 -P 5000 -u root6. 测试连接到MySQL服务器，并确认使用MySQL集群（NDB）可以创建表①连接到MySQL 服务器：[plain]view plaincopy1.shell> /home/mysql/mysqlc/bin/mysql -h 127.0.0.1 -P 5000 -u root2.mysql> create database clusterdb;use clusterdb;3.mysql> create table simples (id int not null primary key) engine=ndb;4.mysql> insert into simples values (1),(2),(3),(4);5.mysql> select * from simples;6.+----+7.| id |8.+----+9.| 3 |10.| 1 |11.| 2 |12.| 4 |13.+----+[plain]view plain copy1.shell> /home/mysql/mysqlc/bin/mysql -h 127.0.0.1 -P 5000 -u root2.mysql> create database clusterdb;use clusterdb;3.mysql> create table simples (id int not null primary key) engine=ndb;4.mysql> insert into simples values (1),(2),(3),(4);5.mysql> select * from simples;6.+----+7.| id |8.+----+9.| 3 |10.| 1 |11.| 2 |12.| 4 |13.+----+7. 停止服务MySQL服务必须手动停止，服务停止后，其他集群节点的停止可以使用管理节点（ndb_mgm）来[plain]view plaincopy1.shell> /home/mysql/mysqlc/bin/mysqladmin -u root -h 127.0.0.1 -P 5000 shutdown2.shell> /home/mysql/mysqlc/bin/ndb_mgm -e shutdown[plain]view plain copy1.shell> /home/mysql/mysqlc/bin/mysqladmin -u root -h 127.0.0.1 -P 5000 shutdown2.shell> /home/mysql/mysqlc/bin/ndb_mgm -e shutdown。