我有两个管理节点：
192.168.100.1
192.168.100.3
4个数据节点和SQL节点
192.168.100.5
192.168.100.6
192.168.100.7
192.168.100.8
my.cnf：
[mysqld]
ndbcluster
ndb-connectstring = "host=192.168.100.1,host=192.168.100.3"
[mysql_cluster]
ndb-connectstring = "host=192.168.100.1,host=192.168.100.3"
config.ini
[NDBD DEFAULT]
NoOfReplicas=2
DataMemory=800M
IndexMemory=400M
[MGM DEFAULT]
PortNumber: 1186
DataDir: /var/lib/mysql-cluster/
Section for the cluster management node
[NDBMGMD]
id=1
HostName=192.168.100.1
DataDir= /var/lib/mysql-cluster
[NDBMGMD]
id=2
HostName=192.168.100.3
DataDir= /var/lib/mysql-cluster
Section for the storage nodes
[NDBD]
HostName=192.168.100.5
DataDir= /var/lib/mysql-cluster
[NDBD]
HostName=192.168.100.6
DataDir=/var/lib/mysql-cluster
[NDBD]
HostName=192.168.100.7
DataDir= /var/lib/mysql-cluster
[NDBD]
HostName=192.168.100.8
DataDir=/var/lib/mysql-cluster
Section for the sqlapi nodes
[MYSQLD]
hostname=192.168.100.5
[MYSQLD]
hostname=192.168.100.6
[MYSQLD]
hostname=192.168.100.7
[MYSQLD]
hostname=192.168.100.8
192.168.100.1/3：#ndb_mgm
Connected to Management Server at: 192.168.100.1:1186
Cluster Configuration
[ndbd(NDB)] 4 node(s)
id=3 @192.168.100.5 (Version: 5.0.83, starting, Nodegroup: 0)
id=4 @192.168.100.6 (Version: 5.0.83, starting, Nodegroup: 0)
id=5 @192.168.100.7 (Version: 5.0.83, starting, Nodegroup: 0)
id=6 @192.168.100.8 (Version: 5.0.83, starting, Nodegroup: 0)
[ndb_mgmd(MGM)] 2 node(s)
id=1 (Version: 5.0.83)
id=2 (not connected, accepting connect from 192.168.100.3)
[mysqld(API)] 4 node(s)
id=7 (not connected, accepting connect from 192.168.100.5)
id=8 (not connected, accepting connect from 192.168.100.6)
id=9 (not connected, accepting connect from 192.168.100.7)
id=10 (not connected, accepting connect from 192.168.100.8)
管理节点日志：
Unable to connect to our own ndb_mgmd (Error -1)
This is probably a bug.
NDB Cluster Management Server. Version 5.0.83
Id: 1, Command port: 1186
2009-07-18 16:24:21 [MgmSrvr] INFO -- NDB Cluster Management Server. Version 5.0.83
2009-07-18 16:24:21 [MgmSrvr] INFO -- Id: 1, Command port: 1186
2009-07-18 16:24:31 [MgmSrvr] INFO -- Mgmt server state: nodeid 3 reserved for ip 192.168.100.5, mreservednodes 0000000000000008.
2009-07-18 16:24:32 [MgmSrvr] INFO -- Node 1: Node 3 Connected
2009-07-18 16:24:32 [MgmSrvr] INFO -- Mgmt server state: nodeid 3 freed, mreservednodes 0000000000000000.
2009-07-18 16:24:33 [MgmSrvr] INFO -- Node 3: Node 2 Connected
2009-07-18 16:24:35 [MgmSrvr] INFO -- Node 3: Initial start, waiting for 0000000000000070 to connect, nodes [ all: 0000000000000078 connected: 0000000000000008 no-wait: 0000000000000000 ]
2009-07-18 16:24:36 [MgmSrvr] INFO -- Mgmt server state: nodeid 5 reserved for ip 192.168.100.7, mreservednodes 0000000000000020.
2009-07-18 16:24:36 [MgmSrvr] INFO -- Node 1: Node 5 Connected
2009-07-18 16:24:37 [MgmSrvr] INFO -- Mgmt server state: nodeid 5 freed, mreservednodes 0000000000000000.
2009-07-18 16:24:37 [MgmSrvr] INFO -- Node 5: Node 2 Connected
2009-07-18 16:24:38 [MgmSrvr] INFO -- Node 3: Initial start, waiting for 0000000000000070 to connect, nodes [ all: 0000000000000078 connected: 0000000000000008 no-wait: 0000000000000000 ]
2009-07-18 16:24:40 [MgmSrvr] INFO -- Node 5: Initial start, waiting for 0000000000000058 to connect, nodes [ all: 0000000000000078 connected: 0000000000000020 no-wait: 0000000000000000 ]
2009-07-18 16:24:41 [MgmSrvr] INFO -- Node 3: Initial start, waiting for 0000000000000070 to connect, nodes [ all: 0000000000000078 connected: 0000000000000008 no-wait: 0000000000000000 ]
2009-07-18 16:24:43 [MgmSrvr] INFO -- Mgmt server state: nodeid 4 reserved for ip 192.168.100.6, mreservednodes 0000000000000010.
2009-07-18 16:24:43 [MgmSrvr] INFO -- Node 5: Initial start, waiting for 0000000000000058 to connect, nodes [ all: 0000000000000078 connected: 0000000000000020 no-wait: 0000000000000000 ]
2009-07-18 16:24:43 [MgmSrvr] INFO -- Node 1: Node 4 Connected
2009-07-18 16:24:43 [MgmSrvr] INFO -- Mgmt server state: nodeid 4 freed, mreservednodes 0000000000000000.
2009-07-18 16:24:43 [MgmSrvr] INFO -- Node 4: Start phase 0 completed
2009-07-18 16:24:43 [MgmSrvr] INFO -- Node 4: Communication to Node 3 opened
2009-07-18 16:24:43 [MgmSrvr] INFO -- Node 4: Communication to Node 5 opened
2009-07-18 16:24:43 [MgmSrvr] INFO -- Node 4: Communication to Node 6 opened
2009-07-18 16:24:43 [MgmSrvr] INFO -- Node 4: Initial start, waiting for 0000000000000068 to connect, nodes [ all: 0000000000000078 connected: 0000000000000010 no-wait: 0000000000000000 ]
2009-07-18 16:24:44 [MgmSrvr] INFO -- Node 4: Node 2 Connected
2009-07-18 16:24:44 [MgmSrvr] INFO -- Node 3: Initial start, waiting for 0000000000000070 to connect, nodes [ all: 0000000000000078 connected: 0000000000000008 no-wait: 0000000000000000 ]
2009-07-18 16:24:46 [MgmSrvr] INFO -- Node 5: Initial start, waiting for 0000000000000058 to connect, nodes [ all: 0000000000000078 connected: 0000000000000020 no-wait: 0000000000000000 ]
2009-07-18 16:24:46 [MgmSrvr] INFO -- Node 4: Initial start, waiting for 0000000000000068 to connect, nodes [ all: 0000000000000078 connected: 0000000000000010 no-wait: 0000000000000000 ]
2009-07-18 16:24:47 [MgmSrvr] INFO -- Node 3: Initial start, waiting for 0000000000000070 to connect, nodes [ all: 0000000000000078 connected: 0000000000000008 no-wait: 0000000000000000 ]
2009-07-18 16:24:49 [MgmSrvr] INFO -- Node 5: Initial start, waiting for 0000000000000058 to connect, nodes [ all: 0000000000000078 connected: 0000000000000020 no-wait: 0000000000000000 ]
2009-07-18 16:24:49 [MgmSrvr] INFO -- Node 4: Initial start, waiting for 0000000000000068 to connect, nodes [ all: 0000000000000078 connected: 0000000000000010 no-wait: 0000000000000000 ]
2009-07-18 16:24:50 [MgmSrvr] INFO -- Node 3: Initial start, waiting for 0000000000000070 to connect, nodes [ all: 0000000000000078 connected: 0000000000000008 no-wait: 0000000000000000 ]
2009-07-18 16:24:52 [MgmSrvr] INFO -- Node 5: Initial start, waiting for 0000000000000058 to connect, nodes [ all: 0000000000000078 connected: 0000000000000020 no-wait: 0000000000000000 ]
2009-07-18 16:24:52 [MgmSrvr] INFO -- Node 4: Initial start, waiting for 0000000000000068 to connect, nodes [ all: 0000000000000078 connected: 0000000000000010 no-wait: 000000000000
