An AWS DMS Replication Journey from Oracle to MySQL and Back

Track

DBA

Date and time

Thursday, 18. October 2018., 11:20

Room

Hall A

Duration

45'

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.

Lecture details

Type: Lecture
Level of difficulty: General
Experience Level: No experience
Desirable listeners function: DBA , Manager - Operational
Group of activity: DBA

About speaker

Best Sponsor

Better Sponsor

Media Sponsor

HrOUG.hr

The conference is organized by the Croatian Association of Oracle users. More about the association can be found at Hroug.hr.

Follow us on Twitter

Keep yourself up to date with all updates!

Follow us on Facebook