DMS Configuration For Migration From RDS To MariaDB On EC2

0

hi
i have some issue about configuration DMS
i have one instance RDS with this class db.m5.large (2 Core Cpu and 8gb RAM)
i need replication that RDS to MariaDB running on EC2

so i already config RDS Replication Instance with this class dms.t2.medium
and i running with task FULL LOB and default advance parameter

I got error message on task "Replication task has failed.
Reason: Last Error Replication task out of memory. Stop Reason FATAL_ERROR Error Level FATAL."

so i got suggestion there is impact from LOB
i check on RDS i have 4148 Columns with LOB column types.

and i still got error I got error message on task "Replication task has failed.
Reason: Last Error Replication task out of memory. Stop Reason FATAL_ERROR Error Level FATAL."

so i need upgrade my DMS Instance ? or i still can use current DMS Instance ?

gefragt vor 4 Jahren921 Aufrufe
2 Antworten
0

Hi,

In order to view if the instance in under resource contention you can have a look at the metrics of the replication instance:

https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Monitoring.html

Further in order to troubleshoot the task, I would suggest you analyze the task logs and also you can have a look at the below link:

https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Troubleshooting.html

Edited by: sahilAWS on Dec 31, 2019 11:03 PM

AWS
beantwortet vor 4 Jahren
0

hi sahil
thanks for your informations.
i already update DMS instance to dms.r4.large
i have 23 task replication
and for each task i have configuration like this
FULL LOB (LOB Chunk size 8 kb)
enable validation
enable cloudwatch logs

advance task setting
maximum number of tables to load in pararell = 1
commit rate during full load = 1
transaction consistency = 600 seconds

currently i still got error message everyday
Message : Replication task has failed.
Reason: Last Error Replication task out of memory. Stop Reason FATAL_ERROR Error Level FATAL

but there is random task from 23 task replication

any advice ?

thanks

beantwortet vor 4 Jahren

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen