For detailed help on COMMAND, use HELP COMMAND.
ndb_mgm> show
Connected to Management Server at: 192.168.55.15:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @192.168.55.15 (mysql-5.6.21 ndb-7.3.7, starting, Nodegroup: 0)
id=3 @192.168.55.16 (mysql-5.6.21 ndb-7.3.7, starting, Nodegroup: 0)
[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.55.15 (mysql-5.6.21 ndb-7.3.7)
[mysqld(API)] 2 node(s)
id=4 (not connected, accepting connect from 192.168.55.15)
id=5 (not connected, accepting connect from 192.168.55.16)
ndb_mgm>
#退出管理工具
ndb_mgm> quit
[root@myqClter1 bin]#
15
简单测试：
使用mysql cluster中需要注意两点：
一是表必须用ENGINE=NDB或ENGINE=NDBCLUSTER选项创建，使用ALTER TABLE选项更改也可以，以使用NDB Cluster存储引擎在 Cluster内复制它们。
二是每个NDB表必须要有一个主键，如果没有，NDB Cluster存储引擎将自动生成隐含主键。
连到sql节点1上，创建ndb引擎数据表beigang，插入数据，连到sql节点2上，查看beigang表数据，再插入数据，连到sql节点1查看，没问题就OK了。
连接sql节点1，创建下表并插入数据：
[root@myqClter1 bin]# ./mysql -h 192.168.55.15 -p test
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| ndb_2_fs |
| ndbinfo |
| performance_schema |
| test |
+--------------------+
6 rows in set (0.00 sec)
mysql> use test;
Database changed
mysql> create table beigang(
-> id int not null auto_increment primary key,
-> name varchar(30) not null default ''
-> )engine = ndbcluster default charset utf8;
Query OK, 0 rows affected (0.21 sec)
mysql>
mysql> insert into beigang values(1, 'ndb t1');
Query OK, 1 row affected (0.14 sec)
mysql> insert into beigang values(2, 'ndb t2');
Query OK, 1 row affected (0.00 sec)
mysql>
mysql> select * from beigang;
+----+--------+
| id | name |
+----+--------+
| 1 | ndb t1 |
| 2 | ndb t2 |
+----+--------+
2 rows in set (0.13 sec)
Bye
[root@myqClter1 bin]#
连到sql节点2上，查看beigang表数据，再插入数据：
[root@myqClter1 bin]# ./mysql -h 192.168.55.16 -p test
Enter password:
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
mysql> select * from beigang;
+----+--------+
| id | name |
+----+--------+
| 1 | ndb t1 |
| 2 | ndb t2 |
+----+--------+
2 rows in set (0.10 sec)
mysql> insert into beigang values(3, 'ndb t3');
Query OK, 1 row affected (0.09 sec)
mysql> \q
Bye
[root@myqClter1 bin]#
连到sql节点1查看，没问题就OK了。
[root@myqClter1 bin]# ./mysql -h 192.168.55.15 -p test
Enter password:
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
mysql>
mysql>
mysql> select * from beigang;
+----+--------+
| id | name |
+----+--------+
| 3 | ndb t3 |
| 1 | ndb t1 |
| 2 | ndb t2 |
+----+--------+
3 rows in set (0.00 sec)
mysql> \q
Bye
16
关闭顺序应该是：
管理节点->数据节点->SQL节点
命令ndb_mgm -e shutdown关闭管理节点和数据节点，sql节点/etc/init.d/mysqld stop关就可以了
[root@myqClter1 bin]# ndb_mgm -e shutdown
Connected to Management Server at: 192.168.55.15:1186
3 NDB Cluster node(s) have shutdown.
Disconnecting to allow management server to shutdown.
[root@myqClter1 bin]#
[root@myqClter1 bin]# /etc/init.d/mysqld stop
Shutting down MySQL..... SUCCESS!
[root@myqClter1 bin]#
[root@myqClter2 bin]# /etc/init.d/mysqld stop
Shutting down MySQL..... SUCCESS!
附：
ndb_mgmd和ndb_mgm的命令行参数：
[root@myqClter1 bin]# ll
总用量 22728
-rwxr-xr-x. 1 root root 7131043 1月 22 21:25 ndb_mgm
-rwxr-xr-x. 1 root root 16141964 1月 22 21:25 ndb_mgmd
[root@myqClter1 bin]# ndb_mgmd --help
MySQL Cluster Management Server mysql-5.6.21 ndb-7.3.7
Usage: ndb_mgmd [OPTIONS]
MyS