日期:2014-05-16  浏览次数:20844 次

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

网上的朋友提供的,仅供参考。

[NDBD DEFAULT]

NoOfReplicas= 2
DataMemory=20G
IndexMemory=5G
MaxNoOfConcurrentTransactions=8192
MaxNoOfConcurrentOperations=100000
MaxNoOfLocalOperations=110000
NoOfFragmentLogFiles=128
TimeBetweenLocalCheckpoints=6
FragmentLogFileSize=256M
RedoBuffer=64M


[MYSQLD DEFAULT]
[NDB_MGMD DEFAULT]
DataDir=/opt/mysql-cluster/data #数据存放目录


[NDB_MGMD]
id=1
HostName= 172.16.48.204


[NDBD]
id=2
Nodegroup=0
HostName= 172.16.48.206
DataDir=/opt/mysql-cluster/data


[NDBD]
id=3
Nodegroup=0
HostName= 172.16.48.207
Datadir=/opt/mysql-cluster/data


[NDBD]
id=4
Nodegroup=1
HostName= 172.16.48.208
Datadir=/opt/mysql-cluster/data


[NDBD]
id=5
Nodegroup=1
HostName= 172.16.48.211
Datadir=/opt/mysql-cluster/data


[MYSQLD]
id=6
HostName= 172.16.48.206


[MYSQLD]
id=7
HostName= 172.16.48.207


[MYSQLD]
id=8
HostName= 172.16.48.208


[MYSQLD]
id=9
HostName= 172.16.48.211


[MYSQLD]
id=10
HostName= 172.16.48.201