MySQL Cluster管理节点配置文件-数据节点4G内存_MySQL
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
bitsCN.com推荐阅读
-
MySQL Cluster验证管理节点配置中内存是否超标的脚本_MySQL
-
mysql cluster数据节点启不了
-
MySQL Cluster在线添加数据节点_MySQL
-
mysql cluster数据节点启不了
-
mysql-【求救】关于MYSQL CLUSTER数据文件存放节点错误问题
-
MySQL Cluster在线添加数据节点_MySQL
-
MySQL Cluster配置文件-SQL节点4G内存_MySQL
-
MySQL Cluster7.2在线增加数据节点存在重大弊端
-
mysql-【求救】关于MYSQL CLUSTER数据文件存放节点错误问题
-
MySQL Cluster配置文件-SQL节点4G内存_MySQL