[tcp default]
SendBufferMemory=16M
ReceiveBufferMemory=16M

[ndbd default]
ServerPort=2200
NoOfReplicas=2                       # Number of replicas
DataMemory=92G                       # How much memory to allocate for data storage
IndexMemory=11G                      # How much memory to allocate for index storage
ODirect=1
LockPagesInMainMemory=1      # Prevent swapping
TransactionBufferMemory=8M
TimeBetweenGlobalCheckpoints=1000
LongMessageBuffer=64M
MaxNoOfTables=4096
MaxNoOfOrderedIndexes=2048
MaxNoOfAttributes=10000

### Limits
MaxNoOfConcurrentOperations=100000
MaxNoOfConcurrentTransactions=16384
MaxNoOfConcurrentScans=500
MaxNoOfLocalScans=100000
MaxNoOfConcurrentIndexOperations=16000

### Filesystem
datadir=/opt/mysql
FileSystemPathUndoFiles=/opt/mysql
FileSystemPathDataFiles=/opt/mysql
FileSystemPathDD=/opt/mysql          # Directory for this data node's data files
BackupDataDir=/opt/mysql

### REDO Log
FragmentLogFileSize=64M     # REDO log file size
InitFragmentLogFiles=SPARSE
NoOfFragmentLogFiles=64
NoOfFragmentLogParts=16
RedoBuffer=64M

### Local Checkpoint
CompressedLCP=0              # Compress local checkpoint data
DiskCheckpointSpeed=10M
DiskCheckpointSpeedInRestart=100M
TimeBetweenLocalCheckpoints=20

### Multithreading 
#MaxNoOfExecutionThreads=24
LockMaintThreadsToCPU=10
ThreadConfig=ldm={count=8,cpubind=0,1,2,4,5,6,8,9},tc={count=4,cpubind=3,7,11,15},main={cpubind=10},io={cpubind=10},rep={cpubind=10},recv={count=3,cpubind=17,18,10},send={count=4,cpubind=16,12,13,14}

### DISK DATA 
SharedGlobalMemory=512M
DiskPageBufferMemory=64M
BatchSizePerLocalScan=512

### Heartbeating 
HeartbeatIntervalDbDb=1500
HeartbeatIntervalDbApi=1500

### Params for setting logging
MemReportFrequency=30
BackupReportFrequency=10
LogLevelStartup=15
LogLevelShutdown=15
LogLevelCheckpoint=8
LogLevelNodeRestart=15

### Params for BACKUP
BackupMaxWriteSize=1M
BackupDataBufferSize=24M
BackupLogBufferSize=16M
BackupMemory=40M

[ndb_mgmd default]
datadir=/var/log
PortNumber=1186

[ndb_mgmd]
hostname=10.84.44.115
NodeId=1
LogDestination=FILE:filename=ndb_1_cluster.log,maxsize=10000000,maxfiles=6
ArbitrationRank=0

[ndb_mgmd]
hostname=10.84.44.116
NodeId=2
LogDestination=FILE:filename=ndb_2_cluster.log,maxsize=10000000,maxfiles=6
ArbitrationRank=0

[ndbd]
hostname=10.84.44.115
NodeId=3
### REALTIME ASPECTS - THREAD BINDING 
### READ http://johanandersson.blogspot.com/2008/02/mysql-cluster-features-what-they-are.html#realtime
#LockExecuteThreadToCPU=X
#LockMaintThreadsToCPU=Y


[ndbd]
hostname=10.84.44.116
NodeId=4
### REALTIME ASPECTS - THREAD BINDING 
### READ http://johanandersson.blogspot.com/2008/02/mysql-cluster-features-what-they-are.html#realtime
#LockExecuteThreadToCPU=X
#LockMaintThreadsToCPU=Y

[ndbd]
hostname=10.84.44.113
NodeId=5
### REALTIME ASPECTS - THREAD BINDING 
### READ http://johanandersson.blogspot.com/2008/02/mysql-cluster-features-what-they-are.html#realtime
#LockExecuteThreadToCPU=X
#LockMaintThreadsToCPU=Y


[ndbd]
hostname=10.84.44.114
NodeId=6
### REALTIME ASPECTS - THREAD BINDING 
### READ http://johanandersson.blogspot.com/2008/02/mysql-cluster-features-what-they-are.html#realtime
#LockExecuteThreadToCPU=X
#LockMaintThreadsToCPU=Y

[mysqld default]
DefaultOperationRedoProblemAction=ABORT
BatchSize=512
#BatchByteSize=2048K
#MaxScanBatchSize=2048K

[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]

[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]

[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]

[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]

[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]

[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]

[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]

[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]

[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]

[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]

[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]

[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]

[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]

[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]

[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]

[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]
[mysqld]