# # DEFAULT SETTINGS # # Default settings for all data nodes [TCP DEFAULT] SendBufferMemory=2M [NDBD DEFAULT] #LockPagesInMainMemory=Y NoOfReplicas=2 DataMemory=1G IndexMemory=200M RedoBuffer=32M UndoIndexBuffer=8M UndoDataBuffer=32M NoOfFragmentLogFiles=50 MaxNoOfAttributes=7000 MaxNoOfOrderedIndexes=512 MaxNoOfUniqueHashIndexes=512 MaxNoOfTriggers=4000 MaxNoOfOpenFiles=60 MaxNoOfConcurrentOperations=500000 MaxNoOfConcurrentTransactions=20000 StopOnError=1 #Disk Settings TimeBetweenLocalCheckpoints=6 NoOfDiskPagesToDiskAfterRestartACC=20 NoOfDiskPagesToDiskAfterRestartTUP=100 NoOfDiskPagesToDiskDuringRestartACC=30 NoOfDiskPagesToDiskDuringRestartTUP=150 DataDir=/path/to/cluster HeartbeatIntervalDbDb=2000 ArbitrationTimeout=2000 # # COMPUTER DEFINITIONS # [COMPUTER] Id = 1 Hostname = ndbsup-priv-1 [COMPUTER] Id = 2 Hostname = ndbsup-priv-2 [COMPUTER] Id = 3 Hostname = ndbsup-priv-3 [COMPUTER] Id = 4 Hostname = ndbsup-priv-4 # # NODE DEFINITIONS # # Data Nodes # Node group #1 [NDBD] Id= 1 ExecuteOnComputer= 3 [NDBD] Id= 2 ExecuteOnComputer= 4 # Node group #2 [NDBD] Id= 3 ExecuteOnComputer= 3 [NDBD] Id= 4 ExecuteOnComputer= 4 # Management node [NDB_MGMD] Id= 17 ExecuteOnComputer= 1 DataDir=/path/to/cluster portnumber=1406 # 4 Nodes on the Datnodes for misc use [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD] # 4 Webnodes [MYSQLD] [MYSQLD] [MYSQLD] [MYSQLD]