MySQL JDBC compression in transit

Question

Good morning,

I am looking to set my application connection to MySQL to compress data in transit. I read MySQL doc. but it's not cleat to me if I need to do something on the client side, on the server side, or if even it's possible. I know that mysql,mysqldump, etc clients can compress data in transit. But again, not clear for an application that use MySQL.

I found this config, but again, not sure if it apply to all connections types.

[mysqld]
protocol_compression_algorithms=zstd,uncompressed

EDIT: I am looking for MySQL 5.7 and 8.x

Did you read [the documentation](https://dev.mysql.com/doc/refman/8.0/en/connection-compression-control.html)? — Gerald Schneider, Jul 05 '22 at 13:45
I did, but as I stated, it's not clear to me if it's support it outside than when using mysql client. What I am looking for is for a JDBC connection string. — yield, Jul 05 '22 at 13:53
Normal usage of a database does not need to shovel so much data that compression would matter. — Rick James, Jul 05 '22 at 14:12

yield · Answer 1 · 2022-07-05T14:13:55.047

0

ok. It seem JDBC connection string only need this value.

useCompression=true

and config set on server side like I posted in my initial question

As a FYI. If you use MySQL in the cloud, like in Google cloud, only the client part is required as the server is already ready to accept compress connection. This is not specified in the MySQL website doc. Most probably is somewhere deep in Google doc.

edited Jul 05 '22 at 14:13

answered Jul 05 '22 at 14:01

yield

731
1
8
24

MySQL JDBC compression in transit

1 Answers1