By using AWS re:Post, you agree to the Terms of Use

DMS Sync Issues with nullable column and new columns


IHAC who is facing a couple of sync issues: Say we have a table T on mysql src db with a column C that is nullable. The table is fully loaded on the target and the DMS task is operating in CDC mode. If this table T gets altered so column C is made not nullable with a default, this change does not propagate , nor does the DMS task indicate an error. In addition, any new columns added to table T on the source, also do not propagate. When the DMS task is operating in CDC mode, new tables that are created without a Primary Key do not propagate to the target. It can break DMS replication (error shows in logs). Thank you

profile picture
asked 10 months ago465 views
2 Answers


this is a documented limitation of CDC for MySQL as a source:

answered 10 months ago
  • Would this also apply to Aurora MySQL as a source? Customer has Aurora MySQL



--> In general, DMS supports below DDL: [+]

--> Using MySQL(on-prem/Aurora MySQL/RDS MySQL) as source having limitation: "However, DROP TABLE, RENAME TABLE, and updates made to other attributes, such as column default value, column nullability, character set and so on, are not supported." [+]

--> If create table or add column not working properly, will need to dive deep into the issue using DMS log with detailed debug on SOURCE_CAPTURE, TASK_MANAGER, TARGET_APPLY to check further.

Note: "Using an ALTER TABLE table_name ADD COLUMN column_name statement to add columns to the beginning (FIRST) or the middle of a table (AFTER) isn't supported. Columns are always added to the end of the table."

--> What are the target/source endpoints:

Engine version (source and target) DMS version -- Check release note see if any known issues

--> Go through the current limitations and documentations to verify further. [+]

answered 10 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions