MySQLCluster管理节点配置文件-数据节点4G内存_MySQL
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了MySQLCluster管理节点配置文件-数据节点4G内存_MySQL,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含2759字,纯文字阅读大概需要4分钟。
内容图文
bitsCN.comMySQL 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内容总结
以上是互联网集市为您收集整理的MySQLCluster管理节点配置文件-数据节点4G内存_MySQL全部内容,希望文章能够帮你解决MySQLCluster管理节点配置文件-数据节点4G内存_MySQL所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。