MySQL Cluster management node configuration file-4 GB memory for data nodes

MySQL Cluster management node configuration file-data node 4G memory self-built on the machine for use, refer to [ndbd default] # TotalSendBufferMemory = 256 MNoOfReplicas = 2 DataMemory = 2500 MIndexMemory = 256 MDataDir =/var/lib/mysql-cluster # FileSystemPath =/data/dbdata # Redo logFragmentLogFileSize = 32 bytes = 8 RedoBuffer = 1024 M StringMemory = 25 bytes = 1 MaxNoOfTables = 4096 bytes = 2048 bytes = 1024 MaxNoOfAttributes = 24576 MaxNoOfTriggers = 14336 ODirect = 1 bytes = 10000 bytes = 50000 MaxNoOfLocalOperations = 55000 bytes = 1000 TimeBetweenEpochs = 100 bytes = 60000 TransactionBufferMemory = 10 MDiskCheckpointSpeed = 10 bytes = 100 bytes = 20 bytes = 400 bytes = 100 RealTimeScheduler = 1 BackupMaxWriteSize = 1 bytes = 16 MBackupLogBufferSize = 4 MBackupMemory = 20 M MaxNoOfExecutionThreads = 4 bytes = 10000 BatchSizePerLocalScan = 512 ### Increasing the LongMessageBuffer B/c of a bug (20090903) longMessageBuffer = 8 M ### Heartbeating HeartbeatIntervalDbDb = 15000 HeartbeatIntervalDbApi = 15000 [mgm default] PortNumber: 1186 DataDir:/var/lib/mysql-cluster1 [tcp default] SendBufferMemory: 64 M ###################################### # Change HOST1 to the name of the NDB_MGMD host # Change HOST2 to the name of the NDB_MGMD host # Change HOST3 to the name of the NDB_MGMD host # Change HOST4 to the name of the NDBD host # Change HOST5 to the name of the NDBD host # Change HOST6 to the name of the NDBD host # Change HOST7 to the name of the NDBD host # Change HOST8 to the name of the NDBD host # Change HOST9 to the name of the NDBD host ############################# ######### [NDB_MGMD] NodeId: 1 HostName: 10.100.200.36ArbitrationRank: 1 [NDBD] NodeId: 4 HostName: 10.100.200.37 [NDBD] NodeId: 5 HostName: 10.100.200.38 # [NDBD] # NodeId: # HostName: ######################################## ############## Note: the following can be MySQLD connections or # ndb api application connecting to the cluster ######################## ############################## [API] NodeId: 10 HostName: Repository: 2 [API] NodeId: 11 HostName: 10.100.200.39ArbitrationRank: 2 [API] NodeId: 12 HostName: 10.100.200.39ArbitrationRank: 2 [API] NodeId: 13 HostName: Repository: 2 [API] NodeId: 14 HostName: 10.100.200.41ArbitrationRank: 2 [API] NodeId: 15 HostName: 10.100.200.41ArbitrationRank: 2 [API] NodeId: 16 HostName: Region: 2 [API] NodeId: 17 HostName: 10.100.200.41ArbitrationRank: 2 [API] [API] # [API] # Id: 12 # HostName: HOST3