AWS DMS Task Resumption Query

0

Hey AWS Community!

I've got a question regarding AWS Database Migration Service (DMS).I recently upgraded my source database, and after a while, I noticed that the DMS task associated with it had failed (binlog_format) .After a fix, I found myself unable to resume the task; it seems like the only option is to restart from the beginning.I'm wondering about the duration within which I can resume it without having to start from scratch.

Vlad
asked 3 months ago373 views
1 Answer
0

Hello,

I understand that you encountered an issue on your task, which you managed to fix. However, after fixing you are unable to resume the task and you would like to know duration within which I can resume it without having to start from scratch.

With AWS DMS, when the task fails, the log file (binary log) DMS read is usually retained which is used when the task resumes to continue with the migration. However, if the binary log is no longer available on the source database instance, you will not be able to resume the task.

The duration in which you can resume the task without restarting is determined by the value set for the binary log retention period [1]. The the binlog retention period ensures that the logs are available for longer duration on the instance. You may configure the binary log retention period using the following command:

CALL mysql.rds_set_configuration(name,value);

You may refer to documentation for more information [1].

I hope the above info is helpful

References: [1] Configuring - https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/mysql-stored-proc-configuring.html

Letty
answered 3 months 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