MySQL Forums
Forum List  »  NDB clusters

Re: SQL nodes fail to connect Management Nodes
Posted by: urgen sherpa
Date: August 18, 2016 10:39PM

Thanks Mikael Ronstrom , but arent these lines supposed to define the number of replica, ndb nodes and sqlnodes(in original post) please correct me if im incorrect. I removed mysqlcluster v 7.4.11 and installed v 7.4.12 . and exact config file worked.

[NDBD]
#NodeId=2
Hostname=100.100.100.20
datadir=/var/lib/mysqlcluster


[NDBD]
#NodeId=3
Hostname=100.100.100.30
datadir=/var/lib/mysqlcluster

[NDBD DEFAULT]
NoOfReplicas=2
ServerPort=2200
Datadir=/var/lib/mysqlcluster/
FileSystemPathDD=/var/lib/mysqlcluster/backup
BackupDataDir=/var/lib/mysqlcluster/backup/
DataMemory=85899345920
IndexMemory=8589934592
LockPagesInMainMemory=1

MaxNoOfConcurrentOperations=150000
MaxNoOfConcurrentTransactions=150000
MaxNoOfLocalOperations=150000
...
...

In fact this config worked for v. 7.4.11 until i changed the
DataMemory = 85899345920 #(80GB)
IndexMemory = 8589934592 #(8GB)

where total memory for each datanode is 95G

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: SQL nodes fail to connect Management Nodes
1123
August 18, 2016 10:39PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.