v.22.3Improvement

MaterializedMySQL Now Supports Configurable Table Replication

Official CH changelog text
MaterializedMySQL (experimental feature) now supports materialized_mysql_tables_list (a comma-separated list of MySQL database tables, which will be replicated by the MaterializedMySQL database engine. Default value: empty list — means all the tables will be replicated), mentioned at #32977. #34487 (zzsmdfj).
MaterializedMySQL engine now supports the materialized_mysql_tables_list setting, allowing users to specify a comma-separated list of MySQL tables to replicate instead of replicating all tables by default.

Why it matters

This feature enables finer control over which MySQL tables are replicated by the MaterializedMySQL database engine. It addresses the need to replicate only a subset of tables, reducing unnecessary data replication and improving resource management.

How to use it

To use this feature, set the materialized_mysql_tables_list parameter in the MaterializedMySQL database configuration to a comma-separated list of desired MySQL tables. By default, if this list is empty, all tables will be replicated. Example:

CREATE DATABASE materialized_mysql_db ENGINE = MaterializedMySQL('host:port', 'user', 'password', 'database_name', 'table1,table2,table3');

Related resources

PreviousNext