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 ?

asked 4 years ago908 views
2 Answers
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
answered 4 years ago
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

answered 4 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions