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

页面导航:首页 > 数据库 > Mysql > MySQL Cluster管理节点配置文件-数据节点4G内存

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

来源: 作者: 时间:2016-02-17 10:07 【

MySQL Cluster管理节点配置文件-数据节点4G内存自己测试机器上搭建使用,大家可以参考一下[NDBD DEFAULT]#TotalSendBufferMemory = 256MNoOfReplicas=2DataMemory=2500MIndexMemory=256MDataDir=/var/lib/my...
MySQL Cluster管理节点配置文件-数据节点4G内存
 
自己测试机器上搭建使用,大家可以参考一下
 
[NDBD DEFAULT]
#TotalSendBufferMemory = 256M
NoOfReplicas=2
DataMemory=2500M
IndexMemory=256M
DataDir=/var/lib/-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
Tags:

文章评论

最 近 更 新
热 点 排 行
Js与CSS工具
代码转换工具

<