Interesting we managed several schema changes when using AWS DMS for replicating data over a long period between MySQL and Postgres clusters. We treated these

Interesting we managed several schema changes when using AWS DMS for replicating data over a long period between MySQL and Postgres clusters. We treated these carefully and tested as we made them but never had any real issues with them. From memory DMS could cope with adding columns pretty transparently. One setting we invested in configuring and understanding was to allow DMS to attempt to recover from replication failures. This allowed it to error on DDL changes and attempt to recover. This usually involved restarting the task, but it would do this transparently as part of the recovery.