|
1 |
| -# Copyright (c) 2018, 2019, Oracle and/or its affiliates. All rights reserved. |
| 1 | +# Copyright (c) 2018, 2020, Oracle and/or its affiliates. All rights reserved. |
2 | 2 | #
|
3 | 3 | # This program is free software; you can redistribute it and/or modify
|
4 | 4 | # it under the terms of the GNU General Public License as published by
|
|
15 | 15 |
|
16 | 16 | [atrt]
|
17 | 17 | basedir = CHOOSE_dir
|
18 |
| -baseport = 14000 |
19 |
| -clusters = .4node |
| 18 | +fix-nodeid = 1 |
| 19 | +mt = 2 |
20 | 20 | mysqld = CHOOSE_host1
|
21 |
| -fix-nodeid=1 |
22 |
| -mt=2 |
23 | 21 |
|
24 | 22 | [ndb_mgmd]
|
25 | 23 |
|
26 | 24 | [mysqld]
|
27 | 25 | loose-default-authentication-plugin=mysql_native_password
|
28 | 26 | loose-mysqlx=0
|
29 |
| -skip-innodb |
30 |
| -loose-skip-bdb |
31 | 27 | socket=mysql.sock
|
32 | 28 | skip-grant-tables
|
33 |
| -default-storage-engine=myisam |
34 | 29 |
|
35 | 30 | [client]
|
36 | 31 | protocol=tcp
|
37 | 32 |
|
| 33 | +# |
| 34 | +# .2node |
| 35 | +# |
| 36 | + |
| 37 | +[cluster_config.2node] |
| 38 | +ndb_mgmd = CHOOSE_host1 |
| 39 | +ndbd = CHOOSE_host2,CHOOSE_host3 |
| 40 | +ndbapi= CHOOSE_host1,CHOOSE_host4,CHOOSE_host5 |
| 41 | + |
| 42 | +NoOfReplicas = 2 |
| 43 | +IndexMemory = 100M |
| 44 | +DataMemory = 300M |
| 45 | +BackupMemory = 64M |
| 46 | +MaxNoOfConcurrentScans = 100 |
| 47 | +MaxNoOfSavedMessages= 5 |
| 48 | +SendBufferMemory = 2M |
| 49 | +NoOfFragmentLogFiles = 4 |
| 50 | +FragmentLogFileSize = 128M |
| 51 | +CompressedLCP=1 |
| 52 | +CompressedBackup=1 |
| 53 | +ODirect=1 |
| 54 | +MaxNoOfAttributes=2000 |
| 55 | + |
| 56 | +SharedGlobalMemory=256M |
| 57 | +InitialLogfileGroup=undo_buffer_size=64M;undofile01.dat:512M;undofile02.dat:512M |
| 58 | +InitialTablespace=datafile01.dat:128M;datafile02.dat:64M |
| 59 | +TimeBetweenWatchDogCheckInitial=60000 |
| 60 | + |
| 61 | +# |
| 62 | +# .2node8thr |
| 63 | +# |
| 64 | + |
| 65 | +[cluster_config.2node8thr] |
| 66 | +ndb_mgmd = CHOOSE_host1 |
| 67 | +ndbd = CHOOSE_host2,CHOOSE_host3 |
| 68 | +ndbapi= CHOOSE_host1,CHOOSE_host4,CHOOSE_host5 |
| 69 | +Checksum=1 |
| 70 | + |
| 71 | +NoOfReplicas = 2 |
| 72 | +IndexMemory = 100M |
| 73 | +DataMemory = 500M |
| 74 | +BackupMemory = 64M |
| 75 | +MaxNoOfConcurrentScans = 100 |
| 76 | +MaxNoOfSavedMessages= 5 |
| 77 | +NoOfFragmentLogFiles = 8 |
| 78 | +FragmentLogFileSize = 128M |
| 79 | +ODirect=1 |
| 80 | +MaxNoOfExecutionThreads=8 |
| 81 | +SendBufferMemory=4M |
| 82 | +MaxNoOfAttributes=2000 |
| 83 | + |
| 84 | +SharedGlobalMemory=256M |
| 85 | +DiskPageBufferMemory=256M |
| 86 | +InitialLogfileGroup=undo_buffer_size=64M;undofile01.dat:512M;undofile02.dat:512M |
| 87 | +InitialTablespace=datafile01.dat:256M;datafile02.dat:256M |
| 88 | +TimeBetweenWatchDogCheckInitial=60000 |
| 89 | + |
| 90 | +# |
| 91 | +# .4node |
| 92 | +# |
| 93 | + |
38 | 94 | [cluster_config.4node]
|
39 |
| -ndb_mgmd = CHOOSE_host1,CHOOSE_host1 |
40 |
| -ndbd = CHOOSE_host2,CHOOSE_host3,CHOOSE_host2,CHOOSE_host3 |
41 |
| -ndbapi= CHOOSE_host1,CHOOSE_host1,CHOOSE_host1 |
| 95 | +ndb_mgmd = CHOOSE_host1 |
| 96 | +ndbd = CHOOSE_host2,CHOOSE_host3,CHOOSE_host4,CHOOSE_host5 |
| 97 | +ndbapi= CHOOSE_host1,CHOOSE_host6,CHOOSE_host7 |
42 | 98 |
|
43 | 99 | NoOfReplicas = 2
|
44 |
| -IndexMemory = 50M |
| 100 | +IndexMemory = 100M |
| 101 | +DataMemory = 500M |
| 102 | +BackupMemory = 64M |
| 103 | +MaxNoOfConcurrentScans = 100 |
| 104 | +MaxNoOfSavedMessages= 5 |
| 105 | +NoOfFragmentLogFiles = 8 |
| 106 | +FragmentLogFileSize = 128M |
| 107 | +ODirect=1 |
| 108 | +MaxNoOfAttributes=2000 |
| 109 | + |
| 110 | +SharedGlobalMemory=256M |
| 111 | +DiskPageBufferMemory=256M |
| 112 | +#FileSystemPath=/data0/autotest |
| 113 | +#FileSystemPathDataFiles=/data1/autotest |
| 114 | +#FileSystemPathUndoFiles=/data2/autotest |
| 115 | +InitialLogfileGroup=undo_buffer_size=64M;undofile01.dat:512M;undofile02.dat:512M |
| 116 | +InitialTablespace=datafile01.dat:256M;datafile02.dat:256M |
| 117 | +TimeBetweenWatchDogCheckInitial=60000 |
| 118 | + |
| 119 | +# |
| 120 | +# .2node2mgm |
| 121 | +# |
| 122 | + |
| 123 | +[cluster_config.2node2mgm] |
| 124 | +ndb_mgmd = CHOOSE_host1,CHOOSE_host6 |
| 125 | +ndbd = CHOOSE_host2,CHOOSE_host3 |
| 126 | +ndbapi= CHOOSE_host1,CHOOSE_host4,CHOOSE_host5 |
| 127 | + |
| 128 | +NoOfReplicas = 2 |
| 129 | +IndexMemory = 50M |
45 | 130 | DataMemory = 100M
|
46 | 131 | BackupMemory = 64M
|
47 | 132 | MaxNoOfConcurrentScans = 100
|
48 | 133 | MaxNoOfSavedMessages= 5
|
49 |
| -SendBufferMemory = 2M |
50 | 134 | NoOfFragmentLogFiles = 4
|
51 | 135 | FragmentLogFileSize = 64M
|
52 | 136 |
|
| 137 | +# |
| 138 | +# .2node8thr2mgm |
| 139 | +# |
| 140 | + |
| 141 | +[cluster_config.2node8thr2mgm] |
| 142 | +ndb_mgmd = CHOOSE_host1,CHOOSE_host6 |
| 143 | +ndbd = CHOOSE_host2,CHOOSE_host3 |
| 144 | +ndbapi= CHOOSE_host1,CHOOSE_host4,CHOOSE_host5 |
| 145 | +Checksum=1 |
| 146 | + |
| 147 | +NoOfReplicas = 2 |
| 148 | +IndexMemory = 50M |
| 149 | +DataMemory = 100M |
| 150 | +BackupMemory = 64M |
| 151 | +MaxNoOfConcurrentScans = 100 |
| 152 | +MaxNoOfSavedMessages= 5 |
| 153 | +NoOfFragmentLogFiles = 4 |
| 154 | +FragmentLogFileSize = 64M |
| 155 | +MaxNoOfExecutionThreads=8 |
| 156 | + |
| 157 | +# |
| 158 | +# .4node2mgm |
| 159 | +# |
| 160 | + |
| 161 | +[cluster_config.4node2mgm] |
| 162 | +ndb_mgmd = CHOOSE_host1,CHOOSE_host8 |
| 163 | +ndbd = CHOOSE_host2,CHOOSE_host3,CHOOSE_host4,CHOOSE_host5 |
| 164 | +ndbapi= CHOOSE_host1,CHOOSE_host6,CHOOSE_host7 |
| 165 | + |
| 166 | +NoOfReplicas = 2 |
| 167 | +IndexMemory = 50M |
| 168 | +DataMemory = 100M |
| 169 | +BackupMemory = 64M |
| 170 | +MaxNoOfConcurrentScans = 100 |
| 171 | +MaxNoOfSavedMessages= 5 |
| 172 | +NoOfFragmentLogFiles = 4 |
| 173 | +FragmentLogFileSize = 64M |
0 commit comments