| 1 |
include/group_replication.inc [rpl_server_count=4] |
| 2 |
Warnings: |
| 3 |
Note #### Sending passwords in plain text without SSL/TLS is extremely insecure. |
| 4 |
Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information. |
| 5 |
[connection server1] |
| 6 |
############################################################ |
| 7 |
# 1. Start group replication on member1 |
| 8 |
############################################################ |
| 9 |
include/start_and_bootstrap_group_replication.inc |
| 10 |
CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY AUTO_INCREMENT) ENGINE=InnoDB; |
| 11 |
############################################################ |
| 12 |
# 2. Executing the same transaction on all members (almost) |
| 13 |
# in parallel, while starting and stopping group |
| 14 |
# replication on members 2,3 and 4, there should be |
| 15 |
# no error |
| 16 |
############################################################ |
| 17 |
INSERT INTO t1 VALUES(NULL); |
| 18 |
INSERT INTO t1 VALUES(NULL); |
| 19 |
INSERT INTO t1 VALUES(NULL); |
| 20 |
INSERT INTO t1 VALUES(NULL); |
| 21 |
INSERT INTO t1 VALUES(NULL); |
| 22 |
INSERT INTO t1 VALUES(NULL); |
| 23 |
INSERT INTO t1 VALUES(NULL); |
| 24 |
INSERT INTO t1 VALUES(NULL); |
| 25 |
INSERT INTO t1 VALUES(NULL); |
| 26 |
INSERT INTO t1 VALUES(NULL); |
| 27 |
START GROUP_REPLICATION; |
| 28 |
include/gr_wait_for_member_state.inc |
| 29 |
include/assert.inc [The value of auto_increment_increment for server1 should be 7] |
| 30 |
include/assert.inc [The value of auto_increment_offset for server1 should be 1] |
| 31 |
include/assert.inc [The value of auto_increment_increment for server2 should be 7] |
| 32 |
include/assert.inc [The value of auto_increment_offset for server2 should be 2] |
| 33 |
INSERT INTO t1 VALUES(NULL); |
| 34 |
INSERT INTO t1 VALUES(NULL); |
| 35 |
INSERT INTO t1 VALUES(NULL); |
| 36 |
INSERT INTO t1 VALUES(NULL); |
| 37 |
INSERT INTO t1 VALUES(NULL); |
| 38 |
INSERT INTO t1 VALUES(NULL); |
| 39 |
INSERT INTO t1 VALUES(NULL); |
| 40 |
INSERT INTO t1 VALUES(NULL); |
| 41 |
INSERT INTO t1 VALUES(NULL); |
| 42 |
INSERT INTO t1 VALUES(NULL); |
| 43 |
INSERT INTO t1 VALUES(NULL); |
| 44 |
INSERT INTO t1 VALUES(NULL); |
| 45 |
INSERT INTO t1 VALUES(NULL); |
| 46 |
INSERT INTO t1 VALUES(NULL); |
| 47 |
INSERT INTO t1 VALUES(NULL); |
| 48 |
INSERT INTO t1 VALUES(NULL); |
| 49 |
INSERT INTO t1 VALUES(NULL); |
| 50 |
INSERT INTO t1 VALUES(NULL); |
| 51 |
INSERT INTO t1 VALUES(NULL); |
| 52 |
INSERT INTO t1 VALUES(NULL); |
| 53 |
START GROUP_REPLICATION; |
| 54 |
include/gr_wait_for_member_state.inc |
| 55 |
include/assert.inc [The value of auto_increment_increment for server1 should be 7] |
| 56 |
include/assert.inc [The value of auto_increment_offset for server1 should be 1] |
| 57 |
include/assert.inc [The value of auto_increment_increment for server2 should be 7] |
| 58 |
include/assert.inc [The value of auto_increment_offset for server2 should be 2] |
| 59 |
include/assert.inc [The value of auto_increment_increment for server3 should be 7] |
| 60 |
include/assert.inc [The value of auto_increment_offset for server3 should be 3] |
| 61 |
INSERT INTO t1 VALUES(NULL); |
| 62 |
INSERT INTO t1 VALUES(NULL); |
| 63 |
INSERT INTO t1 VALUES(NULL); |
| 64 |
INSERT INTO t1 VALUES(NULL); |
| 65 |
INSERT INTO t1 VALUES(NULL); |
| 66 |
INSERT INTO t1 VALUES(NULL); |
| 67 |
INSERT INTO t1 VALUES(NULL); |
| 68 |
INSERT INTO t1 VALUES(NULL); |
| 69 |
INSERT INTO t1 VALUES(NULL); |
| 70 |
INSERT INTO t1 VALUES(NULL); |
| 71 |
INSERT INTO t1 VALUES(NULL); |
| 72 |
INSERT INTO t1 VALUES(NULL); |
| 73 |
INSERT INTO t1 VALUES(NULL); |
| 74 |
INSERT INTO t1 VALUES(NULL); |
| 75 |
INSERT INTO t1 VALUES(NULL); |
| 76 |
INSERT INTO t1 VALUES(NULL); |
| 77 |
INSERT INTO t1 VALUES(NULL); |
| 78 |
INSERT INTO t1 VALUES(NULL); |
| 79 |
INSERT INTO t1 VALUES(NULL); |
| 80 |
INSERT INTO t1 VALUES(NULL); |
| 81 |
INSERT INTO t1 VALUES(NULL); |
| 82 |
INSERT INTO t1 VALUES(NULL); |
| 83 |
INSERT INTO t1 VALUES(NULL); |
| 84 |
INSERT INTO t1 VALUES(NULL); |
| 85 |
INSERT INTO t1 VALUES(NULL); |
| 86 |
INSERT INTO t1 VALUES(NULL); |
| 87 |
INSERT INTO t1 VALUES(NULL); |
| 88 |
INSERT INTO t1 VALUES(NULL); |
| 89 |
INSERT INTO t1 VALUES(NULL); |
| 90 |
INSERT INTO t1 VALUES(NULL); |
| 91 |
START GROUP_REPLICATION; |
| 92 |
include/gr_wait_for_member_state.inc |
| 93 |
include/assert.inc [The value of auto_increment_increment for server1 should be 7] |
| 94 |
include/assert.inc [The value of auto_increment_offset for server1 should be 1] |
| 95 |
include/assert.inc [The value of auto_increment_increment for server2 should be 7] |
| 96 |
include/assert.inc [The value of auto_increment_offset for server2 should be 2] |
| 97 |
include/assert.inc [The value of auto_increment_increment for server3 should be 7] |
| 98 |
include/assert.inc [The value of auto_increment_offset for server3 should be 3] |
| 99 |
include/assert.inc [The value of auto_increment_increment for server4 should be 7] |
| 100 |
include/assert.inc [The value of auto_increment_offset for server4 should be 4] |
| 101 |
INSERT INTO t1 VALUES(NULL); |
| 102 |
INSERT INTO t1 VALUES(NULL); |
| 103 |
INSERT INTO t1 VALUES(NULL); |
| 104 |
INSERT INTO t1 VALUES(NULL); |
| 105 |
INSERT INTO t1 VALUES(NULL); |
| 106 |
INSERT INTO t1 VALUES(NULL); |
| 107 |
INSERT INTO t1 VALUES(NULL); |
| 108 |
INSERT INTO t1 VALUES(NULL); |
| 109 |
INSERT INTO t1 VALUES(NULL); |
| 110 |
INSERT INTO t1 VALUES(NULL); |
| 111 |
INSERT INTO t1 VALUES(NULL); |
| 112 |
INSERT INTO t1 VALUES(NULL); |
| 113 |
INSERT INTO t1 VALUES(NULL); |
| 114 |
INSERT INTO t1 VALUES(NULL); |
| 115 |
INSERT INTO t1 VALUES(NULL); |
| 116 |
INSERT INTO t1 VALUES(NULL); |
| 117 |
INSERT INTO t1 VALUES(NULL); |
| 118 |
INSERT INTO t1 VALUES(NULL); |
| 119 |
INSERT INTO t1 VALUES(NULL); |
| 120 |
INSERT INTO t1 VALUES(NULL); |
| 121 |
INSERT INTO t1 VALUES(NULL); |
| 122 |
INSERT INTO t1 VALUES(NULL); |
| 123 |
INSERT INTO t1 VALUES(NULL); |
| 124 |
INSERT INTO t1 VALUES(NULL); |
| 125 |
INSERT INTO t1 VALUES(NULL); |
| 126 |
INSERT INTO t1 VALUES(NULL); |
| 127 |
INSERT INTO t1 VALUES(NULL); |
| 128 |
INSERT INTO t1 VALUES(NULL); |
| 129 |
INSERT INTO t1 VALUES(NULL); |
| 130 |
INSERT INTO t1 VALUES(NULL); |
| 131 |
INSERT INTO t1 VALUES(NULL); |
| 132 |
INSERT INTO t1 VALUES(NULL); |
| 133 |
INSERT INTO t1 VALUES(NULL); |
| 134 |
INSERT INTO t1 VALUES(NULL); |
| 135 |
INSERT INTO t1 VALUES(NULL); |
| 136 |
INSERT INTO t1 VALUES(NULL); |
| 137 |
STOP GROUP_REPLICATION; |
| 138 |
INSERT INTO t1 VALUES(NULL); |
| 139 |
INSERT INTO t1 VALUES(NULL); |
| 140 |
INSERT INTO t1 VALUES(NULL); |
| 141 |
include/gr_wait_for_member_state.inc |
| 142 |
include/assert.inc [The value of auto_increment_increment for server1 should be 7] |
| 143 |
include/assert.inc [The value of auto_increment_offset for server1 should be 1] |
| 144 |
include/assert.inc [The value of auto_increment_increment for server2 should be 7] |
| 145 |
include/assert.inc [The value of auto_increment_offset for server2 should be 2] |
| 146 |
include/assert.inc [The value of auto_increment_increment for server3 should be 7] |
| 147 |
include/assert.inc [The value of auto_increment_offset for server3 should be 3] |
| 148 |
include/assert.inc [The value of auto_increment_increment for server4 should be 1] |
| 149 |
include/assert.inc [The value of auto_increment_offset for server4 should be 1] |
| 150 |
include/assert_and_disable_read_only.inc |
| 151 |
INSERT INTO t1 VALUES(NULL); |
| 152 |
INSERT INTO t1 VALUES(NULL); |
| 153 |
INSERT INTO t1 VALUES(NULL); |
| 154 |
INSERT INTO t1 VALUES(NULL); |
| 155 |
INSERT INTO t1 VALUES(NULL); |
| 156 |
INSERT INTO t1 VALUES(NULL); |
| 157 |
INSERT INTO t1 VALUES(NULL); |
| 158 |
INSERT INTO t1 VALUES(NULL); |
| 159 |
INSERT INTO t1 VALUES(NULL); |
| 160 |
INSERT INTO t1 VALUES(NULL); |
| 161 |
INSERT INTO t1 VALUES(NULL); |
| 162 |
INSERT INTO t1 VALUES(NULL); |
| 163 |
INSERT INTO t1 VALUES(NULL); |
| 164 |
INSERT INTO t1 VALUES(NULL); |
| 165 |
INSERT INTO t1 VALUES(NULL); |
| 166 |
INSERT INTO t1 VALUES(NULL); |
| 167 |
INSERT INTO t1 VALUES(NULL); |
| 168 |
INSERT INTO t1 VALUES(NULL); |
| 169 |
INSERT INTO t1 VALUES(NULL); |
| 170 |
INSERT INTO t1 VALUES(NULL); |
| 171 |
INSERT INTO t1 VALUES(NULL); |
| 172 |
INSERT INTO t1 VALUES(NULL); |
| 173 |
INSERT INTO t1 VALUES(NULL); |
| 174 |
INSERT INTO t1 VALUES(NULL); |
| 175 |
INSERT INTO t1 VALUES(NULL); |
| 176 |
INSERT INTO t1 VALUES(NULL); |
| 177 |
INSERT INTO t1 VALUES(NULL); |
| 178 |
STOP GROUP_REPLICATION; |
| 179 |
INSERT INTO t1 VALUES(NULL); |
| 180 |
INSERT INTO t1 VALUES(NULL); |
| 181 |
include/gr_wait_for_member_state.inc |
| 182 |
include/assert.inc [The value of auto_increment_increment for server1 should be 7] |
| 183 |
include/assert.inc [The value of auto_increment_offset for server1 should be 1] |
| 184 |
include/assert.inc [The value of auto_increment_increment for server2 should be 7] |
| 185 |
include/assert.inc [The value of auto_increment_offset for server2 should be 2] |
| 186 |
include/assert.inc [The value of auto_increment_increment for server3 should be 1] |
| 187 |
include/assert.inc [The value of auto_increment_offset for server3 should be 1] |
| 188 |
include/assert_and_disable_read_only.inc |
| 189 |
INSERT INTO t1 VALUES(NULL); |
| 190 |
INSERT INTO t1 VALUES(NULL); |
| 191 |
INSERT INTO t1 VALUES(NULL); |
| 192 |
INSERT INTO t1 VALUES(NULL); |
| 193 |
INSERT INTO t1 VALUES(NULL); |
| 194 |
INSERT INTO t1 VALUES(NULL); |
| 195 |
INSERT INTO t1 VALUES(NULL); |
| 196 |
INSERT INTO t1 VALUES(NULL); |
| 197 |
INSERT INTO t1 VALUES(NULL); |
| 198 |
INSERT INTO t1 VALUES(NULL); |
| 199 |
INSERT INTO t1 VALUES(NULL); |
| 200 |
INSERT INTO t1 VALUES(NULL); |
| 201 |
INSERT INTO t1 VALUES(NULL); |
| 202 |
INSERT INTO t1 VALUES(NULL); |
| 203 |
INSERT INTO t1 VALUES(NULL); |
| 204 |
INSERT INTO t1 VALUES(NULL); |
| 205 |
INSERT INTO t1 VALUES(NULL); |
| 206 |
INSERT INTO t1 VALUES(NULL); |
| 207 |
STOP GROUP_REPLICATION; |
| 208 |
INSERT INTO t1 VALUES(NULL); |
| 209 |
include/gr_wait_for_member_state.inc |
| 210 |
include/assert.inc [The value of auto_increment_increment for server1 should be 7] |
| 211 |
include/assert.inc [The value of auto_increment_offset for server1 should be 1] |
| 212 |
include/assert.inc [The value of auto_increment_increment for server2 should be 1] |
| 213 |
include/assert.inc [The value of auto_increment_offset for server2 should be 1] |
| 214 |
include/assert_and_disable_read_only.inc |
| 215 |
############################################################ |
| 216 |
# 3. Start group replication on all members and wait for sync |
| 217 |
############################################################ |
| 218 |
include/start_group_replication.inc |
| 219 |
include/start_group_replication.inc |
| 220 |
include/start_group_replication.inc |
| 221 |
include/rpl_sync.inc |
| 222 |
############################################################ |
| 223 |
# 4. Validate members state is equal. |
| 224 |
############################################################ |
| 225 |
include/diff_tables.inc [server1:t1, server2:t1, server3:t1, server4:t1] |
| 226 |
############################################################ |
| 227 |
# 5. Clean up and reset auto_inc variables value |
| 228 |
############################################################ |
| 229 |
DROP TABLE t1; |
| 230 |
include/group_replication_end.inc |