MySQL Cluster管理节点配置文件-数据节点4G内存
来源:互联网 发布:淘宝产品首页营销图片 编辑:程序博客网 时间:2024/05/01 09:27
自己测试机器上搭建使用,大家可以参考一下
[NDBD DEFAULT]
#TotalSendBufferMemory = 256MNoOfReplicas=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
- MySQL Cluster管理节点配置文件-数据节点4G内存
- MySQL Cluster线上管理节点配置文件-数据节点32G内存
- MySQL Cluster线上管理节点配置文件-数据节点96G内存
- MySQL Cluster配置文件-SQL节点4G内存
- mysql cluster管理节点启动报错
- mysql cluster管理节点配置详解
- mysql cluster在线添加数据节点
- mysql-cluster数据节点启动过程中报错
- Mysql Cluster水平扩展-添加数据节点
- Mysql Cluster在线添加数据节点
- mysql cluster在线添加数据节点
- Mysql Cluster 动态增加数据节点
- Mysql Cluster水平扩展-添加数据节点
- MySQL Cluster验证管理节点配置中内存是否超标的脚本
- [置顶]Windows Server 2008R2配置MySQL Cluster并将管理节点和数据节点配置成windows服务
- MySQL Cluster (五) --- 动态增加数据节点配置步骤
- MySQL Cluster (五) --- 动态增加数据节点配置步骤
- mysql cluster 7.2在线添加数数据节点
- 8种Nosql数据库系统对比
- 底层编码能力正逐步丧失
- mongodb与mysql相比的优缺点
- [20130825]A Short History of Nearly Everything[serial]
- JAVA常用方法
- MySQL Cluster管理节点配置文件-数据节点4G内存
- VC 快捷启动桌面制作
- 一天游戏后的感悟
- 写在Aras Innovator技术贴 前面
- UVA 11404 Palindromic Subsequence
- 深入学习Django源码基础1 - 深刻理解Python中的元类(metaclass)
- SOJ 1310. Right-Heavy Tree
- 中国集成电路发展探秘
- MemSQL学习笔记-类似MySQL的数据库