Debian Codegraph @

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

raw
1 -- source include/have_binlog_format_mixed.inc
2 -- source include/master-slave.inc
3
4 # Testing rpl option replicate_rewrite_db
5
6 --echo #
7 --echo # MDEV-15530 Variable replicate_rewrite_db cannot be found
8 --echo # in "show global variables"
9 --echo #
10
11 --echo # Create DBs and verify that slave has to be stopped before setting sys var
12
13 connection slave;
14 --let $rpl_server_id= `select @@session.server_id`
15 select @@session.server_id;
16
17 # These DBs will be rewrited from opt file
18 create database replica_db1;
19 create database y;
20 # This DB will be rewrited from test case
21 create database test_replica;
22 let $rewrite_db_sss= query_get_value(SHOW SLAVE STATUS, Replicate_Rewrite_DB, 1);
23 eval SELECT @@GLOBAL.replicate_rewrite_db, '$rewrite_db_sss' as 'Replicate_Rewrite_DB from SHOW SLAVE STATUS';
24
25 --echo # Create DBs and tables on primary
26 connection master;
27 --enable_warnings
28 create database primary_db1;
29 create database x;
30 use primary_db1;
31 create table my_table (t int);
32 insert into my_table values (2),(4);
33 use x;
34 create table my_table (t int);
35 insert into my_table values (654),(532);
36 --source include/save_master_gtid.inc
37
38 --echo # Check replica
39 --connection slave
40 --source include/sync_with_master_gtid.inc
41 --let $diff_tables=master:primary_db1.my_table,slave:replica_db1.my_table
42 --source include/diff_tables.inc
43 --let $diff_tables=master:x.my_table,slave:y.my_table
44 --source include/diff_tables.inc
45 SELECT @@GLOBAL.replicate_rewrite_db;
46 show tables from replica_db1;
47 select * from replica_db1.my_table;
48 show tables from y;
49 select * from y.my_table;
50
51 --echo # Set replica sys var replicate_rewrite_db
52 connection slave;
53 --error ER_SLAVE_MUST_STOP
54 SET @@GLOBAL.replicate_rewrite_db="test_master->test_replica";
55 source include/stop_slave.inc;
56 SET @save_replicate_rewrite_db = @@GLOBAL.replicate_rewrite_db;
57 SELECT @@GLOBAL.replicate_rewrite_db;
58 SET @@GLOBAL.replicate_rewrite_db="test_master->test_replica";
59 SHOW DATABASES like 'test_replica';
60 source include/start_slave.inc;
61 let $rewrite_db_sss= query_get_value(SHOW SLAVE STATUS, Replicate_Rewrite_DB, 1);
62 eval SELECT @@GLOBAL.replicate_rewrite_db, '$rewrite_db_sss' as 'Replicate_Rewrite_DB from SHOW SLAVE STATUS';
63
64 --echo # Create DB and tables on primary
65 connection master;
66 --enable_warnings
67 create database test_master;
68 use test_master;
69 create table my_table (t int);
70 insert into my_table values (1),(3);
71 --source include/save_master_gtid.inc
72
73 --echo # Ensure that the replica receives all of the primary's events without
74 --echo # error
75 --connection slave
76 --source include/sync_with_master_gtid.inc
77 let $error= query_get_value(SHOW SLAVE STATUS, Last_SQL_Error, 1);
78 --echo Last_SQL_Error = $error
79 let $errno= query_get_value(SHOW SLAVE STATUS, Last_SQL_Errno, 1);
80 --echo Last_SQL_Errno = $errno
81
82 SELECT @@GLOBAL.replicate_rewrite_db;
83 SHOW tables from test_replica;
84 select * from test_replica.my_table;
85
86 # Additional check for tables
87 --let $diff_tables=master:test_master.my_table,slave:test_replica.my_table
88 --source include/diff_tables.inc
89
90 --echo # Update of values on primary for DB not set in replication_rewrite_db
91 --source include/stop_slave.inc
92 --source include/reset_slave.inc
93
94 connection master;
95 use x;
96 insert into my_table values (314);
97 select * from my_table;
98 --source include/save_master_gtid.inc
99
100 connection slave;
101 --source include/start_slave.inc
102 SELECT @@GLOBAL.replicate_rewrite_db;
103 --source include/sync_with_master_gtid.inc
104 # This shouldn't get the new values from x DB on master
105 select * from y.my_table;
106
107 --echo # Dynamic updates to the replication filter should be lost after server restart
108 # Old value
109 connection slave;
110 SELECT @@GLOBAL.replicate_rewrite_db;
111
112 connection master;
113 use x;
114 insert into my_table values (1000);
115 select * from my_table;
116 --source include/save_master_gtid.inc
117
118 connection slave;
119 --source include/stop_slave.inc
120 --source include/reset_slave.inc
121 --let $rpl_server_number= 2
122 --source include/rpl_restart_server.inc
123 --replace_result $MASTER_MYPORT MASTER_MYPORT
124 eval CHANGE MASTER TO MASTER_HOST='127.0.0.1', MASTER_PORT=$MASTER_MYPORT, MASTER_USER='root', MASTER_SSL_VERIFY_SERVER_CERT=0;
125
126 # New value
127 connection slave;
128 --source include/start_slave.inc
129 SELECT @@GLOBAL.replicate_rewrite_db;
130 --source include/sync_with_master_gtid.inc
131 # This should update values with 314 and 1000 from primary
132 select * from y.my_table;
133
134 --echo # Cleanup
135 connection master;
136 drop database test_master;
137 drop database primary_db1;
138 drop database x;
139 --source include/save_master_gtid.inc
140
141
142 --connection slave
143 --source include/sync_with_master_gtid.inc
144 drop database test_replica;
145 drop database replica_db1;
146 drop database y;
147 source include/stop_slave.inc;
148 source include/start_slave.inc;
149
150 --source include/rpl_end.inc
151 # end of 10.11 tests