| 1 |
include/master-slave.inc |
| 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 master] |
| 6 |
# Using MyISAM storage engine |
| 7 |
## Running the test with the SQL thread stopped |
| 8 |
[connection slave] |
| 9 |
include/stop_slave_sql.inc |
| 10 |
[connection slave] |
| 11 |
[connection master] |
| 12 |
[connection slave] |
| 13 |
include/gtid_step_reset_on_retrieved.inc |
| 14 |
[connection master] |
| 15 |
CREATE TABLE t1 (i INT NOT NULL AUTO_INCREMENT PRIMARY KEY, info VARCHAR(64)) ENGINE=MYISAM; |
| 16 |
CREATE TABLE t2 (i INT) ENGINE=MYISAM; |
| 17 |
INSERT INTO t1 (info) VALUE ('Insert data without splitting transactions in the relay log'); |
| 18 |
BEGIN; |
| 19 |
INSERT INTO t2 (i) VALUES (-6); |
| 20 |
INSERT INTO t2 (i) VALUES (-5); |
| 21 |
INSERT INTO t2 (i) VALUES (-4); |
| 22 |
COMMIT; |
| 23 |
[connection master] |
| 24 |
include/sync_slave_io_with_master.inc |
| 25 |
[connection slave] |
| 26 |
include/stop_slave_io.inc |
| 27 |
include/start_slave_io.inc |
| 28 |
[connection slave] |
| 29 |
include/gtid_step_assert_on_retrieved.inc [count=6, only_count=0] |
| 30 |
Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set) |
| 31 |
[connection master] |
| 32 |
INSERT INTO t1 (info) VALUE ('Insert data rotating master binlog between two transactions'); |
| 33 |
BEGIN; |
| 34 |
INSERT INTO t2 (i) VALUES (-3); |
| 35 |
INSERT INTO t2 (i) VALUES (-2); |
| 36 |
COMMIT; |
| 37 |
FLUSH LOGS; |
| 38 |
INSERT INTO t1 (info) VALUE ('After FLUSH LOGS at master'); |
| 39 |
BEGIN; |
| 40 |
INSERT INTO t2 (i) VALUES (-1); |
| 41 |
INSERT INTO t2 (i) VALUES (0); |
| 42 |
COMMIT; |
| 43 |
[connection master] |
| 44 |
include/sync_slave_io_with_master.inc |
| 45 |
[connection slave] |
| 46 |
include/stop_slave_io.inc |
| 47 |
include/start_slave_io.inc |
| 48 |
[connection slave] |
| 49 |
include/gtid_step_assert_on_retrieved.inc [count=6, only_count=0] |
| 50 |
Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set) |
| 51 |
[connection slave] |
| 52 |
[connection master] |
| 53 |
INSERT INTO t1 (info) VALUES ('stop_io_after_reading_gtid_log_event'); |
| 54 |
include/sync_slave_io_with_master.inc |
| 55 |
# Adding debug point 'stop_io_after_reading_gtid_log_event' to @@GLOBAL.debug |
| 56 |
[connection master] |
| 57 |
BEGIN; |
| 58 |
INSERT INTO t2 VALUES (100 * 1 + 1); |
| 59 |
SET @val= 100 * 1 + 2; |
| 60 |
INSERT INTO t2 VALUES (@val); |
| 61 |
COMMIT; |
| 62 |
[connection slave] |
| 63 |
include/wait_for_slave_io_to_stop.inc |
| 64 |
# Removing debug point 'stop_io_after_reading_gtid_log_event' from @@GLOBAL.debug |
| 65 |
include/gtid_step_assert_on_retrieved.inc [count=1, only_count=0] |
| 66 |
Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set) |
| 67 |
[connection master] |
| 68 |
INSERT INTO t2 VALUES (100 * 1 + 3); |
| 69 |
[connection slave] |
| 70 |
include/start_slave_io.inc |
| 71 |
[connection master] |
| 72 |
include/sync_slave_io_with_master.inc |
| 73 |
include/gtid_step_assert_on_retrieved.inc [count=3, only_count=0] |
| 74 |
Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set) |
| 75 |
[connection slave] |
| 76 |
[connection master] |
| 77 |
INSERT INTO t1 (info) VALUES ('stop_io_after_reading_query_log_event'); |
| 78 |
include/sync_slave_io_with_master.inc |
| 79 |
# Adding debug point 'stop_io_after_reading_query_log_event' to @@GLOBAL.debug |
| 80 |
[connection master] |
| 81 |
BEGIN; |
| 82 |
INSERT INTO t2 VALUES (100 * 2 + 1); |
| 83 |
SET @val= 100 * 2 + 2; |
| 84 |
INSERT INTO t2 VALUES (@val); |
| 85 |
COMMIT; |
| 86 |
[connection slave] |
| 87 |
include/wait_for_slave_io_to_stop.inc |
| 88 |
# Removing debug point 'stop_io_after_reading_query_log_event' from @@GLOBAL.debug |
| 89 |
include/gtid_step_assert_on_retrieved.inc [count=1, only_count=0] |
| 90 |
Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set) |
| 91 |
[connection master] |
| 92 |
INSERT INTO t2 VALUES (100 * 2 + 3); |
| 93 |
[connection slave] |
| 94 |
include/start_slave_io.inc |
| 95 |
[connection master] |
| 96 |
include/sync_slave_io_with_master.inc |
| 97 |
include/gtid_step_assert_on_retrieved.inc [count=3, only_count=0] |
| 98 |
Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set) |
| 99 |
[connection slave] |
| 100 |
[connection master] |
| 101 |
INSERT INTO t1 (info) VALUES ('stop_io_after_reading_table_map_event'); |
| 102 |
include/sync_slave_io_with_master.inc |
| 103 |
# Adding debug point 'stop_io_after_reading_table_map_event' to @@GLOBAL.debug |
| 104 |
[connection master] |
| 105 |
BEGIN; |
| 106 |
INSERT INTO t2 VALUES (100 * 3 + 1); |
| 107 |
SET @val= 100 * 3 + 2; |
| 108 |
INSERT INTO t2 VALUES (@val); |
| 109 |
COMMIT; |
| 110 |
[connection slave] |
| 111 |
include/wait_for_slave_io_to_stop.inc |
| 112 |
# Removing debug point 'stop_io_after_reading_table_map_event' from @@GLOBAL.debug |
| 113 |
include/gtid_step_assert_on_retrieved.inc [count=1, only_count=0] |
| 114 |
Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set) |
| 115 |
[connection master] |
| 116 |
INSERT INTO t2 VALUES (100 * 3 + 3); |
| 117 |
[connection slave] |
| 118 |
include/start_slave_io.inc |
| 119 |
[connection master] |
| 120 |
include/sync_slave_io_with_master.inc |
| 121 |
include/gtid_step_assert_on_retrieved.inc [count=3, only_count=0] |
| 122 |
Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set) |
| 123 |
[connection master] |
| 124 |
DROP TABLE t1,t2; |
| 125 |
## Starting and syncing the SQL thread before next round |
| 126 |
[connection slave] |
| 127 |
include/start_slave_sql.inc |
| 128 |
[connection master] |
| 129 |
include/sync_slave_sql_with_master.inc |
| 130 |
## Running the test with the SQL thread started |
| 131 |
[connection slave] |
| 132 |
[connection master] |
| 133 |
[connection slave] |
| 134 |
include/gtid_step_reset.inc |
| 135 |
[connection master] |
| 136 |
CREATE TABLE t1 (i INT NOT NULL AUTO_INCREMENT PRIMARY KEY, info VARCHAR(64)) ENGINE=MYISAM; |
| 137 |
CREATE TABLE t2 (i INT) ENGINE=MYISAM; |
| 138 |
INSERT INTO t1 (info) VALUE ('Insert data without splitting transactions in the relay log'); |
| 139 |
BEGIN; |
| 140 |
INSERT INTO t2 (i) VALUES (-6); |
| 141 |
INSERT INTO t2 (i) VALUES (-5); |
| 142 |
INSERT INTO t2 (i) VALUES (-4); |
| 143 |
COMMIT; |
| 144 |
[connection master] |
| 145 |
include/sync_slave_sql_with_master.inc |
| 146 |
include/diff_tables.inc [master:t1, slave:t1] |
| 147 |
[connection slave] |
| 148 |
include/stop_slave_io.inc |
| 149 |
include/start_slave_io.inc |
| 150 |
[connection slave] |
| 151 |
include/gtid_step_assert.inc [count=6, only_count=0] |
| 152 |
[connection master] |
| 153 |
INSERT INTO t1 (info) VALUE ('Insert data rotating master binlog between two transactions'); |
| 154 |
BEGIN; |
| 155 |
INSERT INTO t2 (i) VALUES (-3); |
| 156 |
INSERT INTO t2 (i) VALUES (-2); |
| 157 |
COMMIT; |
| 158 |
FLUSH LOGS; |
| 159 |
INSERT INTO t1 (info) VALUE ('After FLUSH LOGS at master'); |
| 160 |
BEGIN; |
| 161 |
INSERT INTO t2 (i) VALUES (-1); |
| 162 |
INSERT INTO t2 (i) VALUES (0); |
| 163 |
COMMIT; |
| 164 |
[connection master] |
| 165 |
include/sync_slave_sql_with_master.inc |
| 166 |
include/diff_tables.inc [master:t1, slave:t1] |
| 167 |
[connection slave] |
| 168 |
include/stop_slave_io.inc |
| 169 |
include/start_slave_io.inc |
| 170 |
[connection slave] |
| 171 |
include/gtid_step_assert.inc [count=6, only_count=0] |
| 172 |
[connection slave] |
| 173 |
[connection master] |
| 174 |
INSERT INTO t1 (info) VALUES ('stop_io_after_reading_gtid_log_event'); |
| 175 |
include/sync_slave_io_with_master.inc |
| 176 |
# Adding debug point 'stop_io_after_reading_gtid_log_event' to @@GLOBAL.debug |
| 177 |
[connection master] |
| 178 |
BEGIN; |
| 179 |
INSERT INTO t2 VALUES (100 * 1 + 1); |
| 180 |
SET @val= 100 * 1 + 2; |
| 181 |
INSERT INTO t2 VALUES (@val); |
| 182 |
COMMIT; |
| 183 |
[connection slave] |
| 184 |
include/wait_for_slave_io_to_stop.inc |
| 185 |
# Removing debug point 'stop_io_after_reading_gtid_log_event' from @@GLOBAL.debug |
| 186 |
include/sync_slave_sql_with_io.inc |
| 187 |
include/gtid_step_assert.inc [count=1, only_count=0] |
| 188 |
[connection master] |
| 189 |
INSERT INTO t2 VALUES (100 * 1 + 3); |
| 190 |
[connection slave] |
| 191 |
include/start_slave_io.inc |
| 192 |
[connection master] |
| 193 |
include/sync_slave_sql_with_master.inc |
| 194 |
include/gtid_step_assert.inc [count=3, only_count=0] |
| 195 |
[connection slave] |
| 196 |
[connection master] |
| 197 |
INSERT INTO t1 (info) VALUES ('stop_io_after_reading_query_log_event'); |
| 198 |
include/sync_slave_io_with_master.inc |
| 199 |
# Adding debug point 'stop_io_after_reading_query_log_event' to @@GLOBAL.debug |
| 200 |
[connection master] |
| 201 |
BEGIN; |
| 202 |
INSERT INTO t2 VALUES (100 * 2 + 1); |
| 203 |
SET @val= 100 * 2 + 2; |
| 204 |
INSERT INTO t2 VALUES (@val); |
| 205 |
COMMIT; |
| 206 |
[connection slave] |
| 207 |
include/wait_for_slave_io_to_stop.inc |
| 208 |
# Removing debug point 'stop_io_after_reading_query_log_event' from @@GLOBAL.debug |
| 209 |
include/sync_slave_sql_with_io.inc |
| 210 |
include/gtid_step_assert.inc [count=1, only_count=0] |
| 211 |
[connection master] |
| 212 |
INSERT INTO t2 VALUES (100 * 2 + 3); |
| 213 |
[connection slave] |
| 214 |
include/start_slave_io.inc |
| 215 |
[connection master] |
| 216 |
include/sync_slave_sql_with_master.inc |
| 217 |
include/gtid_step_assert.inc [count=3, only_count=0] |
| 218 |
[connection slave] |
| 219 |
[connection master] |
| 220 |
INSERT INTO t1 (info) VALUES ('stop_io_after_reading_table_map_event'); |
| 221 |
include/sync_slave_io_with_master.inc |
| 222 |
# Adding debug point 'stop_io_after_reading_table_map_event' to @@GLOBAL.debug |
| 223 |
[connection master] |
| 224 |
BEGIN; |
| 225 |
INSERT INTO t2 VALUES (100 * 3 + 1); |
| 226 |
SET @val= 100 * 3 + 2; |
| 227 |
INSERT INTO t2 VALUES (@val); |
| 228 |
COMMIT; |
| 229 |
[connection slave] |
| 230 |
include/wait_for_slave_io_to_stop.inc |
| 231 |
# Removing debug point 'stop_io_after_reading_table_map_event' from @@GLOBAL.debug |
| 232 |
include/sync_slave_sql_with_io.inc |
| 233 |
include/gtid_step_assert.inc [count=1, only_count=0] |
| 234 |
[connection master] |
| 235 |
INSERT INTO t2 VALUES (100 * 3 + 3); |
| 236 |
[connection slave] |
| 237 |
include/start_slave_io.inc |
| 238 |
[connection master] |
| 239 |
include/sync_slave_sql_with_master.inc |
| 240 |
include/gtid_step_assert.inc [count=3, only_count=0] |
| 241 |
[connection master] |
| 242 |
include/sync_slave_sql_with_master.inc |
| 243 |
include/diff_tables.inc [master:t1, slave:t1] |
| 244 |
[connection master] |
| 245 |
DROP TABLE t1,t2; |
| 246 |
include/sync_slave_sql_with_master.inc |
| 247 |
[connection slave] |
| 248 |
include/stop_slave.inc |
| 249 |
RESET MASTER; |
| 250 |
RESET SLAVE; |
| 251 |
Warnings: |
| 252 |
Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead |
| 253 |
[connection master] |
| 254 |
RESET MASTER; |
| 255 |
[connection slave] |
| 256 |
include/stop_slave.inc |
| 257 |
Warnings: |
| 258 |
Note 3084 Replication thread(s) for channel '' are already stopped. |
| 259 |
CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION= 0; |
| 260 |
include/start_slave.inc |
| 261 |
# Using MyISAM storage engine without auto positioning |
| 262 |
## Running the test with the SQL thread stopped |
| 263 |
[connection slave] |
| 264 |
include/stop_slave_sql.inc |
| 265 |
[connection slave] |
| 266 |
[connection master] |
| 267 |
[connection slave] |
| 268 |
include/gtid_step_reset_on_retrieved.inc |
| 269 |
[connection master] |
| 270 |
CREATE TABLE t1 (i INT NOT NULL AUTO_INCREMENT PRIMARY KEY, info VARCHAR(64)) ENGINE=MYISAM; |
| 271 |
CREATE TABLE t2 (i INT) ENGINE=MYISAM; |
| 272 |
INSERT INTO t1 (info) VALUE ('Insert data without splitting transactions in the relay log'); |
| 273 |
BEGIN; |
| 274 |
INSERT INTO t2 (i) VALUES (-6); |
| 275 |
INSERT INTO t2 (i) VALUES (-5); |
| 276 |
INSERT INTO t2 (i) VALUES (-4); |
| 277 |
COMMIT; |
| 278 |
[connection master] |
| 279 |
include/sync_slave_io_with_master.inc |
| 280 |
[connection slave] |
| 281 |
include/stop_slave_io.inc |
| 282 |
include/start_slave_io.inc |
| 283 |
[connection slave] |
| 284 |
include/gtid_step_assert_on_retrieved.inc [count=6, only_count=0] |
| 285 |
Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set) |
| 286 |
[connection master] |
| 287 |
INSERT INTO t1 (info) VALUE ('Insert data rotating master binlog between two transactions'); |
| 288 |
BEGIN; |
| 289 |
INSERT INTO t2 (i) VALUES (-3); |
| 290 |
INSERT INTO t2 (i) VALUES (-2); |
| 291 |
COMMIT; |
| 292 |
FLUSH LOGS; |
| 293 |
INSERT INTO t1 (info) VALUE ('After FLUSH LOGS at master'); |
| 294 |
BEGIN; |
| 295 |
INSERT INTO t2 (i) VALUES (-1); |
| 296 |
INSERT INTO t2 (i) VALUES (0); |
| 297 |
COMMIT; |
| 298 |
[connection master] |
| 299 |
include/sync_slave_io_with_master.inc |
| 300 |
[connection slave] |
| 301 |
include/stop_slave_io.inc |
| 302 |
include/start_slave_io.inc |
| 303 |
[connection slave] |
| 304 |
include/gtid_step_assert_on_retrieved.inc [count=6, only_count=0] |
| 305 |
Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set) |
| 306 |
[connection slave] |
| 307 |
[connection master] |
| 308 |
INSERT INTO t1 (info) VALUES ('stop_io_after_reading_gtid_log_event'); |
| 309 |
include/sync_slave_io_with_master.inc |
| 310 |
# Adding debug point 'stop_io_after_reading_gtid_log_event' to @@GLOBAL.debug |
| 311 |
[connection master] |
| 312 |
BEGIN; |
| 313 |
INSERT INTO t2 VALUES (100 * 1 + 1); |
| 314 |
SET @val= 100 * 1 + 2; |
| 315 |
INSERT INTO t2 VALUES (@val); |
| 316 |
COMMIT; |
| 317 |
[connection slave] |
| 318 |
include/wait_for_slave_io_to_stop.inc |
| 319 |
# Removing debug point 'stop_io_after_reading_gtid_log_event' from @@GLOBAL.debug |
| 320 |
include/gtid_step_assert_on_retrieved.inc [count=1, only_count=0] |
| 321 |
Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set) |
| 322 |
[connection master] |
| 323 |
INSERT INTO t2 VALUES (100 * 1 + 3); |
| 324 |
[connection slave] |
| 325 |
include/start_slave_io.inc |
| 326 |
[connection master] |
| 327 |
include/sync_slave_io_with_master.inc |
| 328 |
include/gtid_step_assert_on_retrieved.inc [count=3, only_count=0] |
| 329 |
Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set) |
| 330 |
[connection slave] |
| 331 |
[connection master] |
| 332 |
INSERT INTO t1 (info) VALUES ('stop_io_after_reading_query_log_event'); |
| 333 |
include/sync_slave_io_with_master.inc |
| 334 |
# Adding debug point 'stop_io_after_reading_query_log_event' to @@GLOBAL.debug |
| 335 |
[connection master] |
| 336 |
BEGIN; |
| 337 |
INSERT INTO t2 VALUES (100 * 2 + 1); |
| 338 |
SET @val= 100 * 2 + 2; |
| 339 |
INSERT INTO t2 VALUES (@val); |
| 340 |
COMMIT; |
| 341 |
[connection slave] |
| 342 |
include/wait_for_slave_io_to_stop.inc |
| 343 |
# Removing debug point 'stop_io_after_reading_query_log_event' from @@GLOBAL.debug |
| 344 |
include/gtid_step_assert_on_retrieved.inc [count=1, only_count=0] |
| 345 |
Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set) |
| 346 |
[connection master] |
| 347 |
INSERT INTO t2 VALUES (100 * 2 + 3); |
| 348 |
[connection slave] |
| 349 |
include/start_slave_io.inc |
| 350 |
[connection master] |
| 351 |
include/sync_slave_io_with_master.inc |
| 352 |
include/gtid_step_assert_on_retrieved.inc [count=3, only_count=0] |
| 353 |
Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set) |
| 354 |
[connection slave] |
| 355 |
[connection master] |
| 356 |
INSERT INTO t1 (info) VALUES ('stop_io_after_reading_table_map_event'); |
| 357 |
include/sync_slave_io_with_master.inc |
| 358 |
# Adding debug point 'stop_io_after_reading_table_map_event' to @@GLOBAL.debug |
| 359 |
[connection master] |
| 360 |
BEGIN; |
| 361 |
INSERT INTO t2 VALUES (100 * 3 + 1); |
| 362 |
SET @val= 100 * 3 + 2; |
| 363 |
INSERT INTO t2 VALUES (@val); |
| 364 |
COMMIT; |
| 365 |
[connection slave] |
| 366 |
include/wait_for_slave_io_to_stop.inc |
| 367 |
# Removing debug point 'stop_io_after_reading_table_map_event' from @@GLOBAL.debug |
| 368 |
include/gtid_step_assert_on_retrieved.inc [count=1, only_count=0] |
| 369 |
Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set) |
| 370 |
[connection master] |
| 371 |
INSERT INTO t2 VALUES (100 * 3 + 3); |
| 372 |
[connection slave] |
| 373 |
include/start_slave_io.inc |
| 374 |
[connection master] |
| 375 |
include/sync_slave_io_with_master.inc |
| 376 |
include/gtid_step_assert_on_retrieved.inc [count=3, only_count=0] |
| 377 |
Asserting based on SHOW SLAVE STATUS(Retrieved_Gtid_Set) |
| 378 |
[connection master] |
| 379 |
DROP TABLE t1,t2; |
| 380 |
## Starting and syncing the SQL thread before next round |
| 381 |
[connection slave] |
| 382 |
include/start_slave_sql.inc |
| 383 |
[connection master] |
| 384 |
include/sync_slave_sql_with_master.inc |
| 385 |
## Running the test with the SQL thread started |
| 386 |
[connection slave] |
| 387 |
[connection master] |
| 388 |
[connection slave] |
| 389 |
include/gtid_step_reset.inc |
| 390 |
[connection master] |
| 391 |
CREATE TABLE t1 (i INT NOT NULL AUTO_INCREMENT PRIMARY KEY, info VARCHAR(64)) ENGINE=MYISAM; |
| 392 |
CREATE TABLE t2 (i INT) ENGINE=MYISAM; |
| 393 |
INSERT INTO t1 (info) VALUE ('Insert data without splitting transactions in the relay log'); |
| 394 |
BEGIN; |
| 395 |
INSERT INTO t2 (i) VALUES (-6); |
| 396 |
INSERT INTO t2 (i) VALUES (-5); |
| 397 |
INSERT INTO t2 (i) VALUES (-4); |
| 398 |
COMMIT; |
| 399 |
[connection master] |
| 400 |
include/sync_slave_sql_with_master.inc |
| 401 |
include/diff_tables.inc [master:t1, slave:t1] |
| 402 |
[connection slave] |
| 403 |
include/stop_slave_io.inc |
| 404 |
include/start_slave_io.inc |
| 405 |
[connection slave] |
| 406 |
include/gtid_step_assert.inc [count=6, only_count=0] |
| 407 |
[connection master] |
| 408 |
INSERT INTO t1 (info) VALUE ('Insert data rotating master binlog between two transactions'); |
| 409 |
BEGIN; |
| 410 |
INSERT INTO t2 (i) VALUES (-3); |
| 411 |
INSERT INTO t2 (i) VALUES (-2); |
| 412 |
COMMIT; |
| 413 |
FLUSH LOGS; |
| 414 |
INSERT INTO t1 (info) VALUE ('After FLUSH LOGS at master'); |
| 415 |
BEGIN; |
| 416 |
INSERT INTO t2 (i) VALUES (-1); |
| 417 |
INSERT INTO t2 (i) VALUES (0); |
| 418 |
COMMIT; |
| 419 |
[connection master] |
| 420 |
include/sync_slave_sql_with_master.inc |
| 421 |
include/diff_tables.inc [master:t1, slave:t1] |
| 422 |
[connection slave] |
| 423 |
include/stop_slave_io.inc |
| 424 |
include/start_slave_io.inc |
| 425 |
[connection slave] |
| 426 |
include/gtid_step_assert.inc [count=6, only_count=0] |
| 427 |
[connection slave] |
| 428 |
[connection master] |
| 429 |
INSERT INTO t1 (info) VALUES ('stop_io_after_reading_gtid_log_event'); |
| 430 |
include/sync_slave_io_with_master.inc |
| 431 |
# Adding debug point 'stop_io_after_reading_gtid_log_event' to @@GLOBAL.debug |
| 432 |
[connection master] |
| 433 |
BEGIN; |
| 434 |
INSERT INTO t2 VALUES (100 * 1 + 1); |
| 435 |
SET @val= 100 * 1 + 2; |
| 436 |
INSERT INTO t2 VALUES (@val); |
| 437 |
COMMIT; |
| 438 |
[connection slave] |
| 439 |
include/wait_for_slave_io_to_stop.inc |
| 440 |
# Removing debug point 'stop_io_after_reading_gtid_log_event' from @@GLOBAL.debug |
| 441 |
include/sync_slave_sql_with_io.inc |
| 442 |
include/gtid_step_assert.inc [count=1, only_count=0] |
| 443 |
[connection master] |
| 444 |
INSERT INTO t2 VALUES (100 * 1 + 3); |
| 445 |
[connection slave] |
| 446 |
include/start_slave_io.inc |
| 447 |
[connection master] |
| 448 |
include/sync_slave_sql_with_master.inc |
| 449 |
include/gtid_step_assert.inc [count=3, only_count=0] |
| 450 |
[connection slave] |
| 451 |
[connection master] |
| 452 |
INSERT INTO t1 (info) VALUES ('stop_io_after_reading_query_log_event'); |
| 453 |
include/sync_slave_io_with_master.inc |
| 454 |
# Adding debug point 'stop_io_after_reading_query_log_event' to @@GLOBAL.debug |
| 455 |
[connection master] |
| 456 |
BEGIN; |
| 457 |
INSERT INTO t2 VALUES (100 * 2 + 1); |
| 458 |
SET @val= 100 * 2 + 2; |
| 459 |
INSERT INTO t2 VALUES (@val); |
| 460 |
COMMIT; |
| 461 |
[connection slave] |
| 462 |
include/wait_for_slave_io_to_stop.inc |
| 463 |
# Removing debug point 'stop_io_after_reading_query_log_event' from @@GLOBAL.debug |
| 464 |
include/sync_slave_sql_with_io.inc |
| 465 |
include/gtid_step_assert.inc [count=1, only_count=0] |
| 466 |
[connection master] |
| 467 |
INSERT INTO t2 VALUES (100 * 2 + 3); |
| 468 |
[connection slave] |
| 469 |
include/start_slave_io.inc |
| 470 |
[connection master] |
| 471 |
include/sync_slave_sql_with_master.inc |
| 472 |
include/gtid_step_assert.inc [count=3, only_count=0] |
| 473 |
[connection slave] |
| 474 |
[connection master] |
| 475 |
INSERT INTO t1 (info) VALUES ('stop_io_after_reading_table_map_event'); |
| 476 |
include/sync_slave_io_with_master.inc |
| 477 |
# Adding debug point 'stop_io_after_reading_table_map_event' to @@GLOBAL.debug |
| 478 |
[connection master] |
| 479 |
BEGIN; |
| 480 |
INSERT INTO t2 VALUES (100 * 3 + 1); |
| 481 |
SET @val= 100 * 3 + 2; |
| 482 |
INSERT INTO t2 VALUES (@val); |
| 483 |
COMMIT; |
| 484 |
[connection slave] |
| 485 |
include/wait_for_slave_io_to_stop.inc |
| 486 |
# Removing debug point 'stop_io_after_reading_table_map_event' from @@GLOBAL.debug |
| 487 |
include/sync_slave_sql_with_io.inc |
| 488 |
include/gtid_step_assert.inc [count=1, only_count=0] |
| 489 |
[connection master] |
| 490 |
INSERT INTO t2 VALUES (100 * 3 + 3); |
| 491 |
[connection slave] |
| 492 |
include/start_slave_io.inc |
| 493 |
[connection master] |
| 494 |
include/sync_slave_sql_with_master.inc |
| 495 |
include/gtid_step_assert.inc [count=3, only_count=0] |
| 496 |
[connection master] |
| 497 |
include/sync_slave_sql_with_master.inc |
| 498 |
include/diff_tables.inc [master:t1, slave:t1] |
| 499 |
[connection master] |
| 500 |
DROP TABLE t1,t2; |
| 501 |
include/sync_slave_sql_with_master.inc |
| 502 |
[connection slave] |
| 503 |
include/stop_slave.inc |
| 504 |
CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION= 1; |
| 505 |
include/start_slave.inc |
| 506 |
include/rpl_end.inc |