Debian Codegraph @

mysql-test/suite/rpl/t/rpl_connection_compression_configuration.test

raw
1 # ==== Requirements ====
2 #
3 # R1: Test configuration of compression algorithm and level for new channel.
4 # 1. ALGORITHM set to different combination of zlib,zstd,uncompressed
5 # 2. ALGORITHM set to different combination of zlib,zstd,uncompressed and
6 # LEVEL set to different values.
7 # 3. ALGORITHM set to invalid values.
8 # 4. ALGORITHM set to invalid values and LEVEL set to different values.
9 # 5. ALGORITHM and LEVEL not specified.
10 # 6. ALGORITHM specified and LEVEL not specified.
11 # 7. ALGORITHM not specified and LEVEL specified.
12 #
13 # R2: Test configuration of compression algorithm and level for existing
14 # channel.
15 # 1. ALGORITHM set to different combination of zlib,zstd,uncompressed which
16 # is different from its previous value.
17 # 2. ALGORITHM set to different combination of zlib,zstd,uncompressed which
18 # is different from its previous value and LEVEL set to different values.
19 # 3. ALGORITHM changed to invalid values.
20 # 4. ALGORITHM changed to invalid values and LEVEL set to different values.
21 # 5. ALGORITHM and LEVEL not specified.
22 # 6. ALGORITHM specified and LEVEL not specified.
23 # 7. ALGORITHM not specified and LEVEL specified.
24 #
25 # ==== References ====
26 #
27 # WL#12475 - Protocol Changes to specify compression configuration for
28 # connections
29
30 --source include/master-slave.inc
31 --source include/rpl_connection_slave.inc
32 # Test requires master-info-repository=TABLE, relay-log-info-repository=TABLE
33 --source include/have_slave_repository_type_table.inc
34
35 --echo ##### TEST FOR NEW CHANNEL #####
36
37 --echo # case 1: ALGORITHM = uncompressed, LEVEL not specified
38 --replace_result $MASTER_MYPORT MASTER_PORT
39 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS='uncompressed', SOURCE_ZSTD_COMPRESSION_LEVEL= 0 FOR CHANNEL 'C1';
40 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C1';
41 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C1';
42
43 --echo # case 2: ALGORITHM = uncompressed, LEVEL = 2
44 --replace_result $MASTER_MYPORT MASTER_PORT
45 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS='uncompressed', SOURCE_ZSTD_COMPRESSION_LEVEL= 2 FOR CHANNEL 'C2';
46 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C2';
47 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C2';
48
49 --echo # case 3: ALGORITHM not specified, LEVEL = 2
50 --replace_result $MASTER_MYPORT MASTER_PORT
51 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_ZSTD_COMPRESSION_LEVEL= 2 FOR CHANNEL 'C3';
52 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C3';
53 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C3';
54
55 --echo # case 4: ALGORITHM = ZSTD, LEVEL = not specified
56 --replace_result $MASTER_MYPORT MASTER_PORT
57 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS='zstd' FOR CHANNEL 'C4';
58 --echo # algorithm and level should be set to zstd and 0
59 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C4';
60 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C4';
61
62 --echo # case 5: ALGORITHM = ZSTD, LEVEL = 9
63 --echo # report error as part of change master
64 --replace_result $MASTER_MYPORT MASTER_PORT
65 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS='zstd', SOURCE_ZSTD_COMPRESSION_LEVEL= 9 FOR CHANNEL 'C5';
66 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C5';
67 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C5';
68
69 --echo # case 6: ALGORITHM = ZSTD, LEVEL = 24
70 --replace_result $MASTER_MYPORT MASTER_PORT
71 --error ER_CHANGE_SOURCE_WRONG_COMPRESSION_LEVEL_CLIENT
72 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS='zstd', SOURCE_ZSTD_COMPRESSION_LEVEL= 24 FOR CHANNEL 'C6';
73 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C6';
74 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C6';
75
76 --echo # case 7: ALGORITHM = invalid value, LEVEL = 2
77 --echo # report error as part of change master
78 --replace_result $MASTER_MYPORT MASTER_PORT
79 --error ER_CHANGE_SOURCE_WRONG_COMPRESSION_ALGORITHM_CLIENT
80 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS='xyz', SOURCE_ZSTD_COMPRESSION_LEVEL= 2 FOR CHANNEL 'C7';
81 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C7';
82 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C7';
83
84 --echo # case 8: ALGORITHM = invalid value, LEVEL = 29
85 --echo # report error as part of change master
86 --replace_result $MASTER_MYPORT MASTER_PORT
87 --error ER_CHANGE_SOURCE_WRONG_COMPRESSION_ALGORITHM_CLIENT
88 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS='xyz', SOURCE_ZSTD_COMPRESSION_LEVEL= 29 FOR CHANNEL 'C8';
89 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C8';
90 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C8';
91
92 --echo # case 9: ALGORITHM = invalid value, LEVEL not specified
93 --echo # report error as part of change master
94 --replace_result $MASTER_MYPORT MASTER_PORT
95 --error ER_CHANGE_SOURCE_WRONG_COMPRESSION_ALGORITHM_CLIENT
96 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS='xyz' FOR CHANNEL 'C9';
97 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C9';
98 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C9';
99
100 --echo # case 10: ALGORITHM = invalid value
101 --echo # report error as part of change master
102 --replace_result $MASTER_MYPORT MASTER_PORT
103 --error ER_CHANGE_SOURCE_WRONG_COMPRESSION_ALGORITHM_CLIENT
104 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS= 'zlib,zstd,abc' FOR CHANNEL 'C10';
105 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C10';
106 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C10';
107
108 --echo # case 11: ALGORITHM specified to more than 3 values
109 --echo # report error as part of change master
110 --replace_result $MASTER_MYPORT MASTER_PORT
111 --error ER_CHANGE_SOURCE_WRONG_COMPRESSION_ALGORITHM_LIST_CLIENT
112 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS= 'zlib,zstd,abc,123' FOR CHANNEL 'C11';
113 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C11';
114 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C11';
115
116 --echo # case 12: ALGORITHM specified to upper case, LEVEL not specified
117 --replace_result $MASTER_MYPORT MASTER_PORT
118 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root',SOURCE_COMPRESSION_ALGORITHMS= 'ZLIB,ZSTD' FOR CHANNEL 'C12';
119 --echo # algorithm and level should be set to ZLIB,ZSTD/0
120 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C12';
121 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C12';
122
123 --echo # case 13: ALGORITHM = 'zlib,uncompressed', LEVEL not specified
124 --replace_result $MASTER_MYPORT MASTER_PORT
125 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS='zlib,uncompressed' FOR CHANNEL 'C13';
126 --echo # algorithm and level should be set to 'zlib,uncompressed'/0
127 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C13';
128 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C13';
129
130 --echo # case 14: ALGORITHM = 'zlib,uncompressed', LEVEL = 4
131 --replace_result $MASTER_MYPORT MASTER_PORT
132 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS='zlib,uncompressed', SOURCE_ZSTD_COMPRESSION_LEVEL=4 FOR CHANNEL 'C14';
133 --echo # algorithm and level should be set to 'zlib,uncompressed'/4
134 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C14';
135 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C14';
136
137 --echo # case 15: ALGORITHM = 'zlib,uncompressed,zstd', LEVEL = 0
138 --replace_result $MASTER_MYPORT MASTER_PORT
139 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS='zlib,uncompressed,zstd', SOURCE_ZSTD_COMPRESSION_LEVEL=0 FOR CHANNEL 'C15';
140 --echo # algorithm and level should be set to 'zlib,uncompressed,zstd'/0
141 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C15';
142 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C15';
143
144 --echo # case 16: ALGORITHM = 'uncompressed,zstd', LEVEL = 14
145 --replace_result $MASTER_MYPORT MASTER_PORT
146 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS='uncompressed,zstd', SOURCE_ZSTD_COMPRESSION_LEVEL=14 FOR CHANNEL 'C16';
147 --echo # algorithm and level should be set to 'uncompressed,zstd'/14
148 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C16';
149 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C16';
150
151 --echo # case 17: ALGORITHM = 'zlib,uncompressed,zlib', LEVEL = 14
152 --replace_result $MASTER_MYPORT MASTER_PORT
153 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS='zlib,uncompressed,zlib', SOURCE_ZSTD_COMPRESSION_LEVEL=14 FOR CHANNEL 'C17';
154 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C17';
155 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C17';
156
157 --echo # case 18: ALGORITHM = 'uncompressed,uncompressed,uncompressed', LEVEL = 14
158 --replace_result $MASTER_MYPORT MASTER_PORT
159 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS='uncompressed,uncompressed,uncompressed', SOURCE_ZSTD_COMPRESSION_LEVEL=14 FOR CHANNEL 'C17';
160 --echo # algorithm and level should be set to 'uncompressed,uncompressed,uncompressed'/14
161 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C17';
162 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C17';
163
164 --echo # case 19: ALGORITHM = 'zstd,zlib,uncompressed', LEVEL = 2
165 --replace_result $MASTER_MYPORT MASTER_PORT
166 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS='zstd,zlib,uncompressed', SOURCE_ZSTD_COMPRESSION_LEVEL=2 FOR CHANNEL 'C17';
167 --echo # algorithm and level should be set to 'zstd,zlib,uncompressed'/2
168 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C17';
169 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C17';
170
171 --echo ##### TEST FOR EXISTING CHANNEL #####
172 --echo # create a new channel
173
174 --replace_result $MASTER_MYPORT MASTER_PORT
175 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS='zstd', SOURCE_ZSTD_COMPRESSION_LEVEL= 2 FOR CHANNEL 'C21';
176 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C21';
177 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C21';
178
179 --echo # case 1: ALGORITHM not specified, LEVEL = 7
180 --replace_result $MASTER_MYPORT MASTER_PORT
181 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_ZSTD_COMPRESSION_LEVEL = 7 FOR CHANNEL 'C21';
182 --echo # algorithm and level should be set to 'zstd'/7
183 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C21';
184 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C21';
185
186 --echo # case 2: ALGORITHM not specified, LEVEL 37
187 --replace_result $MASTER_MYPORT MASTER_PORT
188 --error ER_CHANGE_SOURCE_WRONG_COMPRESSION_LEVEL_CLIENT
189 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_ZSTD_COMPRESSION_LEVEL = 37 FOR CHANNEL 'C21';
190 --echo # level should be same as previous which is 7
191 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C21';
192 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C21';
193
194 --echo # case 3: ALGORITHM not specified, LEVEL is not specified
195 --replace_result $MASTER_MYPORT MASTER_PORT
196 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root' FOR CHANNEL 'C21';
197 --echo # algorithm and level should not change
198 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C21';
199 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C21';
200
201 --echo # case 4: ALGORITHM changed from zstd to zlib, LEVEL = 6
202 --replace_result $MASTER_MYPORT MASTER_PORT
203 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS='zlib', SOURCE_ZSTD_COMPRESSION_LEVEL = 6 FOR CHANNEL 'C21';
204 --echo # level should be 6 and algorithm should be zlib
205 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C21';
206 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C21';
207
208 --echo # case 5: ALGORITHM changed from zlib to zstd/uncompressed, LEVEL = 27
209 --replace_result $MASTER_MYPORT MASTER_PORT
210 --error ER_CHANGE_SOURCE_WRONG_COMPRESSION_LEVEL_CLIENT
211 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS='zlib,uncompressed', SOURCE_ZSTD_COMPRESSION_LEVEL = 27 FOR CHANNEL 'C21';
212 --echo # level should be 6 and algorithm should be zlib
213 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C21';
214 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C21';
215
216
217 --echo # case 6: ALGORITHM changed from zstd to zlib, LEVEL not specified
218 --replace_result $MASTER_MYPORT MASTER_PORT
219 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS='zlib' FOR CHANNEL 'C21';
220 --echo # level should not change
221 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C21';
222 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C21';
223
224 --echo # case 7: ALGORITHM = invalid values, LEVEL = 6
225 --replace_result $MASTER_MYPORT MASTER_PORT
226 --error ER_CHANGE_SOURCE_WRONG_COMPRESSION_ALGORITHM_CLIENT
227 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS='xyz', SOURCE_ZSTD_COMPRESSION_LEVEL = 6 FOR CHANNEL 'C21';
228
229 --echo # case 8: ALGORITHM = invalid values, LEVEL = 26
230 --replace_result $MASTER_MYPORT MASTER_PORT
231 --error ER_CHANGE_SOURCE_WRONG_COMPRESSION_ALGORITHM_CLIENT
232 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS='xyz', SOURCE_ZSTD_COMPRESSION_LEVEL = 26 FOR CHANNEL 'C21';
233
234 --echo # case 9: ALGORITHM = invalid values, LEVEL is not specified
235 --replace_result $MASTER_MYPORT MASTER_PORT
236 --error ER_CHANGE_SOURCE_WRONG_COMPRESSION_ALGORITHM_CLIENT
237 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS='xyz' FOR CHANNEL 'C21';
238
239 --echo # case 10: ALGORITHM changed from zlib to 'zstd,zlib,uncompressed', LEVEL is not specified
240 --replace_result $MASTER_MYPORT MASTER_PORT
241 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS='zstd,zlib,uncompressed' FOR CHANNEL 'C21';
242 --echo # level should be 0 and algorithm should be 'zstd,zlib,uncompressed' and warning is reported
243 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C21';
244 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C21';
245
246 --echo # case 11: ALGORITHM changed from 'zstd,zlib,uncompressed' to 'zstd', LEVEL = 3
247 --replace_result $MASTER_MYPORT MASTER_PORT
248 eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$MASTER_MYPORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS='zstd', SOURCE_ZSTD_COMPRESSION_LEVEL = 3 FOR CHANNEL 'C21';
249 --echo # level should be 3 and algorithm should be 'zstd'
250 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C21';
251 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C21';
252
253 --echo
254 --echo # cleanup
255 --echo
256 --source include/stop_slave.inc
257 RESET SLAVE ALL FOR CHANNEL 'c1';
258 RESET SLAVE ALL FOR CHANNEL 'c10';
259 RESET SLAVE ALL FOR CHANNEL 'c11';
260 RESET SLAVE ALL FOR CHANNEL 'c12';
261 RESET SLAVE ALL FOR CHANNEL 'c13';
262 RESET SLAVE ALL FOR CHANNEL 'c14';
263 RESET SLAVE ALL FOR CHANNEL 'c15';
264 RESET SLAVE ALL FOR CHANNEL 'c16';
265 RESET SLAVE ALL FOR CHANNEL 'c17';
266 RESET SLAVE ALL FOR CHANNEL 'c2';
267 RESET SLAVE ALL FOR CHANNEL 'c21';
268 RESET SLAVE ALL FOR CHANNEL 'c3';
269 RESET SLAVE ALL FOR CHANNEL 'c4';
270 RESET SLAVE ALL FOR CHANNEL 'c5';
271 RESET SLAVE ALL FOR CHANNEL 'c6';
272 RESET SLAVE ALL FOR CHANNEL 'c7';
273 RESET SLAVE ALL FOR CHANNEL 'c8';
274 RESET SLAVE ALL FOR CHANNEL 'c9';
275
276 --source include/start_slave.inc
277 --source include/rpl_end.inc