Debian Codegraph @

mysql-test/suite/multi_source/status_vars.test

raw
1 #
2 # Status variables related to a replication connection
3 #
4
5 --source include/not_embedded.inc
6 --let $rpl_server_count= 0
7
8 --connect (slave,127.0.0.1,root,,,$SERVER_MYPORT_3)
9
10 call mtr.add_suppression("Connection 'master1' already exists");
11
12 # Start replication from the first master
13
14 --replace_result $SERVER_MYPORT_1 MYPORT_1
15 eval change master 'master1' to
16 master_port=$SERVER_MYPORT_1,
17 master_host='127.0.0.1',
18 master_user='root', master_ssl_verify_server_cert=0,
19 master_heartbeat_period = 25;
20
21 start slave 'master1';
22 set default_master_connection = 'master1';
23 --source include/wait_for_slave_to_start.inc
24
25
26 # Set up a proper 'default' connection to master2
27
28 set default_master_connection = '';
29
30 --replace_result $SERVER_MYPORT_2 MYPORT_2
31 eval change master to
32 master_port=$SERVER_MYPORT_2,
33 master_host='127.0.0.1',
34 master_user='root', master_ssl_verify_server_cert=0,
35 master_heartbeat_period=35;
36
37 start slave;
38 --source include/wait_for_slave_to_start.inc
39
40 --echo #
41 --echo # Check how status works for the default connection, anonymous or named
42 --echo #
43
44 --echo # Slave_running and Slave_heartbeat_period should be local for a connection
45 --echo #
46
47 set default_master_connection = '';
48 show status like 'Slave_running';
49 show status like 'Slave_heartbeat_period';
50 stop slave io_thread;
51 --source include/wait_for_slave_io_to_stop.inc
52 show status like 'Slave_running';
53
54 set default_master_connection = 'master1';
55 show status like 'Slave_running';
56 show status like 'Slave_heartbeat_period';
57
58 --echo #
59 --echo # Slave_received_heartbeats should also be local
60 --echo #
61
62 set default_master_connection = '';
63 stop slave sql_thread;
64 --source include/wait_for_slave_sql_to_stop.inc
65 change master to master_heartbeat_period=1;
66 show status like 'Slave_received_heartbeats';
67 start slave;
68 --source include/wait_for_slave_to_start.inc
69
70 --let $status_var = Slave_received_heartbeats
71 --let $status_var_value = 2
72 # The units are tens of seconds
73 --let $status_timeout = 30
74 --source include/wait_for_status_var.inc
75 show status like 'Slave_received_heartbeats';
76 stop slave;
77 --source include/wait_for_slave_to_stop.inc
78
79 set default_master_connection = 'master1';
80 show status like 'Slave_received_heartbeats';
81
82 stop slave;
83 --source include/wait_for_slave_to_stop.inc
84 change master to master_heartbeat_period=2;
85 start slave;
86 --source include/wait_for_slave_to_start.inc
87
88 --let $status_var = Slave_received_heartbeats
89 --let $status_var_value = 1
90 --let $status_timeout = 30
91 --source include/wait_for_status_var.inc
92 show status like 'Slave_received_heartbeats';
93
94
95 --echo #
96 --echo # Slave_open_temp_tables should be global
97 --echo #
98
99 set default_master_connection = '';
100 start slave;
101 --source include/wait_for_slave_to_start.inc
102
103 --connect (master1,127.0.0.1,root,,,$SERVER_MYPORT_1)
104 set binlog_format = statement;
105 create temporary table tmp1 (i int) engine=MyISAM;
106 --save_master_pos
107
108 --connection slave
109 --sync_with_master 0,'master1'
110 show status like 'Slave_open_temp_tables';
111
112 set default_master_connection = 'master1';
113 show status like 'Slave_open_temp_tables';
114
115 --connect (master2,127.0.0.1,root,,,$SERVER_MYPORT_2)
116 set binlog_format = statement;
117 create temporary table tmp1 (i int) engine=MyISAM;
118 --save_master_pos
119
120 --connection slave
121 --sync_with_master 0,''
122 show status like 'Slave_open_temp_tables';
123
124 set default_master_connection = '';
125 show status like 'Slave_open_temp_tables';
126
127
128 # Cleanup
129
130 --source include/reset_master_slave.inc
131 --disconnect slave
132 --connection master1
133 --source include/reset_master_slave.inc
134 --disconnect master1
135 --connection master2
136 --source include/reset_master_slave.inc
137 --disconnect master2
138
139