neo@mgm:~$ sudo vim /var/lib/mysql-cluster/config.ini[NDBD DEFAULT]NoOfReplicas=2DataMemory=80MIndexMemory=18M[MYSQLD DEFAULT][NDB_MGMD DEFAULT][TCP DEFAULT]portnumber=2202[NDB_MGMD]hostname=192.168.0.1datadir=/var/lib/mysql-cluster[NDBD]hostname=192.168.0.2datadir=/var/lib/mysql-cluster[NDBD]hostname=192.168.0.3datadir=/var/lib/mysql-cluster[MYSQLD]hostname=192.168.0.4[MYSQLD]hostname=192.168.0.5

my.cnf

neo@data:~$ sudo vim /etc/mysql/my.cnf[mysqld]ndbclusterndb-connectstring=192.168.0.1	# the IP of the MANAGMENT SERVER[mysql_cluster]ndb-connectstring=192.168.0.1	# the IP of the MANAGMENT SERVER

my.cnf

neo@sql:~$ sudo vim /etc/mysql/my.cnf[mysqld]ndbclusterndb-connectstring=192.168.0.1	# the IP of the MANAGMENT SERVER[mysql_cluster]ndb-connectstring=192.168.0.1	# the IP of the MANAGMENT SERVER

MGM

$ sudo ndb_mgm -e shutdown

neo@mgm:~$ ndb_mgm-- NDB Cluster -- Management Client --ndb_mgm> showConnected to Management Server at: localhost:1186Cluster Configuration---------------------[ndbd(NDB)]     2 node(s)id=2    @192.168.0.2  (Version: 5.0.51, Nodegroup: 0)id=3    @192.168.0.3  (Version: 5.0.51, Nodegroup: 0, Master)[ndb_mgmd(MGM)] 1 node(s)id=1    @192.168.0.1  (Version: 5.0.51)[mysqld(API)]   2 node(s)id=4    @192.168.0.4  (Version: 5.0.51)id=5    @192.168.0.5  (Version: 5.0.51)ndb_mgm>

与没有使用簇的MySQL相比，在MySQL簇内操作数据的方式没有太大的区别。

执行这类操作时应记住三点 表必须用ENGINE=NDB或ENGINE=NDBCLUSTER选项创建，或用ALTER TABLE选项更改，以使用NDB Cluster存储引擎在 Cluster内复制它们。如果使用mysqldump的输出从已有数据库导入表，可在文本编辑器中打开SQL脚本，并将该选项添加到任何表创建语句，或用这类选项之一替换任何已有的ENGINE（或TYPE）选项。 另外还请记住，每个NDB表必须有一个主键。如果在创建表时用户未定义主键，NDB Cluster存储引擎将自动生成隐含的主键。（注释：该隐含 键也将占用空间，就像任何其他的表索引一样。由于没有足够的内存来容纳这些自动创建的键，出现问题并不罕见）。 当你在一个节点上运行create database mydb;你去其他sql node上执行show databases;将不能看到mydb,你需要创建它，然后use mydb; show tables;你将看到同步的表。

SQL Node 1

neo@sql:~$ mysql -uroot -pEnter password:Welcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 7Server version: 5.0.51a-3ubuntu5.1 (Ubuntu)Type 'help;' or '\h' for help. Type '\c' to clear the buffer.mysql> create database cluster;Query OK, 1 row affected (0.00 sec)mysql> use clusterDatabase changedmysql> create table city( id mediumint unsigned not null auto_increment primary key, name varchar(20) not null default '' ) engine = ndbcluster default charset utf8;Query OK, 0 rows affected (1.07 sec)mysql> insert into city values(1, 'Shenzhen');Query OK, 1 row affected (0.12 sec)mysql> insert into city values(2, 'Guangdong');Query OK, 1 row affected (0.00 sec)

SQL Node 2

neo@sql:~$ mysql -uroot -pEnter password:Welcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 7Server version: 5.0.51a-3ubuntu5.1 (Ubuntu)Type 'help;' or '\h' for help. Type '\c' to clear the buffer.mysql> show databases;+--------------------+| Database           |+--------------------+| information_schema || example            || mydb               || mysql              || neo                |+--------------------+6 rows in set (0.13 sec)mysql> create database cluster;Query OK, 1 row affected (0.00 sec)mysql> show databases;+--------------------+| Database           |+--------------------+| information_schema || cluster            || example            || mydb               || mysql              || neo                |+--------------------+6 rows in set (0.13 sec)mysql> use cluster;Reading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADatabase changedmysql> show tables;+-------------------+| Tables_in_cluster |+-------------------+| city              |+-------------------+1 row in set (0.01 sec)mysql> select * from city;+----+-----------+| id | name      |+----+-----------+|  1 | Shenzhen  ||  2 | Guangdong |+----+-----------+2 rows in set (0.03 sec)mysql>