Hello All,

I'm trying to setup the default mysql clustering setup described in Chapter 15 from the MySQL Reference 5.0 but i keep on having problems with the SQL node.

The situation is al follows:

data node 1 = 192.168.100.62 = stagshoot02 data node 2 = 192.168.100.64 = stagshoot04

management = 192.168.100.65 = stagshoot05 sql node = 192.168.100.63 = stagshoot03

all the nodes (data&sql) have the basic setup and use the following /etc/my.cnf:

[MYSQLD] ndbcluster # run NDB engine ndb-connectstring=192.168.100.65 # location of MGM node

[MYSQL_CLUSTER] ndb-connectstring=192.168.100.65 # location of MGM node

The data node's connect fine, without problems. However the sql node give:

stagshoot03:/usr/local/mysql/bin# ./ndbd --initial error=2350 2006-07-06 17:34:17 [ndbd] INFO -- Error handler restarting system 2006-07-06 17:34:17 [ndbd] INFO -- Error handler shutdown completed - exiting sphase=0 exit=-1

The log file for ndbd gives:

stagshoot03:/usr/local/mysql/bin# cat /usr/local/mysql/ndb_pid6690_error.log Current byte-offset of file-pointer is: 568

Time: Thursday 6 July 2006 - 14:09:20 Status: Permanent error, external action needed Message: Invalid configuration received from Management Server (Configuration error) Error: 2350 Error data: Unable to alloc node id Error object: Could not alloc node id at 192.168.100.65 port 1186: No free node id found for ndbd(NDB). Program: bin/ndbd Pid: 6690 Trace: <no tracefile> Version: Version 5.0.22 ***EOM***

The config.ini is like this:

stagshoot05:~# cat /var/lib/mysql-cluster/config.ini [NDBD DEFAULT] NoOfReplicas=2 # Number of replicas DataMemory=80M # How much memory to allocate for data storage IndexMemory=18M # How much memory to allocate for index storage # For DataMemory and IndexMemory, we have used the # default values. Since the "world" database takes up # only about 500KB, this should be more than enough for this Cluster setup.

# TCP/IP options: [TCP DEFAULT] portnumber=2202 # default port number

# Management process options:

[NDB_MGMD] Id=1 hostname=192.168.100.65 # Hostname or IP address of MGM node datadir=/var/lib/mysql-cluster # Directory for MGM node logfiles

# Options for data node "A": # (one [NDBD] section per data node) [NDBD] Id=2 hostname=192.168.100.62 # Hostname or IP address datadir=/usr/local/mysql/data # Directory for this data node's datafiles

# Options for data node "B": [NDBD] Id=3 hostname=192.168.100.64 # Hostname or IP address datadir=/usr/local/mysql/data # Directory for this data node's datafiles

# SQL node options: [mysqld] Id=4

[mysqld] Id=5 HostName=196.168.100.63

I tried fiddling with the [mysqld] settings but it didn't help.

The management client looks like this:

-- NDB Cluster -- Management Client -- ndb_mgm> show Connected to Management Server at: localhost:1186 Cluster Configuration

--------------------- [ndbd(NDB)] 2 node(s) id=2 @192.168.100.62 (Version: 5.0.22, Nodegroup: 0, Master) id=3 @192.168.100.64 (Version: 5.0.22, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s) id=1 @192.168.100.65 (Version: 5.0.22)

[mysqld(API)] 2 node(s) id=4 @192.168.100.64 (Version: 5.0.22) id=5 (not connected, accepting connect from 196.168.100.63)

Would anybody please be able to help me?

Thanks.

Erik van Dam