Debian Codegraph @

mysql-test/suite/multi_source/skip_counter.test

raw
1 #
2 # Test of sql_slave_skip_counter and rpl_max_size
3 #
4
5 # Create a schema and a table i
6 # on the 1st master
7
8 --source include/not_embedded.inc
9 --let $rpl_server_count= 0
10
11 --connect (master1,127.0.0.1,root,,,$SERVER_MYPORT_1)
12
13 --disable_warnings
14 drop database if exists db;
15 --enable_warnings
16 create database db;
17 create table db.this_will_not_be_replicated (i int) engine=MyISAM;
18 create table db.t1 (i int) engine=MyISAM;
19 create table db.t2 (i int) engine=MyISAM;
20 --save_master_pos
21
22 # Create the same schema and another table
23 # on the 2nd master
24
25 --connect (master2,127.0.0.1,root,,,$SERVER_MYPORT_2)
26
27 --disable_warnings
28 drop database if exists db;
29 --enable_warnings
30 create database db;
31 create table db.t3 (i int) engine=MyISAM;
32
33 --connect (slave,127.0.0.1,root,,,$SERVER_MYPORT_3)
34
35 # Start replication from the first master
36
37 --replace_result $SERVER_MYPORT_1 MYPORT_1
38 eval change master 'master1' to
39 master_port=$SERVER_MYPORT_1,
40 master_host='127.0.0.1',
41 master_user='root', master_ssl_verify_server_cert=0,
42 master_use_gtid=no;
43
44 start slave 'master1';
45 set default_master_connection = 'master1';
46 --source include/wait_for_slave_to_start.inc
47 --sync_with_master 0,'master1'
48
49 # Start replication from the second master
50
51 set default_master_connection = 'master2';
52
53 --replace_result $SERVER_MYPORT_2 MYPORT_2
54 eval change master 'master2' to
55 master_port=$SERVER_MYPORT_2,
56 master_host='127.0.0.1',
57 master_user='root', master_ssl_verify_server_cert=0,
58 master_use_gtid=no;
59
60 # the schema creation will be replicated from the 1st master,
61 # so we want to skip it in the second replication connection
62 # The events we want to skip are:
63 #
64 # The start format statement event
65 # drop database if exists db
66 # create database db
67 # Create table db.t1
68 # - > 4 events in total
69
70 --let $skip_counter_saved = `select @@global.sql_slave_skip_counter`
71 --let $max_relay_log_size_saved= `select @@global.max_relay_log_size`
72 --let $max_binlog_size_saved= `select @@global.max_binlog_size`
73 set global sql_slave_skip_counter = 2;
74 select @@global.sql_slave_skip_counter;
75 select @@session.sql_slave_skip_counter;
76 set session sql_slave_skip_counter = 3;
77 select @@global.sql_slave_skip_counter;
78 select @@session.sql_slave_skip_counter;
79 set global sql_slave_skip_counter= default;
80 select @@global.sql_slave_skip_counter;
81 select @@session.sql_slave_skip_counter;
82 set global sql_slave_skip_counter= 4;
83
84 set default_master_connection = 'master1';
85 select @@session.sql_slave_skip_counter;
86 set default_master_connection = 'qqq';
87 select @@session.sql_slave_skip_counter;
88 set default_master_connection = 'master2';
89 select @@session.sql_slave_skip_counter;
90
91 # Test of setting max_relay_log_size
92 select @@global.max_relay_log_size;
93 set global max_relay_log_size = 1*1024*1024;
94 select @@global.max_relay_log_size;
95 select @@session.max_relay_log_size;
96 set session max_relay_log_size = 3*1024*1024;
97 select @@global.max_relay_log_size;
98 select @@session.max_relay_log_size;
99 set global max_relay_log_size= default;
100 select @@global.max_relay_log_size;
101 select @@session.max_relay_log_size;
102 set global max_relay_log_size= 3*1024*1024;
103 set default_master_connection = 'master1';
104 select @@session.max_relay_log_size;
105 set default_master_connection = 'qqq';
106 select @@session.max_relay_log_size;
107 set default_master_connection = 'master2';
108 select @@session.max_relay_log_size;
109 set global max_binlog_size= 4*1024*1024;
110 select @@global.max_relay_log_size;
111
112 start slave 'master2';
113 --source include/wait_for_slave_to_start.inc
114 set default_master_connection = '';
115
116 --connection master2
117 --save_master_pos
118
119 --connection slave
120
121 --sync_with_master 0,'master2'
122
123 # If the skip_counter worked as expected, we should
124 # get here (replication shouldn't have broken)
125 # and should see both tables here
126 # (drop database which came from master2 shouldn't have been executed
127 # so t1 should still exist)
128
129 show tables in db;
130
131 # Cleanup
132
133 drop database db;
134
135 --eval set global sql_slave_skip_counter = $skip_counter_saved
136 --eval set global max_relay_log_size = $max_relay_log_size_saved
137 --eval set global max_binlog_size = $max_binlog_size_saved
138
139 --source include/reset_master_slave.inc
140 --disconnect slave
141
142 --connection master1
143 drop database db;
144 --source include/reset_master_slave.inc
145 --disconnect master1
146
147 --connection master2
148 drop database db;
149 --source include/reset_master_slave.inc
150 --disconnect master2
151