Debian Codegraph @

mysql-test/suite/rpl/t/rpl_gtid_mdev9033.test

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