- Newest
- Most votes
- Most comments
You can find limits for DMS here: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Limits.html
Multiple tasks will be a better path for you as you also may be hitting some limits of the migration instance.
I dont think there is a limit on databases or schemas to migrate for mysql source. I would suggest enable extra logging (DETAILED_DEBUG) on component SOURCE_UNLOAD and track the query being passed by DMS against source to capture table list. once you have the query from log use that directly on source db to identify any issues. this could be an edge case or a bug. once identified i would suggest working with AWS Support for solution/bug reporting/workaround.
Thank you for the response. I've tried the job again with the suggested settings, but the error remains unchanged. No additional logging is visible in CloudWatch. I'll try to contact AWS Support on this.
Relevant content
- Accepted Answer
- asked a year ago
- asked 2 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago
See here for how to change the number of tasks: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_BestPractices.html