# Options affecting ndbd processes on all home/data nodes:
[ndbd default]
NoOfReplicas=2

DataMemory=1024M    # How much memory to allocate for home/data storage
IndexMemory=64M    # How much memory to allocate for index storage
                  # For DataMemory and IndexMemory, we have used the
                  # default values. Since the "world" home/database takes up
                  # only about 500KB, this should be more than enough for
                  # this example Cluster setup.
LockPagesInMainMemory=1
TransactionDeadLockDetectionTimeOut=10000
TransactionBufferMemory=64M

MaxNoOfConcurrentOperations=500000
MaxNoOfLocalOperations=550000
#    (maximum number of tables accessed in any single transaction + 1)
#    * number of cluster SQL nodes
MaxNoOfConcurrentTransactions=25600

#Out of scanfrag records in TC (increase MaxNoOfLocalScans);[ERROR] Got error 291 when reading table './ekor2new/betdetail'
MaxNoOfLocalScans=102400
#The default value of MaxNoOfConcurrentScans is 256. The maximum value is 500.
MaxNoOfConcurrentScans=400
#Temporary error: 410: REDO log files overloaded (decrease TimeBetweenLocalCheckpoints or increase NoOfFragmentLogFiles)
NoOfFragmentLogFiles=512

#Can't create table 'ekor3.sysconfig' (errno: 708)
MaxNoOfAttributes=51200
MaxNoOfOrderedIndexes=25600
MaxNoOfUniqueHashIndexes=25600

#Got temporary error 1218 'Send Buffers overloaded in NDB kernel'
TotalSendBufferMemory=128M

#GCP Stop 2303 Error
TimeBetweenGlobalCheckpoints=1000
TimeBetweenEpochsTimeout=0

### DISK DATA
DiskPageBufferMemory=64M

### Undo Buffers
SharedGlobalMemory=32M
UndoIndexBuffer=16M
UndoDataBuffer=32M

### Redo Buffers
RedoBuffer=64M

### Multithreading
MaxNoOfExecutionThreads=2

# Error in NdbJTie: returnCode -1, code 218, mysqlCode -1, status 1, classification 7, message Out of LongMessageBuffer
LongMessageBuffer=64M

[TCP DEFAULT]
OverloadLimit=64M

[ndb_mgmd]
NodeId=1
Hostname=192.168.100.1
Datadir=/opt/data/mgmd
LogDestination=FILE:filename=ndb_1_cluster.log,maxsize=10000000,maxfiles=8
ArbitrationRank=0
[ndb_mgmd]
NodeId=2
Hostname=192.168.100.2
Datadir=/opt/data/mgmd
LogDestination=FILE:filename=ndb_2_cluster.log,maxsize=10000000,maxfiles=8
ArbitrationRank=0

[ndbd]
NodeId=10
HostName=192.168.100.1
DataDir=/opt/data/ndbd
backupdatadir=/opt/data/backup
[ndbd]
NodeId=11
HostName=192.168.100.2
DataDir=/opt/data/ndbd
backupdatadir=/opt/data/backup

[mysqld]
NodeId=20
[mysqld]
[mysqld]
[mysqld]