How to Determine When a Full-Load and Ongoing Migration Task Has Completed the Full Load Part.

Question

Greetings,

Is there an event or something else that can be intercept in order to apply indexes to a database after a full-load portion of a dms task has completed.

It seems possible to determine when a task transitions from "Running" to "Failed", however, nothing could be found that indicates when a Task transitions from "Running" to "Load complete, replication ongoing".

I don't see this particular state transition here https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Monitoring.html#CHAP_Tasks.Status

However, I did see a COMPLETE state transition for each table https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Monitoring.html#CHAP_Tasks.CustomizingTasks.TableState

Am I overlooking something, is there an easier way than to check every tables state for complete?

Thanks, and have a good day.

Answer

Hi,

If you run 'aws dms describe-event-categories' like I did, you'll find an event "state change" on replication tasks. So, try to capture this event to see if you get the transition to "Load complete, replication ongoing" that you're looking. You can hook a lambda on it to then do what you need.

See https://docs.aws.amazon.com/dms/latest/userguide/CHAP_EventBridge.html for implementation guidance

```
aws dms describe-event-categories
{
    "EventCategoryGroupList": [
        {
            "SourceType": "replication-instance",
            "EventCategories": [
                "failover",
                "deletion",
                "configuration change",
                "low storage",
                "failure",
                "maintenance",
                "creation"
            ]
        },
        {
            "SourceType": "replication-task",
            "EventCategories": [
                "deletion",
                "configuration change",
                "state change",
                "failure",
                "creation"
            ]
        }
    ]
}
```

Best,
Didier

How to Determine When a Full-Load and Ongoing Migration Task Has Completed the Full Load Part.

Relevant content