MySQLCluster management node configuration file-data node 4 GB memory _ MySQL

MySQLCluster management node configuration file-data node 4G memory bitsCN.com

MySQL Cluster management node configuration file-4 GB memory for data nodes

Build and use the machine on your own. you can refer

[Ndbd default]

# TotalSendBufferMemory = 256 M

NoOfReplicas = 2

DataMemory = 2500 M

IndexMemory = 256 M

DataDir =/var/lib/mysql-cluster

# FileSystemPath =/data/dbdata

# Redo log

FragmentLogFileSize = 32 M

InitFragmentLogFiles = SPARSE

NoOfFragmentLogFiles = 8

RedoBuffer = 1024 M

StringMemory = 25

LockPagesInMainMemory = 1

MaxNoOfTables = 4096

MaxNoOfOrderedIndexes = 2048

MaxNoOfUniqueHashIndexes = 1024

MaxNoOfAttributes = 24576

MaxNoOfTriggers = 14336

ODirect = 1

MaxNoOfConcurrentTransactions = 10000

MaxNoOfConcurrentOperations = 50000

MaxNoOfLocalOperations = 55000

TimeBetweenGlobalCheckpoints = 1000

Time betweenepochs = 100

TimeBetweenWatchdogCheckInitial = 60000

TransactionBufferMemory = 10 M

DiskCheckpointSpeed = 10 M

DiskCheckpointSpeedInRestart = 100 M

TimeBetweenLocalCheckpoints = 20

SchedulerSpinTimer = 400

SchedulerExecutionTimer = 100

RealTimeScheduler = 1

BackupMaxWriteSize = 1 M

BackupDataBufferSize = 16 M

BackupLogBufferSize = 4 M

BackupMemory = 20 M

MaxNoOfExecutionThreads = 4

TransactionDeadLockDetectionTimeOut = 10000

BatchSizePerLocalScan = 512

### Increasing the LongMessageBuffer B/c of a bugs (20090903)

LongMessageBuffer = 8 M

### Heartbeating

HeartbeatIntervalDbDb = 15000

HeartbeatIntervalDbApi = 15000

[Mgm default]

PortNumber: 1186

DataDir:/var/lib/mysql-cluster1

[Tcp default]

SendBufferMemory: 64 M

#######################################

# 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