- Newest
- Most votes
- Most comments
Hi,
Thank you for asking your question.
DMS has limitation on auto_increment as described in the document.
The AUTO_INCREMENT attribute on a column isn't migrated to a target database column.
To upgrade to RDS MySQL8.0 from RDS MySQL5.7, we have several option, in-place[1], snapshot/restore, and Amazon RDS Blue/Green Deployments[2].
For more information, please see AWS database blog Best practices for using a MySQL read replica to upgrade an Amazon RDS for MySQL database
[1] https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_UpgradeDBInstance.MySQL.html#USER_UpgradeDBInstance.MySQL.Major / https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/MySQL.Procedural.Importing.External.Repl.html
[2] https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/blue-green-deployments-overview.html
I hope this might help.
Thanks for your clarification.
But in my case the 2 RDSs in different accounts and the source RDS is encrypted using the default key so we can't share the key to the other account to use the snapshot solution.
Is the blue/green deployment can work on that case?
You can copy a snapshot to one with a KMS key and then share with the other account if needed.
Unfortunately, Amazon RDS Blue/Green Deployments doesn't support cross account configuration.
For snapshot share with KMS key, please see below documents.
Hi, I'd suggest to use AWS DMS with MySQL as source: see https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.MySQL.html
DMS will provide you with lots of flexibility in this migration via transformation rules, etc.
Also, if you use its CDC feature, you can create the new version in parallel of the current one and get it updated in quasi real-time to see how it behaves.
See https://aws.amazon.com/dms/features/ for all available features
Best,
Didier
I already tried DMS as my first solution but after using it, I find that the auto_increment and restet the auto_increment are missing from the tables.
Relevant content
- asked 2 years ago
- Accepted Answerasked 2 years ago
- asked 3 months ago
- asked 4 years ago
AWS OFFICIALUpdated 2 years ago- AWS OFFICIALUpdated 3 years ago
- AWS OFFICIALUpdated a year ago
Can you claify you are Migrating data vs upgrading your RDS instance from 5.7 to 8? How have you been migrating the data so far if thats the case?
I do both. I migrate data from RDS 5.7 to another RDS 8.0.. I migrated the data using DMS and the auto_incremenet isn't migrated.