How to Determine When a Full-Load and Ongoing Migration Task Has Completed the Full Load Part.
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.
- 최신
- 최다 투표
- 가장 많은 댓글
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
Thanks for the reply. I have not seen a documented status of "Load complete, replication ongoing" in the Task State documentation. That is what is displayed in the UI; however, I can't find any documented data migration task status that matches this condition.