1# Copyright (c) 2005, 2020, 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