Debian Codegraph @

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

raw
1 ################################################################################
2 # Test to verify the value of WRITE_CONSENSUS_SINGLE_LEADER_CAPABLE in
3 # performance_schema.replication_group_communication_information
4 #
5 # Test:
6 # ====
7 # 1. Start GR group with 3 servers.
8 # 2. Value of WRITE_CONSENSUS_SINGLE_LEADER_CAPABLE is 0 on all servers.
9 # 3. Change the value of group_replication_paxos_single_leader to 1
10 # on all servers and restart GR.
11 # 4. Value of WRITE_CONSENSUS_SINGLE_LEADER_CAPABLE is 1 on all servers.
12 # 5. Switch to single-primary mode.
13 # 6. Value of WRITE_CONSENSUS_SINGLE_LEADER_CAPABLE is 1 on all servers.
14 # 7. Change value of group_replication_paxos_single_leader to 1 on 2 servers.
15 # 8. Value of WRITE_CONSENSUS_SINGLE_LEADER_CAPABLE is 1 on all servers.
16 # 9. Change communication protocol to 8.0.21.
17 # 10. Value of WRITE_CONSENSUS_SINGLE_LEADER_CAPABLE is 0 on all servers.
18 # 11. Switch to multi-primary mode.
19 # 12. Value of WRITE_CONSENSUS_SINGLE_LEADER_CAPABLE is 0 on all servers.
20 # 13. Change communication protocol to 8.0.27.
21 # 14. Value of WRITE_CONSENSUS_SINGLE_LEADER_CAPABLE is 1 on all servers.
22 # 15. Cleanup
23 #
24 ################################################################################
25 --source include/big_test.inc
26 --source include/have_group_replication_plugin.inc
27
28 # 1. Start GR group with 3 servers
29 --let $rpl_server_count = 3
30 --source include/group_replication.inc
31
32 # 2. Value of WRITE_CONSENSUS_SINGLE_LEADER_CAPABLE is 0 on all servers.
33 --let $single_leader_capable = 0
34 --source include/gr_assert_write_consensus_single_leader_capable.inc
35
36 # 3. Change the value of group_replication_paxos_single_leader to 1
37 # on all servers and restart GR.
38 --let $rpl_connection_name= server3
39 --source include/rpl_connection.inc
40 --source include/stop_group_replication.inc
41
42 --let $rpl_connection_name= server2
43 --source include/rpl_connection.inc
44 --source include/stop_group_replication.inc
45
46 --let $rpl_connection_name= server1
47 --source include/rpl_connection.inc
48 --source include/stop_group_replication.inc
49 SET GLOBAL group_replication_paxos_single_leader = 1;
50 --source include/start_and_bootstrap_group_replication.inc
51
52 --let $rpl_connection_name= server2
53 --source include/rpl_connection.inc
54 SET GLOBAL group_replication_paxos_single_leader = 1;
55 --source include/start_group_replication.inc
56
57 --let $rpl_connection_name= server3
58 --source include/rpl_connection.inc
59 SET GLOBAL group_replication_paxos_single_leader = 1;
60 --source include/start_group_replication.inc
61
62 # 4. Value of WRITE_CONSENSUS_SINGLE_LEADER_CAPABLE is 1 on all servers.
63 --let $single_leader_capable = 1
64 --source include/gr_assert_write_consensus_single_leader_capable.inc
65
66 # 5. Switch to single-primary mode.
67 SELECT group_replication_switch_to_single_primary_mode();
68
69 # 6. Value of WRITE_CONSENSUS_SINGLE_LEADER_CAPABLE is 1 on all servers.
70 --let $single_leader_capable = 1
71 --source include/gr_assert_write_consensus_single_leader_capable.inc
72
73 # 7. Change value of group_replication_paxos_single_leader to 1 on 2 servers.
74 --let $rpl_connection_name= server2
75 --source include/rpl_connection.inc
76 SET GLOBAL group_replication_paxos_single_leader = 0;
77
78 --let $rpl_connection_name= server3
79 --source include/rpl_connection.inc
80 SET GLOBAL group_replication_paxos_single_leader = 0;
81
82 # 8. Value of WRITE_CONSENSUS_SINGLE_LEADER_CAPABLE is 1 on all servers.
83 --let $single_leader_capable = 1
84 --source include/gr_assert_write_consensus_single_leader_capable.inc
85
86 # 9. Change communication protocol to 8.0.21. Must change
87 # group_replication_paxos_single_leader to OFF
88
89 --let $rpl_connection_name= server3
90 --source include/rpl_connection.inc
91
92 --source include/stop_group_replication.inc
93 --eval SET GLOBAL group_replication_paxos_single_leader = "OFF"
94
95 --let $rpl_connection_name= server2
96 --source include/rpl_connection.inc
97
98 --source include/stop_group_replication.inc
99 --eval SET GLOBAL group_replication_paxos_single_leader = "OFF"
100
101 --let $rpl_connection_name= server1
102 --source include/rpl_connection.inc
103
104 --source include/stop_group_replication.inc
105 --eval SET GLOBAL group_replication_paxos_single_leader = "OFF"
106
107 --source include/start_and_bootstrap_group_replication.inc
108
109 --let $rpl_connection_name= server2
110 --source include/rpl_connection.inc
111
112 --source include/start_group_replication.inc
113
114 --let $rpl_connection_name= server3
115 --source include/rpl_connection.inc
116
117 --source include/start_group_replication.inc
118
119 SELECT group_replication_set_communication_protocol("8.0.21");
120
121 # 10. Value of WRITE_CONSENSUS_SINGLE_LEADER_CAPABLE is 0 on all servers.
122 --let $single_leader_capable = 0
123 --source include/gr_assert_write_consensus_single_leader_capable.inc
124
125 # 11. Switch to multi-primary mode.
126 SELECT group_replication_switch_to_multi_primary_mode();
127
128 # 12. Value of WRITE_CONSENSUS_SINGLE_LEADER_CAPABLE is 0 on all servers.
129 --let $single_leader_capable = 0
130 --source include/gr_assert_write_consensus_single_leader_capable.inc
131
132 # 13. Change communication protocol to 8.0.27.
133 SELECT group_replication_set_communication_protocol("8.0.27");
134
135 --let $rpl_connection_name= server3
136 --source include/rpl_connection.inc
137
138 --source include/stop_group_replication.inc
139 --eval SET GLOBAL group_replication_paxos_single_leader = "ON"
140
141 --let $rpl_connection_name= server2
142 --source include/rpl_connection.inc
143
144 --source include/stop_group_replication.inc
145 --eval SET GLOBAL group_replication_paxos_single_leader = "ON"
146
147 --let $rpl_connection_name= server1
148 --source include/rpl_connection.inc
149
150 --source include/stop_group_replication.inc
151 --eval SET GLOBAL group_replication_paxos_single_leader = "ON"
152
153 --source include/start_and_bootstrap_group_replication.inc
154
155 --let $rpl_connection_name= server2
156 --source include/rpl_connection.inc
157
158 --source include/start_group_replication.inc
159
160 --let $rpl_connection_name= server3
161 --source include/rpl_connection.inc
162
163 --source include/start_group_replication.inc
164
165 # 14. Value of WRITE_CONSENSUS_SINGLE_LEADER_CAPABLE is 1 on all servers.
166 --let $single_leader_capable = 1
167 --source include/gr_assert_write_consensus_single_leader_capable.inc
168
169 # Cleanup
170
171 # Change the value to 0 in all servers and restart GR.
172
173 --let $rpl_connection_name= server3
174 --source include/rpl_connection.inc
175 --source include/stop_group_replication.inc
176 SET GLOBAL group_replication_paxos_single_leader = 0;
177
178 --let $rpl_connection_name= server2
179 --source include/rpl_connection.inc
180 --source include/stop_group_replication.inc
181 SET GLOBAL group_replication_paxos_single_leader = 0;
182
183 --let $rpl_connection_name= server1
184 --source include/rpl_connection.inc
185 --source include/stop_group_replication.inc
186 SET GLOBAL group_replication_paxos_single_leader = 0;
187
188 --let $rpl_group_replication_reset_persistent_vars= 1
189 --source include/group_replication_end.inc