1###############################################################################
2#
3#  4-node system configuration file for MySQL Cluster
4#
5###############################################################################
6
7[DB DEFAULT]
8NoOfReplicas: 1
9StopOnError: N
10NoOfIndexPages: 1500
11NoOfDataPages: 5000
12BackupMemory: 4M
13BackupDataBufferSize: 2M
14BackupLogBufferSize: 2M
15BackupWriteSize: 32k
16
17[COMPUTER]
18Id: 1
19ByteOrder: Little
20HostName: CHOOSE_HOSTNAME_1
21
22[COMPUTER]
23Id: 2
24ByteOrder: Little
25HostName: CHOOSE_HOSTNAME_2
26
27[COMPUTER]
28Id: 3
29ByteOrder: Little
30HostName: CHOOSE_HOSTNAME_3
31
32[COMPUTER]
33Id: 4
34ByteOrder: Little
35HostName: CHOOSE_HOSTNAME_4
36
37[MGM]
38Id: 1
39ExecuteOnComputer: 1
40PortNumber: CHOOSE_PORT_BASE00
41PortNumberStats: CHOOSE_PORT_BASE01
42
43[DB]
44Id: 2
45ExecuteOnComputer: 1
46FileSystemPath: WRITE_PATH_TO_FILESYSTEM_1_HERE
47
48[DB]
49Id: 3
50ExecuteOnComputer: 2
51FileSystemPath: WRITE_PATH_TO_FILESYSTEM_2_HERE
52
53[DB]
54Id: 4
55ExecuteOnComputer: 3
56FileSystemPath: WRITE_PATH_TO_FILESYSTEM_3_HERE
57
58[DB]
59Id: 5
60ExecuteOnComputer: 4
61FileSystemPath: WRITE_PATH_TO_FILESYSTEM_4_HERE
62
63[API]
64Id: 6
65ExecuteOnComputer: 1
66
67[API]
68Id: 7
69ExecuteOnComputer: 2
70
71[API]
72Id: 8
73ExecuteOnComputer: 3
74
75[API]
76Id: 9
77ExecuteOnComputer: 4
78
79# Designated MySQL Server API node id
80[API]
81Id: 11
82ExecuteOnComputer: 1
83
84# Designated MySQL Server API node id
85[API]
86Id: 12
87ExecuteOnComputer: 2
88
89# Designated MySQL Server API node id
90[API]
91Id: 13
92ExecuteOnComputer: 3
93
94# Designated MySQL Server API node id
95[API]
96Id: 14
97ExecuteOnComputer: 4
98
99[TCP DEFAULT]
100SendSignalId: N
101Compression: N
102Checksum: N
103SendBufferSize: 2000
104MaxReceiveSize: 2000
105
106# Management server
107[TCP]
108NodeId1: 1
109NodeId2: 2
110PortNumber: CHOOSE_PORT_BASE02
111
112[TCP]
113NodeId1: 1
114NodeId2: 3
115PortNumber: CHOOSE_PORT_BASE03
116
117[TCP]
118NodeId1: 1
119NodeId2: 4
120PortNumber: CHOOSE_PORT_BASE04
121
122[TCP]
123NodeId1: 1
124NodeId2: 5
125PortNumber: CHOOSE_PORT_BASE05
126
127# Database cluster
128[TCP]
129NodeId1: 2
130NodeId2: 3
131PortNumber: CHOOSE_PORT_BASE06
132
133[TCP]
134NodeId1: 2
135NodeId2: 4
136PortNumber: CHOOSE_PORT_BASE07
137
138[TCP]
139NodeId1: 2
140NodeId2: 5
141PortNumber: CHOOSE_PORT_BASE08
142
143[TCP]
144NodeId1: 3
145NodeId2: 4
146PortNumber: CHOOSE_PORT_BASE09
147
148[TCP]
149NodeId1: 3
150NodeId2: 5
151PortNumber: CHOOSE_PORT_BASE10
152
153[TCP]
154NodeId1: 4
155NodeId2: 5
156PortNumber: CHOOSE_PORT_BASE11
157
158# API node 6
159[TCP]
160NodeId1: 6
161NodeId2: 2
162PortNumber: CHOOSE_PORT_BASE12
163
164[TCP]
165NodeId1: 6
166NodeId2: 3
167PortNumber: CHOOSE_PORT_BASE13
168
169[TCP]
170NodeId1: 6
171NodeId2: 4
172PortNumber: CHOOSE_PORT_BASE14
173
174[TCP]
175NodeId1: 6
176NodeId2: 5
177PortNumber: CHOOSE_PORT_BASE15
178
179# API node 7
180[TCP]
181NodeId1: 7
182NodeId2: 2
183PortNumber: CHOOSE_PORT_BASE16
184
185[TCP]
186NodeId1: 7
187NodeId2: 3
188PortNumber: CHOOSE_PORT_BASE17
189
190[TCP]
191NodeId1: 7
192NodeId2: 4
193PortNumber: CHOOSE_PORT_BASE18
194
195[TCP]
196NodeId1: 7
197NodeId2: 5
198PortNumber: CHOOSE_PORT_BASE19
199
200# API node 8
201[TCP]
202NodeId1: 8
203NodeId2: 2
204PortNumber: CHOOSE_PORT_BASE20
205
206[TCP]
207NodeId1: 8
208NodeId2: 3
209PortNumber: CHOOSE_PORT_BASE21
210
211[TCP]
212NodeId1: 8
213NodeId2: 4
214PortNumber: CHOOSE_PORT_BASE22
215
216[TCP]
217NodeId1: 8
218NodeId2: 5
219PortNumber: CHOOSE_PORT_BASE23
220
221# API node 9
222[TCP]
223NodeId1: 9
224NodeId2: 2
225PortNumber: CHOOSE_PORT_BASE24
226
227[TCP]
228NodeId1: 9
229NodeId2: 3
230PortNumber: CHOOSE_PORT_BASE25
231
232[TCP]
233NodeId1: 9
234NodeId2: 4
235PortNumber: CHOOSE_PORT_BASE26
236
237[TCP]
238NodeId1: 9
239NodeId2: 5
240PortNumber: CHOOSE_PORT_BASE27
241
242# Designated MySQL Server API node connection
243[TCP]
244NodeId1: 2
245NodeId2: 11
246PortNumber: CHOOSE_PORT_BASE28
247
248# Designated MySQL Server API node connection
249[TCP]
250NodeId1: 3
251NodeId2: 11
252PortNumber: CHOOSE_PORT_BASE29
253
254# Designated MySQL Server API node connection
255[TCP]
256NodeId1: 4
257NodeId2: 11
258PortNumber: CHOOSE_PORT_BASE30
259
260# Designated MySQL Server API node connection
261[TCP]
262NodeId1: 5
263NodeId2: 11
264PortNumber: CHOOSE_PORT_BASE31
265
266# Designated MySQL Server API node connection
267[TCP]
268NodeId1: 2
269NodeId2: 12
270PortNumber: CHOOSE_PORT_BASE32
271
272# Designated MySQL Server API node connection
273[TCP]
274NodeId1: 3
275NodeId2: 12
276PortNumber: CHOOSE_PORT_BASE33
277
278# Designated MySQL Server API node connection
279[TCP]
280NodeId1: 4
281NodeId2: 12
282PortNumber: CHOOSE_PORT_BASE34
283
284# Designated MySQL Server API node connection
285[TCP]
286NodeId1: 5
287NodeId2: 12
288PortNumber: CHOOSE_PORT_BASE35
289
290# Designated MySQL Server API node connection
291[TCP]
292NodeId1: 2
293NodeId2: 13
294PortNumber: CHOOSE_PORT_BASE36
295
296# Designated MySQL Server API node connection
297[TCP]
298NodeId1: 3
299NodeId2: 13
300PortNumber: CHOOSE_PORT_BASE37
301
302# Designated MySQL Server API node connection
303[TCP]
304NodeId1: 4
305NodeId2: 13
306PortNumber: CHOOSE_PORT_BASE38
307
308# Designated MySQL Server API node connection
309[TCP]
310NodeId1: 5
311NodeId2: 13
312PortNumber: CHOOSE_PORT_BASE39
313
314# Designated MySQL Server API node connection
315[TCP]
316NodeId1: 2
317NodeId2: 14
318PortNumber: CHOOSE_PORT_BASE40
319
320# Designated MySQL Server API node connection
321[TCP]
322NodeId1: 3
323NodeId2: 14
324PortNumber: CHOOSE_PORT_BASE41
325
326# Designated MySQL Server API node connection
327[TCP]
328NodeId1: 4
329NodeId2: 14
330PortNumber: CHOOSE_PORT_BASE42
331
332# Designated MySQL Server API node connection
333[TCP]
334NodeId1: 5
335NodeId2: 14
336PortNumber: CHOOSE_PORT_BASE43
337