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
