[NDBD DEFAULT] NoOfReplicas=2 MaxNoOfAttributes=10240 DataMemory=11264M IndexMemory=1024M LockPagesInMainMemory=1 MaxNoOfConcurrentOperations=10000000 MaxNoOfConcurrentTransactions=32768 TransactionDeadLockDetectionTimeOut=10000 MaxNoOfConcurrentScans=500 StringMemory=25 MaxNoOfTables=4096 MaxNoOfOrderedIndexes=1024 MaxNoOfUniqueHashIndexes=64 MaxNoOfTriggers=14336 DiskCheckpointSpeedInRestart=100M DiskCheckpointSpeed=10M FragmentLogFileSize=256M InitFragmentLogFiles=SPARSE NoOfFragmentLogFiles=12 RedoBuffer=64M TimeBetweenLocalCheckpoints=20 TimeBetweenEpochsTimeout=32000 TimeBetweenGlobalCheckpoints=2000 TimeBetweenEpochs=200 ## Heartbeating HeartbeatIntervalDbDb=15000 HeartbeatIntervalDbApi=15000 ### Params for setting logging MemReportFrequency=30 BackupReportFrequency=10 LogLevelStartup=15 LogLevelShutdown=15 LogLevelCheckpoint=8 LogLevelNodeRestart=15 LogLevelError=0 LogLevelInfo=15 ### Params for BACKUP BackupMaxWriteSize=1M BackupDataBufferSize=16M BackupLogBufferSize=4M BackupMemory=20M ### 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 ### REALTIME EXTENSIONS #RealTimeScheduler=1 ### REALTIME EXTENSIONS FOR 6.3 ONLY #SchedulerExecutionTimer=80 #SchedulerSpinTimer=40 ### DISK DATA SharedGlobalMemory=384M DiskPageBufferMemory=512M ### Multithreading MaxNoOfExecutionThreads=8 DiskIOThreadPool=1 ### Increasing the LongMessageBuffer b/c of a bug (20090903) LongMessageBuffer=32M BatchSizePerLocalScan=512 [MYSQLD DEFAULT] [NDB_MGMD DEFAULT] PortNumber=1186 [TCP DEFAULT] SendBufferMemory=16M ReceiveBufferMemory=16M [NDB_MGMD] NodeId=1 HostName=172.16.129.67 [NDB_MGMD] NodeId=2 HostName=172.16.129.68 [NDBD] NodeId=3 NodeGroup=0 HostName=172.16.129.67 # the IP of the FIRST SERVER DataDir=/rancore1/mysql-cluster/data0 [NDBD] NodeId=4 NodeGroup=0 HostName=172.16.129.68 # the IP of the SECOND SERVER DataDir=/rancore1/mysql-cluster/data0 [NDBD] NodeId=5 NodeGroup=1 HostName=172.16.129.67 # the IP of the FIRST SERVER DataDir=/rancore2/mysql-cluster/data2 [NDBD] NodeId=6 NodeGroup=1 HostName=172.16.129.68 # the IP of the SECOND SERVER DataDir=/rancore2/mysql-cluster/data2 [MYSQLD] HostName=172.16.129.67 [MYSQLD] HostName=172.16.129.68 [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD] [API] [API] [API] [API] [API] [API] [API] [API] [API] [API] [API] [API] [API] [API] [API] [API] [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD] [API] [API] [API] [API] [API] [API] [API] [API] [API] [API] [API] [API] [API] [API] [API] [API] [API] [API] [API] [API] [API] [API] [API] [API] [API] [API] [API] [API] [API] [API] [API] [API] [API] [API] [API] [API] [API] [API] [API] [API] [API]