| 1 |
include/master-slave.inc |
| 2 |
[connection master] |
| 3 |
connection slave; |
| 4 |
call mtr.add_suppression("WSREP: handlerton rollback failed"); |
| 5 |
include/stop_slave.inc |
| 6 |
ALTER TABLE mysql.gtid_slave_pos ENGINE=InnoDB; |
| 7 |
SET @old_parallel_threads = @@GLOBAL.slave_parallel_threads; |
| 8 |
SET @old_parallel_mode = @@GLOBAL.slave_parallel_mode; |
| 9 |
SET @@global.slave_parallel_mode ='optimistic'; |
| 10 |
include/start_slave.inc |
| 11 |
connection master; |
| 12 |
CREATE TABLE t1 (a INT, b INT) ENGINE=InnoDB; |
| 13 |
CREATE TABLE t2 (a INT AUTO_INCREMENT PRIMARY KEY, b INT) ENGINE=InnoDB; |
| 14 |
include/sync_slave_sql_with_master.inc |
| 15 |
include/diff_tables.inc [master:t1, slave:t1] |
| 16 |
connection slave; |
| 17 |
include/stop_slave.inc |
| 18 |
SET GLOBAL slave_parallel_threads=@old_parallel_threads; |
| 19 |
SET GLOBAL slave_parallel_mode=@old_parallel_mode; |
| 20 |
include/start_slave.inc |
| 21 |
connection master; |
| 22 |
DROP TABLE t1, t2; |
| 23 |
include/rpl_end.inc |