MySQL Cluster線上管理節點配置文件-數據節點32G內存

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