ClickHouse Supports MySQL Replication via MaterializeMySQL Engine

Why it matters

The feature enables users to replicate data from MySQL into ClickHouse, providing real-time materialized views of MySQL databases. This allows analytic queries in ClickHouse on MySQL data without impacting the performance of the MySQL server.

How to use it

To enable MySQL replication, create a database in ClickHouse using the MaterializeMySQL engine by specifying MySQL connection parameters. For example:

CREATE DATABASE mysql_replica ENGINE = MaterializeMySQL('mysql_host', 'mysql_db', 'user', 'password');

This will start replication and materialization of MySQL tables within the specified ClickHouse database.