Debian Codegraph @

mysql-test/suite/rpl/r/rpl_heartbeat_basic.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 call mtr.add_suppression("Replica I/O: The replica I/O thread stops because a fatal error is encountered when it tried to SET @master_binlog_checksum");
7 call mtr.add_suppression("The replica coordinator and worker threads are stopped, possibly leaving data in inconsistent state");
8
9 *** Preparing ***
10 include/sync_slave_sql_with_master.inc
11 include/stop_slave.inc
12 RESET SLAVE;
13 Warnings:
14 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
15 RESET MASTER;
16 SET @restore_replica_net_timeout=@@global.replica_net_timeout;
17 RESET MASTER;
18 SET @restore_replica_net_timeout=@@global.replica_net_timeout;
19 SET @restore_event_scheduler=@@global.event_scheduler;
20
21 *** Default value ***
22 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root';
23 Warnings:
24 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
25 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
26 replica_net_timeout/slave_heartbeat_timeout=2.0000
27 RESET SLAVE;
28 Warnings:
29 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
30 RESET MASTER;
31
32 *** Reset slave affect ***
33 SET @@global.replica_net_timeout=30;
34 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=20, SOURCE_HEARTBEAT_PERIOD=5;
35 Warnings:
36 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
37 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
38 RESET SLAVE;
39 Warnings:
40 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
41 RESET MASTER;
42 select heartbeat_interval from performance_schema.replication_connection_configuration;
43 heartbeat_interval
44 5.000
45
46 *** Default value if replica_net_timeout changed ***
47 SET @@global.replica_net_timeout=50;
48 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=20;
49 Warnings:
50 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
51 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
52 select heartbeat_interval from performance_schema.replication_connection_configuration;
53 heartbeat_interval
54 25.000
55 SET @@global.replica_net_timeout=@restore_replica_net_timeout;
56 RESET SLAVE;
57 Warnings:
58 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
59 RESET MASTER;
60
61 *** Warning if updated replica_net_timeout < slave_heartbeat_timeout ***
62 SET @@global.replica_net_timeout=FLOOR(SLAVE_HEARTBEAT_TIMEOUT)-1;
63 Warnings:
64 Warning 1704 The requested value for the heartbeat period exceeds the value of `replica_net_timeout' seconds. A sensible value for the period should be less than the timeout.
65 SET @@global.replica_net_timeout=@restore_replica_net_timeout;
66 RESET SLAVE;
67 Warnings:
68 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
69 RESET MASTER;
70
71 *** Warning if updated slave_heartbeat_timeout > replica_net_timeout ***
72 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=20, SOURCE_HEARTBEAT_PERIOD=REPLICA_NET_TIMEOUT;
73 Warnings:
74 Warning #### The requested value for the heartbeat period exceeds the value of `replica_net_timeout' seconds. A sensible value for the period should be less than the timeout.
75 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
76 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
77 RESET SLAVE;
78 Warnings:
79 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
80 RESET MASTER;
81
82 *** CHANGE MASTER statement only updates slave_heartbeat_period ***
83 SET @@global.replica_net_timeout=20;
84 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=20, SOURCE_HEARTBEAT_PERIOD=5;
85 Warnings:
86 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
87 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
88 SHOW VARIABLES LIKE 'replica_net_timeout';
89 Variable_name Value
90 replica_net_timeout 20
91 select heartbeat_interval from performance_schema.replication_connection_configuration;
92 heartbeat_interval
93 5.000
94 SET @@global.replica_net_timeout=2*@@global.replica_net_timeout;
95 SHOW VARIABLES LIKE 'replica_net_timeout';
96 Variable_name Value
97 replica_net_timeout 40
98 select heartbeat_interval from performance_schema.replication_connection_configuration;
99 heartbeat_interval
100 5.000
101 SET @@global.replica_net_timeout=@restore_replica_net_timeout;
102 RESET SLAVE;
103 Warnings:
104 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
105 RESET MASTER;
106
107 *** Update replica_net_timeout on master ***
108 SET @@global.replica_net_timeout=500;
109 SET @@global.replica_net_timeout=200;
110 RESET SLAVE;
111 Warnings:
112 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
113 RESET MASTER;
114 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=20;
115 Warnings:
116 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
117 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
118 include/start_slave.inc
119 include/sync_slave_sql_with_master.inc
120 SHOW VARIABLES LIKE 'replica_net_timeout';
121 Variable_name Value
122 replica_net_timeout 200
123 select heartbeat_interval from performance_schema.replication_connection_configuration;
124 heartbeat_interval
125 100.000
126 SET @@global.replica_net_timeout=@restore_replica_net_timeout;
127 Warnings:
128 Warning 1704 The requested value for the heartbeat period exceeds the value of `replica_net_timeout' seconds. A sensible value for the period should be less than the timeout.
129 include/stop_slave.inc
130 RESET SLAVE;
131 Warnings:
132 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
133 RESET MASTER;
134 SET @@global.replica_net_timeout=@restore_replica_net_timeout;
135
136 *** Start/stop slave ***
137 SET @@global.replica_net_timeout=100;
138 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=20, SOURCE_HEARTBEAT_PERIOD=20;
139 Warnings:
140 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
141 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
142 include/start_slave.inc
143 include/sync_slave_sql_with_master.inc
144 select heartbeat_interval from performance_schema.replication_connection_configuration;
145 heartbeat_interval
146 20.000
147 include/stop_slave.inc
148 select heartbeat_interval from performance_schema.replication_connection_configuration;
149 heartbeat_interval
150 20.000
151
152 *** Reload slave ***
153 SET @@global.replica_net_timeout=50;
154 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=20, SOURCE_HEARTBEAT_PERIOD=30;
155 Warnings:
156 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
157 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
158 include/rpl_restart_server.inc [server_number=2]
159 select heartbeat_interval from performance_schema.replication_connection_configuration;
160 heartbeat_interval
161 30.000
162 SET @restore_replica_net_timeout=@@global.replica_net_timeout;
163
164 *** Disable heartbeat ***
165 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=20, SOURCE_HEARTBEAT_PERIOD=0;
166 Warnings:
167 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
168 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
169 select heartbeat_interval from performance_schema.replication_connection_configuration;
170 heartbeat_interval
171 0.000
172 select count_received_heartbeats from performance_schema.replication_connection_status;
173 count_received_heartbeats
174 0
175 include/start_slave.inc
176 include/sync_slave_sql_with_master.inc
177 select heartbeat_interval from performance_schema.replication_connection_configuration;
178 heartbeat_interval
179 0.000
180 select count_received_heartbeats from performance_schema.replication_connection_status;
181 count_received_heartbeats
182 0
183 include/stop_slave.inc
184 select heartbeat_interval from performance_schema.replication_connection_configuration;
185 heartbeat_interval
186 0.000
187 select count_received_heartbeats from performance_schema.replication_connection_status;
188 count_received_heartbeats
189 0
190 RESET SLAVE;
191 Warnings:
192 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
193 RESET MASTER;
194 SELECT SLAVE_HEARTBEAT_TIMEOUT = 0 AS Result;
195 Result
196 1
197
198 *** Min slave_heartbeat_timeout ***
199 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=20, SOURCE_HEARTBEAT_PERIOD=0.001;
200 Warnings:
201 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
202 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
203 select heartbeat_interval from performance_schema.replication_connection_configuration;
204 heartbeat_interval
205 0.001
206 RESET SLAVE;
207 Warnings:
208 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
209 RESET MASTER;
210 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=20, SOURCE_HEARTBEAT_PERIOD=0.0009;
211 Warnings:
212 Warning #### The requested value for the heartbeat period is less than 1 millisecond. The value is reset to 0, meaning that heartbeating will effectively be disabled.
213 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
214 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
215 select heartbeat_interval from performance_schema.replication_connection_configuration;
216 heartbeat_interval
217 0.000
218 RESET SLAVE;
219 Warnings:
220 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
221 RESET MASTER;
222
223 *** Max slave_heartbeat_timeout ***
224 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=20, SOURCE_HEARTBEAT_PERIOD=4294967;
225 Warnings:
226 Warning #### The requested value for the heartbeat period exceeds the value of `replica_net_timeout' seconds. A sensible value for the period should be less than the timeout.
227 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
228 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
229 select heartbeat_interval from performance_schema.replication_connection_configuration;
230 heartbeat_interval
231 4294967.000
232 RESET SLAVE;
233 Warnings:
234 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
235 RESET MASTER;
236 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=20, SOURCE_HEARTBEAT_PERIOD=4294968;
237 ERROR HY000: The requested value for the heartbeat period is either negative or exceeds the maximum allowed (4294967 seconds).
238 RESET SLAVE;
239 Warnings:
240 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
241 RESET MASTER;
242 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=20, SOURCE_HEARTBEAT_PERIOD=8589935;
243 ERROR HY000: The requested value for the heartbeat period is either negative or exceeds the maximum allowed (4294967 seconds).
244 RESET SLAVE;
245 Warnings:
246 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
247 RESET MASTER;
248 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=20, SOURCE_HEARTBEAT_PERIOD=4294967296;
249 ERROR HY000: The requested value for the heartbeat period is either negative or exceeds the maximum allowed (4294967 seconds).
250 RESET SLAVE;
251 Warnings:
252 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
253 RESET MASTER;
254
255 *** Misc incorrect values ***
256 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=20, SOURCE_HEARTBEAT_PERIOD='-1';
257 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''-1'' at line 1
258 RESET SLAVE;
259 Warnings:
260 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
261 RESET MASTER;
262 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=20, SOURCE_HEARTBEAT_PERIOD='123abc';
263 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''123abc'' at line 1
264 RESET SLAVE;
265 Warnings:
266 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
267 RESET MASTER;
268 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=20, SOURCE_HEARTBEAT_PERIOD='';
269 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '''' at line 1
270 RESET SLAVE;
271 Warnings:
272 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
273 RESET MASTER;
274
275 *** Running slave ***
276 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=20, SOURCE_HEARTBEAT_PERIOD= 3.0;
277 Warnings:
278 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
279 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
280 SELECT unix_timestamp() into @time_0;
281 include/start_slave.inc
282 include/sync_slave_sql_with_master.inc
283 SELECT unix_timestamp() into @time_1;
284 Heartbeat event received
285
286 *** Stopped slave ***
287 include/stop_slave.inc
288 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=20, SOURCE_HEARTBEAT_PERIOD= 0.1;
289 Warnings:
290 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
291 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
292 Number of received heartbeat events while slave stopped: 0
293
294 *** Started slave ***
295 include/start_slave.inc
296 Heartbeat event received
297
298 *** Stopped IO thread ***
299 include/stop_slave_io.inc
300 Number of received heartbeat events while io thread stopped: 0
301
302 *** Started IO thread ***
303 START SLAVE IO_THREAD;
304 Warnings:
305 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
306 include/wait_for_slave_io_to_start.inc
307 Heartbeat event received
308
309 *** Stopped SQL thread ***
310 include/stop_slave_sql.inc
311 Heartbeat events are received while sql thread stopped (1 means 'yes'): 1
312
313 *** Started SQL thread ***
314 START SLAVE SQL_THREAD;
315 Warnings:
316 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
317 include/wait_for_slave_sql_to_start.inc
318 Heartbeat event received
319
320 *** Stopped SQL thread by error ***
321 CREATE TABLE t1 (a INT PRIMARY KEY, b VARCHAR(10), c LONGTEXT);
322 include/sync_slave_sql_with_master.inc
323 INSERT INTO t1 VALUES (1, 'on slave', NULL);
324 INSERT INTO t1 VALUES (1, 'on master', NULL);
325 call mtr.add_suppression("Replica SQL.*Duplicate entry .1. for key .t1.PRIMARY.. on query.* Error_code: MY-001062");
326 call mtr.add_suppression("Replica SQL.*Request to stop replica SQL Thread received while applying a group that has non-transactional changes; waiting for completion of the group");
327 Heartbeat events are received while sql thread stopped (1 means 'yes'): 1
328 include/stop_slave_io.inc
329 DELETE FROM t1;
330 include/start_slave.inc
331 include/sync_slave_sql_with_master.inc
332 DROP TABLE t1;
333
334 include/sync_slave_sql_with_master.inc
335 *** Flush logs on slave ***
336 include/rpl_reset.inc
337 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=20, SOURCE_HEARTBEAT_PERIOD=0.5;
338 Warnings:
339 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
340 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
341 include/start_slave.inc
342 include/assert.inc [Should receive at least one heartbeat event while running FLUSH LOGS for 10 seconds]
343
344 *** Compressed protocol ***
345 SET @@global.replica_compressed_protocol=1;
346 include/stop_slave.inc
347 RESET SLAVE;
348 Warnings:
349 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
350 RESET MASTER;
351 SET @@global.replica_compressed_protocol=1;
352 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=20, SOURCE_HEARTBEAT_PERIOD=0.1;
353 Warnings:
354 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
355 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
356 include/start_slave.inc
357 Heartbeat event received
358 SET @@global.replica_compressed_protocol=0;
359 SET @@global.replica_compressed_protocol=0;
360
361 *** Reset master ***
362 STOP SLAVE;
363 Warnings:
364 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
365 RESET SLAVE;
366 Warnings:
367 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
368 RESET MASTER;
369 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=20, SOURCE_HEARTBEAT_PERIOD=0.1;
370 Warnings:
371 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
372 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
373 include/start_slave.inc
374 RESET MASTER;
375 include/sync_slave_sql_with_master.inc
376 Heartbeat events are received after reset of master (1 means 'yes'): 1
377
378 *** Reload master ***
379 STOP SLAVE;
380 Warnings:
381 Warning 1287 'STOP SLAVE' is deprecated and will be removed in a future release. Please use STOP REPLICA instead
382 RESET SLAVE;
383 Warnings:
384 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
385 RESET MASTER;
386 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_CONNECT_RETRY=20, SOURCE_HEARTBEAT_PERIOD=0.1;
387 Warnings:
388 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
389 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
390 include/start_slave.inc
391 Heartbeat event received
392 include/rpl_restart_server.inc [server_number=1]
393 include/wait_for_slave_io_to_start.inc
394 Heartbeat event received
395
396 *** Circular replication ***
397 include/rpl_reset.inc
398 include/stop_slave.inc
399 include/rpl_change_topology.inc [new topology=1->2->1]
400 Warnings:
401 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
402 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
403 CHANGE REPLICATION SOURCE TO SOURCE_HEARTBEAT_PERIOD=1;
404 include/start_slave.inc
405 CREATE TABLE t1 (a INT PRIMARY KEY, b VARCHAR(10));
406 INSERT INTO t1 VALUES(1, 'on master');
407 CHANGE REPLICATION SOURCE TO SOURCE_HEARTBEAT_PERIOD=0.1;
408 include/start_slave.inc
409 INSERT INTO t1 VALUES(2, 'on slave');
410 include/sync_slave_sql_with_master.inc
411 SELECT * FROM t1 ORDER BY a;
412 a b
413 1 on master
414 2 on slave
415 SELECT * FROM t1 ORDER BY a;
416 a b
417 1 on master
418 2 on slave
419 Heartbeat event received on master
420 Heartbeat event received on slave
421 *** Clean up ***
422 DROP TABLE t1;
423 SET @@global.replica_net_timeout=@restore_replica_net_timeout;
424 include/rpl_end.inc