Debian Codegraph @

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

raw
1 include/rpl_init.inc [topology=1->2]
2 connection server_2;
3 SET @old_parallel_threads=@@GLOBAL.slave_parallel_threads;
4 include/stop_slave.inc
5 SET GLOBAL slave_parallel_threads=10;
6 SET @old_max_relay= @@GLOBAL.max_relay_log_size;
7 SET GLOBAL max_relay_log_size = 4096;
8 CHANGE MASTER TO master_use_gtid=slave_pos;
9 include/start_slave.inc
10 connection server_1;
11 ALTER TABLE mysql.gtid_slave_pos ENGINE=InnoDB;
12 CREATE TABLE t1 (a int PRIMARY KEY, b VARCHAR(100)) ENGINE=InnoDB;
13 INSERT INTO t1 VALUES (1, "a");
14 connection server_2;
15 *** Create a long transaction that will span a relay log file. ***
16 connection server_1;
17 SET @old_domain= @@gtid_domain_id;
18 SET gtid_domain_id=10;
19 INSERT INTO t1 VALUES (10000, "domain 10");
20 SET gtid_domain_id=20;
21 INSERT INTO t1 VALUES (20000, "domain 20");
22 SET gtid_domain_id=@old_domain;
23 BEGIN;
24 [lots of inserts omitted]
25 COMMIT;
26 connection server_2;
27 connection server_1;
28 BEGIN;
29 [lots of inserts omitted]
30 COMMIT;
31 connection server_2;
32 include/stop_slave_sql.inc
33 START SLAVE SQL_THREAD;
34 include/wait_for_slave_to_start.inc
35 connection server_1;
36 INSERT INTO t1 VALUES (100000, "More stuffs.");
37 INSERT INTO t1 VALUES (100001, "And even more");
38 connection server_2;
39 SELECT * FROM t1 WHERE a >= 100000 ORDER BY a;
40 a b
41 100000 More stuffs.
42 100001 And even more
43 connection server_2;
44 include/stop_slave.inc
45 SET GLOBAL slave_parallel_threads=@old_parallel_threads;
46 SET GLOBAL max_relay_log_size= @old_max_relay;
47 include/start_slave.inc
48 connection server_1;
49 ALTER TABLE mysql.gtid_slave_pos ENGINE=Aria;
50 DROP TABLE t1;
51 include/rpl_end.inc