Debian Codegraph @

mysql-test/suite/multi_source/skip_counter.result

raw
1 connect master1,127.0.0.1,root,,,$SERVER_MYPORT_1;
2 drop database if exists db;
3 create database db;
4 create table db.this_will_not_be_replicated (i int) engine=MyISAM;
5 create table db.t1 (i int) engine=MyISAM;
6 create table db.t2 (i int) engine=MyISAM;
7 connect master2,127.0.0.1,root,,,$SERVER_MYPORT_2;
8 drop database if exists db;
9 create database db;
10 create table db.t3 (i int) engine=MyISAM;
11 connect slave,127.0.0.1,root,,,$SERVER_MYPORT_3;
12 change master 'master1' to
13 master_port=MYPORT_1,
14 master_host='127.0.0.1',
15 master_user='root', master_ssl_verify_server_cert=0,
16 master_use_gtid=no;
17 start slave 'master1';
18 set default_master_connection = 'master1';
19 include/wait_for_slave_to_start.inc
20 set default_master_connection = 'master2';
21 change master 'master2' to
22 master_port=MYPORT_2,
23 master_host='127.0.0.1',
24 master_user='root', master_ssl_verify_server_cert=0,
25 master_use_gtid=no;
26 set global sql_slave_skip_counter = 2;
27 select @@global.sql_slave_skip_counter;
28 @@global.sql_slave_skip_counter
29 2
30 select @@session.sql_slave_skip_counter;
31 @@session.sql_slave_skip_counter
32 2
33 set session sql_slave_skip_counter = 3;
34 select @@global.sql_slave_skip_counter;
35 @@global.sql_slave_skip_counter
36 3
37 select @@session.sql_slave_skip_counter;
38 @@session.sql_slave_skip_counter
39 3
40 set global sql_slave_skip_counter= default;
41 select @@global.sql_slave_skip_counter;
42 @@global.sql_slave_skip_counter
43 0
44 select @@session.sql_slave_skip_counter;
45 @@session.sql_slave_skip_counter
46 0
47 set global sql_slave_skip_counter= 4;
48 set default_master_connection = 'master1';
49 select @@session.sql_slave_skip_counter;
50 @@session.sql_slave_skip_counter
51 0
52 set default_master_connection = 'qqq';
53 select @@session.sql_slave_skip_counter;
54 @@session.sql_slave_skip_counter
55 0
56 Warnings:
57 Warning 1617 There is no master connection 'qqq'
58 set default_master_connection = 'master2';
59 select @@session.sql_slave_skip_counter;
60 @@session.sql_slave_skip_counter
61 4
62 select @@global.max_relay_log_size;
63 @@global.max_relay_log_size
64 1073741824
65 set global max_relay_log_size = 1*1024*1024;
66 select @@global.max_relay_log_size;
67 @@global.max_relay_log_size
68 1048576
69 select @@session.max_relay_log_size;
70 @@session.max_relay_log_size
71 1048576
72 set session max_relay_log_size = 3*1024*1024;
73 select @@global.max_relay_log_size;
74 @@global.max_relay_log_size
75 3145728
76 select @@session.max_relay_log_size;
77 @@session.max_relay_log_size
78 3145728
79 set global max_relay_log_size= default;
80 select @@global.max_relay_log_size;
81 @@global.max_relay_log_size
82 1073741824
83 select @@session.max_relay_log_size;
84 @@session.max_relay_log_size
85 1073741824
86 set global max_relay_log_size= 3*1024*1024;
87 set default_master_connection = 'master1';
88 select @@session.max_relay_log_size;
89 @@session.max_relay_log_size
90 1073741824
91 set default_master_connection = 'qqq';
92 select @@session.max_relay_log_size;
93 @@session.max_relay_log_size
94 0
95 Warnings:
96 Warning 1617 There is no master connection 'qqq'
97 set default_master_connection = 'master2';
98 select @@session.max_relay_log_size;
99 @@session.max_relay_log_size
100 3145728
101 set global max_binlog_size= 4*1024*1024;
102 select @@global.max_relay_log_size;
103 @@global.max_relay_log_size
104 3145728
105 start slave 'master2';
106 include/wait_for_slave_to_start.inc
107 set default_master_connection = '';
108 connection master2;
109 connection slave;
110 show tables in db;
111 Tables_in_db
112 t1
113 t2
114 t3
115 this_will_not_be_replicated
116 drop database db;
117 set global sql_slave_skip_counter = 0;
118 set global max_relay_log_size = 1073741824;
119 set global max_binlog_size = 1073741824;
120 include/reset_master_slave.inc
121 disconnect slave;
122 connection master1;
123 drop database db;
124 include/reset_master_slave.inc
125 disconnect master1;
126 connection master2;
127 drop database db;
128 include/reset_master_slave.inc
129 disconnect master2;