Debian Codegraph @

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

raw
1 ################################################################################
2 #
3 # Validate that receiver group members does receive changes to
4 # replication_asynchronous_connection_failover table using
5 # asynchronous_connection_failover_add_source() and
6 # asynchronous_connection_failover_delete_source() UDFs.
7 #
8 # Test:
9 # 0. The test requires 5 servers:
10 # server1: group primary (async channel to server4)
11 # server2: group secondary
12 # server3: group secondary
13 # server4: source server
14 # server5: source server
15 # 1. Deploy a 3 members group in single primary mode.
16 # 2. Create a replication channel to replicate from server4 to
17 # server1.
18 # 3. Add replication connection details of server4 and server5
19 # to replication_asynchronous_connection_failover table
20 # through asynchronous_connection_failover_add_source() UDF.
21 # 4. Start replica for channel ch1.
22 # 5. Verify replication_asynchronous_connection_failover on
23 # server1 has two rows (of server4 and server5) and member action
24 # configuration version value is 2 in
25 # replication_group_configuration_version.
26 # 6. Verify replication_asynchronous_connection_failover on
27 # server2 and server 3 has two rows (of server4 and server5) and
28 # member action configuration version value is 2 in
29 # replication_group_configuration_version.
30 # 7. Delete replication connection details of server4 and server5
31 # from replication_asynchronous_connection_failover table
32 # through asynchronous_connection_failover_delete_source() UDF.
33 # 8. Verify replication_asynchronous_connection_failover on
34 # server1 is empty and member action configuration version value
35 # is 4 in replication_group_configuration_version.
36 # 9. Verify replication_asynchronous_connection_failover on
37 # server2 is empty and member action configuration version value
38 # is 4 in replication_group_configuration_version.
39 # 10. Clean up.
40 #
41 --source include/big_test.inc
42 --source include/have_group_replication_plugin.inc
43 --let $rpl_skip_group_replication_start= 1
44 --let $rpl_server_count= 5
45 --source include/group_replication.inc
46
47
48 --echo
49 --echo # 1. Deploy a 3 members group in single primary mode.
50 --echo
51 --let $rpl_connection_name= server1
52 --source include/rpl_connection.inc
53 --source include/start_and_bootstrap_group_replication.inc
54
55 --let $rpl_connection_name= server2
56 --source include/rpl_connection.inc
57
58 # The failover channel must be created on all group members.
59 --replace_result $SERVER_MYPORT_4 SERVER_4_PORT
60 --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'
61
62 --source include/start_group_replication.inc
63
64 --let $rpl_connection_name= server3
65 --source include/rpl_connection.inc
66
67 # The failover channel must be created on all group members.
68 --replace_result $SERVER_MYPORT_4 SERVER_4_PORT
69 --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'
70
71 --source include/start_group_replication.inc
72
73
74 --echo
75 --echo # 2. Create a replication channel to replicate from server4 to
76 --echo # server1.
77 --echo
78 --let $rpl_connection_name= server1
79 --source include/rpl_connection.inc
80 --replace_result $SERVER_MYPORT_4 SERVER_4_PORT
81 --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'
82
83
84 --echo
85 --echo # 3. Add replication connection details of server4 and server5
86 --echo # to replication_asynchronous_connection_failover table
87 --echo # through asynchronous_connection_failover_add_source() UDF.
88 --echo
89 --replace_result $SERVER_MYPORT_4 SERVER_MYPORT_4
90 --eval SELECT asynchronous_connection_failover_add_source('ch1', '127.0.0.1', $SERVER_MYPORT_4, '', 50)
91
92 --replace_result $SERVER_MYPORT_5 SERVER_MYPORT_5
93 --eval SELECT asynchronous_connection_failover_add_source('ch1', '127.0.0.1', $SERVER_MYPORT_5, '', 40)
94
95
96 --echo
97 --echo # 4. Start replica for channel ch1.
98 --echo
99 --let $rpl_channel_name='ch1'
100 --source include/start_slave.inc
101 --let $rpl_channel_name=
102
103
104 --echo
105 --echo # 5. Verify replication_asynchronous_connection_failover on
106 --echo # server1 has two rows (of server4 and server5) and member action
107 --echo # configuration version value is 2 in
108 --echo # replication_group_configuration_version.
109 --echo
110 --let $wait_condition= SELECT COUNT(*)=2 FROM performance_schema.replication_asynchronous_connection_failover
111 --source include/wait_condition.inc
112
113 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_group_configuration_version where name='replication_asynchronous_connection_failover' and version>=2
114 --source include/wait_condition.inc
115 --let $failover_version_step5= query_get_value(SELECT VERSION FROM performance_schema.replication_group_configuration_version where name='replication_asynchronous_connection_failover', VERSION, 1)
116
117
118
119
120 --echo
121 --echo # 6. Verify replication_asynchronous_connection_failover on
122 --echo # server2 and server3 has two rows (of server4 and server5) and
123 --echo # member action configuration version value is 2 in
124 --echo # replication_group_configuration_version.
125 --echo
126 --let $rpl_connection_name= server2
127 --source include/rpl_connection.inc
128
129 --let $wait_condition= SELECT COUNT(*)=2 FROM performance_schema.replication_asynchronous_connection_failover
130 --source include/wait_condition.inc
131
132 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_group_configuration_version where name='replication_asynchronous_connection_failover' and version>=$failover_version_step5
133 --source include/wait_condition.inc
134
135
136 --let $rpl_connection_name= server3
137 --source include/rpl_connection.inc
138
139 --let $wait_condition= SELECT COUNT(*)=2 FROM performance_schema.replication_asynchronous_connection_failover
140 --source include/wait_condition.inc
141
142 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_group_configuration_version where name='replication_asynchronous_connection_failover' and version>=$failover_version_step5
143 --source include/wait_condition.inc
144
145
146 --echo
147 --echo # 7. Delete replication connection details of server4 and server5
148 --echo # from replication_asynchronous_connection_failover table
149 --echo # through asynchronous_connection_failover_delete_source() UDF.
150 --echo
151 --let $rpl_connection_name= server1
152 --source include/rpl_connection.inc
153
154 --replace_result $SERVER_MYPORT_4 SERVER_MYPORT_4
155 --eval SELECT asynchronous_connection_failover_delete_source('ch1', '127.0.0.1', $SERVER_MYPORT_4, '')
156
157 --replace_result $SERVER_MYPORT_5 SERVER_MYPORT_5
158 --eval SELECT asynchronous_connection_failover_delete_source('ch1', '127.0.0.1', $SERVER_MYPORT_5, '')
159
160
161 --echo
162 --echo # 8. Verify replication_asynchronous_connection_failover on
163 --echo # server1 is empty and member action configuration version value
164 --echo # is 4 in replication_group_configuration_version.
165 --echo
166 --let $wait_condition= SELECT COUNT(*)=0 FROM performance_schema.replication_asynchronous_connection_failover
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>=3
170 --source include/wait_condition.inc
171 --let $failover_version_step8= query_get_value(SELECT VERSION FROM performance_schema.replication_group_configuration_version where name='replication_asynchronous_connection_failover', VERSION, 1)
172
173
174 --echo
175 --echo # 9. Verify replication_asynchronous_connection_failover on
176 --echo # server2 is empty and member action configuration version value
177 --echo # is 4 in replication_group_configuration_version.
178 --echo
179 --let $rpl_connection_name= server2
180 --source include/rpl_connection.inc
181
182 --let $wait_condition= SELECT COUNT(*)=0 FROM performance_schema.replication_asynchronous_connection_failover
183 --source include/wait_condition.inc
184
185 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_group_configuration_version where name='replication_asynchronous_connection_failover' and version>=$failover_version_step8
186 --source include/wait_condition.inc
187
188
189 --echo
190 --echo # 10. Clean up.
191 --echo
192 --let $rpl_connection_name= server1
193 --source include/rpl_connection.inc
194
195 --let $rpl_channel_name='ch1'
196 --source include/stop_slave.inc
197
198 --let $rpl_reset_slave_all= 1
199 --let $rpl_multi_source= 1
200 --source include/rpl_reset_slave.inc
201 --let $rpl_channel_name=
202 --let $rpl_reset_slave_all=
203 --let $rpl_multi_source=
204
205 --let $rpl_connection_name= server2
206 --source include/rpl_connection.inc
207 --let $rpl_channel_name='ch1'
208 --let $rpl_reset_slave_all= 1
209 --let $rpl_multi_source= 1
210 --source include/rpl_reset_slave.inc
211 --let $rpl_channel_name=
212 --let $rpl_reset_slave_all=
213 --let $rpl_multi_source=
214
215 --let $rpl_connection_name= server3
216 --source include/rpl_connection.inc
217 --let $rpl_channel_name='ch1'
218 --let $rpl_reset_slave_all= 1
219 --let $rpl_multi_source= 1
220 --source include/rpl_reset_slave.inc
221 --let $rpl_channel_name=
222 --let $rpl_reset_slave_all=
223 --let $rpl_multi_source=
224
225 --source include/group_replication_end.inc