Hi all,

I have been trying to setup MySQL cluster (MySQL CGE 7.3.2) on three nodes. One Management Node (10.1.254.32), One SQL Node (10.1.254.32), and two data nodes (10.11.11.114 and 10.11.11.90).

Following is my config.ini at /root/MySQL_Cluster at the Management node:


************************************************** ************************

#
# Configuration file for ptcldbcluster
#

[NDB_MGMD DEFAULT]
Portnumber=1186

[NDB_MGMD]
NodeId=49
HostName=10.1.254.32
DataDir=/root/MySQL_Cluster/49/
Portnumber=1186


[TCP DEFAULT]
SendBufferMemory=4M
ReceiveBufferMemory=4M

[NDBD DEFAULT]
BackupMaxWriteSize=1M
BackupDataBufferSize=16M
BackupLogBufferSize=4M
BackupMemory=20M
BackupReportFrequency=10
MemReportFrequency=30
LogLevelStartup=15
LogLevelShutdown=15
LogLevelCheckpoint=8
LogLevelNodeRestart=15
DataMemory=1M
IndexMemory=1M
MaxNoOfTables=4096
MaxNoOfTriggers=3500
NoOfReplicas=2
StringMemory=25
DiskPageBufferMemory=64M
SharedGlobalMemory=20M
LongMessageBuffer=32M
MaxNoOfConcurrentTransactions=16384
BatchSizePerLocalScan=512
FragmentLogFileSize=256M
NoOfFragmentLogFiles=3
RedoBuffer=32M
MaxNoOfExecutionThreads=2
StopOnError=false
LockPagesInMainMemory=1
TimeBetweenEpochsTimeout=32000
TimeBetweenWatchdogCheckInitial=60000
TransactionInactiveTimeout=60000
HeartbeatIntervalDbDb=15000
HeartbeatIntervalDbApi=15000

[NDBD]
NodeId=1
HostName=10.11.11.114
DataDir=/root/MySQL_Cluster/1/

[NDBD]
NodeId=2
HostName=10.11.11.90
DataDir=/root/MySQL_Cluster/2/

[MYSQLD DEFAULT]

[MYSQLD]
NodeId=55
HostName=10.1.254.32

************************************************** *********************

So following is the status on Management Node:


[root@mysqclusternode1 ~]# ndb_mgm
-- NDB Cluster -- Management Client --
ndb_mgm> SHOW
Connected to Management Server at: localhost:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=1 (not connected, accepting connect from 10.11.11.114)
id=2 (not connected, accepting connect from 10.11.11.90)

[ndb_mgmd(MGM)] 1 node(s)
id=49 @10.1.254.32 (mysql-5.6.11 ndb-7.3.2)

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

************************************************** ****************************

When I try to start the data nodes by entering 'ndbd' on each of the node, I get the following error:

[root@mysqlclusternode4 ~]# ndbd
Unable to connect with connect string: nodeid=0,localhost:1186
Retrying every 5 seconds. Attempts left: 12 11 10 9 8 7 6 5 4 3 2 1, failed.
2013-11-19 12:12:42 [ndbd] ERROR -- Could not connect to management server, error: ''

Following is the logfile on the data node:


ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
2013-11-19 12:11:24 [ndbd] ERROR -- Could not set dynamic port for 1->50 (/pb2/build/sb_0-9483450-1371110533.26/rpm/BUILD/mysql-cluster-com-7.3.2/mysql-cluster-com-7.3.2/storage/ndb/src/common/transporter/TransporterRegistry.cpp:2229) - Repeated 18 times
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
2013-11-19 12:11:27 [ndbd] ERROR -- Could not set dynamic port for 1->50 (/pb2/build/sb_0-9483450-1371110533.26/rpm/BUILD/mysql-cluster-com-7.3.2/mysql-cluster-com-7.3.2/storage/ndb/src/common/transporter/TransporterRegistry.cpp:2229) - Repeated 17 times
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
2013-11-19 12:11:30 [ndbd] ERROR -- Could not set dynamic port for 1->50 (/pb2/build/sb_0-9483450-1371110533.26/rpm/BUILD/mysql-cluster-com-7.3.2/mysql-cluster-com-7.3.2/storage/ndb/src/common/transporter/TransporterRegistry.cpp:2229) - Repeated 19 times
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
2013-11-19 12:11:33 [ndbd] ERROR -- Could not set dynamic port for 1->50 (/pb2/build/sb_0-9483450-1371110533.26/rpm/BUILD/mysql-cluster-com-7.3.2/mysql-cluster-com-7.3.2/storage/ndb/src/common/transporter/TransporterRegistry.cpp:2229) - Repeated 18 times
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
2013-11-19 12:11:36 [ndbd] ERROR -- Could not set dynamic port for 1->50 (/pb2/build/sb_0-9483450-1371110533.26/rpm/BUILD/mysql-cluster-com-7.3.2/mysql-cluster-com-7.3.2/storage/ndb/src/common/transporter/TransporterRegistry.cpp:2229) - Repeated 17 times
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
2013-11-19 12:11:39 [ndbd] ERROR -- Could not set dynamic port for 1->50 (/pb2/build/sb_0-9483450-1371110533.26/rpm/BUILD/mysql-cluster-com-7.3.2/mysql-cluster-com-7.3.2/storage/ndb/src/common/transporter/TransporterRegistry.cpp:2229) - Repeated 17 times
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
2013-11-19 12:11:42 [ndbd] ERROR -- Could not set dynamic port for 1->50 (/pb2/build/sb_0-9483450-1371110533.26/rpm/BUILD/mysql-cluster-com-7.3.2/mysql-cluster-com-7.3.2/storage/ndb/src/common/transporter/TransporterRegistry.cpp:2229) - Repeated 18 times
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
ERROR Message: Failed
2013-11-19 12:11:45 [ndbd] ERROR -- Could not set dynamic port for 1->50 (/pb2/build/sb_0-9483450-1371110533.26/rpm/BUILD/mysql-cluster-com-7.3.2/mysql-cluster-com-7.3.2/storage/ndb/src/common/transporter/TransporterRegistry.cpp:2229) - Repeated 17 times

I am unable to start any of the data node and I am stuck. Kindly help me out if you know the workaround!! Will be really thankful