Migrating from MySQL to Aurora (Using Replica)

0

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.

Thanks!

clee-1
asked 4 years ago1126 views
2 Answers
0

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.

answered 4 years ago
0

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

answered 4 years ago

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