Debian Codegraph @

mysql-test/suite/rpl/r/rpl_connection_compression_configuration.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 [connection slave]
7 ##### TEST FOR NEW CHANNEL #####
8 # case 1: ALGORITHM = uncompressed, LEVEL not specified
9 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS='uncompressed', SOURCE_ZSTD_COMPRESSION_LEVEL= 0 FOR CHANNEL 'C1';
10 Warnings:
11 Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure.
12 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.
13 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C1';
14 MASTER_COMPRESSION_ALGORITHM MASTER_ZSTD_COMPRESSION_LEVEL
15 uncompressed 3
16 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C1';
17 COMPRESSION_ALGORITHM ZSTD_COMPRESSION_LEVEL
18 uncompressed 3
19 # case 2: ALGORITHM = uncompressed, LEVEL = 2
20 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS='uncompressed', SOURCE_ZSTD_COMPRESSION_LEVEL= 2 FOR CHANNEL 'C2';
21 Warnings:
22 Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure.
23 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.
24 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C2';
25 MASTER_COMPRESSION_ALGORITHM MASTER_ZSTD_COMPRESSION_LEVEL
26 uncompressed 2
27 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C2';
28 COMPRESSION_ALGORITHM ZSTD_COMPRESSION_LEVEL
29 uncompressed 2
30 # case 3: ALGORITHM not specified, LEVEL = 2
31 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_ZSTD_COMPRESSION_LEVEL= 2 FOR CHANNEL 'C3';
32 Warnings:
33 Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure.
34 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.
35 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C3';
36 MASTER_COMPRESSION_ALGORITHM MASTER_ZSTD_COMPRESSION_LEVEL
37 uncompressed 2
38 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C3';
39 COMPRESSION_ALGORITHM ZSTD_COMPRESSION_LEVEL
40 uncompressed 2
41 # case 4: ALGORITHM = ZSTD, LEVEL = not specified
42 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS='zstd' FOR CHANNEL 'C4';
43 Warnings:
44 Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure.
45 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.
46 # algorithm and level should be set to zstd and 0
47 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C4';
48 MASTER_COMPRESSION_ALGORITHM MASTER_ZSTD_COMPRESSION_LEVEL
49 zstd 3
50 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C4';
51 COMPRESSION_ALGORITHM ZSTD_COMPRESSION_LEVEL
52 zstd 3
53 # case 5: ALGORITHM = ZSTD, LEVEL = 9
54 # report error as part of change master
55 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS='zstd', SOURCE_ZSTD_COMPRESSION_LEVEL= 9 FOR CHANNEL 'C5';
56 Warnings:
57 Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure.
58 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.
59 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C5';
60 MASTER_COMPRESSION_ALGORITHM MASTER_ZSTD_COMPRESSION_LEVEL
61 zstd 9
62 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C5';
63 COMPRESSION_ALGORITHM ZSTD_COMPRESSION_LEVEL
64 zstd 9
65 # case 6: ALGORITHM = ZSTD, LEVEL = 24
66 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS='zstd', SOURCE_ZSTD_COMPRESSION_LEVEL= 24 FOR CHANNEL 'C6';
67 ERROR HY000: Invalid SOURCE_ZSTD_COMPRESSION_LEVEL 24 for channel 'c6'.
68 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C6';
69 MASTER_COMPRESSION_ALGORITHM MASTER_ZSTD_COMPRESSION_LEVEL
70 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C6';
71 COMPRESSION_ALGORITHM ZSTD_COMPRESSION_LEVEL
72 zstd 3
73 # case 7: ALGORITHM = invalid value, LEVEL = 2
74 # report error as part of change master
75 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS='xyz', SOURCE_ZSTD_COMPRESSION_LEVEL= 2 FOR CHANNEL 'C7';
76 ERROR HY000: Invalid SOURCE_COMPRESSION_ALGORITHMS 'xyz' for channel 'c7'.
77 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C7';
78 MASTER_COMPRESSION_ALGORITHM MASTER_ZSTD_COMPRESSION_LEVEL
79 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C7';
80 COMPRESSION_ALGORITHM ZSTD_COMPRESSION_LEVEL
81 uncompressed 3
82 # case 8: ALGORITHM = invalid value, LEVEL = 29
83 # report error as part of change master
84 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS='xyz', SOURCE_ZSTD_COMPRESSION_LEVEL= 29 FOR CHANNEL 'C8';
85 ERROR HY000: Invalid SOURCE_COMPRESSION_ALGORITHMS 'xyz' for channel 'c8'.
86 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C8';
87 MASTER_COMPRESSION_ALGORITHM MASTER_ZSTD_COMPRESSION_LEVEL
88 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C8';
89 COMPRESSION_ALGORITHM ZSTD_COMPRESSION_LEVEL
90 uncompressed 3
91 # case 9: ALGORITHM = invalid value, LEVEL not specified
92 # report error as part of change master
93 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS='xyz' FOR CHANNEL 'C9';
94 ERROR HY000: Invalid SOURCE_COMPRESSION_ALGORITHMS 'xyz' for channel 'c9'.
95 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C9';
96 MASTER_COMPRESSION_ALGORITHM MASTER_ZSTD_COMPRESSION_LEVEL
97 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C9';
98 COMPRESSION_ALGORITHM ZSTD_COMPRESSION_LEVEL
99 uncompressed 3
100 # case 10: ALGORITHM = invalid value
101 # report error as part of change master
102 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS= 'zlib,zstd,abc' FOR CHANNEL 'C10';
103 ERROR HY000: Invalid SOURCE_COMPRESSION_ALGORITHMS 'abc' for channel 'c10'.
104 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C10';
105 MASTER_COMPRESSION_ALGORITHM MASTER_ZSTD_COMPRESSION_LEVEL
106 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C10';
107 COMPRESSION_ALGORITHM ZSTD_COMPRESSION_LEVEL
108 uncompressed 3
109 # case 11: ALGORITHM specified to more than 3 values
110 # report error as part of change master
111 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS= 'zlib,zstd,abc,123' FOR CHANNEL 'C11';
112 ERROR HY000: Specified compression algorithm list 'zlib,zstd,abc,123' exceeds total count of 3 for channel 'c11'.
113 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C11';
114 MASTER_COMPRESSION_ALGORITHM MASTER_ZSTD_COMPRESSION_LEVEL
115 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C11';
116 COMPRESSION_ALGORITHM ZSTD_COMPRESSION_LEVEL
117 uncompressed 3
118 # case 12: ALGORITHM specified to upper case, LEVEL not specified
119 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root',SOURCE_COMPRESSION_ALGORITHMS= 'ZLIB,ZSTD' FOR CHANNEL 'C12';
120 Warnings:
121 Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure.
122 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.
123 # algorithm and level should be set to ZLIB,ZSTD/0
124 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C12';
125 MASTER_COMPRESSION_ALGORITHM MASTER_ZSTD_COMPRESSION_LEVEL
126 ZLIB,ZSTD 3
127 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C12';
128 COMPRESSION_ALGORITHM ZSTD_COMPRESSION_LEVEL
129 ZLIB,ZSTD 3
130 # case 13: ALGORITHM = 'zlib,uncompressed', LEVEL not specified
131 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS='zlib,uncompressed' FOR CHANNEL 'C13';
132 Warnings:
133 Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure.
134 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.
135 # algorithm and level should be set to 'zlib,uncompressed'/0
136 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C13';
137 MASTER_COMPRESSION_ALGORITHM MASTER_ZSTD_COMPRESSION_LEVEL
138 zlib,uncompressed 3
139 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C13';
140 COMPRESSION_ALGORITHM ZSTD_COMPRESSION_LEVEL
141 zlib,uncompressed 3
142 # case 14: ALGORITHM = 'zlib,uncompressed', LEVEL = 4
143 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS='zlib,uncompressed', SOURCE_ZSTD_COMPRESSION_LEVEL=4 FOR CHANNEL 'C14';
144 Warnings:
145 Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure.
146 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.
147 # algorithm and level should be set to 'zlib,uncompressed'/4
148 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C14';
149 MASTER_COMPRESSION_ALGORITHM MASTER_ZSTD_COMPRESSION_LEVEL
150 zlib,uncompressed 4
151 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C14';
152 COMPRESSION_ALGORITHM ZSTD_COMPRESSION_LEVEL
153 zlib,uncompressed 4
154 # case 15: ALGORITHM = 'zlib,uncompressed,zstd', LEVEL = 0
155 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS='zlib,uncompressed,zstd', SOURCE_ZSTD_COMPRESSION_LEVEL=0 FOR CHANNEL 'C15';
156 Warnings:
157 Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure.
158 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.
159 # algorithm and level should be set to 'zlib,uncompressed,zstd'/0
160 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C15';
161 MASTER_COMPRESSION_ALGORITHM MASTER_ZSTD_COMPRESSION_LEVEL
162 zlib,uncompressed,zstd 3
163 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C15';
164 COMPRESSION_ALGORITHM ZSTD_COMPRESSION_LEVEL
165 zlib,uncompressed,zstd 3
166 # case 16: ALGORITHM = 'uncompressed,zstd', LEVEL = 14
167 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS='uncompressed,zstd', SOURCE_ZSTD_COMPRESSION_LEVEL=14 FOR CHANNEL 'C16';
168 Warnings:
169 Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure.
170 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.
171 # algorithm and level should be set to 'uncompressed,zstd'/14
172 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C16';
173 MASTER_COMPRESSION_ALGORITHM MASTER_ZSTD_COMPRESSION_LEVEL
174 uncompressed,zstd 14
175 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C16';
176 COMPRESSION_ALGORITHM ZSTD_COMPRESSION_LEVEL
177 uncompressed,zstd 14
178 # case 17: ALGORITHM = 'zlib,uncompressed,zlib', LEVEL = 14
179 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS='zlib,uncompressed,zlib', SOURCE_ZSTD_COMPRESSION_LEVEL=14 FOR CHANNEL 'C17';
180 Warnings:
181 Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure.
182 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.
183 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C17';
184 MASTER_COMPRESSION_ALGORITHM MASTER_ZSTD_COMPRESSION_LEVEL
185 zlib,uncompressed,zlib 14
186 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C17';
187 COMPRESSION_ALGORITHM ZSTD_COMPRESSION_LEVEL
188 zlib,uncompressed,zlib 14
189 # case 18: ALGORITHM = 'uncompressed,uncompressed,uncompressed', LEVEL = 14
190 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS='uncompressed,uncompressed,uncompressed', SOURCE_ZSTD_COMPRESSION_LEVEL=14 FOR CHANNEL 'C17';
191 Warnings:
192 Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure.
193 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.
194 # algorithm and level should be set to 'uncompressed,uncompressed,uncompressed'/14
195 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C17';
196 MASTER_COMPRESSION_ALGORITHM MASTER_ZSTD_COMPRESSION_LEVEL
197 uncompressed,uncompressed,uncompressed 14
198 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C17';
199 COMPRESSION_ALGORITHM ZSTD_COMPRESSION_LEVEL
200 uncompressed,uncompressed,uncompressed 14
201 # case 19: ALGORITHM = 'zstd,zlib,uncompressed', LEVEL = 2
202 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS='zstd,zlib,uncompressed', SOURCE_ZSTD_COMPRESSION_LEVEL=2 FOR CHANNEL 'C17';
203 Warnings:
204 Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure.
205 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.
206 # algorithm and level should be set to 'zstd,zlib,uncompressed'/2
207 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C17';
208 MASTER_COMPRESSION_ALGORITHM MASTER_ZSTD_COMPRESSION_LEVEL
209 zstd,zlib,uncompressed 2
210 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C17';
211 COMPRESSION_ALGORITHM ZSTD_COMPRESSION_LEVEL
212 zstd,zlib,uncompressed 2
213 ##### TEST FOR EXISTING CHANNEL #####
214 # create a new channel
215 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS='zstd', SOURCE_ZSTD_COMPRESSION_LEVEL= 2 FOR CHANNEL 'C21';
216 Warnings:
217 Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure.
218 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.
219 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C21';
220 MASTER_COMPRESSION_ALGORITHM MASTER_ZSTD_COMPRESSION_LEVEL
221 zstd 2
222 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C21';
223 COMPRESSION_ALGORITHM ZSTD_COMPRESSION_LEVEL
224 zstd 2
225 # case 1: ALGORITHM not specified, LEVEL = 7
226 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_ZSTD_COMPRESSION_LEVEL = 7 FOR CHANNEL 'C21';
227 Warnings:
228 Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure.
229 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.
230 # algorithm and level should be set to 'zstd'/7
231 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C21';
232 MASTER_COMPRESSION_ALGORITHM MASTER_ZSTD_COMPRESSION_LEVEL
233 zstd 7
234 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C21';
235 COMPRESSION_ALGORITHM ZSTD_COMPRESSION_LEVEL
236 zstd 7
237 # case 2: ALGORITHM not specified, LEVEL 37
238 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_ZSTD_COMPRESSION_LEVEL = 37 FOR CHANNEL 'C21';
239 ERROR HY000: Invalid SOURCE_ZSTD_COMPRESSION_LEVEL 37 for channel 'c21'.
240 # level should be same as previous which is 7
241 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C21';
242 MASTER_COMPRESSION_ALGORITHM MASTER_ZSTD_COMPRESSION_LEVEL
243 zstd 7
244 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C21';
245 COMPRESSION_ALGORITHM ZSTD_COMPRESSION_LEVEL
246 zstd 7
247 # case 3: ALGORITHM not specified, LEVEL is not specified
248 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root' FOR CHANNEL 'C21';
249 Warnings:
250 Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure.
251 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.
252 # algorithm and level should not change
253 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C21';
254 MASTER_COMPRESSION_ALGORITHM MASTER_ZSTD_COMPRESSION_LEVEL
255 zstd 7
256 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C21';
257 COMPRESSION_ALGORITHM ZSTD_COMPRESSION_LEVEL
258 zstd 7
259 # case 4: ALGORITHM changed from zstd to zlib, LEVEL = 6
260 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS='zlib', SOURCE_ZSTD_COMPRESSION_LEVEL = 6 FOR CHANNEL 'C21';
261 Warnings:
262 Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure.
263 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.
264 # level should be 6 and algorithm should be zlib
265 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C21';
266 MASTER_COMPRESSION_ALGORITHM MASTER_ZSTD_COMPRESSION_LEVEL
267 zlib 6
268 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C21';
269 COMPRESSION_ALGORITHM ZSTD_COMPRESSION_LEVEL
270 zlib 6
271 # case 5: ALGORITHM changed from zlib to zstd/uncompressed, LEVEL = 27
272 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS='zlib,uncompressed', SOURCE_ZSTD_COMPRESSION_LEVEL = 27 FOR CHANNEL 'C21';
273 ERROR HY000: Invalid SOURCE_ZSTD_COMPRESSION_LEVEL 27 for channel 'c21'.
274 # level should be 6 and algorithm should be zlib
275 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C21';
276 MASTER_COMPRESSION_ALGORITHM MASTER_ZSTD_COMPRESSION_LEVEL
277 zlib 6
278 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C21';
279 COMPRESSION_ALGORITHM ZSTD_COMPRESSION_LEVEL
280 zlib,uncompressed 6
281 # case 6: ALGORITHM changed from zstd to zlib, LEVEL not specified
282 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS='zlib' FOR CHANNEL 'C21';
283 Warnings:
284 Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure.
285 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.
286 # level should not change
287 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C21';
288 MASTER_COMPRESSION_ALGORITHM MASTER_ZSTD_COMPRESSION_LEVEL
289 zlib 6
290 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C21';
291 COMPRESSION_ALGORITHM ZSTD_COMPRESSION_LEVEL
292 zlib 6
293 # case 7: ALGORITHM = invalid values, LEVEL = 6
294 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS='xyz', SOURCE_ZSTD_COMPRESSION_LEVEL = 6 FOR CHANNEL 'C21';
295 ERROR HY000: Invalid SOURCE_COMPRESSION_ALGORITHMS 'xyz' for channel 'c21'.
296 # case 8: ALGORITHM = invalid values, LEVEL = 26
297 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS='xyz', SOURCE_ZSTD_COMPRESSION_LEVEL = 26 FOR CHANNEL 'C21';
298 ERROR HY000: Invalid SOURCE_COMPRESSION_ALGORITHMS 'xyz' for channel 'c21'.
299 # case 9: ALGORITHM = invalid values, LEVEL is not specified
300 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS='xyz' FOR CHANNEL 'C21';
301 ERROR HY000: Invalid SOURCE_COMPRESSION_ALGORITHMS 'xyz' for channel 'c21'.
302 # case 10: ALGORITHM changed from zlib to 'zstd,zlib,uncompressed', LEVEL is not specified
303 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS='zstd,zlib,uncompressed' FOR CHANNEL 'C21';
304 Warnings:
305 Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure.
306 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.
307 # level should be 0 and algorithm should be 'zstd,zlib,uncompressed' and warning is reported
308 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C21';
309 MASTER_COMPRESSION_ALGORITHM MASTER_ZSTD_COMPRESSION_LEVEL
310 zstd,zlib,uncompressed 6
311 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C21';
312 COMPRESSION_ALGORITHM ZSTD_COMPRESSION_LEVEL
313 zstd,zlib,uncompressed 6
314 # case 11: ALGORITHM changed from 'zstd,zlib,uncompressed' to 'zstd', LEVEL = 3
315 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=MASTER_PORT, SOURCE_USER='root', SOURCE_COMPRESSION_ALGORITHMS='zstd', SOURCE_ZSTD_COMPRESSION_LEVEL = 3 FOR CHANNEL 'C21';
316 Warnings:
317 Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure.
318 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.
319 # level should be 3 and algorithm should be 'zstd'
320 SELECT MASTER_COMPRESSION_ALGORITHM, MASTER_ZSTD_COMPRESSION_LEVEL FROM mysql.slave_master_info WHERE CHANNEL_NAME = 'C21';
321 MASTER_COMPRESSION_ALGORITHM MASTER_ZSTD_COMPRESSION_LEVEL
322 zstd 3
323 SELECT COMPRESSION_ALGORITHM, ZSTD_COMPRESSION_LEVEL FROM performance_schema.replication_connection_configuration where CHANNEL_NAME = 'C21';
324 COMPRESSION_ALGORITHM ZSTD_COMPRESSION_LEVEL
325 zstd 3
326
327 # cleanup
328
329 include/stop_slave.inc
330 Warnings:
331 Note 3084 Replication thread(s) for channel 'c1' are already stopped.
332 Note 3084 Replication thread(s) for channel 'c10' are already stopped.
333 Note 3084 Replication thread(s) for channel 'c11' are already stopped.
334 Note 3084 Replication thread(s) for channel 'c12' are already stopped.
335 Note 3084 Replication thread(s) for channel 'c13' are already stopped.
336 Note 3084 Replication thread(s) for channel 'c14' are already stopped.
337 Note 3084 Replication thread(s) for channel 'c15' are already stopped.
338 Note 3084 Replication thread(s) for channel 'c16' are already stopped.
339 Note 3084 Replication thread(s) for channel 'c17' are already stopped.
340 Note 3084 Replication thread(s) for channel 'c2' are already stopped.
341 Note 3084 Replication thread(s) for channel 'c21' are already stopped.
342 Note 3084 Replication thread(s) for channel 'c3' are already stopped.
343 Note 3084 Replication thread(s) for channel 'c4' are already stopped.
344 Note 3084 Replication thread(s) for channel 'c5' are already stopped.
345 Note 3084 Replication thread(s) for channel 'c6' are already stopped.
346 Note 3084 Replication thread(s) for channel 'c7' are already stopped.
347 Note 3084 Replication thread(s) for channel 'c8' are already stopped.
348 Note 3084 Replication thread(s) for channel 'c9' are already stopped.
349 RESET SLAVE ALL FOR CHANNEL 'c1';
350 Warnings:
351 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
352 RESET SLAVE ALL FOR CHANNEL 'c10';
353 Warnings:
354 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
355 RESET SLAVE ALL FOR CHANNEL 'c11';
356 Warnings:
357 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
358 RESET SLAVE ALL FOR CHANNEL 'c12';
359 Warnings:
360 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
361 RESET SLAVE ALL FOR CHANNEL 'c13';
362 Warnings:
363 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
364 RESET SLAVE ALL FOR CHANNEL 'c14';
365 Warnings:
366 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
367 RESET SLAVE ALL FOR CHANNEL 'c15';
368 Warnings:
369 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
370 RESET SLAVE ALL FOR CHANNEL 'c16';
371 Warnings:
372 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
373 RESET SLAVE ALL FOR CHANNEL 'c17';
374 Warnings:
375 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
376 RESET SLAVE ALL FOR CHANNEL 'c2';
377 Warnings:
378 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
379 RESET SLAVE ALL FOR CHANNEL 'c21';
380 Warnings:
381 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
382 RESET SLAVE ALL FOR CHANNEL 'c3';
383 Warnings:
384 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
385 RESET SLAVE ALL FOR CHANNEL 'c4';
386 Warnings:
387 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
388 RESET SLAVE ALL FOR CHANNEL 'c5';
389 Warnings:
390 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
391 RESET SLAVE ALL FOR CHANNEL 'c6';
392 Warnings:
393 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
394 RESET SLAVE ALL FOR CHANNEL 'c7';
395 Warnings:
396 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
397 RESET SLAVE ALL FOR CHANNEL 'c8';
398 Warnings:
399 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
400 RESET SLAVE ALL FOR CHANNEL 'c9';
401 Warnings:
402 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
403 include/start_slave.inc
404 include/rpl_end.inc