An AWS DMS Replication Journey from Oracle to MySQL and Back

Moving to the cloud is still a hot topic these days, and one of the challenges of these migrations is dealing with the databases, that too need to be “cloudified”. Sometimes it means changing the flavor of the RDBMS, and sometimes it also means tight downtime windows for the move itself. AWS Data Migration Service (DMS) is one of the obvious options to consider when AWS is involved, but it can be used in other situations too.This presentation is based on a real world project where an oracle database was migrated to AWS Aurora MySQL with the help of AWS DMS. Additionally, a reverse replication from MySQL to Oracle was set up to provide real time data back to a legacy application still connected to the Oracle database. I'll cover the different stages of the project - designing the MySQL database with the help of AWS Schema Conversion Tool, setting up the DMS tasks, monitoring the replication and validating the result. I'll also reveal some issues I faced and solutions we chose.