Problems with MySQL nodes

[Tim Pommerening]

Hi,

I tried to set up a MySQL Cluster configuration with MySQL Max 4.1.10

I have 3 hosts

1. 192.168.0.1 (MySQL node 1)
2. 192.168.0.2 (MySQL nodd 2)
3. 192.168.0.3 (Management node)

I installed "ndb_mgm" and "ndb_mgmd" at host 3 and started "ndb_mgmd". Its config file looks like:

------------------------------------------------ code -------------------------------------------

[NDBD DEFAULT]

[MYSQLD DEFAULT]

[NDB_MGMD DEFAULT]

[TCP DEFAULT]

### Management Server #################################
[NDB_MGMD]
hostName=192.168.0.3
datadir=/var/lib/mysql-cluster

### Storage Engines ###################################

[NDBD]
hostname=192.168.0.1
datadir=/var/lib/mysql

[NDBD]
hostname=192.168.0.2
datadir= /var/lib/mysql

### MySQL Clients #####################################

[MYSQLD]
[MYSQLD]

------------------------------------------------ code -------------------------------------------

After this I started "ndbd --initial" on my MySQL nodes on host 1 and 2.
Finally I startet MySQL with the following config file my.cnf:

------------------------------------------------ code -------------------------------------------

[mysqld]
ndbcluster
ndb-connectstring=192.168.0.3:1186

[mysql_cluster]
ndb-connectstring=192.168.0.3:1186

[ndbd]
ndb-connectstring=192.168.0.3:1186

[ndbd_mgm]
ndb-connectstring=192.168.0.3:1186

[ndbd_mgmd]
config-file=/var/lib/mysql-cluster/config.ini

------------------------------------------------ code -------------------------------------------

After starting the 2 "ndbd" nodes and the 2 "mysqld" nodes, I went back to host 3 and looked at the management console:

------------------------------------------------ console -------------------------------------------

:] ndb_mgm
-- NDB Cluster -- Management Client --
ndb_mgm> show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 (Version: 4.1.10, starting, Nodegroup: 0, Master)
id=3 (Version: 4.1.10, starting, Nodegroup: 0, Master)

[ndb_mgmd(MGM)] 1 node(s)
id=1 @192.168.0.3 (Version: 4.1.10)

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

------------------------------------------------ console -------------------------------------------

The logfile of "ndb_mgmd" shows the following:

------------------------------------------------ console -------------------------------------------

2005-02-22 11:36:40 [MgmSrvr] INFO -- NDB Cluster Management Server. Version 4.1.10
2005-02-22 11:36:40 [MgmSrvr] INFO -- Id: 1, Command port: 1186
2005-02-22 11:36:40 [MgmSrvr] INFO -- Node 1: Node 2 Connected
2005-02-22 11:36:42 [MgmSrvr] INFO -- Node 1: Node 3 Connected
2005-02-22 11:38:27 [MgmSrvr] INFO -- Mgmt server state: nodeid 4 reserved for ip 192.168.0.1, m_reserved_nodes 0000000000000012.
2005-02-22 11:39:05 [MgmSrvr] INFO -- Mgmt server state: nodeid 5 reserved for ip 192.168.0.2, m_reserved_nodes 0000000000000032.

------------------------------------------------ console -------------------------------------------

Where is my promlem that my "MySQL nodes" are not able to connect to the management console?
Node 1 and 2 seems to be all right. No firewalls are up anywhere. It seems that a connection between mysql and the ndb_mgmd could also be established but the console shows node 4 and 5 as not connected. The logfile shows them as preserved for their right ips.

Kind regards

Tim Pommerening