Debian Codegraph @

mysql-test/suite/group_replication/r/gr_group_members_change.result

raw
1 include/group_replication.inc [rpl_server_count=3]
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 server1]
6 SET @debug_save= @@GLOBAL.DEBUG;
7 #
8 # 1) Setup a new single member group
9 #
10 server1
11 # Set the debug flag to block recovery
12 SET @@GLOBAL.DEBUG='d,recovery_thread_wait_before_finish';
13 # Member should be offline before start
14 include/assert.inc [On the new stopped member, the status is OFFLINE]
15 include/start_and_bootstrap_group_replication.inc
16 # Member should be online as the member is alone and doesn't need recovery
17 include/gr_wait_for_member_state.inc
18 #
19 # 2) A new member enters the existing group
20 #
21 SET @@GLOBAL.DEBUG='+d,block_applier_updates';
22 server2
23 # Member should be marked as on recovery on both members
24 include/start_group_replication.inc
25 server1
26 include/gr_wait_for_member_state.inc
27 SET DEBUG_SYNC = "now WAIT_FOR applier_read_blocked";
28 SET @@GLOBAL.DEBUG='-d,block_applier_updates';
29 SET DEBUG_SYNC = "now SIGNAL resume_applier_read";
30 server2
31 # Member should be marked as online on both members
32 include/gr_wait_for_member_state.inc
33 server1
34 SET DEBUG_SYNC= 'RESET';
35 include/gr_wait_for_member_state.inc
36 #
37 # 3) A member leaves the existing group
38 #
39 # Add a new member to hold quorum
40 server3
41 include/start_group_replication.inc
42 # Member should be marked as online
43 include/gr_wait_for_member_state.inc
44 include/stop_group_replication.inc
45 # Member should be marked as offline after stop
46 include/gr_wait_for_member_state.inc
47 #
48 # Cleaning up
49 #
50 server3
51 SET @@GLOBAL.DEBUG= @debug_save;
52 server2
53 SET @@GLOBAL.DEBUG= @debug_save;
54 server1
55 SET @@GLOBAL.DEBUG= @debug_save;
56 include/group_replication_end.inc