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