MySQL Cluster管理节点配置文件-数据节点4G内存

kidys

　　自己测试机器上搭建使用，大家可以参考一下
　　
　　[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