Debian Codegraph @

mysql-test/suite/rpl_gtid/r/rpl_semi_sync_observe_commit_only.result

raw
1 # 1. Set-up semi sync replication environment
2 # a) Setup a 2 layered topology with the given topology 1->2
3 include/rpl_init.inc [topology=1->2]
4 Warnings:
5 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
6 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.
7 [connection server_1]
8 SET GLOBAL replication_sender_observe_commit_only = 1;
9 SET GLOBAL replication_optimize_for_static_plugin_config = 1;
10 CALL mtr.add_suppression("Semi-sync source failed on net_flush.*");
11 CALL mtr.add_suppression("Read semi-sync reply magic number error.*");
12 CALL mtr.add_suppression("A message intended for a client cannot be sent there as no client-session is attached.*");
13 CALL mtr.add_suppression("Timeout waiting for reply of binlog.*");
14 include/install_semisync_source.inc
15 [connection server_2]
16 include/install_semisync_replica.inc
17 CALL mtr.add_suppression("The replica coordinator and worker threads are stopped.*");
18 # b) Ensure that replication_sender_observe_commit_only is turned on
19 [connection server_1]
20 # replication_sender_observe_commit_only: 1
21 include/assert.inc [replication_sender_observe_commit_only should be ON (source)]
22 # 2. Prepare a testing environment and execute statements in the background
23 CREATE TABLE t (a int);
24 # 3. Issue the replica restart while the source is running statements
25 [connection server_2]
26 include/rpl_restart_server.inc [server_number=2 gtids=on parameters: --skip_slave_start=0 --rpl_semi_sync_replica_enabled=1]
27 # 4. Sanity check - check whether semi-sync replication was correctly restarted
28 include/check_slave_is_running.inc
29 include/check_slave_no_error.inc
30 include/assert.inc [Semi sync should be enabled on the replica]
31 # 5. Wait for source to finish the execution of statements
32 [connection server_1]
33 # 6. Wait for replica to catch-up with latest changes
34 [connection server_2]
35 include/rpl_sync.inc
36 # 7. Check whether the replica replicated table correctly
37 include/diff_tables.inc [server_1:t, server_2:t]
38 # 8. Clean up
39 [connection server_2]
40 include/uninstall_semisync_replica.inc
41 [connection server_1]
42 SET GLOBAL replication_sender_observe_commit_only = OFF;
43 SET GLOBAL replication_optimize_for_static_plugin_config = OFF;
44 include/uninstall_semisync_source.inc
45 DROP TABLE t;
46 include/rpl_end.inc