[NDBD DEFAULT] NoOfReplicas=2 DataDir=/var/lib/mysql-cluster DataMemory=28G IndexMemory=3G # Transaction specifics MaxNoOfConcurrentTransactions=131072 MaxNoOfConcurrentOperations=1048576 # MaxNoOfConcurrentTransactions=12000 # MaxNoOfConcurrentOperations=800000 # Transaction Storage MaxNoOfConcurrentIndexOperations=18000 #logging and Checkpointing NoOfFragmentLogFiles=500 TimeBetweenLocalCheckpoints=16 RedoBuffer=200MB UndoDataBuffer=320M UndoIndexBuffer=80M #MetaData Objects MaxNoOfAttributes=4000 MaxNoOfTables=1000 MaxNoOfOrderedIndexes=3000 MaxNoOfUniqueHashIndexes=2000 MaxNoOfTriggers=900 #Timeouts and Intervals StartFailureTimeout=0 [TCP DEFAULT] SendBufferMemory=2MB [MYSQLD DEFAULT] ArbitrationRank=2 ArbitrationDelay=0 [NDB_MGMD DEFAULT] LogDestination=FILE:filename=my-cluster.log,maxsize=1000000,maxfiles=10 PortNumber=1186 ArbitrationRank=1 #NDB Management Nodes [NDB_MGMD] ID=1 HostName=172.16.0.1 DataDir=/var/lib/mysql-cluster # Storage Nodes [NDBD] ID=5 HostName=172.16.0.10 [NDBD] ID=6 HostName=172.16.0.11 [NDBD] ID=7 HostName=172.16.0.12 [NDBD] ID=8 HostName=172.16.0.13 [NDBD] ID=9 HostName=172.16.0.14 [NDBD] ID=10 HostName=172.16.0.15 [NDBD] ID=11 HostName=172.16.0.16 [NDBD] ID=12 HostName=172.16.0.17 #Mysql Head Nodes [MYSQLD] ID=2 HostName=172.16.0.1 [MYSQLD] ID=3 HostName=172.16.0.2 ArbitrationRank=2 [MYSQLD] ID=4 HostName=172.16.0.3 [MYSQLD] ID=26 HostName=172.16.0.18 [MYSQLD] ID=27 HostName=172.16.0.19 #These extra MySQLDs are for restoring backups (One for every data Node) [MYSQLD] ID=13 [MYSQLD] ID=14 [MYSQLD] ID=15 [MYSQLD] ID=16 [MYSQLD] ID=17 [MYSQLD] ID=18 [MYSQLD] ID=19 [MYSQLD] ID=20