1# Copyright (c) 2005, 2021, Oracle and/or its affiliates.
2#
3# This program is free software; you can redistribute it and/or modify
4# it under the terms of the GNU General Public License, version 2.0,
5# as published by the Free Software Foundation.
6#
7# This program is also distributed with certain software (including
8# but not limited to OpenSSL) that is licensed under separate terms,
9# as designated in a particular file or component or in included license
10# documentation.  The authors of MySQL hereby grant you an additional
11# permission to link the program and your derivative works with the
12# separately licensed software that they have included with MySQL.
13#
14# This program is distributed in the hope that it will be useful,
15# but WITHOUT ANY WARRANTY; without even the implied warranty of
16# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
17# GNU General Public License, version 2.0, for more details.
18#
19# You should have received a copy of the GNU General Public License
20# along with this program; if not, write to the Free Software
21# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301  USA
22
23###############################################################################
24#
25#  4-node system configuration file for MySQL Cluster
26#
27###############################################################################
28
29[DB DEFAULT]
30NoOfReplicas: 1
31StopOnError: N
32NoOfIndexPages: 1500
33NoOfDataPages: 5000
34BackupMemory: 4M
35BackupDataBufferSize: 2M
36BackupLogBufferSize: 2M
37BackupWriteSize: 32k
38
39[COMPUTER]
40Id: 1
41ByteOrder: Little
42HostName: CHOOSE_HOSTNAME_1
43
44[COMPUTER]
45Id: 2
46ByteOrder: Little
47HostName: CHOOSE_HOSTNAME_2
48
49[COMPUTER]
50Id: 3
51ByteOrder: Little
52HostName: CHOOSE_HOSTNAME_3
53
54[COMPUTER]
55Id: 4
56ByteOrder: Little
57HostName: CHOOSE_HOSTNAME_4
58
59[MGM]
60Id: 1
61ExecuteOnComputer: 1
62PortNumber: CHOOSE_PORT_BASE00
63PortNumberStats: CHOOSE_PORT_BASE01
64
65[DB]
66Id: 2
67ExecuteOnComputer: 1
68FileSystemPath: WRITE_PATH_TO_FILESYSTEM_1_HERE
69
70[DB]
71Id: 3
72ExecuteOnComputer: 2
73FileSystemPath: WRITE_PATH_TO_FILESYSTEM_2_HERE
74
75[DB]
76Id: 4
77ExecuteOnComputer: 3
78FileSystemPath: WRITE_PATH_TO_FILESYSTEM_3_HERE
79
80[DB]
81Id: 5
82ExecuteOnComputer: 4
83FileSystemPath: WRITE_PATH_TO_FILESYSTEM_4_HERE
84
85[API]
86Id: 6
87ExecuteOnComputer: 1
88
89[API]
90Id: 7
91ExecuteOnComputer: 2
92
93[API]
94Id: 8
95ExecuteOnComputer: 3
96
97[API]
98Id: 9
99ExecuteOnComputer: 4
100
101# Designated MySQL Server API node id
102[API]
103Id: 11
104ExecuteOnComputer: 1
105
106# Designated MySQL Server API node id
107[API]
108Id: 12
109ExecuteOnComputer: 2
110
111# Designated MySQL Server API node id
112[API]
113Id: 13
114ExecuteOnComputer: 3
115
116# Designated MySQL Server API node id
117[API]
118Id: 14
119ExecuteOnComputer: 4
120
121[TCP DEFAULT]
122SendSignalId: N
123Compression: N
124Checksum: N
125SendBufferSize: 2000
126MaxReceiveSize: 2000
127
128# Management server
129[TCP]
130NodeId1: 1
131NodeId2: 2
132PortNumber: CHOOSE_PORT_BASE02
133
134[TCP]
135NodeId1: 1
136NodeId2: 3
137PortNumber: CHOOSE_PORT_BASE03
138
139[TCP]
140NodeId1: 1
141NodeId2: 4
142PortNumber: CHOOSE_PORT_BASE04
143
144[TCP]
145NodeId1: 1
146NodeId2: 5
147PortNumber: CHOOSE_PORT_BASE05
148
149# Database cluster
150[TCP]
151NodeId1: 2
152NodeId2: 3
153PortNumber: CHOOSE_PORT_BASE06
154
155[TCP]
156NodeId1: 2
157NodeId2: 4
158PortNumber: CHOOSE_PORT_BASE07
159
160[TCP]
161NodeId1: 2
162NodeId2: 5
163PortNumber: CHOOSE_PORT_BASE08
164
165[TCP]
166NodeId1: 3
167NodeId2: 4
168PortNumber: CHOOSE_PORT_BASE09
169
170[TCP]
171NodeId1: 3
172NodeId2: 5
173PortNumber: CHOOSE_PORT_BASE10
174
175[TCP]
176NodeId1: 4
177NodeId2: 5
178PortNumber: CHOOSE_PORT_BASE11
179
180# API node 6
181[TCP]
182NodeId1: 6
183NodeId2: 2
184PortNumber: CHOOSE_PORT_BASE12
185
186[TCP]
187NodeId1: 6
188NodeId2: 3
189PortNumber: CHOOSE_PORT_BASE13
190
191[TCP]
192NodeId1: 6
193NodeId2: 4
194PortNumber: CHOOSE_PORT_BASE14
195
196[TCP]
197NodeId1: 6
198NodeId2: 5
199PortNumber: CHOOSE_PORT_BASE15
200
201# API node 7
202[TCP]
203NodeId1: 7
204NodeId2: 2
205PortNumber: CHOOSE_PORT_BASE16
206
207[TCP]
208NodeId1: 7
209NodeId2: 3
210PortNumber: CHOOSE_PORT_BASE17
211
212[TCP]
213NodeId1: 7
214NodeId2: 4
215PortNumber: CHOOSE_PORT_BASE18
216
217[TCP]
218NodeId1: 7
219NodeId2: 5
220PortNumber: CHOOSE_PORT_BASE19
221
222# API node 8
223[TCP]
224NodeId1: 8
225NodeId2: 2
226PortNumber: CHOOSE_PORT_BASE20
227
228[TCP]
229NodeId1: 8
230NodeId2: 3
231PortNumber: CHOOSE_PORT_BASE21
232
233[TCP]
234NodeId1: 8
235NodeId2: 4
236PortNumber: CHOOSE_PORT_BASE22
237
238[TCP]
239NodeId1: 8
240NodeId2: 5
241PortNumber: CHOOSE_PORT_BASE23
242
243# API node 9
244[TCP]
245NodeId1: 9
246NodeId2: 2
247PortNumber: CHOOSE_PORT_BASE24
248
249[TCP]
250NodeId1: 9
251NodeId2: 3
252PortNumber: CHOOSE_PORT_BASE25
253
254[TCP]
255NodeId1: 9
256NodeId2: 4
257PortNumber: CHOOSE_PORT_BASE26
258
259[TCP]
260NodeId1: 9
261NodeId2: 5
262PortNumber: CHOOSE_PORT_BASE27
263
264# Designated MySQL Server API node connection
265[TCP]
266NodeId1: 2
267NodeId2: 11
268PortNumber: CHOOSE_PORT_BASE28
269
270# Designated MySQL Server API node connection
271[TCP]
272NodeId1: 3
273NodeId2: 11
274PortNumber: CHOOSE_PORT_BASE29
275
276# Designated MySQL Server API node connection
277[TCP]
278NodeId1: 4
279NodeId2: 11
280PortNumber: CHOOSE_PORT_BASE30
281
282# Designated MySQL Server API node connection
283[TCP]
284NodeId1: 5
285NodeId2: 11
286PortNumber: CHOOSE_PORT_BASE31
287
288# Designated MySQL Server API node connection
289[TCP]
290NodeId1: 2
291NodeId2: 12
292PortNumber: CHOOSE_PORT_BASE32
293
294# Designated MySQL Server API node connection
295[TCP]
296NodeId1: 3
297NodeId2: 12
298PortNumber: CHOOSE_PORT_BASE33
299
300# Designated MySQL Server API node connection
301[TCP]
302NodeId1: 4
303NodeId2: 12
304PortNumber: CHOOSE_PORT_BASE34
305
306# Designated MySQL Server API node connection
307[TCP]
308NodeId1: 5
309NodeId2: 12
310PortNumber: CHOOSE_PORT_BASE35
311
312# Designated MySQL Server API node connection
313[TCP]
314NodeId1: 2
315NodeId2: 13
316PortNumber: CHOOSE_PORT_BASE36
317
318# Designated MySQL Server API node connection
319[TCP]
320NodeId1: 3
321NodeId2: 13
322PortNumber: CHOOSE_PORT_BASE37
323
324# Designated MySQL Server API node connection
325[TCP]
326NodeId1: 4
327NodeId2: 13
328PortNumber: CHOOSE_PORT_BASE38
329
330# Designated MySQL Server API node connection
331[TCP]
332NodeId1: 5
333NodeId2: 13
334PortNumber: CHOOSE_PORT_BASE39
335
336# Designated MySQL Server API node connection
337[TCP]
338NodeId1: 2
339NodeId2: 14
340PortNumber: CHOOSE_PORT_BASE40
341
342# Designated MySQL Server API node connection
343[TCP]
344NodeId1: 3
345NodeId2: 14
346PortNumber: CHOOSE_PORT_BASE41
347
348# Designated MySQL Server API node connection
349[TCP]
350NodeId1: 4
351NodeId2: 14
352PortNumber: CHOOSE_PORT_BASE42
353
354# Designated MySQL Server API node connection
355[TCP]
356NodeId1: 5
357NodeId2: 14
358PortNumber: CHOOSE_PORT_BASE43
359