1
######################################################
2
# MySQL NDB Cluster Huge Sample Configuration File #
3
######################################################
4
# This files assumes that you are using at least 9 #
5
# hosts for running the cluster. Hostnames and paths #
6
# listed below should be changed to match your setup #
7
######################################################
11
DataDir: /add/path/here
12
FileSystemPath: /add/path/here
14
# Data Memory, Index Memory, and String Memory #
19
# Transaction Parameters #
20
MaxNoOfConcurrentTransactions: 4096
21
MaxNoOfConcurrentOperations: 100000
22
MaxNoOfLocalOperations: 100000
24
# Transaction Temporary Storage #
25
MaxNoOfConcurrentIndexOperations: 8192
26
MaxNoOfFiredTriggers: 4000
27
TransactionBufferMemory: 1M
29
# Scans and buffering #
30
MaxNoOfConcurrentScans: 300
32
BatchSizePerLocalScan: 64
35
# Logging and Checkpointing #
36
NoOfFragmentLogFiles: 300
37
FragmentLogFileSize: 16M
39
InitialNoOfOpenFiles: 27
40
MaxNoOfSavedMessages: 25
43
MaxNoOfAttributes: 1500
45
MaxNoOfOrderedIndexes: 200
46
MaxNoOfUniqueHashIndexes: 200
49
# Boolean Parameters #
50
LockPagesInMainMemory: 0
55
# Controlling Timeouts, Intervals, and Disk Paging #
56
TimeBetweenWatchDogCheck: 6000
57
TimeBetweenWatchDogCheckInitial: 6000
58
StartPartialTimeout: 30000
59
StartPartitionedTimeout: 60000
60
StartFailureTimeout: 1000000
61
HeartbeatIntervalDbDb: 2000
62
HeartbeatIntervalDbApi: 3000
63
TimeBetweenLocalCheckpoints: 20
64
TimeBetweenGlobalCheckpoints: 2000
65
TransactionInactiveTimeout: 0
66
TransactionDeadlockDetectionTimeout: 1200
68
DiskCheckpointSpeed: 10M
69
DiskCheckpointSpeedInRestart: 100M
70
ArbitrationTimeout: 10
72
# Buffering and Logging #
80
LogLevelNodeRestart: 0
88
BackupDataBufferSize: 2M
89
BackupLogBufferSize: 2M
92
BackupMaxWriteSize: 256K
96
DataDir: /add/path/here
101
#######################################
102
# Change HOST1 to the name of the NDB_MGMD host
103
# Change HOST2 to the name of the NDB_MGMD host
104
# Change HOST3 to the name of the NDB_MGMD host
105
# Change HOST4 to the name of the NDBD host
106
# Change HOST5 to the name of the NDBD host
107
# Change HOST6 to the name of the NDBD host
108
# Change HOST7 to the name of the NDBD host
109
# Change HOST8 to the name of the NDBD host
110
# Change HOST9 to the name of the NDBD host
111
#######################################
152
######################################################
153
# Note: The following can be MySQLD connections or #
154
# NDB API application connecting to the cluster #
155
######################################################