| 1 |
include/group_replication.inc [rpl_server_count=3] |
| 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 |
[connection server1] |
| 7 |
SET sql_log_bin = 0; |
| 8 |
include/gtid_utils.inc |
| 9 |
SET sql_log_bin = 1; |
| 10 |
[connection server2] |
| 11 |
SET sql_log_bin = 0; |
| 12 |
include/gtid_utils.inc |
| 13 |
SET sql_log_bin = 1; |
| 14 |
[connection server3] |
| 15 |
SET sql_log_bin = 0; |
| 16 |
include/gtid_utils.inc |
| 17 |
SET sql_log_bin = 1; |
| 18 |
|
| 19 |
############################################################ |
| 20 |
# 1. Start server 1 and assert it only has one transaction |
| 21 |
[connection server1] |
| 22 |
SET @group_replication_view_change_uuid_save= @@GLOBAL.group_replication_view_change_uuid; |
| 23 |
SET GLOBAL group_replication_view_change_uuid = "c0dec0de-c0de-c0de-c0de-c0dec0dec0de"; |
| 24 |
Warnings: |
| 25 |
Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release. |
| 26 |
include/start_and_bootstrap_group_replication.inc |
| 27 |
Warnings: |
| 28 |
Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release. |
| 29 |
include/assert.inc [GTID_EXECUTED must have one transaction of view change] |
| 30 |
include/show_binlog_events.inc |
| 31 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 32 |
server-binary-log.000001 # Previous_gtids # # |
| 33 |
server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set' |
| 34 |
server-binary-log.000001 # Query # # BEGIN |
| 35 |
server-binary-log.000001 # Query # # COMMIT |
| 36 |
|
| 37 |
############################################################ |
| 38 |
# 2. Start server 2 and assert it has two transactions |
| 39 |
[connection server2] |
| 40 |
SET @group_replication_view_change_uuid_save= @@GLOBAL.group_replication_view_change_uuid; |
| 41 |
SET GLOBAL group_replication_view_change_uuid = "c0dec0de-c0de-c0de-c0de-c0dec0dec0de"; |
| 42 |
Warnings: |
| 43 |
Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release. |
| 44 |
include/start_group_replication.inc |
| 45 |
Warnings: |
| 46 |
Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release. |
| 47 |
include/assert.inc [GTID_EXECUTED must have two transactions of view changes] |
| 48 |
include/show_binlog_events.inc |
| 49 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 50 |
server-binary-log.000001 # Previous_gtids # # |
| 51 |
server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set' |
| 52 |
server-binary-log.000001 # Query # # BEGIN |
| 53 |
server-binary-log.000001 # Query # # COMMIT |
| 54 |
server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set' |
| 55 |
server-binary-log.000001 # Query # # BEGIN |
| 56 |
server-binary-log.000001 # Query # # COMMIT |
| 57 |
|
| 58 |
############################################################ |
| 59 |
# 3. Confirm server 1 has same GTID_EXECUTED as server 2 |
| 60 |
[connection server1] |
| 61 |
include/assert.inc [GTID_EXECUTED must have two transactions of view changes] |
| 62 |
include/show_binlog_events.inc |
| 63 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 64 |
server-binary-log.000001 # Previous_gtids # # |
| 65 |
server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set' |
| 66 |
server-binary-log.000001 # Query # # BEGIN |
| 67 |
server-binary-log.000001 # Query # # COMMIT |
| 68 |
server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set' |
| 69 |
server-binary-log.000001 # Query # # BEGIN |
| 70 |
server-binary-log.000001 # Query # # COMMIT |
| 71 |
|
| 72 |
############################################################ |
| 73 |
# 4. Start server 3 and assert it has three transactions |
| 74 |
[connection server3] |
| 75 |
SET @group_replication_view_change_uuid_save= @@GLOBAL.group_replication_view_change_uuid; |
| 76 |
SET GLOBAL group_replication_view_change_uuid = "c0dec0de-c0de-c0de-c0de-c0dec0dec0de"; |
| 77 |
Warnings: |
| 78 |
Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release. |
| 79 |
include/start_group_replication.inc |
| 80 |
Warnings: |
| 81 |
Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release. |
| 82 |
include/assert.inc [GTID_EXECUTED must have three transactions of view changes] |
| 83 |
include/show_binlog_events.inc |
| 84 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 85 |
server-binary-log.000001 # Previous_gtids # # |
| 86 |
server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set' |
| 87 |
server-binary-log.000001 # Query # # BEGIN |
| 88 |
server-binary-log.000001 # Query # # COMMIT |
| 89 |
server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set' |
| 90 |
server-binary-log.000001 # Query # # BEGIN |
| 91 |
server-binary-log.000001 # Query # # COMMIT |
| 92 |
server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set' |
| 93 |
server-binary-log.000001 # Query # # BEGIN |
| 94 |
server-binary-log.000001 # Query # # COMMIT |
| 95 |
|
| 96 |
############################################################ |
| 97 |
# 5. Confirm server 1 has same GTID_EXECUTED than server 3 |
| 98 |
[connection server1] |
| 99 |
include/assert.inc [GTID_EXECUTED must have three transactions of view changes] |
| 100 |
include/show_binlog_events.inc |
| 101 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 102 |
server-binary-log.000001 # Previous_gtids # # |
| 103 |
server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set' |
| 104 |
server-binary-log.000001 # Query # # BEGIN |
| 105 |
server-binary-log.000001 # Query # # COMMIT |
| 106 |
server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set' |
| 107 |
server-binary-log.000001 # Query # # BEGIN |
| 108 |
server-binary-log.000001 # Query # # COMMIT |
| 109 |
server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set' |
| 110 |
server-binary-log.000001 # Query # # BEGIN |
| 111 |
server-binary-log.000001 # Query # # COMMIT |
| 112 |
############################################################ |
| 113 |
# 6. Confirm server 2 has same GTID_EXECUTED than server 3 |
| 114 |
[connection server2] |
| 115 |
include/assert.inc [GTID_EXECUTED must have three transactions of view changes] |
| 116 |
include/show_binlog_events.inc |
| 117 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 118 |
server-binary-log.000001 # Previous_gtids # # |
| 119 |
server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set' |
| 120 |
server-binary-log.000001 # Query # # BEGIN |
| 121 |
server-binary-log.000001 # Query # # COMMIT |
| 122 |
server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set' |
| 123 |
server-binary-log.000001 # Query # # BEGIN |
| 124 |
server-binary-log.000001 # Query # # COMMIT |
| 125 |
server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set' |
| 126 |
server-binary-log.000001 # Query # # BEGIN |
| 127 |
server-binary-log.000001 # Query # # COMMIT |
| 128 |
|
| 129 |
############################################################ |
| 130 |
# 7. Stop server 3 and assert it has three transactions |
| 131 |
[connection server3] |
| 132 |
include/stop_group_replication.inc |
| 133 |
include/assert.inc [GTID_EXECUTED must have three transactions of view changes] |
| 134 |
include/show_binlog_events.inc |
| 135 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 136 |
server-binary-log.000001 # Previous_gtids # # |
| 137 |
server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set' |
| 138 |
server-binary-log.000001 # Query # # BEGIN |
| 139 |
server-binary-log.000001 # Query # # COMMIT |
| 140 |
server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set' |
| 141 |
server-binary-log.000001 # Query # # BEGIN |
| 142 |
server-binary-log.000001 # Query # # COMMIT |
| 143 |
server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set' |
| 144 |
server-binary-log.000001 # Query # # BEGIN |
| 145 |
server-binary-log.000001 # Query # # COMMIT |
| 146 |
|
| 147 |
############################################################ |
| 148 |
# 8. Stop server 2 and assert it has three transactions |
| 149 |
[connection server2] |
| 150 |
include/stop_group_replication.inc |
| 151 |
include/assert.inc [GTID_EXECUTED must have three transactions of view changes] |
| 152 |
include/show_binlog_events.inc |
| 153 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 154 |
server-binary-log.000001 # Previous_gtids # # |
| 155 |
server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set' |
| 156 |
server-binary-log.000001 # Query # # BEGIN |
| 157 |
server-binary-log.000001 # Query # # COMMIT |
| 158 |
server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set' |
| 159 |
server-binary-log.000001 # Query # # BEGIN |
| 160 |
server-binary-log.000001 # Query # # COMMIT |
| 161 |
server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set' |
| 162 |
server-binary-log.000001 # Query # # BEGIN |
| 163 |
server-binary-log.000001 # Query # # COMMIT |
| 164 |
|
| 165 |
############################################################ |
| 166 |
# 9. Start server 2 and assert it has 4 transactions |
| 167 |
[connection server2] |
| 168 |
include/start_group_replication.inc |
| 169 |
Warnings: |
| 170 |
Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release. |
| 171 |
include/assert.inc [GTID_EXECUTED must have four transactions of view changes] |
| 172 |
include/show_binlog_events.inc |
| 173 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 174 |
server-binary-log.000001 # Previous_gtids # # |
| 175 |
server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set' |
| 176 |
server-binary-log.000001 # Query # # BEGIN |
| 177 |
server-binary-log.000001 # Query # # COMMIT |
| 178 |
server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set' |
| 179 |
server-binary-log.000001 # Query # # BEGIN |
| 180 |
server-binary-log.000001 # Query # # COMMIT |
| 181 |
server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set' |
| 182 |
server-binary-log.000001 # Query # # BEGIN |
| 183 |
server-binary-log.000001 # Query # # COMMIT |
| 184 |
server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set' |
| 185 |
server-binary-log.000001 # Query # # BEGIN |
| 186 |
server-binary-log.000001 # Query # # COMMIT |
| 187 |
|
| 188 |
############################################################ |
| 189 |
# 10. Confirm server 1 has same GTID_EXECUTED as server 2 |
| 190 |
[connection server1] |
| 191 |
include/assert.inc [GTID_EXECUTED must have four transactions of view changes] |
| 192 |
include/show_binlog_events.inc |
| 193 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 194 |
server-binary-log.000001 # Previous_gtids # # |
| 195 |
server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set' |
| 196 |
server-binary-log.000001 # Query # # BEGIN |
| 197 |
server-binary-log.000001 # Query # # COMMIT |
| 198 |
server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set' |
| 199 |
server-binary-log.000001 # Query # # BEGIN |
| 200 |
server-binary-log.000001 # Query # # COMMIT |
| 201 |
server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set' |
| 202 |
server-binary-log.000001 # Query # # BEGIN |
| 203 |
server-binary-log.000001 # Query # # COMMIT |
| 204 |
server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set' |
| 205 |
server-binary-log.000001 # Query # # BEGIN |
| 206 |
server-binary-log.000001 # Query # # COMMIT |
| 207 |
|
| 208 |
############################################################ |
| 209 |
# 11. Start server 3 and assert it has 5 transactions |
| 210 |
[connection server3] |
| 211 |
include/start_group_replication.inc |
| 212 |
Warnings: |
| 213 |
Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release. |
| 214 |
include/assert.inc [GTID_EXECUTED must have five transactions of view changes] |
| 215 |
include/show_binlog_events.inc |
| 216 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 217 |
server-binary-log.000001 # Previous_gtids # # |
| 218 |
server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set' |
| 219 |
server-binary-log.000001 # Query # # BEGIN |
| 220 |
server-binary-log.000001 # Query # # COMMIT |
| 221 |
server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set' |
| 222 |
server-binary-log.000001 # Query # # BEGIN |
| 223 |
server-binary-log.000001 # Query # # COMMIT |
| 224 |
server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set' |
| 225 |
server-binary-log.000001 # Query # # BEGIN |
| 226 |
server-binary-log.000001 # Query # # COMMIT |
| 227 |
server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set' |
| 228 |
server-binary-log.000001 # Query # # BEGIN |
| 229 |
server-binary-log.000001 # Query # # COMMIT |
| 230 |
server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set' |
| 231 |
server-binary-log.000001 # Query # # BEGIN |
| 232 |
server-binary-log.000001 # Query # # COMMIT |
| 233 |
############################################################ |
| 234 |
# 12. Confirm server 1 has same GTID_EXECUTED than server 3 |
| 235 |
[connection server1] |
| 236 |
include/assert.inc [GTID_EXECUTED must have five transactions of view changes] |
| 237 |
include/show_binlog_events.inc |
| 238 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 239 |
server-binary-log.000001 # Previous_gtids # # |
| 240 |
server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set' |
| 241 |
server-binary-log.000001 # Query # # BEGIN |
| 242 |
server-binary-log.000001 # Query # # COMMIT |
| 243 |
server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set' |
| 244 |
server-binary-log.000001 # Query # # BEGIN |
| 245 |
server-binary-log.000001 # Query # # COMMIT |
| 246 |
server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set' |
| 247 |
server-binary-log.000001 # Query # # BEGIN |
| 248 |
server-binary-log.000001 # Query # # COMMIT |
| 249 |
server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set' |
| 250 |
server-binary-log.000001 # Query # # BEGIN |
| 251 |
server-binary-log.000001 # Query # # COMMIT |
| 252 |
server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set' |
| 253 |
server-binary-log.000001 # Query # # BEGIN |
| 254 |
server-binary-log.000001 # Query # # COMMIT |
| 255 |
############################################################ |
| 256 |
# 13. Confirm server 2 has same GTID_EXECUTED than server 3 |
| 257 |
[connection server2] |
| 258 |
include/assert.inc [GTID_EXECUTED must have five transactions of view changes] |
| 259 |
include/show_binlog_events.inc |
| 260 |
Log_name Pos Event_type Server_id End_log_pos Info |
| 261 |
server-binary-log.000001 # Previous_gtids # # |
| 262 |
server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set' |
| 263 |
server-binary-log.000001 # Query # # BEGIN |
| 264 |
server-binary-log.000001 # Query # # COMMIT |
| 265 |
server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set' |
| 266 |
server-binary-log.000001 # Query # # BEGIN |
| 267 |
server-binary-log.000001 # Query # # COMMIT |
| 268 |
server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set' |
| 269 |
server-binary-log.000001 # Query # # BEGIN |
| 270 |
server-binary-log.000001 # Query # # COMMIT |
| 271 |
server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set' |
| 272 |
server-binary-log.000001 # Query # # BEGIN |
| 273 |
server-binary-log.000001 # Query # # COMMIT |
| 274 |
server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set' |
| 275 |
server-binary-log.000001 # Query # # BEGIN |
| 276 |
server-binary-log.000001 # Query # # COMMIT |
| 277 |
|
| 278 |
############################################################ |
| 279 |
# 14. Cleanup |
| 280 |
[connection server1] |
| 281 |
SET sql_log_bin = 0; |
| 282 |
include/gtid_utils_end.inc |
| 283 |
SET sql_log_bin = 1; |
| 284 |
include/stop_group_replication.inc |
| 285 |
SET @@GLOBAL.group_replication_view_change_uuid= @group_replication_view_change_uuid_save; |
| 286 |
Warnings: |
| 287 |
Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release. |
| 288 |
SET GLOBAL group_replication_view_change_uuid = "AUTOMATIC"; |
| 289 |
Warnings: |
| 290 |
Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release. |
| 291 |
[connection server2] |
| 292 |
SET sql_log_bin = 0; |
| 293 |
include/gtid_utils_end.inc |
| 294 |
SET sql_log_bin = 1; |
| 295 |
include/stop_group_replication.inc |
| 296 |
SET @@GLOBAL.group_replication_view_change_uuid= @group_replication_view_change_uuid_save; |
| 297 |
Warnings: |
| 298 |
Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release. |
| 299 |
[connection server3] |
| 300 |
SET sql_log_bin = 0; |
| 301 |
include/gtid_utils_end.inc |
| 302 |
SET sql_log_bin = 1; |
| 303 |
include/stop_group_replication.inc |
| 304 |
SET @@GLOBAL.group_replication_view_change_uuid= @group_replication_view_change_uuid_save; |
| 305 |
Warnings: |
| 306 |
Warning 1681 'group_replication_view_change_uuid' is deprecated and will be removed in a future release. |
| 307 |
include/group_replication_end.inc |