Migrating from MySQL to Aurora (Using Replica)

Came here looking for answer to same question - I have a MySQL I'm trying to convert to Aurora in another region. First time I copied a snapshot over to new region and restored from snapsnot and it worked, took about 3 hours total.

Since then, preparing for final migration, I've done it twice and both times it has sat in "preparing-data-migration" for over 24 hours with no other event/log/change etc. Seems like it's obviously a bug of some type.

Very disappointing, I'm now trying to migrate several DBs over using dump and import method, and that is going on 12 hours and counting, so it's not feasible either. At this point our company may just be stuck due to AWS bug.

Hello,

There are various possibilities that could cause this issue as there are lot of processes that need to take place in preparation for the data migration which includes data type conversion and depending on the size of the data being migrated the instance may stuck on this state for sometime. In rare cases, a underlying process might be failing causing the instance to get stuck on the same state for a long time.

I came across the below article whereby another user encountered the same issue and they reached out to AWS support for assistance in resolving the issue which helped.
[1] https://www.reddit.com/r/aws/comments/jl5314/rds_mysql_aurora_migration_stuck_in/?utm_source=amp&utm_medium=&utm_content=post_body

You can also consider using a different approach for migrating your data and for a better migration performance when compared to native migration tools. The Database Migration Service also known as DMS allows migration of data between supported engines with minimal downtime. You will need to take into consideration that since you will be doing cross region migration, you will be charged for the amount of data being migrated.

You can refer to this link https://docs.aws.amazon.com/dms/latest/userguide/CHAP_GettingStarted.html to get more information about the service.

Let us know if you need anything.

regards
jabulile

Edited by: Jabulile on Nov 6, 2020 4:36 AM

Edited by: Jabulile on Nov 6, 2020 4:50 AM

Edited by: Jabulile on Nov 6, 2020 4:50 AM

Edited by: Jabulile on Nov 6, 2020 5:09 AM