asked on

Recommendation for migration: AWS RDS (MySql v5.6) to AWS Aurora (MySQL 5.7)

I am working through a production issue where the client company migrated from MySQL v5.6 (AWS RDS) to Aurora (AWS), and the MySQL version is 5.7. Initially the migration worked, but ran into locks on the Aurora engine, within 24 hours.

I am looking for the best practice scenario for this migration, and recommendations.

David Favor

Aurora is Amazon's... modified (they don't say how) version of MySQL, so no one really knows what's been done to this code.

If you trust Amazon (you're an independently wealthy thrillseeker), then use Aurora.

If you pay your bills from your site, stick with dedicated hardware + MariaDB (so no Amazon).

Note: The only way you might get an answer is to open a ticket with AWS support... They rarely answer + when they do, their answers tend to provide very little real help.

Note: As you can tell, I've used AWS before + only use dedicated iron (physical machines) now.

theGhost_k8

Hello,

Can you post something that you see? processlist/ innodb stauts?

Ramasamy P

Please throw more light on the issue.

When you are getting the issue?
Type of errors?
what is the concurrency ?
what is the DB Size?
What is the workload type?

Martin Miller

ASKER

@David, not interested in bashing AWS, it does not help with my question

@Ramasamy, @the_Gohost_k8 I am not looking to debug, although the writer had locks on it...

I am looking for the best practice scenario for this migration, and recommendations.

If you have this did this migration already I am looking for documenting the best practice on this.

Thanks!

ASKER CERTIFIED SOLUTION

theGhost_k8

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Martin Miller

ASKER

Thanks @theGhost_k8, I agree, not looking for this... I will close this out and credit your response.

Thanks!

Martin Miller

ASKER

Not exactly what I was looking for, but thank you.

theGhost_k8

You can further elaborate exact and may be we can have other experts to contribute. Eg specific considerations for schema changes or application specific changes for database ops!!?