Debian Codegraph @

mysql-test/suite/group_replication/t/gr_group_members_change.test

raw
1 ################################################################################
2 # Multi master member state change test
3 # This test serves the purpose of evaluating the state changes a member can
4 # undergo.
5 #
6 # The state changes tested are:
7 # 1) Single member group
8 # Member 1: Offline => Online
9 # 2) Member joining into existing group
10 # Member 2: Offline => Recovering => Online
11 # 3) Member leaving (after adding another member to guarantee quorum):
12 # Member 3: Online => Offline
13 # 4) Clean up.
14 ################################################################################
15
16 --source include/have_debug.inc
17 --source include/have_debug_sync.inc
18 --let $group_replication_group_name= 89ab83b0-9f17-11e3-a5e2-0800200c9a66
19 --source include/have_group_replication_plugin.inc
20 --let $rpl_skip_group_replication_start= 1
21 --let $rpl_server_count= 3
22 --source include/group_replication.inc
23
24 SET @debug_save= @@GLOBAL.DEBUG;
25
26 --echo #
27 --echo # 1) Setup a new single member group
28 --echo #
29
30 --connection server1
31 --echo server1
32
33 --echo # Set the debug flag to block recovery
34 SET @@GLOBAL.DEBUG='d,recovery_thread_wait_before_finish';
35
36 --echo # Member should be offline before start
37
38 --let $assert_text= On the new stopped member, the status is OFFLINE
39 --let $assert_cond= [select count(*) from performance_schema.replication_group_members WHERE member_state="OFFLINE"] = 1;
40 --source include/assert.inc
41
42 --source include/start_and_bootstrap_group_replication.inc
43
44 --echo # Member should be online as the member is alone and doesn't need recovery
45
46 --let $group_replication_member_state= ONLINE
47 --source include/gr_wait_for_member_state.inc
48
49 --echo #
50 --echo # 2) A new member enters the existing group
51 --echo #
52
53 # Block the applier on server 1 so view change event wont be written and recovery blocks on server 2
54 SET @@GLOBAL.DEBUG='+d,block_applier_updates';
55
56 --connection server2
57 --echo server2
58
59 --echo # Member should be marked as on recovery on both members
60 --let $group_replication_start_member_state= RECOVERING
61 --source include/start_group_replication.inc
62
63 --let $group_replication_member_id= query_get_value(SELECT @@SERVER_UUID, @@SERVER_UUID, 1)
64
65 --connection server1
66 --echo server1
67
68 --let $group_replication_member_state= RECOVERING
69 --source include/gr_wait_for_member_state.inc
70
71 #Unblock recovery
72 SET DEBUG_SYNC = "now WAIT_FOR applier_read_blocked";
73 SET @@GLOBAL.DEBUG='-d,block_applier_updates';
74 SET DEBUG_SYNC = "now SIGNAL resume_applier_read";
75
76 --connection server2
77 --echo server2
78
79 --echo # Member should be marked as online on both members
80
81 --let $group_replication_member_state= ONLINE
82 --source include/gr_wait_for_member_state.inc
83
84 --connection server1
85 --echo server1
86 SET DEBUG_SYNC= 'RESET';
87
88 --let $group_replication_member_state= ONLINE
89 --source include/gr_wait_for_member_state.inc
90
91 --echo #
92 --echo # 3) A member leaves the existing group
93 --echo #
94
95 --echo # Add a new member to hold quorum
96
97 --connection server3
98 --echo server3
99 --source include/start_group_replication.inc
100
101 --echo # Member should be marked as online
102
103 #reset the member id variable as it was pointing server 2
104 --let $group_replication_member_id=
105 --let $group_replication_member_state= ONLINE
106 --source include/gr_wait_for_member_state.inc
107
108 --source include/stop_group_replication.inc
109
110 --echo # Member should be marked as offline after stop
111
112 --let $group_replication_member_state= OFFLINE
113 --source include/gr_wait_for_member_state.inc
114
115 --echo #
116 --echo # Cleaning up
117 --echo #
118
119 --let $server_count=3
120 while ($server_count)
121 {
122 --connection server$server_count
123 --echo server$server_count
124 SET @@GLOBAL.DEBUG= @debug_save;
125 --dec $server_count
126 }
127
128 --source include/group_replication_end.inc