Debian Codegraph @

mysql-test/suite/multi_source/replicate_rewrite_db_dynamic.test

raw
1 #
2 # Test multi-source dynamically setting of replication filter
3 # "replicate_rewrite_db"
4 #
5 # This test ensures that setting a replica's replicate_rewrite_db works on a
6 # per-master basis. To ensure this, this test connects a replica to two
7 # different primary server instances. Each primary uses the same database
8 # name and table name. To ensure the data operations don't interfere with one
9 # another on the replica, it sets replicate_rewrite_db individually per
10 # connection to apply the events from each primary into a database specific to
11 # that connection.
12 #
13
14 --source include/not_embedded.inc
15 --source include/have_innodb.inc
16
17 --connect (server_1,127.0.0.1,root,,,$SERVER_MYPORT_1)
18 --connect (server_2,127.0.0.1,root,,,$SERVER_MYPORT_2)
19 --connect (server_3,127.0.0.1,root,,,$SERVER_MYPORT_3)
20
21
22 --echo # Connect the slave (server_3) to two masters (server_1 and server_2)
23 --connection server_3
24 --replace_result $SERVER_MYPORT_1 MYPORT_1
25 eval CHANGE MASTER 'm1' TO master_port=$SERVER_MYPORT_1, master_host='127.0.0.1', master_user='root', master_ssl_verify_server_cert=0;
26 --replace_result $SERVER_MYPORT_2 MYPORT_2
27 eval CHANGE MASTER 'm2' TO master_port=$SERVER_MYPORT_2, master_host='127.0.0.1', master_user='root', master_ssl_verify_server_cert=0;
28
29 --echo # Apply events from server_1 (m1) into m1_test
30 create database m1_test;
31 SET @@global.'m1'.replicate_rewrite_db='test->m1_test';
32
33 --echo # Apply events from server_2 (m2) into m2_test
34 create database m2_test;
35 SET @@global.'m2'.replicate_rewrite_db='test->m2_test';
36
37 start all slaves;
38 set default_master_connection = 'm1';
39 --source include/wait_for_slave_to_start.inc
40 set default_master_connection = 'm2';
41 --source include/wait_for_slave_to_start.inc
42
43 --echo # Create test data for servers 1 and 2 with different data
44 --connection server_1
45 create table t (a int);
46 insert into t values (1);
47 insert into t values (2);
48 insert into t values (3);
49 --source include/save_master_gtid.inc
50 --connection server_3
51 --source include/sync_with_master_gtid.inc
52
53 --connection server_2
54 create table t (a int);
55 insert into t values (4);
56 insert into t values (5);
57 insert into t values (6);
58 --source include/save_master_gtid.inc
59 --connection server_3
60 --source include/sync_with_master_gtid.inc
61
62 --echo # Ensure the slave correctly replicates data from each master into its
63 --echo # respective database
64 --let $diff_tables=server_1:test.t,server_3:m1_test.t
65 --source include/diff_tables.inc
66
67 --let $diff_tables=server_2:test.t,server_3:m2_test.t
68 --source include/diff_tables.inc
69
70
71 --echo #
72 --echo # Cleanup
73
74 --connection server_1
75 DROP TABLE t;
76 --source include/save_master_gtid.inc
77 --connection server_3
78 --source include/sync_with_master_gtid.inc
79
80 --connection server_2
81 DROP TABLE t;
82 --source include/save_master_gtid.inc
83 --connection server_3
84 --source include/sync_with_master_gtid.inc
85
86 --connection server_3
87 stop all slaves;
88 SET default_master_connection = "m1";
89 --source include/wait_for_slave_to_stop.inc
90 SET default_master_connection = "m2";
91 --source include/wait_for_slave_to_stop.inc
92 RESET SLAVE ALL;
93 DROP DATABASE m1_test;
94 DROP DATABASE m2_test;
95
96 --echo # End of replicate_rewrite_db_dynamic.test