欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

MySQL Cluster管理节点配置文件-数据节点4G内存_MySQL

程序员文章站 2022-04-26 16:22:51
...
bitsCN.com

MySQL 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
相关标签: 配置文件