Hi,

Looking through the list archive I have seen that many people have had a similar problem but none ot the threads seem to help me.

I am trying to set up a test cluster with two machines. On machine A, I have ndb_mgmd, ndbd, and mysql running. Machine B has ndbd and mysql.

Machine A config.ini: [NDBD DEFAULT] NoOfReplicas=2 DataDir=/var/lib/mysql-cluster

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

[NDB_MGMD] HostName=141.142.234.57 DataDir=/var/lib/mysql-cluster LogDestination=FILE:filename=/usr/local/mysql-max-4.1.18-pc-linux-gnu-i686-glibc23/data/cluster.log,maxsize=1000000,maxfiles=6

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

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

[MYSQLD]

[MYSQLD]

Machine A my.cnf: [mysqld] ndbcluster ndb-connectstring=141.142.234.57 log=/usr/local/mysql-max-4.1.18-pc-linux-gnu-i686-glibc23/data/logfile log_error=/usr/local/mysql-max-4.1.18-pc-linux-gnu-i686-glibc23/data/err.log log_slow_queries=/usr/local/mysql-max-4.1.18-pc-linux-gnu-i686-glibc23/data/slow.log max_connections=200 innodb innodb_lock_wait_timeout=120

# Options for ndbd process: [MYSQL_CLUSTER] ndb-connectstring=141.142.234.57 # location of MGM node

Machine B my.cnf: [mysqld] ndbcluster ndb-connectstring=141.142.234.57 max_connections=200 log-error=/usr/local/mysql-max-4.1.18-pc-linux-gnu-i686-glibc23/data/err.log log-slow-queries=/usr/local/mysql-max-4.1.18-pc-linux-gnu-i686-glibc23/data/slow.log log=/usr/local/mysql-max-4.1.18-pc-linux-gnu-i686-glibc23/data/logfile.log innodb innodb_lock_wait_timeout=120

# Options for ndbd process: [MYSQL_CLUSTER] ndb-connectstring=141.142.234.57 # location of MGM node

I start ndb_mgmd like this: /usr/local/mysql-max-4.1.18-pc-linux-gnu-i686-glibc23/bin/ndb_mgmd -f /var/lib/mysql-cluster/config.ini

I then start the two ndbd nodes.

I start mysql.

When I do a /usr/local/mysql-max-4.1.18-pc-linux-gnu-i686-glibc23/bin/ndb_mgm -e show, I see: Connected to Management Server at: localhost:1186 Cluster Configuration

--------------------- [ndbd(NDB)] 2 node(s) id=2 @127.0.0.1 (Version: 4.1.18, starting, Nodegroup: 0, Master) id=3 (not connected, accepting connect from 141.142.234.28)

[ndb_mgmd(MGM)] 1 node(s) id=1 @141.142.234.57 (Version: 4.1.18)

[mysqld(API)] 2 node(s) id=4 (not connected, accepting connect from any host) id=5 (not connected, accepting connect from any host)

The log file for mgmd shows: 2006-05-17 07:34:27 [MgmSrvr] INFO -- NDB Cluster Management Server. Version 4.1.18 2006-05-17 07:34:27 [MgmSrvr] INFO -- Id: 1, Command port: 1186 2006-05-17 07:34:42 [MgmSrvr] INFO -- Mgmt server state: nodeid 2 reserved for ip 127.0.0.1, m_reserved_nodes 0000000000000006. 2006-05-17 07:34:43 [MgmSrvr] INFO -- Node 1: Node 2 Connected 2006-05-17 07:35:16 [MgmSrvr] INFO -- Node 2: Start phase 1 completed 2006-05-17 07:35:21 [MgmSrvr] INFO -- Mgmt server state: nodeid 4 reserved for ip 141.142.234.57, m_reserved_nodes 0000000000000016. 2006-05-17 07:49:46 [MgmSrvr] INFO -- Mgmt server state: nodeid 4 freed, m_reserved_nodes 0000000000000006. 2006-05-17 07:52:37 [MgmSrvr] INFO -- Mgmt server state: nodeid 3 reserved for ip 141.142.234.28, m_reserved_nodes 000000000000000e. 2006-05-17 08:10:39 [MgmSrvr] INFO -- Mgmt server state: nodeid 4 reserved for ip 141.142.234.57, m_reserved_nodes 000000000000001e.

Machine A's ndbd log file is: 2006-05-17 07:34:42 [ndbd] INFO -- Angel pid: 20008 ndb pid: 20009 2006-05-17 07:34:42 [ndbd] INFO -- NDB Cluster -- DB node 2 2006-05-17 07:34:42 [ndbd] INFO -- Version 4.1.18 -- 2006-05-17 07:34:42 [ndbd] INFO -- Configuration fetched at localhost port 1186

Machine B's log file is: 2006-05-17 07:52:37 [ndbd] INFO -- Angel pid: 20993 ndb pid: 20994 2006-05-17 07:52:37 [ndbd] INFO -- NDB Cluster -- DB node 3 2006-05-17 07:52:37 [ndbd] INFO -- Version 4.1.18 -- 2006-05-17 07:52:37 [ndbd] INFO -- Configuration fetched at 141.142.234.57 port 1186

From everything I have read these configurations should be right.

Why is machine B's ndbd not connecting to the ndb_mgm?

Why are neither of the mysql's connecting?

I am totally at a loss at this point. I have looked at the list archive and several different web pages referenced in past threads. So far nothing has helped.

I could use some guidance.

Thanks