An AWS DMS Replication Journey from Oracle to MySQL and Back

Track

DBA

Datum i vrijeme

četvrtak, 18. listopad 2018., 11:20

Dvorana

Dvorana A

Trajanje

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.

Detalji o predavanju

Vrsta: Predavanje
Razina težine: Općenito
Poželjno iskustvo slušatelja: Bez iskustva (1 g. i manje)
Poželjna funkcija slušatelja: DBA , Menadžer - operativni
Grupa aktivnosti: DBA

O predavaču

Najbolji pokrovitelj

Bolji pokrovitelj

Medijski pokrovitelj

HrOUG.hr

Konferenciju organizira Hrvatska udruga Oracle korisnika. Više o udruzi možete saznati na Hroug.hr.

Prati nas na Twitteru

Sve novosti i zanimljivosti vezane uz HrOUG 2018 objavljujemo na Twitteru!

Prati nas na Facebooku