Debian Codegraph @

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

raw
1 include/rpl_init.inc [topology=1->2->3]
2 connection server_2;
3 include/stop_slave.inc
4 CHANGE MASTER TO
5 MASTER_USE_GTID = SLAVE_POS, IGNORE_DOMAIN_IDS = (2,3);
6 START SLAVE;
7 connection server_3;
8 include/stop_slave.inc
9 CHANGE MASTER TO
10 MASTER_USE_GTID = SLAVE_POS, IGNORE_DOMAIN_IDS = (2,3);
11 START SLAVE;
12 connection server_1;
13 CREATE TABLE t1 (a INT PRIMARY KEY, b VARCHAR(10)) ENGINE=InnoDB;
14 INSERT INTO t1 VALUES (1, "m1");
15 INSERT INTO t1 VALUES (2, "m2"), (3, "m3"), (4, "m4");
16 SET @@session.gtid_domain_id=2;
17 # The following should get filetered on slave.
18 CREATE TABLE t2 (a INT PRIMARY KEY, b VARCHAR(10)) ENGINE=InnoDB;
19 INSERT INTO t2 VALUES (1, "m1");
20 INSERT INTO t2 VALUES (2, "m2"), (3, "m3"), (4, "m4");
21 include/save_master_gtid.inc
22 connection server_2;
23 include/sync_with_master_gtid.inc
24 SELECT * FROM t1 ORDER BY a;
25 a b
26 1 m1
27 2 m2
28 3 m3
29 4 m4
30 # Only 't1' should have replicated to slaves.
31 SHOW TABLES;
32 Tables_in_test
33 t1
34 include/save_master_gtid.inc
35 connection server_3;
36 include/sync_with_master_gtid.inc
37 SELECT * FROM t1 ORDER BY a;
38 a b
39 1 m1
40 2 m2
41 3 m3
42 4 m4
43 # Only 't1' should have replicated to slaves.
44 SHOW TABLES;
45 Tables_in_test
46 t1
47 # Cleanup
48 connection server_1;
49 SET @@session.gtid_domain_id=1;
50 DROP TABLE t1;
51 SET @@session.gtid_domain_id=2;
52 DROP TABLE t2;
53 include/save_master_gtid.inc
54 connection server_2;
55 include/sync_with_master_gtid.inc
56 include/save_master_gtid.inc
57 connection server_3;
58 include/sync_with_master_gtid.inc
59 connection server_2;
60 STOP SLAVE;
61 CHANGE MASTER TO IGNORE_DOMAIN_IDS = ();
62 connection server_3;
63 STOP SLAVE;
64 CHANGE MASTER TO IGNORE_DOMAIN_IDS = ();
65 # End of test.