Debian Codegraph @

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

raw
1 ################################################################################
2 #
3 # Validate that:
4 # - The Automatic Connection failover feature for Receiver works when
5 # asynchronous replication receiver is a Primary member.
6 # - Whenever there is a running Managed channel receiver who is also the
7 # Primary on a Single-primary group, if the Primary changes, then the new
8 # selected Primary of the receiver group MUST establish asynchronous
9 # replication connection with the sender, provided
10 # mysql_start_failover_channels_if_primary internal member action is
11 # enabled on the receiver group.
12 #
13 # Test:
14 # 0. The test requires 4 servers:
15 # server1: single-primary group A primary
16 # server2: single-primary group A secondary
17 # server3: single-primary group B primary
18 # server4: single-primary group B secondary
19 # 1. Create a replication channel to replicate from server4 to
20 # to server1 on both server1 and 2.
21 # 2. Deploy a 2 members receiver group in single primary mode.
22 # 3. Deploy a 2 members sender group in single primary mode.
23 # 4. Add replication connection details of managed channel ch1
24 # to replication_asynchronous_connection_failover_managed table
25 # through asynchronous_connection_failover_add_managed() UDF.
26 # 5. Verify replication_asynchronous_connection_failover on
27 # server1 has two rows and member action configuration version
28 # value for replication_asynchronous_connection_failover
29 # and for replication_asynchronous_connection_failover_managed.
30 # 6. Verify replication_asynchronous_connection_failover on
31 # server2 has two rows and member action configuration version
32 # value for replication_asynchronous_connection_failover
33 # and for replication_asynchronous_connection_failover_managed.
34 # 7. Stop group replication on existing primary (server1), the new
35 # primary will establish asynchronous replication channel (ch1)
36 # connection with sender which is server4.
37 # 8. Delete replication connection details for managed channel ch1
38 # from replication_asynchronous_connection_failover_managed
39 # and replication_asynchronous_connection_failover table
40 # through asynchronous_connection_failover_delete_managed() UDF.
41 # 9. Verify replication_asynchronous_connection_failover on
42 # server2 is empty and member action configuration version
43 # value for replication_asynchronous_connection_failover
44 # and for replication_asynchronous_connection_failover_managed.
45 # 10. Verify replication_asynchronous_connection_failover on
46 # server1 is empty and member action configuration version
47 # value for replication_asynchronous_connection_failover
48 # and for replication_asynchronous_connection_failover_managed.
49 # 11. Clean up.
50 --source include/big_test.inc
51 --source include/have_group_replication_plugin.inc
52 --let $rpl_skip_group_replication_start= 1
53 --let $rpl_server_count= 4
54 --source include/group_replication.inc
55
56 --let $group_A= `SELECT UUID()`
57 --let $group_B= `SELECT UUID()`
58
59 # Use the appropriate XCom port, that does depend on
60 # `group_replication_communication_stack`.
61 --let $have_xcom_stack= `SELECT @@group_replication_communication_stack LIKE 'XCOM'`
62 --let $group_a_group_seeds= "localhost:$SERVER_GR_PORT_1,localhost:$SERVER_GR_PORT_2"
63 --let $group_b_group_seeds= "localhost:$SERVER_GR_PORT_3,localhost:$SERVER_GR_PORT_4"
64 if (!$have_xcom_stack) {
65 --let $group_a_group_seeds= "localhost:$SERVER_MYPORT_1,localhost:$SERVER_MYPORT_2"
66 --let $group_b_group_seeds= "localhost:$SERVER_MYPORT_3,localhost:$SERVER_MYPORT_4"
67 }
68
69 --echo
70 --echo # 1. Create a replication channel to replicate from server4 to
71 --echo # to server1 on both server1 and 2.
72 --echo
73 --replace_result $SERVER_MYPORT_4 SERVER_4_PORT
74 --eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_USER='root', SOURCE_AUTO_POSITION=1, SOURCE_PORT=$SERVER_MYPORT_4, SOURCE_CONNECT_RETRY=1, SOURCE_RETRY_COUNT=1, SOURCE_CONNECTION_AUTO_FAILOVER=1 FOR CHANNEL 'ch1'
75
76
77 --let $rpl_connection_name= server2
78 --source include/rpl_connection.inc
79 --replace_result $SERVER_MYPORT_4 SERVER_4_PORT
80 --eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_USER='root', SOURCE_AUTO_POSITION=1, SOURCE_PORT=$SERVER_MYPORT_4, SOURCE_CONNECT_RETRY=1, SOURCE_RETRY_COUNT=1, SOURCE_CONNECTION_AUTO_FAILOVER=1 FOR CHANNEL 'ch1'
81
82
83 --echo
84 --echo # 2. Deploy a 2 members receiver group in single primary mode.
85 --echo
86 --let $rpl_connection_name= server1
87 --source include/rpl_connection.inc
88 --let $group_replication_group_name = $group_A
89 --disable_query_log
90 --eval SET GLOBAL group_replication_group_seeds= $group_a_group_seeds
91 --enable_query_log
92 --source include/start_and_bootstrap_group_replication.inc
93
94 --let $rpl_channel_name='ch1'
95 --source include/wait_for_slave_to_start.inc
96
97 --let $assert_text= Verify replica_monitor thread is running
98 --let $assert_cond= "[select count(*) FROM performance_schema.threads where NAME=\"thread/sql/replica_monitor\"]" = 1;
99 --source include/assert.inc
100
101 --let $rpl_connection_name= server2
102 --source include/rpl_connection.inc
103 --let $group_replication_group_name = $group_A
104 --disable_query_log
105 --eval SET GLOBAL group_replication_group_seeds= $group_a_group_seeds
106 --enable_query_log
107 --source include/start_group_replication.inc
108
109
110 --echo #
111 --echo # 3. Deploy a 2 members sender group in single primary mode.
112 --echo #
113 --let $rpl_connection_name= server3
114 --source include/rpl_connection.inc
115 --let $group_replication_group_name = $group_B
116 --disable_query_log
117 --eval SET GLOBAL group_replication_group_seeds= $group_b_group_seeds
118 --enable_query_log
119 --source include/start_and_bootstrap_group_replication.inc
120
121
122 --let $rpl_connection_name= server4
123 --source include/rpl_connection.inc
124 --let $group_replication_group_name = $group_B
125 --disable_query_log
126 --eval SET GLOBAL group_replication_group_seeds= $group_b_group_seeds
127 --enable_query_log
128 --source include/start_group_replication.inc
129
130
131
132 --echo
133 --echo # 4. Add replication connection details of managed channel ch1
134 --echo # to replication_asynchronous_connection_failover_managed table
135 --echo # through asynchronous_connection_failover_add_managed() UDF.
136 --echo
137 --let $rpl_connection_name= server1
138 --source include/rpl_connection.inc
139 --replace_result $SERVER_MYPORT_4 SERVER_MYPORT_4 $group_B GROUP_NAME_SERVER2
140 --eval SELECT asynchronous_connection_failover_add_managed('ch1', 'GroupReplication', "$group_B",'127.0.0.1', $SERVER_MYPORT_4, '', 80, 60)
141
142
143 --echo
144 --echo # 5. Verify replication_asynchronous_connection_failover on
145 --echo # server1 has two rows and member action configuration version
146 --echo # value for replication_asynchronous_connection_failover
147 --echo # and for replication_asynchronous_connection_failover_managed.
148 --echo
149 --let $wait_condition= SELECT COUNT(*)=2 FROM performance_schema.replication_asynchronous_connection_failover
150 --source include/wait_condition.inc
151
152 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_asynchronous_connection_failover_managed
153 --source include/wait_condition.inc
154
155 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_group_configuration_version where name='replication_asynchronous_connection_failover' and version>=2
156 --source include/wait_condition.inc
157 --let $failover_version_step5= query_get_value(SELECT VERSION FROM performance_schema.replication_group_configuration_version where name='replication_asynchronous_connection_failover', VERSION, 1)
158
159 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_group_configuration_version where name='replication_asynchronous_connection_failover_managed' and version=1
160 --source include/wait_condition.inc
161
162 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_connection_configuration where CHANNEL_NAME='ch1' and HOST='127.0.0.1' and PORT=$SERVER_MYPORT_3
163 --source include/wait_condition.inc
164
165 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_connection_status where CHANNEL_NAME='ch1' and SERVICE_STATE='ON'
166 --source include/wait_condition.inc
167
168 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_applier_status where CHANNEL_NAME='ch1' and SERVICE_STATE='ON'
169 --source include/wait_condition.inc
170
171
172 --echo
173 --echo # 6. Verify replication_asynchronous_connection_failover on
174 --echo # server2 has two rows and member action configuration version
175 --echo # value for replication_asynchronous_connection_failover
176 --echo # and for replication_asynchronous_connection_failover_managed.
177 --echo
178 --let $rpl_connection_name= server2
179 --source include/rpl_connection.inc
180
181 --let $wait_condition= SELECT COUNT(*)=2 FROM performance_schema.replication_asynchronous_connection_failover
182 --source include/wait_condition.inc
183
184 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_asynchronous_connection_failover_managed
185 --source include/wait_condition.inc
186
187 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_group_configuration_version where name='replication_asynchronous_connection_failover' and version>=$failover_version_step5
188 --source include/wait_condition.inc
189
190 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_group_configuration_version where name='replication_asynchronous_connection_failover_managed' and version=1
191 --source include/wait_condition.inc
192
193
194 --echo
195 --echo # 7. Stop group replication on existing primary (server1), and change
196 --echo # primary to server2. The asynchronous replication channel (ch1)
197 --echo # connection will be started without any error.
198 --echo
199 --let $server2_uuid= `SELECT @@server_uuid`
200
201 --let $rpl_connection_name= server1
202 --source include/rpl_connection.inc
203
204 --let $rpl_channel_name='ch1'
205 --source include/stop_slave.inc
206
207 --let $rpl_connection_name= server2
208 --source include/rpl_connection.inc
209
210 --replace_result $server2_uuid SERVER2_UUID
211 --eval SELECT group_replication_set_as_primary("$server2_uuid")
212
213 --let $group_replication_expected_uuid= $server2_uuid
214 --source include/gr_wait_primary_member_uuid.inc
215
216 --let $wait_condition=SELECT COUNT(*)=2 FROM performance_schema.replication_group_members where MEMBER_STATE="ONLINE"
217 --source include/wait_condition.inc
218
219 --let $rpl_channel_name='ch1'
220 --source include/wait_for_slave_to_start.inc
221
222 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_connection_configuration where CHANNEL_NAME='ch1' and HOST='127.0.0.1' and PORT=$SERVER_MYPORT_3
223 --source include/wait_condition.inc
224
225 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_connection_status where CHANNEL_NAME='ch1' and SERVICE_STATE='ON'
226 --source include/wait_condition.inc
227
228 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_applier_status where CHANNEL_NAME='ch1' and SERVICE_STATE='ON'
229 --source include/wait_condition.inc
230
231 --let $assert_text= Verify replica_monitor thread is running
232 --let $assert_cond= "[select count(*) FROM performance_schema.threads where NAME=\"thread/sql/replica_monitor\"]" = 1;
233 --source include/assert.inc
234
235
236 --echo
237 --echo # 8. Delete replication connection details for managed channel ch1
238 --echo # from replication_asynchronous_connection_failover_managed
239 --echo # and replication_asynchronous_connection_failover table
240 --echo # through asynchronous_connection_failover_delete_managed() UDF.
241 --echo
242 --let $rpl_connection_name= server2
243 --source include/rpl_connection.inc
244
245 --replace_result $group_B GROUP_NAME_SERVER2
246 --eval SELECT asynchronous_connection_failover_delete_managed('ch1', '$group_B')
247
248
249 --echo
250 --echo # 9. Verify replication_asynchronous_connection_failover on
251 --echo # server2 is empty and member action configuration version
252 --echo # value for replication_asynchronous_connection_failover
253 --echo # and for replication_asynchronous_connection_failover_managed.
254 --echo
255 --let $rpl_connection_name= server2
256 --source include/rpl_connection.inc
257
258 --let $wait_condition= SELECT COUNT(*)=0 FROM performance_schema.replication_asynchronous_connection_failover
259 --source include/wait_condition.inc
260
261 --let $wait_condition= SELECT COUNT(*)=0 FROM performance_schema.replication_asynchronous_connection_failover_managed
262 --source include/wait_condition.inc
263
264 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_group_configuration_version where name='replication_asynchronous_connection_failover' and version>=3
265 --source include/wait_condition.inc
266 --let $failover_version_step9= query_get_value(SELECT VERSION FROM performance_schema.replication_group_configuration_version where name='replication_asynchronous_connection_failover', VERSION, 1)
267
268 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_connection_configuration where CHANNEL_NAME='ch1' and HOST='127.0.0.1' and PORT=$SERVER_MYPORT_3
269 --source include/wait_condition.inc
270
271 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_connection_status where CHANNEL_NAME='ch1' and SERVICE_STATE='ON'
272 --source include/wait_condition.inc
273
274 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_applier_status where CHANNEL_NAME='ch1' and SERVICE_STATE='ON'
275 --source include/wait_condition.inc
276
277
278 --echo
279 --echo # 10. Verify replication_asynchronous_connection_failover on
280 --echo # server1 is empty and member action configuration version
281 --echo # value for replication_asynchronous_connection_failover
282 --echo # and for replication_asynchronous_connection_failover_managed.
283 --echo
284 --let $rpl_connection_name= server1
285 --source include/rpl_connection.inc
286
287 --let $wait_condition= SELECT COUNT(*)=0 FROM performance_schema.replication_asynchronous_connection_failover
288 --source include/wait_condition.inc
289
290 --let $wait_condition= SELECT COUNT(*)=0 FROM performance_schema.replication_asynchronous_connection_failover_managed
291 --source include/wait_condition.inc
292
293 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_group_configuration_version where name='replication_asynchronous_connection_failover' and version>=$failover_version_step9
294 --source include/wait_condition.inc
295
296 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_connection_status where CHANNEL_NAME='ch1' and SERVICE_STATE='OFF'
297 --source include/wait_condition.inc
298
299 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_applier_status where CHANNEL_NAME='ch1' and SERVICE_STATE='OFF'
300 --source include/wait_condition.inc
301
302
303
304 --echo #
305 --echo # 11. Clean up.
306 --echo #
307 --let $rpl_connection_name= server1
308 --source include/rpl_connection.inc
309
310 --let $rpl_channel_name='ch1'
311 --let $rpl_reset_slave_all= 1
312 --let $rpl_multi_source= 1
313 --source include/rpl_reset_slave.inc
314 --let $rpl_channel_name=
315 --let $rpl_reset_slave_all=
316 --let $rpl_multi_source=
317
318 --let $rpl_connection_name= server2
319 --source include/rpl_connection.inc
320
321 --let $rpl_channel_name='ch1'
322 --source include/stop_slave.inc
323
324 --let $rpl_reset_slave_all= 1
325 --let $rpl_multi_source= 1
326 --source include/rpl_reset_slave.inc
327 --let $rpl_channel_name=
328 --let $rpl_reset_slave_all=
329 --let $rpl_multi_source=
330
331 --let $rpl_connection_name= server4
332 --source include/rpl_connection.inc
333 --source include/stop_group_replication.inc
334
335 --let $rpl_connection_name= server3
336 --source include/rpl_connection.inc
337 --source include/stop_group_replication.inc
338
339 --let $rpl_connection_name= server2
340 --source include/rpl_connection.inc
341 --source include/stop_group_replication.inc
342
343 --let $rpl_connection_name= server1
344 --source include/rpl_connection.inc
345 --source include/stop_group_replication.inc
346
347 --source include/group_replication_end.inc