v.24.1New Feature

Introduced MySQL Binlog Client for MaterializedMySQL with Multi-Database Support

Introduced MySQL Binlog Client for MaterializedMySQL: One binlog connection for many databases. #57323 (Val Doroshchuk).
Introduced a MySQL binlog client that enables a single binlog connection to handle multiple databases for the MaterializedMySQL engine.

Why it matters

This feature improves the efficiency and scalability of data replication from MySQL to ClickHouse by using one binlog connection to replicate changes from many MySQL databases, reducing resource consumption and simplifying connection management.

How to use it

To use this feature, configure the MaterializedMySQL table engine to utilize the new binlog client that supports one connection for multiple databases. This typically involves setting up your MaterializedMySQL tables with the appropriate connection parameters as per the updated engine documentation.