v.21.6Improvement

MaterializeMySQL Now Supports MySQL 5.7.9 with SQL Compatibility Fix

Official CH changelog text
MaterializeMySQL (experimental feature): Previously, MySQL 5.7.9 was not supported due to SQL incompatibility. Now leave MySQL parameter verification to the MaterializeMySQL. #23413 (TCeason).
MaterializeMySQL (experimental): Added support for MySQL 5.7.9 by delegating MySQL parameter verification to MaterializeMySQL itself.

Why it matters

Previously, MySQL 5.7.9 was not supported in ClickHouse due to SQL incompatibilities. This feature resolves the issue by allowing MaterializeMySQL to handle parameter verification, enabling compatibility with this MySQL version and improving integration.

How to use it

To use this feature, enable the experimental MaterializeMySQL engine as usual. The improved parameter verification is applied automatically, allowing replication from MySQL 5.7.9 servers without additional configuration.

Related resources

PreviousNext