MySQL Cluster管理節點配置文件-數據節點4G內存 自己測試機器上搭建使用，大家可以參考一下 [NDBD DEFAULT] #TotalSendBufferMemory = 256M NoOfReplicas=2 DataMemory=2500M IndexMemory=256M DataDir=/var/lib/mysql-cluster #FileSystemPath=/data/dbdata #Redo log FragmentLogFileSize=32M InitFragmentLogFiles=SPARSE NoOfFragmentLogFiles=8 RedoBuffer=1024M StringMemory=25 LockPagesInMainMemory=1 MaxNoOfTables=4096 MaxNoOfOrderedIndexes=2048 MaxNoOfUniqueHashIndexes=1024 MaxNoOfAttributes=24576 MaxNoOfTriggers=14336 ODirect=1 MaxNoOfConcurrentTransactions=10000 MaxNoOfConcurrentOperations=50000 MaxNoOfLocalOperations=55000 TimeBetweenGlobalCheckpoints=1000 TimeBetweenEpochs=100 TimeBetweenWatchdogCheckInitial=60000 TransactionBufferMemory=10M DiskCheckpointSpeed=10M DiskCheckpointSpeedInRestart=100M TimeBetweenLocalCheckpoints=20 SchedulerSpinTimer=400 SchedulerExecutionTimer=100 RealTimeScheduler=1 BackupMaxWriteSize=1M BackupDataBufferSize=16M BackupLogBufferSize=4M BackupMemory=20M MaxNoOfExecutionThreads=4 TransactionDeadLockDetectionTimeOut=10000 BatchSizePerLocalScan=512 ### Increasing the LongMessageBuffer b/c of a bug (20090903) LongMessageBuffer=8M ### Heartbeating HeartbeatIntervalDbDb=15000 HeartbeatIntervalDbApi=15000 [MGM DEFAULT] PortNumber: 1186 DataDir: /var/lib/mysql-cluster1 [TCP DEFAULT] SendBufferMemory: 64M ####################################### # 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.36 ArbitrationRank: 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: 10.100.200.39 ArbitrationRank: 2 [API] NodeId: 11 HostName: 10.100.200.39 ArbitrationRank: 2 [API] NodeId: 12 HostName: 10.100.200.39 ArbitrationRank: 2 [API] NodeId: 13 HostName: 10.100.200.39 ArbitrationRank: 2 [API] NodeId: 14 HostName: 10.100.200.41 ArbitrationRank: 2 [API] NodeId: 15 HostName: 10.100.200.41 ArbitrationRank: 2 [API] NodeId: 16 HostName: 10.100.200.41 ArbitrationRank: 2 [API] NodeId: 17 HostName: 10.100.200.41 ArbitrationRank: 2 [API] [API] #[API] #Id: 12 #HostName: HOST3
