v.21.12Improvements

MaterializedMySQL Supports CREATE TABLE ... LIKE DDL Queries

MaterializedMySQL now handles CREATE TABLE ... LIKE ... DDL queries. #31410 (Stig Bakken).
MaterializedMySQL now supports handling CREATE TABLE ... LIKE ... DDL queries.

Why it matters

This feature enables MaterializedMySQL to correctly replicate table creation commands that use the LIKE clause, ensuring accurate and consistent schema synchronization with MySQL databases. It solves issues related to missing support for this common MySQL DDL pattern, improving compatibility and usability.

How to use it

Users can utilize this feature by executing CREATE TABLE ... LIKE ... statements in the source MySQL database. MaterializedMySQL will now automatically process and replicate these DDL queries to maintain synchronized table structures.