By using AWS re:Post, you agree to the Terms of Use
/Migrate MySQL 8 to Aurora MySQL 8/

Migrate MySQL 8 to Aurora MySQL 8

0

We are having trouble migrating on-premise MySQL 8.0.26 to AWS Aurora MySQL. For this project we're using AWS Database Migration Service (DMS) but it seems we are reaching the limit of the amount of databases to migrate. When we try to migrate over 500+ databases with one task, the task fails with the error "No tables were found at task initialization". When we edit the filter to migrate < 500 databases, the task starts successfully. Can anyone confirm that 500 databases is the limit for DMS? We have to do over 7k databases, but filtering those will not be easy. Is it possible to increase the current limit of 500? Kind regards, Lennard.

2 Answers
0

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.

EXPERT
answered 3 months ago
0

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.

answered 3 months ago
  • 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.

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