Debian Codegraph @

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

raw
1 #
2 # Validate when a server on sender list changes group its information is updated
3 # accordingly in the replication_asynchronous_connection_failover table i.e.
4 # first deleted from table when its leaves a group and added again to the table
5 # when it joins new group whose one of the member information is present in the
6 # table.
7 #
8 # Test:
9 # 0. The test requires 5 servers:
10 # server1: group A primary
11 # server2: group A secondary
12 # server3: group B primary
13 # server4: group B secondary
14 # server5: single server
15 # 1. Deploy a 2 members group A in single primary mode.
16 # 2. Deploy a 2 members group B in single primary mode.
17 # 3. Configure replica to manage the asynchronous connection
18 # to groups A and B.
19 # 4. Create and start the managed channel.
20 # 5. Stop server2 from group A and validate is removed from senders list
21 # 6. Join server2 to group B and validate is added to senders list
22 # 7. Clean up.
23 #
24
25 --source include/have_group_replication_plugin.inc
26 --let $rpl_skip_group_replication_start= 1
27 --let $rpl_server_count= 5
28 --source include/group_replication.inc
29
30
31 --echo
32 --echo # 1. Deploy a 2 members group A in single primary mode.
33 --echo
34 --let $rpl_connection_name= server1
35 --source include/rpl_connection.inc
36 --let $server1_uuid= `SELECT @@server_uuid`
37 --let $group_replication_group_name= aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa
38 --let $group_a= $group_replication_group_name
39 --disable_query_log
40 if ($have_xcom_stack){
41 --eval SET GLOBAL group_replication_group_seeds= "localhost:$SERVER_GR_PORT_1,localhost:$SERVER_GR_PORT_2"
42 }
43
44 if (!$have_xcom_stack){
45 --eval SET GLOBAL group_replication_group_seeds= "localhost:$SERVER_MYPORT_1,localhost:$SERVER_MYPORT_2"
46 }
47 --enable_query_log
48 --source include/start_and_bootstrap_group_replication.inc
49
50 --let $rpl_connection_name= server2
51 --source include/rpl_connection.inc
52 --let $server2_uuid= `SELECT @@server_uuid`
53 --disable_query_log
54 if ($have_xcom_stack){
55 --eval SET GLOBAL group_replication_group_seeds= "localhost:$SERVER_GR_PORT_1,localhost:$SERVER_GR_PORT_2"
56 }
57
58 if (!$have_xcom_stack){
59 --eval SET GLOBAL group_replication_group_seeds= "localhost:$SERVER_MYPORT_1,localhost:$SERVER_MYPORT_2"
60 }
61 --enable_query_log
62 --source include/start_group_replication.inc
63
64
65 --echo
66 --echo # 2. Deploy a 2 members group B in single primary mode.
67 --echo
68 --let $rpl_connection_name= server3
69 --source include/rpl_connection.inc
70 --let $server3_uuid= `SELECT @@server_uuid`
71 --let $group_replication_group_name= bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb
72 --let $group_b= $group_replication_group_name
73 --disable_query_log
74 if ($have_xcom_stack){
75 --eval SET GLOBAL group_replication_group_seeds= "localhost:$SERVER_GR_PORT_3,localhost:$SERVER_GR_PORT_4"
76 }
77 if (!$have_xcom_stack){
78 --eval SET GLOBAL group_replication_group_seeds= "localhost:$SERVER_MYPORT_3,localhost:$SERVER_MYPORT_4"
79 }
80 --enable_query_log
81 --source include/start_and_bootstrap_group_replication.inc
82
83 --let $rpl_connection_name= server4
84 --source include/rpl_connection.inc
85 --let $server4_uuid= `SELECT @@server_uuid`
86 --disable_query_log
87 if ($have_xcom_stack){
88 --eval SET GLOBAL group_replication_group_seeds= "localhost:$SERVER_GR_PORT_3,localhost:$SERVER_GR_PORT_4"
89 }
90 if (!$have_xcom_stack){
91 --eval SET GLOBAL group_replication_group_seeds= "localhost:$SERVER_MYPORT_3,localhost:$SERVER_MYPORT_4"
92 }
93 --enable_query_log
94 --source include/start_group_replication.inc
95
96
97 --echo
98 --echo # 3. Configure replica to manage the asynchronous connection
99 --echo # to groups A and B.
100 --echo
101 --let $rpl_connection_name= server5
102 --source include/rpl_connection.inc
103
104 --replace_result $SERVER_MYPORT_1 SERVER_MYPORT_1 $group_a GROUP_A
105 --eval SELECT asynchronous_connection_failover_add_managed('ch1', 'GroupReplication', '$group_a', '127.0.0.1', $SERVER_MYPORT_1, '', 90, 70);
106
107 --replace_result $SERVER_MYPORT_3 SERVER_MYPORT_3 $group_b GROUP_B
108 --eval SELECT asynchronous_connection_failover_add_managed('ch1', 'GroupReplication', '$group_b', '127.0.0.1', $SERVER_MYPORT_3, '', 85, 65);
109
110 --let $assert_text= 'There is one row in performance_schema.replication_asynchronous_connection_failover for server1'
111 --let $assert_cond= [SELECT COUNT(*) count FROM performance_schema.replication_asynchronous_connection_failover WHERE port=$SERVER_MYPORT_1, count, 1] = 1
112 --source include/assert.inc
113
114 --let $assert_text= 'There is one row in performance_schema.replication_asynchronous_connection_failover for server3'
115 --let $assert_cond= [SELECT COUNT(*) count FROM performance_schema.replication_asynchronous_connection_failover WHERE port=$SERVER_MYPORT_3, count, 1] = 1
116 --source include/assert.inc
117
118 --let $assert_text= 'There is one row in performance_schema.replication_asynchronous_connection_failover_managed for group A'
119 --let $assert_cond= [SELECT COUNT(*) count FROM performance_schema.replication_asynchronous_connection_failover_managed WHERE managed_name="$group_a", count, 1] = 1
120 --source include/assert.inc
121
122 --let $assert_text= 'There is one row in performance_schema.replication_asynchronous_connection_failover_managed for group B'
123 --let $assert_cond= [SELECT COUNT(*) count FROM performance_schema.replication_asynchronous_connection_failover_managed WHERE managed_name="$group_b", count, 1] = 1
124 --source include/assert.inc
125
126
127 --echo
128 --echo # 4. Create and start the managed channel.
129 --echo
130 --let $rpl_connection_name= server5
131 --source include/rpl_connection.inc
132 --replace_result $SERVER_MYPORT_1 SERVER_1_PORT
133 --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=1 FOR CHANNEL 'ch1'
134
135 --let $rpl_channel_name='ch1'
136 --source include/start_slave.inc
137 --let $rpl_channel_name=
138
139 --let $assert_text= Verify channel ch1 IO_THREAD is ON and connected to server1
140 --let $assert_cond= "[SELECT SERVICE_STATE FROM performance_schema.replication_connection_status WHERE channel_name=\'ch1\' AND source_uuid=\'$server1_uuid\', SERVICE_STATE, 1]" = "ON"
141 --source include/assert.inc
142
143 --let $wait_condition= SELECT COUNT(*)=4 FROM performance_schema.replication_asynchronous_connection_failover
144 --source include/wait_condition.inc
145
146 --echo
147 --echo # 5. Stop server2 from group A and validate is removed from senders list
148 --echo
149
150 --let $rpl_connection_name= server2
151 --source include/rpl_connection.inc
152 --source include/stop_group_replication.inc
153
154 --let $rpl_connection_name= server5
155 --source include/rpl_connection.inc
156 --let $wait_condition= SELECT COUNT(*)=3 FROM performance_schema.replication_asynchronous_connection_failover
157 --source include/wait_condition.inc
158
159 --let $assert_text= 'There is no row in performance_schema.replication_asynchronous_connection_failover for server2'
160 --let $assert_cond= [SELECT COUNT(*) count FROM performance_schema.replication_asynchronous_connection_failover WHERE port=$SERVER_MYPORT_2, count, 1] = 0
161 --source include/assert.inc
162
163 --echo
164 --echo # 6. Join server2 to group B and validate is added to senders list
165 --echo
166
167 --let $rpl_connection_name= server2
168 --source include/rpl_connection.inc
169
170 # to clean old transactions and be able to join new group
171 RESET MASTER;
172
173 --let $group_replication_group_name= bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb
174 --disable_query_log
175 if ($have_xcom_stack){
176 --eval SET GLOBAL group_replication_group_seeds= "localhost:$SERVER_GR_PORT_3,localhost:$SERVER_GR_PORT_4"
177 }
178 if (!$have_xcom_stack){
179 --eval SET GLOBAL group_replication_group_seeds= "localhost:$SERVER_MYPORT_3,localhost:$SERVER_MYPORT_4"
180 }
181 --enable_query_log
182 --source include/start_group_replication.inc
183
184 --let $rpl_connection_name= server5
185 --source include/rpl_connection.inc
186 --let $wait_condition= SELECT COUNT(*)=4 FROM performance_schema.replication_asynchronous_connection_failover
187 --source include/wait_condition.inc
188
189 --let $assert_text= 'There one row in performance_schema.replication_asynchronous_connection_failover for server2'
190 --let $assert_cond= [SELECT COUNT(*) count FROM performance_schema.replication_asynchronous_connection_failover WHERE port=$SERVER_MYPORT_2, count, 1] = 1
191 --source include/assert.inc
192
193
194 --echo
195 --echo # 7. Clean up.
196 --echo
197 --let $rpl_connection_name= server5
198 --source include/rpl_connection.inc
199
200 SET SESSION sql_log_bin = 0;
201 call mtr.add_suppression("The source .* for channel 'ch1' has joined the group .*, and so added its entry into replication_asynchronous_connection_failover table.");
202 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.");
203 call mtr.add_suppression("The source .* for channel 'ch1' has left the group .*, and so removed its entry from replication_asynchronous_connection_failover table.");
204 call mtr.add_suppression("The group .* for the channel .* has been removed, and so removed its entry from replication_asynchronous_connection_failover_managed and all the group members from replication_asynchronous_connection_failover table.");
205 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.");
206 call mtr.add_suppression("The Monitor IO thread failed to detect if the source belongs to the group majority on the source .* for channel .*");
207 SET SESSION sql_log_bin = 1;
208
209 --let $rpl_channel_name='ch1'
210 --source include/stop_slave.inc
211
212 --let $rpl_reset_slave_all= 1
213 --let $rpl_multi_source= 1
214 --source include/rpl_reset_slave.inc
215 --let $rpl_channel_name=
216 --let $rpl_reset_slave_all=
217 --let $rpl_multi_source=
218
219 --replace_result $group_a GROUP_A
220 --eval SELECT asynchronous_connection_failover_delete_managed('ch1', '$group_a')
221
222 --replace_result $group_b GROUP_B
223 --eval SELECT asynchronous_connection_failover_delete_managed('ch1', '$group_b')
224
225 # stop all group members to avoid problems with sync_with_master.inc
226 --let $rpl_connection_name= server1
227 --source include/rpl_connection.inc
228 --source include/stop_group_replication.inc
229
230 --let $rpl_connection_name= server2
231 --source include/rpl_connection.inc
232 --source include/stop_group_replication.inc
233
234 --let $rpl_connection_name= server3
235 --source include/rpl_connection.inc
236 --source include/stop_group_replication.inc
237
238 --let $rpl_connection_name= server4
239 --source include/rpl_connection.inc
240 --source include/stop_group_replication.inc
241
242 --source include/group_replication_end.inc