MySQL DMS continuous replication with schema changes.

Question

A customer wants to migration a MySQL with DMS they will do continuous sync of the database, from the [docs][1] it states replication is done at the database logs level.  Does mean that any schema changes that they would make during the migration would also be migrated across?

[1]: http://docs.aws.amazon.com/dms/latest/userguide/CHAP_Introduction.html

Accepted Answer

DMS supports a part of DDL only. Please see http://docs.aws.amazon.com/dms/latest/userguide/CHAP_Introduction.SupportedDDL.html .

And DMS has some limitations around DDL on MySQL as a source. Please see http://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.MySQL.html#CHAP_Source.MySQL.Limitations .

MySQL DMS continuous replication with schema changes.

Relevanter Inhalt