Debian Codegraph @

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

raw
1 ################################################################################
2 #
3 # Validate that receiver group members do receive changes to
4 # replication_asynchronous_connection_failover_managed
5 # and replication_asynchronous_connection_failover table using
6 # asynchronous_connection_failover_add_managed() and
7 # asynchronous_connection_failover_delete_managed() UDFs.
8 #
9 # Test:
10 # 0. The test requires 5 servers:
11 # server1: group1 primary (async channel to server3)
12 # server2: group1 secondary
13 # server3: group2 primary
14 # server4: group2 secondary
15 # server5: group2 secondary
16 # 1. Deploy a 2 members receiver group in single primary mode.
17 # 2. Deploy a 2 members sender group in single primary mode.
18 # The third member of the group i.e. server5 will be added later
19 # to verify changes are getting synced to receiver group members.
20 # 3. Create a replication channel to replicate from server3 to
21 # server1.
22 # 4. Add replication connection details of managed channel ch1
23 # to replication_asynchronous_connection_failover_managed table
24 # through asynchronous_connection_failover_add_managed() UDF.
25 # 5. Start replica for channel ch1.
26 # 6. 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 # 7. 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 # 8. Add another member i.e. server5 to sender group.
35 # 9. Verify replication_asynchronous_connection_failover on
36 # server1 has three rows and member action configuration version
37 # value for replication_asynchronous_connection_failover
38 # and for replication_asynchronous_connection_failover_managed.
39 # 10. Verify replication_asynchronous_connection_failover on
40 # server2 has three rows and member action configuration version
41 # value for replication_asynchronous_connection_failover
42 # and for replication_asynchronous_connection_failover_managed.
43 # 11. Delete replication connection details for managed channel ch1
44 # from replication_asynchronous_connection_failover_managed
45 # and replication_asynchronous_connection_failover table
46 # through asynchronous_connection_failover_delete_managed() UDF.
47 # 12. Verify replication_asynchronous_connection_failover on
48 # server1 is empty and member action configuration version
49 # value for replication_asynchronous_connection_failover
50 # and for replication_asynchronous_connection_failover_managed.
51 # 13. Verify replication_asynchronous_connection_failover on
52 # server2 is empty and member action configuration version
53 # value for replication_asynchronous_connection_failover
54 # and for replication_asynchronous_connection_failover_managed.
55 # 14. Clean up.
56 --source include/big_test.inc
57 --source include/have_group_replication_plugin.inc
58 --let $rpl_skip_group_replication_start= 1
59 --let $rpl_server_count= 5
60 --source include/group_replication.inc
61
62 # Get address and UUID of all servers
63 --let $local_address_server1= `SELECT @@GLOBAL.group_replication_local_address`
64
65 --let $rpl_connection_name= server2
66 --source include/rpl_connection.inc
67 --let $local_address_server2= `SELECT @@GLOBAL.group_replication_local_address`
68
69 --let $rpl_connection_name= server3
70 --source include/rpl_connection.inc
71 --let $local_address_server3= `SELECT @@GLOBAL.group_replication_local_address`
72
73 --let $rpl_connection_name= server4
74 --source include/rpl_connection.inc
75 --let $local_address_server4= `SELECT @@GLOBAL.group_replication_local_address`
76
77 --let $rpl_connection_name= server5
78 --source include/rpl_connection.inc
79 --let $local_address_server5= `SELECT @@GLOBAL.group_replication_local_address`
80
81 --let $group_a= `SELECT UUID()`
82 --let $group_b= `SELECT UUID()`
83
84
85 --echo #
86 --echo # 1. Deploy a 3 members receiver group in single primary mode.
87 --echo #
88 --let $rpl_connection_name= server1
89 --source include/rpl_connection.inc
90 --let $group_replication_group_name = $group_a
91 --replace_result $local_address_server1 LOCAL_ADDRESS_SERVER1 $local_address_server2 LOCAL_ADDRESS_SERVER2
92 --eval SET GLOBAL GROUP_REPLICATION_GROUP_SEEDS= "$local_address_server1, $local_address_server2"
93 --source include/start_and_bootstrap_group_replication.inc
94
95
96 --let $rpl_connection_name= server2
97 --source include/rpl_connection.inc
98
99 # The failover channel must be created on all group members.
100 --replace_result $SERVER_MYPORT_4 SERVER_4_PORT
101 --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'
102
103 --let $group_replication_group_name = $group_a
104 --replace_result $local_address_server1 LOCAL_ADDRESS_SERVER1 $local_address_server2 LOCAL_ADDRESS_SERVER2
105 --eval SET GLOBAL GROUP_REPLICATION_GROUP_SEEDS= "$local_address_server1, $local_address_server2"
106 --source include/start_group_replication.inc
107
108
109 --echo #
110 --echo # 2. Deploy a 2 members sender group in single primary mode.
111 --echo # The third member of the group i.e. server5 will be added later
112 --echo # to verify changes are getting synced to receiver group members.
113 --echo #
114 --let $rpl_connection_name= server3
115 --source include/rpl_connection.inc
116 --let $group_replication_group_name = $group_b
117 --replace_result $local_address_server3 LOCAL_ADDRESS_SERVER3 $local_address_server4 LOCAL_ADDRESS_SERVER4 $local_address_server5 LOCAL_ADDRESS_SERVER5
118 --eval SET GLOBAL GROUP_REPLICATION_GROUP_SEEDS= "$local_address_server3, $local_address_server4, $local_address_server5"
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 --replace_result $local_address_server3 LOCAL_ADDRESS_SERVER3 $local_address_server4 LOCAL_ADDRESS_SERVER4 $local_address_server5 LOCAL_ADDRESS_SERVER5
126 --eval SET GLOBAL GROUP_REPLICATION_GROUP_SEEDS= "$local_address_server3, $local_address_server4, $local_address_server5"
127 --source include/start_group_replication.inc
128
129
130 --echo
131 --echo # 3. Create a replication channel to replicate from server3 to
132 --echo # server1.
133 --echo
134 --let $rpl_connection_name= server1
135 --source include/rpl_connection.inc
136 --replace_result $SERVER_MYPORT_4 SERVER_4_PORT
137 --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'
138
139
140 --echo
141 --echo # 4. Add replication connection details of managed channel ch1
142 --echo # to replication_asynchronous_connection_failover_managed table
143 --echo # through asynchronous_connection_failover_add_managed() UDF.
144 --echo
145 --replace_result $SERVER_MYPORT_4 SERVER_MYPORT_4 $group_b GROUP_B
146 --eval SELECT asynchronous_connection_failover_add_managed('ch1', 'GroupReplication', "$group_b",'127.0.0.1', $SERVER_MYPORT_4, '', 80, 60)
147
148
149 --echo
150 --echo # 5. Start replica for channel ch1.
151 --echo
152 --let $rpl_channel_name='ch1'
153 --source include/start_slave.inc
154 --let $rpl_channel_name=
155
156
157 --echo
158 --echo # 6. Verify replication_asynchronous_connection_failover on
159 --echo # server1 has two rows and member action configuration version
160 --echo # value for replication_asynchronous_connection_failover
161 --echo # and for replication_asynchronous_connection_failover_managed.
162 --echo
163 --let $wait_condition= SELECT COUNT(*)=2 FROM performance_schema.replication_asynchronous_connection_failover
164 --source include/wait_condition.inc
165
166 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_asynchronous_connection_failover_managed
167 --source include/wait_condition.inc
168
169 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_group_configuration_version where name='replication_asynchronous_connection_failover' and version>=2
170 --source include/wait_condition.inc
171 --let $failover_version_step6= query_get_value(SELECT VERSION FROM performance_schema.replication_group_configuration_version where name='replication_asynchronous_connection_failover', VERSION, 1)
172
173 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_group_configuration_version where name='replication_asynchronous_connection_failover_managed' and version=1
174 --source include/wait_condition.inc
175
176
177 --echo
178 --echo # 7. Verify replication_asynchronous_connection_failover on
179 --echo # server2 has two rows and member action configuration version
180 --echo # value for replication_asynchronous_connection_failover
181 --echo # and for replication_asynchronous_connection_failover_managed.
182 --echo
183 --let $rpl_connection_name= server2
184 --source include/rpl_connection.inc
185 --let $wait_condition= SELECT COUNT(*)=2 FROM performance_schema.replication_asynchronous_connection_failover
186 --source include/wait_condition.inc
187
188 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_asynchronous_connection_failover_managed
189 --source include/wait_condition.inc
190
191 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_group_configuration_version where name='replication_asynchronous_connection_failover' and version>=$failover_version_step6
192 --source include/wait_condition.inc
193
194 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_group_configuration_version where name='replication_asynchronous_connection_failover_managed' and version=1
195 --source include/wait_condition.inc
196
197
198 --echo #
199 --echo # 8. Add another member i.e. server5 to sender group.
200 --echo #
201 --let $rpl_connection_name= server5
202 --source include/rpl_connection.inc
203 --replace_result $local_address_server3 LOCAL_ADDRESS_SERVER3 $local_address_server4 LOCAL_ADDRESS_SERVER4 $local_address_server5 LOCAL_ADDRESS_SERVER5
204 --eval SET GLOBAL GROUP_REPLICATION_GROUP_SEEDS= "$local_address_server3, $local_address_server4, $local_address_server5"
205 --source include/start_group_replication.inc
206
207 --let $assert_text= There are three members in the group.
208 --let $assert_cond= "[SELECT COUNT(*) from performance_schema.replication_group_members WHERE MEMBER_STATE=\"ONLINE\"]" = 3
209 --source include/assert.inc
210
211
212 --echo
213 --echo # 9. Verify replication_asynchronous_connection_failover on
214 --echo # server1 has three rows and member action configuration version
215 --echo # value for replication_asynchronous_connection_failover
216 --echo # and for replication_asynchronous_connection_failover_managed.
217 --echo
218 --let $rpl_connection_name= server1
219 --source include/rpl_connection.inc
220
221 --let $wait_condition=SELECT COUNT(*)=3 FROM performance_schema.replication_asynchronous_connection_failover
222 --source include/wait_condition.inc
223
224 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_asynchronous_connection_failover_managed
225 --source include/wait_condition.inc
226
227 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_group_configuration_version where name='replication_asynchronous_connection_failover' and version>=3
228 --source include/wait_condition.inc
229 --let $failover_version_step9= query_get_value(SELECT VERSION FROM performance_schema.replication_group_configuration_version where name='replication_asynchronous_connection_failover', VERSION, 1)
230
231 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_group_configuration_version where name='replication_asynchronous_connection_failover_managed' and version=1
232 --source include/wait_condition.inc
233
234
235 --echo
236 --echo # 10. Verify replication_asynchronous_connection_failover on
237 --echo # server2 has three rows and member action configuration version
238 --echo # value for replication_asynchronous_connection_failover
239 --echo # and for replication_asynchronous_connection_failover_managed.
240 --echo
241 --let $rpl_connection_name= server2
242 --source include/rpl_connection.inc
243
244 --let $wait_condition=SELECT COUNT(*)=3 FROM performance_schema.replication_asynchronous_connection_failover
245 --source include/wait_condition.inc
246
247 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_asynchronous_connection_failover_managed
248 --source include/wait_condition.inc
249
250 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_group_configuration_version where name='replication_asynchronous_connection_failover' and version>=$failover_version_step9
251 --source include/wait_condition.inc
252
253 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_group_configuration_version where name='replication_asynchronous_connection_failover_managed' and version=1
254 --source include/wait_condition.inc
255
256
257 --echo
258 --echo # 11. Delete replication connection details for managed channel ch1
259 --echo # from replication_asynchronous_connection_failover_managed
260 --echo # and replication_asynchronous_connection_failover table
261 --echo # through asynchronous_connection_failover_delete_managed() UDF.
262 --echo
263 --let $rpl_connection_name= server1
264 --source include/rpl_connection.inc
265
266 --replace_result $group_b GROUP_B
267 --eval SELECT asynchronous_connection_failover_delete_managed('ch1', '$group_b')
268
269
270 --echo
271 --echo # 12. Verify replication_asynchronous_connection_failover on
272 --echo # server1 is empty and member action configuration version
273 --echo # value for replication_asynchronous_connection_failover
274 --echo # and for replication_asynchronous_connection_failover_managed.
275 --echo
276 --let $wait_condition= SELECT COUNT(*)=0 FROM performance_schema.replication_asynchronous_connection_failover
277 --source include/wait_condition.inc
278
279 --let $wait_condition= SELECT COUNT(*)=0 FROM performance_schema.replication_asynchronous_connection_failover_managed
280 --source include/wait_condition.inc
281
282 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_group_configuration_version where name='replication_asynchronous_connection_failover' and version>=4
283 --source include/wait_condition.inc
284 --let $failover_version_step12= query_get_value(SELECT VERSION FROM performance_schema.replication_group_configuration_version where name='replication_asynchronous_connection_failover', VERSION, 1)
285
286 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_group_configuration_version where name='replication_asynchronous_connection_failover_managed' and version=2
287 --source include/wait_condition.inc
288
289
290 --echo
291 --echo # 13. Verify replication_asynchronous_connection_failover on
292 --echo # server2 is empty and member action configuration version
293 --echo # value for replication_asynchronous_connection_failover
294 --echo # and for replication_asynchronous_connection_failover_managed.
295 --echo
296 --let $rpl_connection_name= server2
297 --source include/rpl_connection.inc
298
299 --let $wait_condition= SELECT COUNT(*)=0 FROM performance_schema.replication_asynchronous_connection_failover
300 --source include/wait_condition.inc
301
302 --let $wait_condition= SELECT COUNT(*)=0 FROM performance_schema.replication_asynchronous_connection_failover_managed
303 --source include/wait_condition.inc
304
305 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_group_configuration_version where name='replication_asynchronous_connection_failover' and version>=$failover_version_step12
306 --source include/wait_condition.inc
307
308 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_group_configuration_version where name='replication_asynchronous_connection_failover_managed' and version=2
309 --source include/wait_condition.inc
310
311
312 --echo #
313 --echo # 14. Clean up.
314 --echo #
315 --let $rpl_connection_name= server1
316 --source include/rpl_connection.inc
317
318 --let $rpl_channel_name='ch1'
319 --source include/stop_slave.inc
320
321 --let $rpl_reset_slave_all= 1
322 --let $rpl_multi_source= 1
323 --source include/rpl_reset_slave.inc
324 --let $rpl_channel_name=
325 --let $rpl_reset_slave_all=
326 --let $rpl_multi_source=
327
328 --let $rpl_connection_name= server5
329 --source include/rpl_connection.inc
330 --source include/stop_group_replication.inc
331
332 --let $rpl_connection_name= server4
333 --source include/rpl_connection.inc
334 --source include/stop_group_replication.inc
335
336 --let $rpl_connection_name= server3
337 --source include/rpl_connection.inc
338 --source include/stop_group_replication.inc
339
340 --let $rpl_connection_name= server2
341 --source include/rpl_connection.inc
342 --source include/stop_group_replication.inc
343
344 --let $rpl_channel_name='ch1'
345 --let $rpl_reset_slave_all= 1
346 --let $rpl_multi_source= 1
347 --source include/rpl_reset_slave.inc
348 --let $rpl_channel_name=
349 --let $rpl_reset_slave_all=
350 --let $rpl_multi_source=
351
352 --let $rpl_connection_name= server1
353 --source include/rpl_connection.inc
354 --source include/stop_group_replication.inc
355
356 --let $rpl_skip_sync = 1
357 --source include/group_replication_end.inc