[TiCDC] support data compression when syncing to MySQL/TiDB

[zhangjinpeng87]

Is your feature request related to a problem?

When deploy multiple TiDB Clusters across multiple regions, TiCDC will be used to replicate data changes between these TiDB Clusters. There are some points need to be considered when doing cross region replication:

• The network bandwidth of cross regions is limited.
• The cost of data transfer across regions is higher than data transfer inside a region.

Describe the feature you'd like

Support compression when replicate data changes across regions.
MySQL protocol support compression: https://dev.mysql.com/doc/refman/8.0/en/connection-compression-control.html
TiDB also support connection compression: pingcap/tidb#22605

Describe alternatives you've considered

1. Don't support compression, pay more cost for cross region replication; but it is easier to hit cross region network bandwidth limitation when the data replication throughput is large enough.

Teachability, Documentation, Adoption, Migration Strategy

No response

[zhangjinpeng87]

MySQL go-sql-driver doesn't support compression yet. https://github.com/go-sql-driver/mysql/blob/43e9bef05581335f84d246aba6211af1b5133aae/dsn.go#L468

[lance6716]

Another less popular MySQL driver has implemented compression go-mysql-org/go-mysql#787 . Hope it's helpful for the contributor who wants to implement it in go-sql-driver

[dveeden]

MySQL go-sql-driver doesn't support compression yet. https://github.com/go-sql-driver/mysql/blob/43e9bef05581335f84d246aba6211af1b5133aae/dsn.go#L468

Indeed: go-sql-driver/mysql#24

Note that if we implement this with either driver we should aim to support both zlib and zstd.