Rabail Posted November 19, 2013 Share Posted November 19, 2013 Hi all, I have been trying to setup MySQL cluster 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 Quote Link to comment https://forums.phpfreaks.com/topic/284045-unable-to-start-data-nodes-on-mysql-cge-732/ Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.