Re: SQL nodes fail to connect Management Nodes

[urgen sherpa]

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