Debian Codegraph @

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

raw
1 # This test checks that the slave rejects events originating
2 # by a server from the list of ignored originators (bug#27808 etc)
3 #
4 # phases of tests:
5 #
6 # 0. master_id new line in show slave status
7 # 1. syntax related:
8 # a. error reporting if options clash;
9 # b. overriding the old IGNORE_SERVER_IDS setup by the following
10 # CHANGE MASTER ... IGNORE_SERVER_IDS= (list);
11 # c. the old setup preserving by CHANGE MASTER w/o IGNORE_SERVER_IDS
12 # d. resetting the ignored server ids with the empty list arg to
13 # IGNORE_SERVER_IDS=()
14 # e. RESET SLAVE preserves the list
15 # 2. run time related:
16 # a. observing no processing events from a master listed in IGNORE_SERVER_IDS
17 # b. nullifying the list and resuming of taking binlog from the very beginning with
18 # executing events this time
19
20 source include/have_binlog_format_mixed.inc;
21 source include/master-slave.inc;
22
23 connection slave;
24
25 # a new line for master_id
26 let $master_id= query_get_value(SHOW SLAVE STATUS, Master_Server_Id, 1);
27 echo master_id: $master_id;
28
29 stop slave;
30 --echo *** --replicate-same-server-id and change master option can clash ***
31 --error ER_SLAVE_IGNORE_SERVER_IDS
32 change master to IGNORE_SERVER_IDS= (2, 1);
33 --echo *** must be empty due to the error ***
34 let $ignore_list= query_get_value(SHOW SLAVE STATUS, Replicate_Ignore_Server_Ids, 1);
35 echo ignore server id list: $ignore_list;
36
37 change master to IGNORE_SERVER_IDS= (10, 100);
38 --echo *** must be 10, 100 ***
39 let $ignore_list= query_get_value(SHOW SLAVE STATUS, Replicate_Ignore_Server_Ids, 1);
40 echo ignore server id list: $ignore_list;
41 --source include/reset_slave.inc
42 --echo *** must be empty due to reset slave ***
43 let $ignore_list= query_get_value(SHOW SLAVE STATUS, Replicate_Ignore_Server_Ids, 1);
44 echo ignore server id list: $ignore_list;
45 change master to IGNORE_SERVER_IDS= (10, 100);
46 --echo *** CHANGE MASTER with IGNORE_SERVER_IDS option overrides (does not increment) the previous setup ***
47 change master to IGNORE_SERVER_IDS= (5, 1, 4, 3, 1);
48 --echo *** must be 1, 3, 4, 5 due to overriding policy ***
49 let $ignore_list= query_get_value(SHOW SLAVE STATUS, Replicate_Ignore_Server_Ids, 1);
50 echo ignore server id list: $ignore_list;
51 --echo *** ignore master (server 1) queries for a while ***
52 start slave;
53
54 connection master;
55
56 #connection slave;
57 sync_slave_with_master;
58 let $slave_relay_pos0= query_get_value(SHOW SLAVE STATUS, Relay_Log_Pos, 1);
59
60 connection master;
61 create table t1 (n int);
62 let $master_binlog_end= query_get_value(SHOW MASTER STATUS, Position, 1);
63
64 connection slave;
65 let $slave_param= Exec_Master_Log_Pos;
66 let $slave_param_value= $master_binlog_end;
67 source include/wait_for_slave_param.inc;
68 --echo *** must be empty as the event is to be filtered out ***
69 show tables;
70 --echo *** allowing events from master ***
71 let $slave_relay_pos1= query_get_value(SHOW SLAVE STATUS, Relay_Log_Pos, 1);
72 #
73 # checking stability of relay log pos
74 #
75 if (`select $slave_relay_pos1 - $slave_relay_pos0`)
76 {
77 --echo Error: relay log position changed: $slave_relay_pos0, $slave_relay_pos1
78 query_vertical show slave status;
79 }
80
81 stop slave;
82 source include/wait_for_slave_to_stop.inc;
83 --source include/reset_slave.inc
84 change master to IGNORE_SERVER_IDS= (10, 100);
85 --echo *** the list must remain (10, 100) after reset slave ***
86 let $ignore_list= query_get_value(SHOW SLAVE STATUS, Replicate_Ignore_Server_Ids, 1);
87
88 change master to IGNORE_SERVER_IDS= ();
89 --echo *** must be empty due to IGNORE_SERVER_IDS empty list ***
90 let $ignore_list= query_get_value(SHOW SLAVE STATUS, Replicate_Ignore_Server_Ids, 1);
91 echo ignore server id list: $ignore_list;
92 --replace_result $MASTER_MYPORT MASTER_PORT
93 eval change master to master_host='127.0.0.1', master_port=$MASTER_MYPORT, master_user='root';
94 start slave;
95
96 connection master;
97
98 #connection slave;
99 sync_slave_with_master;
100 --echo *** must have caught create table ***
101 show tables;
102
103 # cleanup
104 connection master;
105 drop table t1;
106 #connection slave
107 sync_slave_with_master;
108
109 --echo end of the tests
110
111
112
113
114
115
116 --source include/rpl_end.inc