Migrating from MySQL to Aurora (Using Replica)


I tried searching through the forum and came out empty.

We are trying to move from RDS/MySQL to Aurora. Referencing AWS user guide https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Migrating.RDSMySQL.Replica.html.

The Aurora cluster is on "Preparing-data-migration" (and instances are in "Creating") status now for over 3 days now. There are no logs on CloudWatch (Yes, it's enabled), and shows no sign of any activities since the initial few changes in the status. This DB is a little over 2 tib.

Any ideas? Any help appreciated.


질문됨 4년 전1186회 조회
2개 답변

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.

답변함 4년 전


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.


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

답변함 4년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠