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