Hello,

I am trying to install MySQL cluster on three physical machines.
Management Node on one machine.
Data Node on two machines.
SQL node on the same machine as Management Node.

Management node started
Data Nodes started
*SQL node started but not connected to Management NOde and it gives no
error *

C:\mysql\bin>ndb_mgm -e show
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=8 @172.16.56.8 (mysql-5.5.25 ndb-7.2.7, Nodegroup: 0, Master)
id=9 @172.16.56.9 (mysql-5.5.25 ndb-7.2.7, Nodegroup: 0)

[ndb_mgmd(MGM)] 1 node(s)
id=6 @172.16.56.7 (mysql-5.5.25 ndb-7.2.7)

[mysqld(API)] 1 node(s)
id=7 (not connected, accepting connect from 172.16.56.7)


*config.ini*

[ndbd default]
# Options affecting ndbd processes on all data nodes:
NoOfReplicas=2 # Number of replicas
DataDir=C:/mysql/bin/cluster-data # Directory for each data node's data
files
DataMemory=80M # Memory allocated to data storage
IndexMemory=18M # Memory allocated to index storage

[ndb_mgmd]
# Management process options:
HostName=172.16.56.7 # Hostname or IP address of management
node
DataDir=C:/mysql/bin/cluster-logs # Directory for management node log
files
NodeId=5

[ndbd]
# Options for data node "A":
HostName=172.16.56.8 # Hostname or IP address
NodeId=8
MaxNoOfOrderedIndexes=1024
MaxNoOfAttributes=3000 # added 2012.8.08

[ndbd]
# Options for data node "B":
HostName=172.16.56.9 # Hostname or IP address
NodeId=9
MaxNoOfOrderedIndexes=1024
MaxNoOfAttributes=3000 # added 2012.8.08



[mysqld]
# SQL node options:
HostName=172.16.56.7 # Hostname or IP address
NodeId=7

*my.ini*
*
*
[mysql_cluster]
# Options for management node process
config-file=c:/mysql/bin/config.ini
configdir=c:/mysql/bin/cluster-cache/


[mysqld]
# Options for mysqld process:
ndbcluster # run NDB storage engine
ndb-connectstring=172.16.56.7 # location of management server
ndb-nodeid=7
server-id=7
default-storage-engine=ndbcluster


Could anyone help to identify/


Aastha Gupta