Debian Codegraph @

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

raw
1 ###############################################################################
2 # Validate that on a group mode change from single to multi-primary,
3 # following will get disabled in multi-primary mode:
4 # * configuration (managed channels sources states,
5 # SOURCE_CONNECTION_AUTO_FAILOVER value) propagation;
6 # * channels start on primary election.
7 #
8 # Test:
9 # 0. This test requires four servers:
10 # server1, server2: group
11 # server3: single server
12 # server4: single server
13 # 1. Deploy a group in single-primary mode on server1 and server2.
14 # 2. Configure a failover channel on server1 that replicates
15 # from server3.
16 # 3. Assert failover channel configuration on server2.
17 # 4. Change to multi-primary mode.
18 # The failover channel will remain working on server1.
19 # 5. Add more sources to channel 'ch1' on server1
20 # and change SOURCE_CONNECTION_AUTO_FAILOVER value,
21 # they will not be propagated to server2.
22 # 6. server1 will leave the group, despite 'ch1' is a failover
23 # channel, since the group is on multi-primary mode, server2
24 # will not start channel 'ch1'.
25 # 7. Clean up.
26 ###############################################################################
27 --source include/big_test.inc
28 --source include/have_group_replication_plugin.inc
29 --let $rpl_group_replication_single_primary_mode=1
30 --let $rpl_skip_group_replication_start= 1
31 --let $rpl_server_count= 4
32 --source include/group_replication.inc
33
34
35 --echo
36 --echo ############################################################
37 --echo # 1. Deploy a group in single-primary mode on server1 and server2.
38 --let $rpl_connection_name= server1
39 --source include/rpl_connection.inc
40 --let $server1_uuid= query_get_value(SELECT @@SERVER_UUID, @@SERVER_UUID, 1)
41 --source include/start_and_bootstrap_group_replication.inc
42 --source include/gr_assert_primary_member.inc
43
44 --let $rpl_connection_name= server2
45 --source include/rpl_connection.inc
46
47 # Replication failover channels must be created on all group members.
48 --let $rpl_connection_name= server2
49 --source include/rpl_connection.inc
50 --replace_result $SERVER_MYPORT_3 SERVER_3_PORT
51 --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_3, SOURCE_CONNECT_RETRY=1, SOURCE_RETRY_COUNT=1 FOR CHANNEL 'ch1'
52
53 --source include/start_group_replication.inc
54 --source include/gr_assert_secondary_member.inc
55
56
57 --echo
58 --echo ############################################################
59 --echo # 2. Configure a failover channel on server1 that replicates
60 --echo # from server3.
61 --let $rpl_connection_name= server3
62 --source include/rpl_connection.inc
63 --let $server3_uuid= `SELECT @@server_uuid`
64
65 --let $rpl_connection_name= server1
66 --source include/rpl_connection.inc
67 --replace_result $SERVER_MYPORT_3 SERVER_3_PORT
68 --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_3, SOURCE_CONNECT_RETRY=1, SOURCE_RETRY_COUNT=1 FOR CHANNEL 'ch1'
69
70 --replace_result $SERVER_MYPORT_3 SERVER_MYPORT_3
71 --eval SELECT asynchronous_connection_failover_add_source('ch1', '127.0.0.1', $SERVER_MYPORT_3, '', 50);
72
73 --let $rpl_channel_name='ch1'
74 --source include/start_slave.inc
75
76 --let $assert_text= 'There is 1 row in performance_schema.replication_asynchronous_connection_failover'
77 --let $assert_cond= [SELECT COUNT(*) count FROM performance_schema.replication_asynchronous_connection_failover, count, 1] = 1
78 --source include/assert.inc
79
80 --let $assert_text= 'The version of replication_asynchronous_connection_failover must be 1'
81 --let $assert_cond= [SELECT version FROM performance_schema.replication_group_configuration_version WHERE name=\'replication_asynchronous_connection_failover\', version, 1] = 1
82 --source include/assert.inc
83
84 --let $assert_text= 'SOURCE_CONNECTION_AUTO_FAILOVER must be enabled on ch1'
85 --let $assert_cond= [SELECT COUNT(*) AS count FROM performance_schema.replication_connection_configuration WHERE CHANNEL_NAME="ch1" AND SOURCE_CONNECTION_AUTO_FAILOVER=1, count, 1] = 1
86 --source include/assert.inc
87
88 --let $assert_text= Verify channel ch1 IO_THREAD is ON and connected to server3
89 --let $assert_cond= "[SELECT SERVICE_STATE FROM performance_schema.replication_connection_status WHERE channel_name=\'ch1\' AND source_uuid=\'$server3_uuid\', SERVICE_STATE, 1]" = "ON"
90 --source include/assert.inc
91
92 --let $assert_text= Verify channel ch1 SQL_THREAD is ON
93 --let $assert_cond= "[SELECT SERVICE_STATE FROM performance_schema.replication_applier_status WHERE channel_name = \'ch1\', SERVICE_STATE, 1]" = "ON"
94 --source include/assert.inc
95
96 --let $assert_text= Verify replica_monitor thread is running
97 --let $assert_cond= "[select count(*) FROM performance_schema.threads where NAME=\"thread/sql/replica_monitor\"]" = 1;
98 --source include/assert.inc
99
100 --echo
101 --echo ############################################################
102 --echo # 3. Assert failover channel configuration on server2.
103 --let $rpl_connection_name= server2
104 --source include/rpl_connection.inc
105
106 --let $assert_text= 'There is 1 row in performance_schema.replication_asynchronous_connection_failover'
107 --let $assert_cond= [SELECT COUNT(*) count FROM performance_schema.replication_asynchronous_connection_failover, count, 1] = 1
108 --source include/assert.inc
109
110 --let $assert_text= 'The version of replication_asynchronous_connection_failover must be 1'
111 --let $assert_cond= [SELECT version FROM performance_schema.replication_group_configuration_version WHERE name=\'replication_asynchronous_connection_failover\', version, 1] = 1
112 --source include/assert.inc
113
114 --let $assert_text= 'SOURCE_CONNECTION_AUTO_FAILOVER must be enabled on ch1'
115 --let $assert_cond= [SELECT COUNT(*) AS count FROM performance_schema.replication_connection_configuration WHERE CHANNEL_NAME="ch1" AND SOURCE_CONNECTION_AUTO_FAILOVER=1, count, 1] = 1
116 --source include/assert.inc
117
118 --let $assert_text= Verify channel ch1 IO_THREAD is OFF
119 --let $assert_cond= "[SELECT SERVICE_STATE FROM performance_schema.replication_connection_status WHERE channel_name=\'ch1\', SERVICE_STATE, 1]" = "OFF"
120 --source include/assert.inc
121
122 --let $assert_text= Verify channel ch1 SQL_THREAD is OFF
123 --let $assert_cond= "[SELECT SERVICE_STATE FROM performance_schema.replication_applier_status WHERE channel_name = \'ch1\', SERVICE_STATE, 1]" = "OFF"
124 --source include/assert.inc
125
126 --let $assert_text= Verify replica_monitor thread is not running
127 --let $assert_cond= "[select count(*) FROM performance_schema.threads where NAME=\"thread/sql/replica_monitor\"]" = 0;
128 --source include/assert.inc
129
130 --replace_column 3 #####
131 SELECT * FROM performance_schema.replication_asynchronous_connection_failover;
132
133 SELECT * FROM performance_schema.replication_group_configuration_version WHERE name LIKE 'replication_asynchronous_connection_failover';
134
135
136 --echo
137 --echo ############################################################
138 --echo # 4. Change to multi-primary mode.
139 --echo # The failover channel will remain working on server1.
140 --let $rpl_connection_name= server1
141 --source include/rpl_connection.inc
142 --replace_result $server1_uuid MEMBER1_UUID
143 SELECT group_replication_switch_to_multi_primary_mode();
144 --source include/gr_assert_multi_primary_mode.inc
145
146 --let $rpl_channel_name= 'ch1'
147 --source include/check_slave_is_running.inc
148 --let $rpl_channel_name=
149
150 --let $rpl_connection_name= server2
151 --source include/rpl_connection.inc
152 --source include/gr_assert_multi_primary_mode.inc
153
154
155 --echo
156 --echo ############################################################
157 --echo # 5. Add more sources to channel 'ch1' on server1
158 --echo # and change SOURCE_CONNECTION_AUTO_FAILOVER value,
159 --echo # they will not be propagated to server2.
160 --let $rpl_connection_name= server1
161 --source include/rpl_connection.inc
162 --replace_result $SERVER_MYPORT_4 SERVER_MYPORT_4
163 --eval SELECT asynchronous_connection_failover_add_source('ch1', '127.0.0.1', $SERVER_MYPORT_4, '', 50);
164
165 --let $rpl_channel_name='ch1'
166 --source include/stop_slave.inc
167
168 CHANGE REPLICATION SOURCE TO SOURCE_CONNECTION_AUTO_FAILOVER=0 FOR CHANNEL 'ch1';
169
170 --let $rpl_channel_name='ch1'
171 --source include/start_slave.inc
172
173
174 --let $assert_text= 'There are 2 rows in performance_schema.replication_asynchronous_connection_failover'
175 --let $assert_cond= [SELECT COUNT(*) count FROM performance_schema.replication_asynchronous_connection_failover, count, 1] = 2
176 --source include/assert.inc
177
178 --let $assert_text= 'The version of replication_asynchronous_connection_failover must be 2'
179 --let $assert_cond= [SELECT version FROM performance_schema.replication_group_configuration_version WHERE name=\'replication_asynchronous_connection_failover\', version, 1] = 2
180
181 --replace_column 3 #####
182 SELECT * FROM performance_schema.replication_asynchronous_connection_failover;
183
184 SELECT * FROM performance_schema.replication_group_configuration_version WHERE name LIKE 'replication_asynchronous_connection_failover';
185
186 --let $rpl_connection_name= server2
187 --source include/rpl_connection.inc
188
189 --let $assert_text= 'There is 1 row in performance_schema.replication_asynchronous_connection_failover'
190 --let $assert_cond= [SELECT COUNT(*) count FROM performance_schema.replication_asynchronous_connection_failover, count, 1] = 1
191 --source include/assert.inc
192
193 --let $assert_text= 'The version of replication_asynchronous_connection_failover must be 1'
194 --let $assert_cond= [SELECT version FROM performance_schema.replication_group_configuration_version WHERE name=\'replication_asynchronous_connection_failover\', version, 1] = 1
195 --source include/assert.inc
196
197 --let $assert_text= 'SOURCE_CONNECTION_AUTO_FAILOVER must be enabled on ch1'
198 --let $assert_cond= [SELECT COUNT(*) AS count FROM performance_schema.replication_connection_configuration WHERE CHANNEL_NAME="ch1" AND SOURCE_CONNECTION_AUTO_FAILOVER=1, count, 1] = 1
199 --source include/assert.inc
200
201 --let $assert_text= Verify channel ch1 IO_THREAD is OFF
202 --let $assert_cond= "[SELECT SERVICE_STATE FROM performance_schema.replication_connection_status WHERE channel_name=\'ch1\', SERVICE_STATE, 1]" = "OFF"
203 --source include/assert.inc
204
205 --let $assert_text= Verify channel ch1 SQL_THREAD is OFF
206 --let $assert_cond= "[SELECT SERVICE_STATE FROM performance_schema.replication_applier_status WHERE channel_name = \'ch1\', SERVICE_STATE, 1]" = "OFF"
207 --source include/assert.inc
208
209 --let $assert_text= Verify replica_monitor thread is not running
210 --let $assert_cond= "[select count(*) FROM performance_schema.threads where NAME=\"thread/sql/replica_monitor\"]" = 0;
211 --source include/assert.inc
212
213 --replace_column 3 #####
214 SELECT * FROM performance_schema.replication_asynchronous_connection_failover;
215
216 SELECT * FROM performance_schema.replication_group_configuration_version WHERE name LIKE 'replication_asynchronous_connection_failover';
217
218
219 --echo
220 --echo ############################################################
221 --echo # 6. server1 will leave the group, despite 'ch1' is a failover
222 --echo # channel, since the group is on multi-primary mode, server2
223 --echo # will not start channel 'ch1'.
224 --let $rpl_connection_name= server1
225 --source include/rpl_connection.inc
226 --source include/stop_group_replication.inc
227
228 --let $rpl_connection_name= server2
229 --source include/rpl_connection.inc
230
231 --let $assert_text= The action mysql_start_failover_channels_if_primary is enabled
232 --let $assert_cond= [SELECT enabled FROM performance_schema.replication_group_member_actions WHERE name=\'mysql_start_failover_channels_if_primary\' AND event=\'AFTER_PRIMARY_ELECTION\', enabled, 1] = 1
233 --source include/assert.inc
234
235 --let $assert_text= 'There is 1 row in performance_schema.replication_asynchronous_connection_failover'
236 --let $assert_cond= [SELECT COUNT(*) count FROM performance_schema.replication_asynchronous_connection_failover, count, 1] = 1
237 --source include/assert.inc
238
239 --let $assert_text= 'The version of replication_asynchronous_connection_failover must be 1'
240 --let $assert_cond= [SELECT version FROM performance_schema.replication_group_configuration_version WHERE name=\'replication_asynchronous_connection_failover\', version, 1] = 1
241 --source include/assert.inc
242
243 --let $assert_text= 'SOURCE_CONNECTION_AUTO_FAILOVER must be enabled on ch1'
244 --let $assert_cond= [SELECT COUNT(*) AS count FROM performance_schema.replication_connection_configuration WHERE CHANNEL_NAME="ch1" AND SOURCE_CONNECTION_AUTO_FAILOVER=1, count, 1] = 1
245 --source include/assert.inc
246
247 --let $assert_text= Verify channel ch1 IO_THREAD is OFF
248 --let $assert_cond= "[SELECT SERVICE_STATE FROM performance_schema.replication_connection_status WHERE channel_name=\'ch1\', SERVICE_STATE, 1]" = "OFF"
249 --source include/assert.inc
250
251 --let $assert_text= Verify channel ch1 SQL_THREAD is OFF
252 --let $assert_cond= "[SELECT SERVICE_STATE FROM performance_schema.replication_applier_status WHERE channel_name = \'ch1\', SERVICE_STATE, 1]" = "OFF"
253 --source include/assert.inc
254
255 --let $assert_text= Verify replica_monitor thread is not running
256 --let $assert_cond= "[select count(*) FROM performance_schema.threads where NAME=\"thread/sql/replica_monitor\"]" = 0;
257 --source include/assert.inc
258
259
260 --echo
261 --echo ############################################################
262 --echo # 7. Clean up.
263 --let $rpl_connection_name= server2
264 --source include/rpl_connection.inc
265 --source include/stop_group_replication.inc
266
267 --let $rpl_channel_name='ch1'
268 --let $rpl_multi_source= 1
269 --let $rpl_reset_slave_all= 1
270 --source include/rpl_reset_slave.inc
271 --let $rpl_channel_name=
272 --let $rpl_multi_source=
273
274 --let $rpl_connection_name= server1
275 --source include/rpl_connection.inc
276 --let $rpl_channel_name='ch1'
277 --let $rpl_multi_source= 1
278 --let $rpl_reset_slave_all= 1
279 --source include/rpl_reset_slave.inc
280 --let $rpl_channel_name=
281 --let $rpl_multi_source=
282
283 --let $rpl_group_replication_reset_persistent_vars=1
284 --source include/group_replication_end.inc