|
1
by brian
clean slate |
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 |
######################################################
|
|
8 |
||
9 |
[NDBD DEFAULT] |
|
10 |
NoOfReplicas: 2
|
|
11 |
DataDir: /add/path/here |
|
12 |
FileSystemPath: /add/path/here |
|
13 |
||
14 |
# Data Memory, Index Memory, and String Memory #
|
|
15 |
DataMemory: 6000M |
|
16 |
IndexMemory: 1500M |
|
17 |
StringMemory: 5
|
|
18 |
||
19 |
# Transaction Parameters #
|
|
20 |
MaxNoOfConcurrentTransactions: 4096
|
|
21 |
MaxNoOfConcurrentOperations: 100000
|
|
22 |
MaxNoOfLocalOperations: 100000
|
|
23 |
||
24 |
# Transaction Temporary Storage #
|
|
25 |
MaxNoOfConcurrentIndexOperations: 8192
|
|
26 |
MaxNoOfFiredTriggers: 4000
|
|
27 |
TransactionBufferMemory: 1M |
|
28 |
||
29 |
# Scans and buffering #
|
|
30 |
MaxNoOfConcurrentScans: 300
|
|
31 |
MaxNoOfLocalScans: 32
|
|
32 |
BatchSizePerLocalScan: 64
|
|
33 |
LongMessageBuffer: 1M |
|
34 |
||
35 |
# Logging and Checkpointing #
|
|
36 |
NoOfFragmentLogFiles: 300
|
|
37 |
FragmentLogFileSize: 16M |
|
38 |
MaxNoOfOpenFiles: 40
|
|
39 |
InitialNoOfOpenFiles: 27
|
|
40 |
MaxNoOfSavedMessages: 25
|
|
41 |
||
42 |
# Metadata Objects #
|
|
43 |
MaxNoOfAttributes: 1500
|
|
44 |
MaxNoOfTables: 400
|
|
45 |
MaxNoOfOrderedIndexes: 200
|
|
46 |
MaxNoOfUniqueHashIndexes: 200
|
|
47 |
MaxNoOfTriggers: 770
|
|
48 |
||
49 |
# Boolean Parameters #
|
|
50 |
LockPagesInMainMemory: 0
|
|
51 |
StopOnError: 1
|
|
52 |
Diskless: 0
|
|
53 |
ODirect: 0
|
|
54 |
||
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
|
|
67 |
DiskSyncSize: 4M |
|
68 |
DiskCheckpointSpeed: 10M |
|
69 |
DiskCheckpointSpeedInRestart: 100M |
|
70 |
ArbitrationTimeout: 10
|
|
71 |
||
72 |
# Buffering and Logging #
|
|
73 |
UndoIndexBuffer: 2M |
|
74 |
UndoDataBuffer: 1M |
|
75 |
RedoBuffer: 32M |
|
76 |
LogLevelStartup: 15
|
|
77 |
LogLevelShutdown: 3
|
|
78 |
LogLevelStatistic: 0
|
|
79 |
LogLevelCheckpoint: 0
|
|
80 |
LogLevelNodeRestart: 0
|
|
81 |
LogLevelConnection: 0
|
|
82 |
LogLevelError: 15
|
|
83 |
LogLevelCongestion: 0
|
|
84 |
LogLevelInfo: 3
|
|
85 |
MemReportFrequency: 0
|
|
86 |
||
87 |
# Backup Parameters #
|
|
88 |
BackupDataBufferSize: 2M |
|
89 |
BackupLogBufferSize: 2M |
|
90 |
BackupMemory: 64M |
|
91 |
BackupWriteSize: 32K |
|
92 |
BackupMaxWriteSize: 256K |
|
93 |
||
94 |
[MGM DEFAULT] |
|
95 |
PortNumber: 1186
|
|
96 |
DataDir: /add/path/here |
|
97 |
||
98 |
[TCP DEFAULT] |
|
99 |
SendBufferMemory: 2M |
|
100 |
||
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 |
#######################################
|
|
112 |
||
113 |
[NDB_MGMD] |
|
114 |
Id: 1
|
|
115 |
HostName: HOST1 |
|
116 |
ArbitrationRank: 1
|
|
117 |
||
118 |
[NDB_MGMD] |
|
119 |
Id: 2
|
|
120 |
HostName: HOST2 |
|
121 |
ArbitrationRank: 1
|
|
122 |
||
123 |
[NDB_MGMD] |
|
124 |
Id: 3
|
|
125 |
HostName: HOST3 |
|
126 |
ArbitrationRank: 1
|
|
127 |
||
128 |
[NDBD] |
|
129 |
Id: 4
|
|
130 |
HostName: HOST4 |
|
131 |
||
132 |
[NDBD] |
|
133 |
Id: 5
|
|
134 |
HostName: HOST5 |
|
135 |
||
136 |
[NDBD] |
|
137 |
Id: 6
|
|
138 |
HostName: HOST6 |
|
139 |
||
140 |
[NDBD] |
|
141 |
Id: 7
|
|
142 |
HostName: HOST7 |
|
143 |
||
144 |
[NDBD] |
|
145 |
Id: 8
|
|
146 |
HostName: HOST8 |
|
147 |
||
148 |
[NDBD] |
|
149 |
Id: 9
|
|
150 |
HostName: HOST9 |
|
151 |
||
152 |
######################################################
|
|
153 |
# Note: The following can be MySQLD connections or #
|
|
154 |
# NDB API application connecting to the cluster #
|
|
155 |
######################################################
|
|
156 |
||
157 |
[API] |
|
158 |
Id: 10
|
|
159 |
HostName: HOST1 |
|
160 |
ArbitrationRank: 2
|
|
161 |
||
162 |
[API] |
|
163 |
Id: 11
|
|
164 |
HostName: HOST2 |
|
165 |
ArbitrationRank: 2
|
|
166 |
||
167 |
[API] |
|
168 |
Id: 12
|
|
169 |
HostName: HOST3 |
|
170 |
||
171 |
[API] |
|
172 |
Id: 13
|
|
173 |
HostName: HOST4 |
|
174 |
||
175 |
[API] |
|
176 |
Id: 14
|
|
177 |
HostName: HOST5 |
|
178 |
||
179 |
[API] |
|
180 |
Id: 15
|
|
181 |
HostName: HOST6 |
|
182 |
||
183 |
[API] |
|
184 |
Id: 16
|
|
185 |
HostName: HOST7 |
|
186 |
||
187 |
[API] |
|
188 |
Id: 17
|
|
189 |
HostName: HOST8 |
|
190 |
||
191 |
[API] |
|
192 |
Id: 19
|
|
193 |
HostName: HOST9 |
|
194 |
||
195 |
[API] |
|
196 |
Id: 20
|
|
197 |
||
198 |
[API] |
|
199 |
Id: 21
|
|
200 |
||
201 |
[API] |
|
202 |
Id: 22
|
|
203 |
||
204 |
[API] |
|
205 |
Id: 23
|
|
206 |
||
207 |
[API] |
|
208 |
Id: 24
|
|
209 |
||
210 |
[API] |
|
211 |
Id: 25
|
|
212 |