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

时间:2023-03-10 06:20:49
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