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!

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

Relevanter Inhalt