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

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