Debian Codegraph @

mysql-test/suite/rpl/r/rpl_connection_compression.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 #### Initialize ####
7 SET sql_log_bin = 0;
8 CREATE TABLE algorithms (
9 id INT AUTO_INCREMENT PRIMARY KEY,
10 name TEXT NOT NULL);
11 INSERT INTO algorithms(name) VALUES
12 ('default'),
13 ('zlib'),
14 ('zstd'),
15 ('uncompressed'),
16 ('zlib,zstd'),
17 ('zlib,uncompressed'),
18 ('zstd,uncompressed'),
19 ('zlib,zstd,uncompressed');
20 CREATE TABLE levels (
21 id INT AUTO_INCREMENT PRIMARY KEY COMMENT 'order in which to set option',
22 level TEXT NOT NULL COMMENT 'compression level',
23 position INT NOT NULL COMMENT 'expected ordinal position of achieved compression'
24 );
25 INSERT INTO levels(level, position) VALUES
26 # ('1', 1),
27 #('2', 2),
28 ('default', 3),
29 #('3', 3),
30 #('13', 4),
31 ('22', 5);
32 CREATE FUNCTION set_intersection(set1 TEXT, set2 TEXT) RETURNS TEXT BEGIN
33 DECLARE ret TEXT DEFAULT '';
34 DECLARE elem TEXT;
35 WHILE set1 != '' DO
36 SET elem = SUBSTRING_INDEX(set1, ',', 1);
37 IF FIND_IN_SET(elem, set2) THEN
38 SET ret = sys.list_add(ret, elem);
39 SET set2 = sys.list_drop(set2, elem);
40 END IF;
41 SET set1 = sys.list_drop(set1, elem);
42 END WHILE;
43 RETURN ret;
44 END|
45 SET sql_log_bin = 1;
46 CREATE TABLE t (a LONGTEXT);
47 INSERT INTO t VALUES (REPEAT('a', 1000000));
48 #### Test ####
49 [connection master]
50 ==== master:default ====
51 [connection master]
52 SET @@global.protocol_compression_algorithms = DEFAULT;
53 SET @@global.protocol_compression_algorithms = 'zlib,zstd,uncompressed';
54 SELECT @@global.protocol_compression_algorithms;
55 @@global.protocol_compression_algorithms
56 zlib,zstd,uncompressed
57 [connection master]
58 [connection slave]
59 [connection master]
60 ---- master:zlib,zstd,uncompressed slave:default slave_option:0 expected:uncompressed ----
61 SET @@global.replica_compressed_protocol = 0;
62 START SLAVE IO_THREAD
63 include/assert.inc [More than 1000000 bytes should be sent uncompressed]
64 Warnings:
65 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
66 ---- master:zlib,zstd,uncompressed slave:default slave_option:1 expected:zlib ----
67 SET @@global.replica_compressed_protocol = 1;
68 START SLAVE IO_THREAD
69 include/assert.inc [Less than 1000000 bytes should be sent compressed]
70 Warnings:
71 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
72 ---- master:zlib,zstd,uncompressed slave:zlib slave_option:0 expected:zlib ----
73 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zlib';
74 SET @@global.replica_compressed_protocol = 0;
75 START SLAVE IO_THREAD
76 include/assert.inc [Less than 1000000 bytes should be sent compressed]
77 Warnings:
78 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
79 ---- master:zlib,zstd,uncompressed slave:zstd slave_option:0 expect:zstd level:default ----
80 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zstd';
81 SET @@global.replica_compressed_protocol = 0;
82 START SLAVE IO_THREAD
83 include/assert.inc [Less than 1000000 bytes should be sent compressed]
84 Warnings:
85 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
86 ---- master:zlib,zstd,uncompressed slave:zstd slave_option:0 expect:zstd level:22 ----
87 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zstd';
88 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
89 SET @@global.replica_compressed_protocol = 0;
90 START SLAVE IO_THREAD
91 include/assert.inc [Less than 1000000 bytes should be sent compressed]
92 Warnings:
93 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
94 include/assert.inc [Compression ratio should be better than previous algorithm]
95 ---- master:zlib,zstd,uncompressed slave:uncompressed slave_option:0 expected:uncompressed ----
96 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'uncompressed';
97 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
98 SET @@global.replica_compressed_protocol = 0;
99 START SLAVE IO_THREAD
100 include/assert.inc [More than 1000000 bytes should be sent uncompressed]
101 Warnings:
102 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
103 ---- master:zlib,zstd,uncompressed slave:uncompressed slave_option:1 expected:zlib ----
104 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'uncompressed';
105 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
106 SET @@global.replica_compressed_protocol = 1;
107 START SLAVE IO_THREAD
108 include/assert.inc [Less than 1000000 bytes should be sent compressed]
109 Warnings:
110 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
111 ---- master:zlib,zstd,uncompressed slave:zlib,zstd slave_option:0 expected:zlib ----
112 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zlib,zstd';
113 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
114 SET @@global.replica_compressed_protocol = 0;
115 START SLAVE IO_THREAD
116 include/assert.inc [Less than 1000000 bytes should be sent compressed]
117 Warnings:
118 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
119 ---- master:zlib,zstd,uncompressed slave:zlib,uncompressed slave_option:0 expected:zlib ----
120 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zlib,uncompressed';
121 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
122 SET @@global.replica_compressed_protocol = 0;
123 START SLAVE IO_THREAD
124 include/assert.inc [Less than 1000000 bytes should be sent compressed]
125 Warnings:
126 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
127 ---- master:zlib,zstd,uncompressed slave:zstd,uncompressed slave_option:0 expect:zstd level:default ----
128 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zstd,uncompressed';
129 SET @@global.replica_compressed_protocol = 0;
130 START SLAVE IO_THREAD
131 include/assert.inc [Less than 1000000 bytes should be sent compressed]
132 Warnings:
133 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
134 ---- master:zlib,zstd,uncompressed slave:zstd,uncompressed slave_option:0 expect:zstd level:22 ----
135 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zstd,uncompressed';
136 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
137 SET @@global.replica_compressed_protocol = 0;
138 START SLAVE IO_THREAD
139 include/assert.inc [Less than 1000000 bytes should be sent compressed]
140 Warnings:
141 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
142 include/assert.inc [Compression ratio should be better than previous algorithm]
143 ---- master:zlib,zstd,uncompressed slave:zlib,zstd,uncompressed slave_option:0 expected:zlib ----
144 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zlib,zstd,uncompressed';
145 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
146 SET @@global.replica_compressed_protocol = 0;
147 START SLAVE IO_THREAD
148 include/assert.inc [Less than 1000000 bytes should be sent compressed]
149 Warnings:
150 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
151 ==== master:zlib ====
152 SET @@global.protocol_compression_algorithms = 'zlib';
153 SELECT @@global.protocol_compression_algorithms;
154 @@global.protocol_compression_algorithms
155 zlib
156 ---- master:zlib slave:default slave_option:0 expect:error ----
157 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
158 SET @@global.replica_compressed_protocol = 0;
159 START SLAVE IO_THREAD;
160 Warnings:
161 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
162 got error
163 RESET SLAVE ALL;
164 Warnings:
165 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
166 ---- master:zlib slave:default slave_option:1 expected:zlib ----
167 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
168 SET @@global.replica_compressed_protocol = 1;
169 START SLAVE IO_THREAD
170 include/assert.inc [Less than 1000000 bytes should be sent compressed]
171 Warnings:
172 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
173 ---- master:zlib slave:zlib slave_option:0 expected:zlib ----
174 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zlib';
175 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
176 SET @@global.replica_compressed_protocol = 0;
177 START SLAVE IO_THREAD
178 include/assert.inc [Less than 1000000 bytes should be sent compressed]
179 Warnings:
180 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
181 ---- master:zlib slave:zstd slave_option:0 expect:error ----
182 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zstd';
183 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
184 SET @@global.replica_compressed_protocol = 0;
185 START SLAVE IO_THREAD;
186 Warnings:
187 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
188 got error
189 RESET SLAVE ALL;
190 Warnings:
191 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
192 ---- master:zlib slave:uncompressed slave_option:0 expect:error ----
193 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'uncompressed';
194 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
195 SET @@global.replica_compressed_protocol = 0;
196 START SLAVE IO_THREAD;
197 Warnings:
198 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
199 got error
200 RESET SLAVE ALL;
201 Warnings:
202 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
203 ---- master:zlib slave:uncompressed slave_option:1 expected:zlib ----
204 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'uncompressed';
205 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
206 SET @@global.replica_compressed_protocol = 1;
207 START SLAVE IO_THREAD
208 include/assert.inc [Less than 1000000 bytes should be sent compressed]
209 Warnings:
210 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
211 ---- master:zlib slave:zlib,zstd slave_option:0 expected:zlib ----
212 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zlib,zstd';
213 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
214 SET @@global.replica_compressed_protocol = 0;
215 START SLAVE IO_THREAD
216 include/assert.inc [Less than 1000000 bytes should be sent compressed]
217 Warnings:
218 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
219 ---- master:zlib slave:zlib,uncompressed slave_option:0 expected:zlib ----
220 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zlib,uncompressed';
221 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
222 SET @@global.replica_compressed_protocol = 0;
223 START SLAVE IO_THREAD
224 include/assert.inc [Less than 1000000 bytes should be sent compressed]
225 Warnings:
226 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
227 ---- master:zlib slave:zstd,uncompressed slave_option:0 expect:error ----
228 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zstd,uncompressed';
229 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
230 SET @@global.replica_compressed_protocol = 0;
231 START SLAVE IO_THREAD;
232 Warnings:
233 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
234 got error
235 RESET SLAVE ALL;
236 Warnings:
237 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
238 ---- master:zlib slave:zlib,zstd,uncompressed slave_option:0 expected:zlib ----
239 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zlib,zstd,uncompressed';
240 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
241 SET @@global.replica_compressed_protocol = 0;
242 START SLAVE IO_THREAD
243 include/assert.inc [Less than 1000000 bytes should be sent compressed]
244 Warnings:
245 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
246 ==== master:zstd ====
247 SET @@global.protocol_compression_algorithms = 'zstd';
248 SELECT @@global.protocol_compression_algorithms;
249 @@global.protocol_compression_algorithms
250 zstd
251 ---- master:zstd slave:default slave_option:0 expect:error ----
252 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
253 SET @@global.replica_compressed_protocol = 0;
254 START SLAVE IO_THREAD;
255 Warnings:
256 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
257 got error
258 RESET SLAVE ALL;
259 Warnings:
260 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
261 ---- master:zstd slave:default slave_option:1 expect:error ----
262 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
263 SET @@global.replica_compressed_protocol = 1;
264 START SLAVE IO_THREAD;
265 Warnings:
266 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
267 got error
268 RESET SLAVE ALL;
269 Warnings:
270 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
271 ---- master:zstd slave:zlib slave_option:0 expect:error ----
272 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zlib';
273 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
274 SET @@global.replica_compressed_protocol = 0;
275 START SLAVE IO_THREAD;
276 Warnings:
277 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
278 got error
279 RESET SLAVE ALL;
280 Warnings:
281 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
282 ---- master:zstd slave:zstd slave_option:0 expect:zstd level:default ----
283 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zstd';
284 SET @@global.replica_compressed_protocol = 0;
285 START SLAVE IO_THREAD
286 include/assert.inc [Less than 1000000 bytes should be sent compressed]
287 Warnings:
288 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
289 ---- master:zstd slave:zstd slave_option:0 expect:zstd level:22 ----
290 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zstd';
291 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
292 SET @@global.replica_compressed_protocol = 0;
293 START SLAVE IO_THREAD
294 include/assert.inc [Less than 1000000 bytes should be sent compressed]
295 Warnings:
296 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
297 include/assert.inc [Compression ratio should be better than previous algorithm]
298 ---- master:zstd slave:uncompressed slave_option:0 expect:error ----
299 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'uncompressed';
300 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
301 SET @@global.replica_compressed_protocol = 0;
302 START SLAVE IO_THREAD;
303 Warnings:
304 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
305 got error
306 RESET SLAVE ALL;
307 Warnings:
308 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
309 ---- master:zstd slave:uncompressed slave_option:1 expect:error ----
310 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'uncompressed';
311 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
312 SET @@global.replica_compressed_protocol = 1;
313 START SLAVE IO_THREAD;
314 Warnings:
315 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
316 got error
317 RESET SLAVE ALL;
318 Warnings:
319 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
320 ---- master:zstd slave:zlib,zstd slave_option:0 expect:zstd level:default ----
321 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zlib,zstd';
322 SET @@global.replica_compressed_protocol = 0;
323 START SLAVE IO_THREAD
324 include/assert.inc [Less than 1000000 bytes should be sent compressed]
325 Warnings:
326 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
327 ---- master:zstd slave:zlib,zstd slave_option:0 expect:zstd level:22 ----
328 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zlib,zstd';
329 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
330 SET @@global.replica_compressed_protocol = 0;
331 START SLAVE IO_THREAD
332 include/assert.inc [Less than 1000000 bytes should be sent compressed]
333 Warnings:
334 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
335 include/assert.inc [Compression ratio should be better than previous algorithm]
336 ---- master:zstd slave:zlib,uncompressed slave_option:0 expect:error ----
337 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zlib,uncompressed';
338 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
339 SET @@global.replica_compressed_protocol = 0;
340 START SLAVE IO_THREAD;
341 Warnings:
342 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
343 got error
344 RESET SLAVE ALL;
345 Warnings:
346 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
347 ---- master:zstd slave:zstd,uncompressed slave_option:0 expect:zstd level:default ----
348 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zstd,uncompressed';
349 SET @@global.replica_compressed_protocol = 0;
350 START SLAVE IO_THREAD
351 include/assert.inc [Less than 1000000 bytes should be sent compressed]
352 Warnings:
353 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
354 ---- master:zstd slave:zstd,uncompressed slave_option:0 expect:zstd level:22 ----
355 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zstd,uncompressed';
356 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
357 SET @@global.replica_compressed_protocol = 0;
358 START SLAVE IO_THREAD
359 include/assert.inc [Less than 1000000 bytes should be sent compressed]
360 Warnings:
361 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
362 include/assert.inc [Compression ratio should be better than previous algorithm]
363 ---- master:zstd slave:zlib,zstd,uncompressed slave_option:0 expect:zstd level:default ----
364 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zlib,zstd,uncompressed';
365 SET @@global.replica_compressed_protocol = 0;
366 START SLAVE IO_THREAD
367 include/assert.inc [Less than 1000000 bytes should be sent compressed]
368 Warnings:
369 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
370 ---- master:zstd slave:zlib,zstd,uncompressed slave_option:0 expect:zstd level:22 ----
371 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zlib,zstd,uncompressed';
372 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
373 SET @@global.replica_compressed_protocol = 0;
374 START SLAVE IO_THREAD
375 include/assert.inc [Less than 1000000 bytes should be sent compressed]
376 Warnings:
377 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
378 include/assert.inc [Compression ratio should be better than previous algorithm]
379 ==== master:uncompressed ====
380 SET @@global.protocol_compression_algorithms = 'uncompressed';
381 SELECT @@global.protocol_compression_algorithms;
382 @@global.protocol_compression_algorithms
383 uncompressed
384 ---- master:uncompressed slave:default slave_option:0 expected:uncompressed ----
385 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
386 SET @@global.replica_compressed_protocol = 0;
387 START SLAVE IO_THREAD
388 include/assert.inc [More than 1000000 bytes should be sent uncompressed]
389 Warnings:
390 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
391 ---- master:uncompressed slave:default slave_option:1 expect:error ----
392 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
393 SET @@global.replica_compressed_protocol = 1;
394 START SLAVE IO_THREAD;
395 Warnings:
396 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
397 got error
398 RESET SLAVE ALL;
399 Warnings:
400 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
401 ---- master:uncompressed slave:zlib slave_option:0 expect:error ----
402 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zlib';
403 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
404 SET @@global.replica_compressed_protocol = 0;
405 START SLAVE IO_THREAD;
406 Warnings:
407 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
408 got error
409 RESET SLAVE ALL;
410 Warnings:
411 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
412 ---- master:uncompressed slave:zstd slave_option:0 expect:error ----
413 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zstd';
414 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
415 SET @@global.replica_compressed_protocol = 0;
416 START SLAVE IO_THREAD;
417 Warnings:
418 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
419 got error
420 RESET SLAVE ALL;
421 Warnings:
422 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
423 ---- master:uncompressed slave:uncompressed slave_option:0 expected:uncompressed ----
424 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'uncompressed';
425 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
426 SET @@global.replica_compressed_protocol = 0;
427 START SLAVE IO_THREAD
428 include/assert.inc [More than 1000000 bytes should be sent uncompressed]
429 Warnings:
430 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
431 ---- master:uncompressed slave:uncompressed slave_option:1 expect:error ----
432 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'uncompressed';
433 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
434 SET @@global.replica_compressed_protocol = 1;
435 START SLAVE IO_THREAD;
436 Warnings:
437 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
438 got error
439 RESET SLAVE ALL;
440 Warnings:
441 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
442 ---- master:uncompressed slave:zlib,zstd slave_option:0 expect:error ----
443 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zlib,zstd';
444 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
445 SET @@global.replica_compressed_protocol = 0;
446 START SLAVE IO_THREAD;
447 Warnings:
448 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
449 got error
450 RESET SLAVE ALL;
451 Warnings:
452 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
453 ---- master:uncompressed slave:zlib,uncompressed slave_option:0 expected:uncompressed ----
454 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zlib,uncompressed';
455 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
456 SET @@global.replica_compressed_protocol = 0;
457 START SLAVE IO_THREAD
458 include/assert.inc [More than 1000000 bytes should be sent uncompressed]
459 Warnings:
460 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
461 ---- master:uncompressed slave:zstd,uncompressed slave_option:0 expected:uncompressed ----
462 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zstd,uncompressed';
463 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
464 SET @@global.replica_compressed_protocol = 0;
465 START SLAVE IO_THREAD
466 include/assert.inc [More than 1000000 bytes should be sent uncompressed]
467 Warnings:
468 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
469 ---- master:uncompressed slave:zlib,zstd,uncompressed slave_option:0 expected:uncompressed ----
470 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zlib,zstd,uncompressed';
471 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
472 SET @@global.replica_compressed_protocol = 0;
473 START SLAVE IO_THREAD
474 include/assert.inc [More than 1000000 bytes should be sent uncompressed]
475 Warnings:
476 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
477 ==== master:zlib,zstd ====
478 SET @@global.protocol_compression_algorithms = 'zlib,zstd';
479 SELECT @@global.protocol_compression_algorithms;
480 @@global.protocol_compression_algorithms
481 zlib,zstd
482 ---- master:zlib,zstd slave:default slave_option:0 expect:error ----
483 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
484 SET @@global.replica_compressed_protocol = 0;
485 START SLAVE IO_THREAD;
486 Warnings:
487 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
488 got error
489 RESET SLAVE ALL;
490 Warnings:
491 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
492 ---- master:zlib,zstd slave:default slave_option:1 expected:zlib ----
493 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
494 SET @@global.replica_compressed_protocol = 1;
495 START SLAVE IO_THREAD
496 include/assert.inc [Less than 1000000 bytes should be sent compressed]
497 Warnings:
498 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
499 ---- master:zlib,zstd slave:zlib slave_option:0 expected:zlib ----
500 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zlib';
501 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
502 SET @@global.replica_compressed_protocol = 0;
503 START SLAVE IO_THREAD
504 include/assert.inc [Less than 1000000 bytes should be sent compressed]
505 Warnings:
506 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
507 ---- master:zlib,zstd slave:zstd slave_option:0 expect:zstd level:default ----
508 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zstd';
509 SET @@global.replica_compressed_protocol = 0;
510 START SLAVE IO_THREAD
511 include/assert.inc [Less than 1000000 bytes should be sent compressed]
512 Warnings:
513 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
514 ---- master:zlib,zstd slave:zstd slave_option:0 expect:zstd level:22 ----
515 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zstd';
516 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
517 SET @@global.replica_compressed_protocol = 0;
518 START SLAVE IO_THREAD
519 include/assert.inc [Less than 1000000 bytes should be sent compressed]
520 Warnings:
521 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
522 include/assert.inc [Compression ratio should be better than previous algorithm]
523 ---- master:zlib,zstd slave:uncompressed slave_option:0 expect:error ----
524 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'uncompressed';
525 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
526 SET @@global.replica_compressed_protocol = 0;
527 START SLAVE IO_THREAD;
528 Warnings:
529 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
530 got error
531 RESET SLAVE ALL;
532 Warnings:
533 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
534 ---- master:zlib,zstd slave:uncompressed slave_option:1 expected:zlib ----
535 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'uncompressed';
536 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
537 SET @@global.replica_compressed_protocol = 1;
538 START SLAVE IO_THREAD
539 include/assert.inc [Less than 1000000 bytes should be sent compressed]
540 Warnings:
541 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
542 ---- master:zlib,zstd slave:zlib,zstd slave_option:0 expected:zlib ----
543 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zlib,zstd';
544 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
545 SET @@global.replica_compressed_protocol = 0;
546 START SLAVE IO_THREAD
547 include/assert.inc [Less than 1000000 bytes should be sent compressed]
548 Warnings:
549 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
550 ---- master:zlib,zstd slave:zlib,uncompressed slave_option:0 expected:zlib ----
551 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zlib,uncompressed';
552 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
553 SET @@global.replica_compressed_protocol = 0;
554 START SLAVE IO_THREAD
555 include/assert.inc [Less than 1000000 bytes should be sent compressed]
556 Warnings:
557 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
558 ---- master:zlib,zstd slave:zstd,uncompressed slave_option:0 expect:zstd level:default ----
559 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zstd,uncompressed';
560 SET @@global.replica_compressed_protocol = 0;
561 START SLAVE IO_THREAD
562 include/assert.inc [Less than 1000000 bytes should be sent compressed]
563 Warnings:
564 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
565 ---- master:zlib,zstd slave:zstd,uncompressed slave_option:0 expect:zstd level:22 ----
566 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zstd,uncompressed';
567 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
568 SET @@global.replica_compressed_protocol = 0;
569 START SLAVE IO_THREAD
570 include/assert.inc [Less than 1000000 bytes should be sent compressed]
571 Warnings:
572 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
573 include/assert.inc [Compression ratio should be better than previous algorithm]
574 ---- master:zlib,zstd slave:zlib,zstd,uncompressed slave_option:0 expected:zlib ----
575 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zlib,zstd,uncompressed';
576 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
577 SET @@global.replica_compressed_protocol = 0;
578 START SLAVE IO_THREAD
579 include/assert.inc [Less than 1000000 bytes should be sent compressed]
580 Warnings:
581 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
582 ==== master:zlib,uncompressed ====
583 SET @@global.protocol_compression_algorithms = 'zlib,uncompressed';
584 SELECT @@global.protocol_compression_algorithms;
585 @@global.protocol_compression_algorithms
586 zlib,uncompressed
587 ---- master:zlib,uncompressed slave:default slave_option:0 expected:uncompressed ----
588 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
589 SET @@global.replica_compressed_protocol = 0;
590 START SLAVE IO_THREAD
591 include/assert.inc [More than 1000000 bytes should be sent uncompressed]
592 Warnings:
593 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
594 ---- master:zlib,uncompressed slave:default slave_option:1 expected:zlib ----
595 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
596 SET @@global.replica_compressed_protocol = 1;
597 START SLAVE IO_THREAD
598 include/assert.inc [Less than 1000000 bytes should be sent compressed]
599 Warnings:
600 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
601 ---- master:zlib,uncompressed slave:zlib slave_option:0 expected:zlib ----
602 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zlib';
603 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
604 SET @@global.replica_compressed_protocol = 0;
605 START SLAVE IO_THREAD
606 include/assert.inc [Less than 1000000 bytes should be sent compressed]
607 Warnings:
608 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
609 ---- master:zlib,uncompressed slave:zstd slave_option:0 expect:error ----
610 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zstd';
611 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
612 SET @@global.replica_compressed_protocol = 0;
613 START SLAVE IO_THREAD;
614 Warnings:
615 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
616 got error
617 RESET SLAVE ALL;
618 Warnings:
619 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
620 ---- master:zlib,uncompressed slave:uncompressed slave_option:0 expected:uncompressed ----
621 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'uncompressed';
622 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
623 SET @@global.replica_compressed_protocol = 0;
624 START SLAVE IO_THREAD
625 include/assert.inc [More than 1000000 bytes should be sent uncompressed]
626 Warnings:
627 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
628 ---- master:zlib,uncompressed slave:uncompressed slave_option:1 expected:zlib ----
629 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'uncompressed';
630 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
631 SET @@global.replica_compressed_protocol = 1;
632 START SLAVE IO_THREAD
633 include/assert.inc [Less than 1000000 bytes should be sent compressed]
634 Warnings:
635 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
636 ---- master:zlib,uncompressed slave:zlib,zstd slave_option:0 expected:zlib ----
637 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zlib,zstd';
638 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
639 SET @@global.replica_compressed_protocol = 0;
640 START SLAVE IO_THREAD
641 include/assert.inc [Less than 1000000 bytes should be sent compressed]
642 Warnings:
643 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
644 ---- master:zlib,uncompressed slave:zlib,uncompressed slave_option:0 expected:zlib ----
645 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zlib,uncompressed';
646 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
647 SET @@global.replica_compressed_protocol = 0;
648 START SLAVE IO_THREAD
649 include/assert.inc [Less than 1000000 bytes should be sent compressed]
650 Warnings:
651 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
652 ---- master:zlib,uncompressed slave:zstd,uncompressed slave_option:0 expected:uncompressed ----
653 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zstd,uncompressed';
654 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
655 SET @@global.replica_compressed_protocol = 0;
656 START SLAVE IO_THREAD
657 include/assert.inc [More than 1000000 bytes should be sent uncompressed]
658 Warnings:
659 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
660 ---- master:zlib,uncompressed slave:zlib,zstd,uncompressed slave_option:0 expected:zlib ----
661 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zlib,zstd,uncompressed';
662 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
663 SET @@global.replica_compressed_protocol = 0;
664 START SLAVE IO_THREAD
665 include/assert.inc [Less than 1000000 bytes should be sent compressed]
666 Warnings:
667 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
668 ==== master:zstd,uncompressed ====
669 SET @@global.protocol_compression_algorithms = 'zstd,uncompressed';
670 SELECT @@global.protocol_compression_algorithms;
671 @@global.protocol_compression_algorithms
672 zstd,uncompressed
673 ---- master:zstd,uncompressed slave:default slave_option:0 expected:uncompressed ----
674 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
675 SET @@global.replica_compressed_protocol = 0;
676 START SLAVE IO_THREAD
677 include/assert.inc [More than 1000000 bytes should be sent uncompressed]
678 Warnings:
679 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
680 ---- master:zstd,uncompressed slave:default slave_option:1 expect:error ----
681 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
682 SET @@global.replica_compressed_protocol = 1;
683 START SLAVE IO_THREAD;
684 Warnings:
685 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
686 got error
687 RESET SLAVE ALL;
688 Warnings:
689 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
690 ---- master:zstd,uncompressed slave:zlib slave_option:0 expect:error ----
691 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zlib';
692 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
693 SET @@global.replica_compressed_protocol = 0;
694 START SLAVE IO_THREAD;
695 Warnings:
696 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
697 got error
698 RESET SLAVE ALL;
699 Warnings:
700 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
701 ---- master:zstd,uncompressed slave:zstd slave_option:0 expect:zstd level:default ----
702 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zstd';
703 SET @@global.replica_compressed_protocol = 0;
704 START SLAVE IO_THREAD
705 include/assert.inc [Less than 1000000 bytes should be sent compressed]
706 Warnings:
707 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
708 ---- master:zstd,uncompressed slave:zstd slave_option:0 expect:zstd level:22 ----
709 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zstd';
710 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
711 SET @@global.replica_compressed_protocol = 0;
712 START SLAVE IO_THREAD
713 include/assert.inc [Less than 1000000 bytes should be sent compressed]
714 Warnings:
715 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
716 include/assert.inc [Compression ratio should be better than previous algorithm]
717 ---- master:zstd,uncompressed slave:uncompressed slave_option:0 expected:uncompressed ----
718 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'uncompressed';
719 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
720 SET @@global.replica_compressed_protocol = 0;
721 START SLAVE IO_THREAD
722 include/assert.inc [More than 1000000 bytes should be sent uncompressed]
723 Warnings:
724 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
725 ---- master:zstd,uncompressed slave:uncompressed slave_option:1 expect:error ----
726 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'uncompressed';
727 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
728 SET @@global.replica_compressed_protocol = 1;
729 START SLAVE IO_THREAD;
730 Warnings:
731 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
732 got error
733 RESET SLAVE ALL;
734 Warnings:
735 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
736 ---- master:zstd,uncompressed slave:zlib,zstd slave_option:0 expect:zstd level:default ----
737 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zlib,zstd';
738 SET @@global.replica_compressed_protocol = 0;
739 START SLAVE IO_THREAD
740 include/assert.inc [Less than 1000000 bytes should be sent compressed]
741 Warnings:
742 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
743 ---- master:zstd,uncompressed slave:zlib,zstd slave_option:0 expect:zstd level:22 ----
744 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zlib,zstd';
745 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
746 SET @@global.replica_compressed_protocol = 0;
747 START SLAVE IO_THREAD
748 include/assert.inc [Less than 1000000 bytes should be sent compressed]
749 Warnings:
750 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
751 include/assert.inc [Compression ratio should be better than previous algorithm]
752 ---- master:zstd,uncompressed slave:zlib,uncompressed slave_option:0 expected:uncompressed ----
753 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zlib,uncompressed';
754 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
755 SET @@global.replica_compressed_protocol = 0;
756 START SLAVE IO_THREAD
757 include/assert.inc [More than 1000000 bytes should be sent uncompressed]
758 Warnings:
759 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
760 ---- master:zstd,uncompressed slave:zstd,uncompressed slave_option:0 expect:zstd level:default ----
761 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zstd,uncompressed';
762 SET @@global.replica_compressed_protocol = 0;
763 START SLAVE IO_THREAD
764 include/assert.inc [Less than 1000000 bytes should be sent compressed]
765 Warnings:
766 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
767 ---- master:zstd,uncompressed slave:zstd,uncompressed slave_option:0 expect:zstd level:22 ----
768 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zstd,uncompressed';
769 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
770 SET @@global.replica_compressed_protocol = 0;
771 START SLAVE IO_THREAD
772 include/assert.inc [Less than 1000000 bytes should be sent compressed]
773 Warnings:
774 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
775 include/assert.inc [Compression ratio should be better than previous algorithm]
776 ---- master:zstd,uncompressed slave:zlib,zstd,uncompressed slave_option:0 expect:zstd level:default ----
777 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zlib,zstd,uncompressed';
778 SET @@global.replica_compressed_protocol = 0;
779 START SLAVE IO_THREAD
780 include/assert.inc [Less than 1000000 bytes should be sent compressed]
781 Warnings:
782 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
783 ---- master:zstd,uncompressed slave:zlib,zstd,uncompressed slave_option:0 expect:zstd level:22 ----
784 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zlib,zstd,uncompressed';
785 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
786 SET @@global.replica_compressed_protocol = 0;
787 START SLAVE IO_THREAD
788 include/assert.inc [Less than 1000000 bytes should be sent compressed]
789 Warnings:
790 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
791 include/assert.inc [Compression ratio should be better than previous algorithm]
792 ==== master:zlib,zstd,uncompressed ====
793 SET @@global.protocol_compression_algorithms = 'zlib,zstd,uncompressed';
794 SELECT @@global.protocol_compression_algorithms;
795 @@global.protocol_compression_algorithms
796 zlib,zstd,uncompressed
797 ---- master:zlib,zstd,uncompressed slave:default slave_option:0 expected:uncompressed ----
798 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
799 SET @@global.replica_compressed_protocol = 0;
800 START SLAVE IO_THREAD
801 include/assert.inc [More than 1000000 bytes should be sent uncompressed]
802 Warnings:
803 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
804 ---- master:zlib,zstd,uncompressed slave:default slave_option:1 expected:zlib ----
805 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
806 SET @@global.replica_compressed_protocol = 1;
807 START SLAVE IO_THREAD
808 include/assert.inc [Less than 1000000 bytes should be sent compressed]
809 Warnings:
810 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
811 ---- master:zlib,zstd,uncompressed slave:zlib slave_option:0 expected:zlib ----
812 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zlib';
813 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
814 SET @@global.replica_compressed_protocol = 0;
815 START SLAVE IO_THREAD
816 include/assert.inc [Less than 1000000 bytes should be sent compressed]
817 Warnings:
818 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
819 ---- master:zlib,zstd,uncompressed slave:zstd slave_option:0 expect:zstd level:default ----
820 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zstd';
821 SET @@global.replica_compressed_protocol = 0;
822 START SLAVE IO_THREAD
823 include/assert.inc [Less than 1000000 bytes should be sent compressed]
824 Warnings:
825 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
826 ---- master:zlib,zstd,uncompressed slave:zstd slave_option:0 expect:zstd level:22 ----
827 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zstd';
828 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
829 SET @@global.replica_compressed_protocol = 0;
830 START SLAVE IO_THREAD
831 include/assert.inc [Less than 1000000 bytes should be sent compressed]
832 Warnings:
833 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
834 include/assert.inc [Compression ratio should be better than previous algorithm]
835 ---- master:zlib,zstd,uncompressed slave:uncompressed slave_option:0 expected:uncompressed ----
836 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'uncompressed';
837 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
838 SET @@global.replica_compressed_protocol = 0;
839 START SLAVE IO_THREAD
840 include/assert.inc [More than 1000000 bytes should be sent uncompressed]
841 Warnings:
842 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
843 ---- master:zlib,zstd,uncompressed slave:uncompressed slave_option:1 expected:zlib ----
844 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'uncompressed';
845 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
846 SET @@global.replica_compressed_protocol = 1;
847 START SLAVE IO_THREAD
848 include/assert.inc [Less than 1000000 bytes should be sent compressed]
849 Warnings:
850 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
851 ---- master:zlib,zstd,uncompressed slave:zlib,zstd slave_option:0 expected:zlib ----
852 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zlib,zstd';
853 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
854 SET @@global.replica_compressed_protocol = 0;
855 START SLAVE IO_THREAD
856 include/assert.inc [Less than 1000000 bytes should be sent compressed]
857 Warnings:
858 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
859 ---- master:zlib,zstd,uncompressed slave:zlib,uncompressed slave_option:0 expected:zlib ----
860 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zlib,uncompressed';
861 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
862 SET @@global.replica_compressed_protocol = 0;
863 START SLAVE IO_THREAD
864 include/assert.inc [Less than 1000000 bytes should be sent compressed]
865 Warnings:
866 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
867 ---- master:zlib,zstd,uncompressed slave:zstd,uncompressed slave_option:0 expect:zstd level:default ----
868 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zstd,uncompressed';
869 SET @@global.replica_compressed_protocol = 0;
870 START SLAVE IO_THREAD
871 include/assert.inc [Less than 1000000 bytes should be sent compressed]
872 Warnings:
873 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
874 ---- master:zlib,zstd,uncompressed slave:zstd,uncompressed slave_option:0 expect:zstd level:22 ----
875 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zstd,uncompressed';
876 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
877 SET @@global.replica_compressed_protocol = 0;
878 START SLAVE IO_THREAD
879 include/assert.inc [Less than 1000000 bytes should be sent compressed]
880 Warnings:
881 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
882 include/assert.inc [Compression ratio should be better than previous algorithm]
883 ---- master:zlib,zstd,uncompressed slave:zlib,zstd,uncompressed slave_option:0 expected:zlib ----
884 CHANGE REPLICATION SOURCE TO SOURCE_COMPRESSION_ALGORITHMS = 'zlib,zstd,uncompressed';
885 CHANGE REPLICATION SOURCE TO SOURCE_ZSTD_COMPRESSION_LEVEL = 22;
886 SET @@global.replica_compressed_protocol = 0;
887 START SLAVE IO_THREAD
888 include/assert.inc [Less than 1000000 bytes should be sent compressed]
889 Warnings:
890 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
891 #### Clean up ####
892 SET @@global.protocol_compression_algorithms = "zlib,zstd,uncompressed";;
893 SET sql_log_bin = 0;
894 DROP TABLE algorithms;
895 DROP TABLE levels;
896 DROP TABLE t;
897 DROP FUNCTION set_intersection;
898 SET sql_log_bin = 1;
899 Warnings:
900 Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure.
901 Note 1760 Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
902 include/rpl_end.inc
903 Warnings:
904 Note 3084 Replication thread(s) for channel '' are already stopped.