Debian Codegraph @

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

raw
1
2 1. Setup a simple replication topology : source -> replica
3
4 include/master-slave.inc
5 Warnings:
6 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
7 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.
8 [connection master]
9
10 2. Setup heartbeat period to 1 ms
11
12 [connection slave]
13 include/stop_slave.inc
14 CHANGE REPLICATION SOURCE TO SOURCE_HEARTBEAT_PERIOD=0.001;
15 include/start_slave.inc
16 [connection master]
17 CREATE TABLE test.t(a INT);
18
19 3. Execute `mysqlslap` in a loop.
20 Let the source send heartbeat messages between iterations.
21
22 [connection server_1]
23
24 4. Sync the replica
25
26 [connection master]
27 include/sync_slave_sql_with_master.inc
28
29 5. Verify that Dump thread was not restarted between
30 mysqlslap iterations. Dump thread should exit only
31 if network is unstable, e.g. there was an error on 'send' or 'flush'
32
33 include/assert_grep.inc [Binary dump log thread should be started twice]
34
35 6. Cleanup
36
37 [connection slave]
38 include/stop_slave.inc
39 CHANGE REPLICATION SOURCE TO SOURCE_HEARTBEAT_PERIOD=SAVED_HEARTBEAT_PERIOD;
40 include/start_slave.inc
41 [connection master]
42 DROP TABLE test.t;
43 include/rpl_end.inc