Debian Codegraph @

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

raw
1 #
2 # Test case to verify that source gets selected based on highest weight
3 # even if source is from different group.
4 #
5 # Test:
6 # 1. Configure first group members: server1 and 2.
7 # 2. Start GR on first group members: server1 and 2.
8 # 3. Configure second group members: server3 and 4.
9 # 4. Start GR on second group members: server3 and 4.
10 # 5. Create and start new channel ch1_5: server5(slave), server1(master)
11 # and verify channel ch1_5 IO and SQL THREADS are ON.
12 # 6. Add two asynchronous connection failover servers from two different
13 # groups and verify that they are inserted successfully in
14 # performance_schema.replication_asynchronous_connection_failover.
15 # 7. Verify four senders are added automatically to
16 # replication_asynchronous_connection_failover table.
17 # 8. Verify it gets reconnected to source with highest
18 # weight which will be server3.
19 # 9. Clean Up.
20 #
21 --source include/big_test.inc
22 --source include/have_group_replication_plugin.inc
23 --let $rpl_skip_group_replication_start= 1
24 --let $rpl_group_replication_single_primary_mode=1
25 --let $rpl_server_count= 4
26 --source include/group_replication.inc
27
28 --let $rpl_connection_name= server5
29 --source include/rpl_connection.inc
30
31 SET SESSION sql_log_bin = 0;
32 call mtr.add_suppression("The source.*for channel.*has joined the group.*and so added its entry into replication_asynchronous_connection_failover table");
33 call mtr.add_suppression("The source.*for channel.*has left the group.*and so removed its entry from replication_asynchronous_connection_failover table");
34 call mtr.add_suppression("The IO thread detected that the source .* does not belong to the group majority, thence the channel .* will try to connect to another source.");
35 call mtr.add_suppression("The Monitor IO thread detected that the source .* does not belong to the group majority, thence the channel .* will try to connect to another source.");
36 call mtr.add_suppression("The group .* for the channel .* has been added, and so added its entry in replication_asynchronous_connection_failover_managed and source to replication_asynchronous_connection_failover table.");
37 call mtr.add_suppression("The Monitor IO thread failed to detect if the source belongs to the group majority on the source .* for channel 'ch1_5'.");
38 SET SESSION sql_log_bin = 1;
39
40 --echo
41 --echo # 1. Configure first group members: server1 and 2.
42 --echo
43
44 --let $rpl_connection_name= server1
45 --source include/rpl_connection.inc
46
47 #check which stack are we using
48 --let $have_xcom_stack= `SELECT @@group_replication_communication_stack LIKE 'XCOM'`
49
50 --let $_group_replication_group_seeds=
51 --let $_rpl_gcs_server_address= localhost
52
53 --let $_rpl_server= 2
54 while ($_rpl_server)
55 {
56
57 --let $_rpl_gcs_server_port=
58 if ($have_xcom_stack)
59 {
60 --let $_rpl_gcs_server_port= \$SERVER_GR_PORT_$_rpl_server
61 }
62 if (!$have_xcom_stack)
63 {
64 --let $_rpl_gcs_server_port= \$SERVER_MYPORT_$_rpl_server
65 }
66
67 if ($_group_replication_group_seeds != "")
68 {
69 --let $_group_replication_group_seeds= $_group_replication_group_seeds,
70 }
71
72 --let $_rpl_gcs_member= $_rpl_gcs_server_address:$_rpl_gcs_server_port
73 --let $_group_replication_group_seeds= $_group_replication_group_seeds$_rpl_gcs_member
74
75 --dec $_rpl_server
76 }
77
78 --let $_group_replication_group_name1= `SELECT UUID()`
79 --let $_rpl_server= 2
80 while ($_rpl_server)
81 {
82 --let $_rpl_connection_name= server$_rpl_server
83 --connection $_rpl_connection_name
84
85 --replace_result $_group_replication_group_seeds GROUP_REPLICATION_GROUP_SEEDS
86 --eval SET GLOBAL group_replication_group_seeds= "$_group_replication_group_seeds"
87
88 --replace_result $_group_replication_group_name1 GROUP_REPLICATION_GROUP_NAME
89 --eval SET GLOBAL group_replication_group_name= "$_group_replication_group_name1"
90
91 if ($_rpl_server == 1)
92 {
93 --let $_group_replication_group_seeds_tmp1 = $_group_replication_group_seeds
94 --let $_group_replication_group_name_tmp1 = $_group_replication_group_name1
95 }
96
97 --dec $_rpl_server
98 }
99
100
101 --echo
102 --echo # 2. Start GR on first group members: server1 and 2.
103 --echo
104
105 --let $rpl_connection_name= server1
106 --source include/rpl_connection.inc
107 --let $group_replication_group_name= $_group_replication_group_name1
108 --source include/start_and_bootstrap_group_replication.inc
109
110 --let $rpl_connection_name= server2
111 --source include/rpl_connection.inc
112 --let $group_replication_group_name= $_group_replication_group_name1
113 --source include/start_group_replication.inc
114
115
116 --echo
117 --echo # 3. Configure second group members: server3 and 4.
118 --echo
119
120 --let $_group_replication_group_seeds=
121
122 --let $_rpl_server=4
123 while ($_rpl_server > 2)
124 {
125 --let $_rpl_gcs_server_port=
126 if ($have_xcom_stack)
127 {
128 --let $_rpl_gcs_server_port= \$SERVER_GR_PORT_$_rpl_server
129 }
130 if (!$have_xcom_stack)
131 {
132 --let $_rpl_gcs_server_port= \$SERVER_MYPORT_$_rpl_server
133 }
134
135 if ($_group_replication_group_seeds != "")
136 {
137 --let $_group_replication_group_seeds= $_group_replication_group_seeds,
138 }
139
140 --let $_rpl_gcs_member= $_rpl_gcs_server_address:$_rpl_gcs_server_port
141 --let $_group_replication_group_seeds= $_group_replication_group_seeds$_rpl_gcs_member
142
143 --dec $_rpl_server
144 }
145
146
147 --let $_group_replication_group_name2= `SELECT UUID()`
148 --let $_rpl_server= 4
149 while ($_rpl_server > 2)
150 {
151 --let $_rpl_connection_name= server$_rpl_server
152 --connection $_rpl_connection_name
153
154 --replace_result $_group_replication_group_seeds GROUP_REPLICATION_GROUP_SEEDS
155 --eval SET GLOBAL group_replication_group_seeds= "$_group_replication_group_seeds"
156
157 --replace_result $_group_replication_group_name2 GROUP_REPLICATION_GROUP_NAME
158 --eval SET GLOBAL group_replication_group_name= "$_group_replication_group_name2"
159
160 --dec $_rpl_server
161 }
162
163
164 --echo
165 --echo # 4. Start GR on second group members: server3 and 4.
166 --echo
167
168 --let $rpl_connection_name= server3
169 --source include/rpl_connection.inc
170 --let $group_replication_group_name= $_group_replication_group_name2
171 --source include/start_and_bootstrap_group_replication.inc
172
173 --let $rpl_connection_name= server4
174 --source include/rpl_connection.inc
175 --let $group_replication_group_name= $_group_replication_group_name2
176 --source include/start_group_replication.inc
177
178 --echo
179 --echo # 5. Create and start new channel ch1_5: server5(slave), server1(master)
180 --echo # and verify channel ch1_5 IO and SQL THREADS are ON.
181 --echo
182 --let $rpl_connection_name= server5
183 --source include/rpl_connection.inc
184
185 --replace_result $SERVER_MYPORT_1 SERVER_1_PORT
186 --eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_USER='root', SOURCE_AUTO_POSITION=1, SOURCE_CONNECTION_AUTO_FAILOVER=1, SOURCE_PORT=$SERVER_MYPORT_1, SOURCE_CONNECT_RETRY=1, SOURCE_RETRY_COUNT=2 for channel 'ch1_5'
187
188 --let $rpl_channel_name='ch1_5'
189 --source include/start_slave.inc
190 --let $rpl_channel_name=
191
192 --let $assert_text= Verify channel ch1_5 IO_THREAD is ON
193 --let $assert_cond= "[SELECT SERVICE_STATE FROM performance_schema.replication_connection_status WHERE channel_name = \'ch1_5\', SERVICE_STATE, 1]" = "ON"
194 --source include/assert.inc
195
196 --let $assert_text= Verify channel ch1_5 SQL_THREAD is ON
197 --let $assert_cond= "[SELECT SERVICE_STATE FROM performance_schema.replication_applier_status WHERE channel_name = \'ch1_5\', SERVICE_STATE, 1]" = "ON"
198 --source include/assert.inc
199
200
201 --echo #
202 --echo # 6. Add two asynchronous connection failover servers from two different
203 --echo # groups and verify that they are inserted successfully in
204 --echo # performance_schema.replication_asynchronous_connection_failover.
205 --echo #
206
207 --let $rpl_connection_name= server2
208 --source include/rpl_connection.inc
209 --let $_tmp_gr_group_name1= `SELECT @@GLOBAL.group_replication_group_name`
210
211 --let $rpl_connection_name= server4
212 --source include/rpl_connection.inc
213 --let $_tmp_gr_group_name2= `SELECT @@GLOBAL.group_replication_group_name`
214
215 --let $rpl_connection_name= server5
216 --source include/rpl_connection.inc
217
218 --replace_result $SERVER_MYPORT_2 SERVER_MYPORT_2 $_tmp_gr_group_name1 GROUP_NAME
219 --eval SELECT asynchronous_connection_failover_add_managed('ch1_5', 'GroupReplication', '$_tmp_gr_group_name1', '127.0.0.1', $SERVER_MYPORT_2, '', 70, 60);
220
221 --replace_result $SERVER_MYPORT_4 SERVER_MYPORT_4 $_tmp_gr_group_name2 GROUP_NAME
222 --eval SELECT asynchronous_connection_failover_add_managed('ch1_5', 'GroupReplication', '$_tmp_gr_group_name2', '127.0.0.1', $SERVER_MYPORT_4, '', 80, 60);
223
224 --let $assert_only_after = CURRENT_TEST: group_replication.gr_acf_switch_highest_weight_auto
225 --let $assert_file= $MYSQLTEST_VARDIR/log/mysqld.5.err
226 --let $assert_count= 2
227 --let $assert_select= The group .* for the channel 'ch1_5' has been added, and so added its entry in replication_asynchronous_connection_failover_managed and source to replication_asynchronous_connection_failover table.
228 --let $assert_text= 'There are two rows in performance_schema.replication_asynchronous_connection_failover'
229 --source include/assert_grep.inc
230
231
232 --echo
233 --echo # 7. Verify four senders are added automatically to
234 --echo # replication_asynchronous_connection_failover table.
235 --echo
236 --let $rpl_connection_name= server5
237 --source include/rpl_connection.inc
238
239 --let $wait_condition= SELECT COUNT(*)=4 FROM performance_schema.replication_asynchronous_connection_failover;
240 --source include/wait_condition.inc
241
242
243 --echo
244 --echo # 8. Verify it gets reconnected to source with highest
245 --echo # weight which will be server3.
246 --echo
247 --let $rpl_connection_name= server5
248 --source include/rpl_connection.inc
249
250 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_connection_configuration WHERE HOST = '127.0.0.1' AND PORT = $SERVER_MYPORT_3
251 --source include/wait_condition.inc
252
253 --let $wait_condition= SELECT COUNT(*)=4 FROM performance_schema.replication_asynchronous_connection_failover;
254 --source include/wait_condition.inc
255
256
257 --echo
258 --echo # 9. Clean Up.
259 --echo
260
261 --let $rpl_connection_name= server3
262 --source include/rpl_connection.inc
263
264 --replace_result $SERVER_MYPORT_1 SERVER_1_PORT
265 --eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_USER='root', SOURCE_PORT=$SERVER_MYPORT_1 FOR CHANNEL 'ch1_3'
266
267 --let $rpl_channel_name='ch1_3'
268 --source include/start_slave.inc
269 --let $rpl_channel_name=
270
271
272 --let $rpl_connection_name= server1
273 --source include/rpl_connection.inc
274
275 --replace_result $SERVER_MYPORT_3 SERVER_3_PORT
276 --eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_USER='root', SOURCE_PORT=$SERVER_MYPORT_3 FOR CHANNEL 'ch3_1'
277
278 --let $rpl_channel_name='ch3_1'
279 --source include/start_slave.inc
280 --let $rpl_channel_name=
281
282
283 --let $sync_slave_connection= server3
284 --source include/sync_slave_sql_with_master.inc
285
286 --let $sync_slave_connection= server1
287 --source include/sync_slave_sql_with_master.inc
288
289 --let $sync_slave_connection= server5
290 --source include/sync_slave_sql_with_master.inc
291
292
293 --let $_rpl_server= 4
294 while ($_rpl_server)
295 {
296 --let $_rpl_connection_name= server$_rpl_server
297 --connection $_rpl_connection_name
298 --source include/stop_group_replication.inc
299 --dec $_rpl_server
300 }
301
302 --let $rpl_connection_name= server5
303 --source include/rpl_connection.inc
304
305 --let $rpl_channel_name='ch1_5'
306 --source include/stop_slave.inc
307 --let $rpl_multi_source= 1
308 --let $rpl_reset_slave_all= 1
309 --source include/rpl_reset_slave.inc
310
311 --replace_result $_tmp_gr_group_name1 GROUP_NAME1
312 --eval SELECT asynchronous_connection_failover_delete_managed('ch1_5', '$_tmp_gr_group_name1')
313
314 --replace_result $_tmp_gr_group_name2 GROUP_NAME2
315 --eval SELECT asynchronous_connection_failover_delete_managed('ch1_5', '$_tmp_gr_group_name2')
316
317
318 --let $rpl_connection_name= server3
319 --source include/rpl_connection.inc
320
321 --let $rpl_channel_name='ch1_3'
322 --source include/stop_slave.inc
323 --let $rpl_multi_source= 1
324 --source include/rpl_reset_slave.inc
325
326 --let $rpl_connection_name= server1
327 --source include/rpl_connection.inc
328
329 --let $rpl_channel_name='ch3_1'
330 --source include/stop_slave.inc
331 --let $rpl_multi_source= 1
332 --let $rpl_reset_slave_all= 1
333 --source include/rpl_reset_slave.inc
334 --let $rpl_channel_name=
335 --let $rpl_multi_source=
336
337
338 --let $skip_recovery_configuration= 1
339 --let $rpl_server_count= 4
340 --source include/group_replication_end.inc