So... I'm trying to setup a cluster on Amazon's EC2 using the MySQL 5.0 docs
and Alex Davies' HOWTO (they're pretty much the same). I can't seem to get
the cluster to start up.

ndb_mgm -e show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 3 node(s)
id=2 @216.182.236.43 (Version: 5.0.27, starting, Nodegroup: 0)
id=3 @216.182.236.29 (Version: 5.0.27, starting, Nodegroup: 0)
id=4 @216.182.236.37 (Version: 5.0.27, starting, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=1 (Version: 5.0.27)

[mysqld(API)] 3 node(s)
id=5 (not connected, accepting connect from any host)
id=6 (not connected, accepting connect from any host)
id=7 (not connected, accepting connect from any host)

Here's what I have:

MANAGEMENT SERVER

cat /var/lib/mysql-cluster/config.ini
[NDBD DEFAULT]
NoOfReplicas=3

[MYSQLD DEFAULT]
[NDB_MGMD DEFAULT]
[TCP DEFAULT]

[NDB_MGMD]
HostName=216.182.233.24
DataDir=/var/lib/mysql-cluster

[NDBD]
HostName=216.182.236.43
DataDir=/var/lib/mysql-cluster

[NDBD]
HostName=216.182.236.29
DataDir=/var/lib/mysql-cluster

[NDBD]
HostName=216.182.236.37
DataDir=/var/lib/mysql-cluster

[MYSQLD]
[MYSQLD]
[MYSQLD]

For each node, I have the following in /etc/my.cnf

[MYSQLD]
ndbcluster
ndb-connectstring=216.182.233.24:1186

[MYSQL_CLUSTER]
ndb-connectstring=216.182.233.24:1186

When I check the cluster logs on the nodes, I get the following:

2007-01-18 02:55:55 [ndbd] INFO -- Angel pid: 5598 ndb pid: 5599
2007-01-18 02:55:55 [ndbd] INFO -- NDB Cluster -- DB node 4
2007-01-18 02:55:55 [ndbd] INFO -- Version 5.0.27 --
2007-01-18 02:55:55 [ndbd] INFO -- Configuration fetched at
216.182.233.24 port 1186
2007-01-18 02:55:56 [ndbd] INFO -- Start initiated (version 5.0.27)

The cluster logs on the management server have constantly repeating
messages:

2007-01-18 11:37:23 [MgmSrvr] INFO -- Node 3: Initial start, waiting for
0000000000000014 to connect, nodes [ all: 000000000000001c connected:
0000000000000008 no-wait: 0000000000000000 ]
2007-01-18 11:37:24 [MgmSrvr] INFO -- Node 2: Initial start, waiting for
0000000000000018 to connect, nodes [ all: 000000000000001c connected:
0000000000000004 no-wait: 0000000000000000 ]
2007-01-18 11:37:24 [MgmSrvr] INFO -- Node 4: Initial start, waiting for
000000000000000c to connect, nodes [ all: 000000000000001c connected:
0000000000000010 no-wait: 0000000000000000 ]

I hope that gives enough information. What should I try and where should I
look?


Michael