Skip to main content
Skip to main content
Edit this page

Schema Changes Propagation Support

ClickPipes for MySQL can detect schema changes in the source tables and, in some cases, automatically propagate the changes to the destination tables. The way each DDL operation is handled is documented below:

Schema Change TypeBehaviour
Adding a new column (ALTER TABLE ADD COLUMN ...)Propagated automatically. The new column(s) will be populated for all rows replicated after the schema change
Adding a new column with a default value (ALTER TABLE ADD COLUMN ... DEFAULT ...)Propagated automatically. The new column(s) will be populated for all rows replicated after the schema change, but existing rows will not show the default value without a full table refresh
Dropping an existing column (ALTER TABLE DROP COLUMN ...)Detected, but not propagated. The dropped column(s) will be populated with NULL for all rows replicated after the schema change

Schema changes on MySQL 5.x are not supported, as reliably tracking columns depends on binlog_row_metadata which was added in MySQL 8.0.