v.21.6Improvement

MaterializeMySQL Enhances MySQL Replication by Ignoring Views

Official CH changelog text
MaterializeMySQL (experimental feature): added an ability to replicate MySQL databases containing views without failing. This is accomplished by ignoring the views. #22760 (Christian).
MaterializeMySQL (experimental): Added support for replicating MySQL databases that contain views by ignoring the views instead of failing.

Why it matters

Previously, MaterializeMySQL replication would fail when the source MySQL database contained views. This feature allows replication to continue by skipping views, enabling users to replicate more complex schemas without interruption.

How to use it

Use the experimental MaterializeMySQL feature as before. When replicating databases with views, the views will automatically be ignored to prevent replication failure. No additional configuration is required to enable view ignoring.

Related resources

PreviousNext