Cloud

Maris Elsins

An AWS DMS Replication Journey from Oracle to MySQL and Back

Maris Elsins
Pythian

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 the solutions we chose.


O Avtorju

Maris Elsins is an experienced Oracle Applications DBA currently working as Lead Database Consultant at The Pythian Group. His main areas of expertise are troubleshooting and performance tuning of Oracle Database and e-Business Suite systems. He is a blogger and a frequent speaker at Oracle related conferences such as UKOUG, Collaborate, HotSos, Oracle OpenWorld, OUGF Harmony and others. Maris is an Oracle ACE, an Oracle Certified Master, and a co-author of “Practical Oracle Database Appliance” (Apress, 2014).