Debian Codegraph @

mysql-test/suite/group_replication/include/gr_acf_membership_updates_2groups.inc

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