Debian Codegraph @

mysql-test/suite/rpl/r/rpl_delayed_slave2.result

raw
1 include/master-slave.inc
2 [connection master]
3 connection master;
4 ALTER TABLE mysql.gtid_slave_pos ENGINE=InnoDB;
5 CREATE TABLE t1 (a INT PRIMARY KEY, b VARCHAR(100));
6 INSERT INTO t1 VALUES (1, "a");
7 connection slave;
8 include/stop_slave.inc
9 CHANGE MASTER TO master_use_gtid=slave_pos;
10 SET @old_mode= @@GLOBAL.slave_parallel_mode;
11 SET GLOBAL slave_parallel_mode=optimistic;
12 SET @old_threads= @@GLOBAL.slave_parallel_threads;
13 SET GLOBAL slave_parallel_threads=10;
14 connection master;
15 INSERT INTO t1 VALUES (2, "b");
16 INSERT INTO t1 VALUES (3, "b");
17 INSERT INTO t1 VALUES (4, "b");
18 SET timestamp= @@timestamp + 24*60*60;
19 INSERT INTO t1 VALUES (5, "c");
20 INSERT INTO t1 VALUES (6, "c");
21 SET timestamp= 0;
22 include/save_master_gtid.inc
23 connection slave;
24 CHANGE MASTER TO master_delay=1;
25 include/start_slave.inc
26 SELECT MASTER_GTID_WAIT('GTID1');
27 MASTER_GTID_WAIT('GTID1')
28 0
29 SELECT MASTER_GTID_WAIT('GTID2', 2);
30 MASTER_GTID_WAIT('GTID2', 2)
31 -1
32 include/stop_slave.inc
33 SELECT * FROM t1 ORDER BY a;
34 a b
35 1 a
36 2 b
37 3 b
38 4 b
39 CHANGE MASTER TO master_delay=0;
40 include/start_slave.inc
41 include/sync_with_master_gtid.inc
42 SELECT * FROM t1 ORDER BY a;
43 a b
44 1 a
45 2 b
46 3 b
47 4 b
48 5 c
49 6 c
50 connection slave;
51 include/stop_slave.inc
52 CHANGE MASTER TO master_use_gtid=no, master_delay=0;
53 SET GLOBAL slave_parallel_mode=@old_mode;
54 SET GLOBAL slave_parallel_threads=@old_threads;
55 include/start_slave.inc
56 connection master;
57 DROP TABLE t1;
58 include/rpl_end.inc