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