[ndbd default]
# Options affecting ndbd processes on all data nodes:
# Local checkpoints, redo logs and undo logs will be placed on datadir.
# Data disk files will be placed on /mysqldata at datanodes.
datadir=/ndbdata                # Directory for this data node's data files
NoOfReplicas=2    		 # Number of replicas
DataMemory=27648M  		 # How much memory to allocate for data storage
IndexMemory=8192M   		 # How much memory to allocate for index storage

# Disk Data
SharedGlobalMemory=1024M
DiskPageBufferMemory=20480M
MaxNoOfConcurrentOperations=128000

# MaxNoOfLocalScans= tcInstances * lqhInstances * noOfDBNodes * MaxNoOfConcurrentScans + 2
MaxNoOfLocalScans=49156

MaxNoOfOrderedIndexes=512
MaxNoOfUniqueHashIndexes=512
MaxNoOfAttributes=4096
MaxNoOfTriggers=28672
MaxNoOfTables=4096

MaxDiskWriteSpeed=50M
MinDiskWriteSpeed=30M


# https://dev.mysql.com/doc/refman/5.6/en/mysql-cluster-ndbd-definition.html#ndbparam-ndbd-nooffragmentlogfiles
# Multithreading
# Total redo log file size: FragmentLogFileSize * NoOfFragmentLogFiles

MaxNoOfExecutionThreads=16
NoOfFragmentLogParts=8
NoOfFragmentLogFiles=96
DiskIOThreadPool=8
FragmentLogFileSize=64M
TransactionDeadlockDetectionTimeout=50000

TotalSendBufferMemory = 64M

[tcp default]
# TCP/IP options:
portnumber=2202   # This the default; however, you can use any
                  # port that is free for all the hosts in the cluster
                  # Note: It is recommended that you do not specify the port
                  # number at all and simply allow the default value to be used
                  # instead

SendBufferMemory   = 8M
ReceiveBufferMemory = 8M

[ndb_mgmd]
nodeid=1
hostname=192.142.152.212
datadir=/var/lib/mysql-cluster

[ndb_mgmd]
nodeid=2
hostname=192.142.152.213
datadir=/var/lib/mysql-cluster

[ndbd]
nodeid=5
hostname=192.142.152.204

[ndbd]
nodeid=6
hostname=192.142.152.205

[ndbd]
nodeid=7
hostname=192.142.152.206

[ndbd]
nodeid=8
hostname=192.142.152.207

[ndbd]
nodeid=9
hostname=192.142.152.208

[ndbd]
nodeid=10
hostname=192.142.152.209

[ndbd]
nodeid=11
hostname=192.142.152.210

[ndbd]
nodeid=12
hostname=192.142.152.211

# Connection pool size is 64. So we need 64 free slots for each mysqld. Also added 2 free slots.
[mysqld]
hostname=192.142.152.212
[mysqld]
hostname=192.142.152.213
[mysqld]
hostname=192.142.152.214
[mysqld]
hostname=192.142.152.215
[mysqld]
hostname=192.142.152.212
[mysqld]
hostname=192.142.152.213
[mysqld]
hostname=192.142.152.214
[mysqld]
hostname=192.142.152.215
[mysqld]
hostname=192.142.152.212
[mysqld]
hostname=192.142.152.213
[mysqld]
hostname=192.142.152.214
[mysqld]
hostname=192.142.152.215
[mysqld]
hostname=192.142.152.212
[mysqld]
hostname=192.142.152.213
[mysqld]
hostname=192.142.152.214
[mysqld]
hostname=192.142.152.215
[mysqld]
hostname=192.142.152.212
[mysqld]
hostname=192.142.152.213
[mysqld]
hostname=192.142.152.214
[mysqld]
hostname=192.142.152.215
[mysqld]
hostname=192.142.152.212
[mysqld]
hostname=192.142.152.213
[mysqld]
hostname=192.142.152.214
[mysqld]
hostname=192.142.152.215
[mysqld]
hostname=192.142.152.212
[mysqld]
hostname=192.142.152.213
[mysqld]
hostname=192.142.152.214
[mysqld]
hostname=192.142.152.215
[mysqld]
hostname=192.142.152.212
[mysqld]
hostname=192.142.152.213
[mysqld]
hostname=192.142.152.214
[mysqld]
hostname=192.142.152.215
[mysqld]
hostname=192.142.152.212
[mysqld]
hostname=192.142.152.213
[mysqld]
hostname=192.142.152.214
[mysqld]
hostname=192.142.152.215
[mysqld]
hostname=192.142.152.212
[mysqld]
hostname=192.142.152.213
[mysqld]
hostname=192.142.152.214
[mysqld]
hostname=192.142.152.215
[mysqld]
hostname=192.142.152.212
[mysqld]
hostname=192.142.152.213
[mysqld]
hostname=192.142.152.214
[mysqld]
hostname=192.142.152.215
[mysqld]
hostname=192.142.152.212
[mysqld]
hostname=192.142.152.213
[mysqld]
hostname=192.142.152.214
[mysqld]
hostname=192.142.152.215