[ndb_mgmd]
NodeId=1
HostName=127.0.0.1          # This is an IP address of the cluster management node
#DataDir=/var/lib/mysql-cluster  # This is a data directory for the cluster management node
#DataDir=/usr/local/mysql/mysql-cluster
DataDir=/usr/local/mysql/data
Portnumber=1186

[tcp default]
# TCP/IP options:
SendBufferMemory=8M
ReceiveBufferMemory=8M
 
[ndbd default]
#DataDir=/var/lib/mysql-cluster
#DataDir=/usr/local/mysql/mysql-cluster
DataDir=/usr/local/mysql/data
NoOfReplicas=1
FileSystemPathDD=/var/lib/mysqlcluster/
#BackupDataDir=/var/lib/mysqlcluster/backup/
#FileSystemPathUndoFiles=/var/lib/mysqlcluster/
#FileSystemPathDataFiles=/var/lib/mysqlcluster/
DataMemory=16483M
IndexMemory=2686M
LockPagesInMainMemory=1

MaxNoOfConcurrentOperations=32768
MaxNoOfConcurrentTransactions=16384

StringMemory=25
MaxNoOfTables=10320
MaxNoOfOrderedIndexes=512
MaxNoOfUniqueHashIndexes=512
MaxNoOfAttributes=18000
MaxNoOfTriggers=71120
DiskCheckpointSpeedInRestart=100M
FragmentLogFileSize=256M
InitFragmentLogFiles=SPARSE
NoOfFragmentLogFiles=84
RedoBuffer=1000M
TransactionBufferMemory=8M

TimeBetweenLocalCheckpoints=20
TimeBetweenEpochsTimeout=32000
TimeBetweenGlobalCheckpoints=2000
TimeBetweenEpochs=100


### Heartbeating 
HeartbeatIntervalDbDb=15000
HeartbeatIntervalDbApi=15000

### 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

### Params for ODIRECT 
#Reports indicates that odirect=1 can cause io errors (os err code 5) on some systems. You must test.
#ODirect=1

### Watchdog 
TimeBetweenWatchdogCheckInitial=60000

### TransactionInactiveTimeout  - should be enabled in Production 
TransactionInactiveTimeout=60000
### New 7.1.10 redo logging parameters 
RedoOverCommitCounter=3
RedoOverCommitLimit=20
### REALTIME EXTENSIONS 
#RealTimeScheduler=1
### REALTIME EXTENSIONS FOR 6.3 ONLY
#SchedulerExecutionTimer=80
#SchedulerSpinTimer=40

### DISK DATA 
SharedGlobalMemory=384M
DiskPageBufferMemory=4024M
BatchSizePerLocalScan=1000M


[NDBD]
NodedId=2
HostName=127.0.0.1
#datadir=/usr/local/mysql/data
DataDir=/usr/local/mysql/data


[mysqld]
HostName=127.0.0.1
NodeId=3

[API]
NodeId=4
HostName=127.0.0.1