Re: Is mysqld connecting?

[Danie Van der Walt]

Hi

I seem to be having the same problem.....

I have 2 pc's to test clustering on, and from what I understood that sould be fine.
I get the management server up but I can't seem to get the datanodes/sql servers to connect to the
management server.

Here is my my.cnf file:
#Options for mysqld process
[MYSQLD]
ndbcluster #run NDB engine
ndb-connectstring=192.168.1.3 #location of MGM node

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


And here is my config.ini file:
Options affecting the ndbd processes on all data nodes:
[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 stroage
#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 example Cluster setup.

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

#Management process options:
[NDB_MGMD]
hostname=192.168.1.3
datadir=/var/lib/mysql-cluster

#Options for data node 'a'
[NDBD]
hostname=192.168.1.3
datadir=/usr/local/mysql/data

#Options for data node 'b'
[NDBD]
hostname=192.168.1.36
datadir=/usr/local/mysql/data

#SQL node
[MYSQLD]
hostname=192.168.1.3

#SQL node
[MYSQLD]
hostname=192.168.1.36






Any suggestions would be appreciated