Data Migration from On-premises MySQL DB to RDS MySQL and Regular Updates from On-premises MySQL DB

Question

I have an on-premises MySQL database that needs to be migrated to an AWS RDS MySQL database. The on-premises database will be updated regularly, and I want to update the RDS database with the latest records from the on-premises database on a daily basis at a scheduled time. The two databases have schema differences, and I need to modify the data from the on-premises database to match the schema of the RDS database. I will not be performing any analytics on the data, and the RDS database will be used as the database for a web application.

Can you suggest an ideal approach for this scenario?

Thanks in Advance!

Can you suggest an ideal approach for this scenario?

Thanks in Advance!

Didier_Durand · Accepted Answer

Your use case will allow full leverage on AWS DMS for MySQL:  https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.MySQL.html

1) You can have different schemas: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_SchemaConversion.html  
2) Transformation rules will allow you to adapt content for new schema: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Tasks.CustomizingTasks.TableMapping.SelectionTransformation.Transformations.html
3) DMS will agregate the changes for you. and apply them when desired via checkpoints: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Task.CDC.html

Data Migration from On-premises MySQL DB to RDS MySQL and Regular Updates from On-premises MySQL DB

Relevant content