Debian Codegraph @

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

raw
1 ################################################################################
2 # WL #9149
3 #
4 # This test checks the basic functionality of the Group Replication
5 # performance_schema.replication_group_communication_information table.
6 #
7 # Test:
8 # 0) The test uses 2 servers: M1 and M2. Confirm the table is empty before
9 # starting Group Replication. M1 bootstraps the group in single-primary
10 # mode.
11 # 1) Confirm the preferred consensus leader is the PRIMARY.
12 # 2) Switch to multi-primary mode. Confirm everyone is a preferred consensus
13 # leader.
14 # 3) Confirm write_concurrency matches the result of
15 # group_replication_get_write_concurrency.
16 # 4) Confirm protocol_version matches the result of
17 # group_replication_get_communication_protocol.
18 # 5) Switch to single-primary mode. Switch communication_protocol to 8.0.21.
19 # Confirm everyone is a preferred consensus leader even in single-primary
20 # mode.
21 # 6) Cleanup.
22 ################################################################################
23 --source include/have_group_replication_plugin.inc
24 --let $rpl_server_count= 2
25 --let $rpl_skip_group_replication_start= 1
26 --let $rpl_group_replication_single_primary_mode= 1
27 --source include/group_replication.inc
28
29 --echo #########################################################################
30 --echo # 0) The test uses 2 servers: M1 and M2. Confirm the table is empty
31 --echo # before starting Group Replication. M1 bootstraps the group in
32 --echo # single-primary mode.
33 --let $assert_text= The performance_schema.replication_group_communication_information table should be empty
34 --let $assert_cond= "[SELECT COUNT(*) FROM performance_schema.replication_group_communication_information]" = "0"
35 --source include/assert.inc
36
37 --source include/start_and_bootstrap_group_replication.inc
38
39 --let $rpl_connection_name= server2
40 --source include/rpl_connection.inc
41
42 --source include/start_group_replication.inc
43
44 --echo ########################################################################
45 --echo # 1) Confirm the preferred consensus leader is the PRIMARY.
46 --let $preferred_leader_uuid= query_get_value(SELECT write_consensus_leaders_preferred FROM performance_schema.replication_group_communication_information, write_consensus_leaders_preferred, 1)
47 --let $primary_uuid= query_get_value(SELECT member_id FROM performance_schema.replication_group_members WHERE member_role = "PRIMARY", member_id, 1)
48 --let $assert_text= The UUID of the PRIMARY member should match the UUID of the preferred consensus leader
49 --let $assert_cond= "$primary_uuid" = "$preferred_leader_uuid"
50 --source include/assert.inc
51
52 --let $rpl_connection_name= server1
53 --source include/rpl_connection.inc
54
55 --let $preferred_leader_uuid= query_get_value(SELECT write_consensus_leaders_preferred FROM performance_schema.replication_group_communication_information, write_consensus_leaders_preferred, 1)
56 --let $primary_uuid= query_get_value(SELECT member_id FROM performance_schema.replication_group_members WHERE member_role = "PRIMARY", member_id, 1)
57 --let $assert_text= The UUID of the PRIMARY member should match the UUID of the preferred consensus leader
58 --let $assert_cond= "$primary_uuid" = "$preferred_leader_uuid"
59 --source include/assert.inc
60
61 --echo ########################################################################
62 --echo # 2) Switch to multi-primary mode, confirm everyone is a preferred
63 --echo # consensus leader.
64 SELECT group_replication_switch_to_multi_primary_mode();
65
66 --let $preferred_leader_uuids= query_get_value(SELECT write_consensus_leaders_preferred FROM performance_schema.replication_group_communication_information, write_consensus_leaders_preferred, 1)
67 --let $primary_uuid_1= query_get_value(SELECT member_id FROM performance_schema.replication_group_members WHERE member_role = "PRIMARY", member_id, 1)
68 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_group_communication_information WHERE write_consensus_leaders_preferred LIKE "%$primary_uuid_1%"
69 --source include/wait_condition_or_abort.inc
70 --let $primary_uuid_2= query_get_value(SELECT member_id FROM performance_schema.replication_group_members WHERE member_role = "PRIMARY", member_id, 2)
71 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_group_communication_information WHERE write_consensus_leaders_preferred LIKE "%$primary_uuid_2%"
72 --source include/wait_condition_or_abort.inc
73
74 --let $rpl_connection_name= server2
75 --source include/rpl_connection.inc
76
77 --let $preferred_leader_uuids= query_get_value(SELECT write_consensus_leaders_preferred FROM performance_schema.replication_group_communication_information, write_consensus_leaders_preferred, 1)
78 --let $primary_uuid_1= query_get_value(SELECT member_id FROM performance_schema.replication_group_members WHERE member_role = "PRIMARY", member_id, 1)
79 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_group_communication_information WHERE write_consensus_leaders_preferred LIKE "%$primary_uuid_1%"
80 --source include/wait_condition_or_abort.inc
81 --let $primary_uuid_2= query_get_value(SELECT member_id FROM performance_schema.replication_group_members WHERE member_role = "PRIMARY", member_id, 2)
82 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_group_communication_information WHERE write_consensus_leaders_preferred LIKE "%$primary_uuid_2%"
83 --source include/wait_condition_or_abort.inc
84
85 --let $rpl_connection_name= server1
86 --source include/rpl_connection.inc
87
88 --echo ########################################################################
89 --echo # 3) Confirm write_concurrency matches the result of
90 --echo # group_replication_get_write_concurrency.
91 --let $write_concurrency_udf= `SELECT group_replication_get_write_concurrency()`
92 --let $write_concurrency_table= query_get_value(SELECT write_concurrency FROM performance_schema.replication_group_communication_information, write_concurrency, 1)
93 --let $assert_text= write_concurrency ($write_concurrency_table) should be $write_concurrency_udf
94 --let $assert_cond= "$write_concurrency_table" = "$write_concurrency_udf"
95 --source include/assert.inc
96
97 --let $rpl_connection_name= server2
98 --source include/rpl_connection.inc
99
100 --let $write_concurrency_udf= `SELECT group_replication_get_write_concurrency()`
101 --let $write_concurrency_table= query_get_value(SELECT write_concurrency FROM performance_schema.replication_group_communication_information, write_concurrency, 1)
102 --let $assert_text= write_concurrency ($write_concurrency_table) should be $write_concurrency_udf
103 --let $assert_cond= "$write_concurrency_table" = "$write_concurrency_udf"
104 --source include/assert.inc
105
106
107 --echo ########################################################################
108 --echo # 4) Confirm protocol_version matches the result of
109 --echo # group_replication_get_communication_protocol.
110 --let $rpl_connection_name= server1
111 --source include/rpl_connection.inc
112
113 --let $communication_protocol_udf= `SELECT group_replication_get_communication_protocol()`
114 --let $communication_protocol_table= query_get_value(SELECT protocol_version FROM performance_schema.replication_group_communication_information, protocol_version, 1)
115 --let $assert_text= protocol_version ($communication_protocol_table) should be $communication_protocol_udf
116 --let $assert_cond= "$communication_protocol_table" = "$communication_protocol_udf"
117 --source include/assert.inc
118
119 --let $rpl_connection_name= server2
120 --source include/rpl_connection.inc
121
122 --let $communication_protocol_udf= `SELECT group_replication_get_communication_protocol()`
123 --let $communication_protocol_table= query_get_value(SELECT protocol_version FROM performance_schema.replication_group_communication_information, protocol_version, 1)
124 --let $assert_text= protocol_version ($communication_protocol_table) should be $communication_protocol_udf
125 --let $assert_cond= "$communication_protocol_table" = "$communication_protocol_udf"
126 --source include/assert.inc
127
128 --echo ########################################################################
129 --echo # 5) Switch to single-primary mode. Switch communication_protocol to
130 --echo # 8.0.21. Confirm everyone is a preferred consensus leader even in
131 --echo # single-primary. Must stop and start the group with
132 --echo # group_replication_paxos_single_leader=OFF
133
134 --let $rpl_connection_name= server2
135 --source include/rpl_connection.inc
136
137 --source include/stop_group_replication.inc
138 --eval SET GLOBAL group_replication_paxos_single_leader = "OFF"
139
140 --let $rpl_connection_name= server1
141 --source include/rpl_connection.inc
142
143 --source include/stop_group_replication.inc
144 --eval SET GLOBAL group_replication_paxos_single_leader = "OFF"
145
146 --source include/start_and_bootstrap_group_replication.inc
147
148 --let $rpl_connection_name= server2
149 --source include/rpl_connection.inc
150
151 --source include/start_group_replication.inc
152
153 --let $rpl_connection_name= server1
154 --source include/rpl_connection.inc
155
156 SELECT group_replication_switch_to_single_primary_mode();
157 SELECT group_replication_set_communication_protocol("8.0.21");
158
159 --let $preferred_leader_uuids= query_get_value(SELECT write_consensus_leaders_preferred FROM performance_schema.replication_group_communication_information, write_consensus_leaders_preferred, 1)
160 --let $member_uuid_1= $primary_uuid_1
161 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_group_communication_information WHERE write_consensus_leaders_preferred LIKE "%$member_uuid_1%"
162 --source include/wait_condition.inc
163 --let $member_uuid_2= $primary_uuid_2
164 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_group_communication_information WHERE write_consensus_leaders_preferred LIKE "%$member_uuid_2%"
165 --source include/wait_condition_or_abort.inc
166
167 --let $assert_only_after = CURRENT_TEST: group_replication.gr_perfschema_group_communication_information
168 --let $assert_file= $MYSQLTEST_VARDIR/log/mysqld.1.err
169 --let $assert_select= A member is joining the group while a group configuration operation is occurring. The member will now leave the group
170 --let $assert_count= 0
171 --let $assert_text= There is no warning about a member joining the group while a group configuration operation is occurring
172 --source include/assert_grep.inc
173
174 --let $rpl_connection_name= server2
175 --source include/rpl_connection.inc
176
177 --let $preferred_leader_uuids= query_get_value(SELECT write_consensus_leaders_preferred FROM performance_schema.replication_group_communication_information, write_consensus_leaders_preferred, 1)
178 --let $member_uuid_1= $primary_uuid_1
179 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_group_communication_information WHERE write_consensus_leaders_preferred LIKE "%$member_uuid_1%"
180 --source include/wait_condition_or_abort.inc
181 --let $member_uuid_2= $primary_uuid_2
182 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_group_communication_information WHERE write_consensus_leaders_preferred LIKE "%$member_uuid_2%"
183 --source include/wait_condition_or_abort.inc
184
185 --let $assert_only_after = CURRENT_TEST: group_replication.gr_perfschema_group_communication_information
186 --let $assert_file= $MYSQLTEST_VARDIR/log/mysqld.2.err
187 --let $assert_select= A member is joining the group while a group configuration operation is occurring. The member will now leave the group
188 --let $assert_count= 0
189 --let $assert_text= There is no warning about a member joining the group while a group configuration operation is occurring
190 --source include/assert_grep.inc
191
192 --echo ########################################################################
193 --echo # 6) Cleanup.
194
195 --let $rpl_connection_name= server2
196 --source include/rpl_connection.inc
197 --eval SET GLOBAL group_replication_paxos_single_leader = "ON"
198
199 --let $rpl_connection_name= server1
200 --source include/rpl_connection.inc
201 --eval SET GLOBAL group_replication_paxos_single_leader = "ON"
202
203 --let $rpl_group_replication_reset_persistent_vars= 1
204 --source include/group_replication_end.inc