1 Answer
- Newest
- Most votes
- Most comments
1
Hello.
As stated in the document below, "Aurora MySQL 3.04" is compatible with "MySQL 8.0.28".
In other words, I think the error is occurring because RDS MySQL of "MySQL 8.0.33" is not compatible with Aurora MySQL 3.04.
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.VersionPolicy.html#Aurora.VersionPolicy.MinorVersions
Currently, I think that the only possible migration method is to obtain a dump file from RDS MySQL using MySQLdump, etc., and then import it into Aurora MySQL.
Otherwise, I think it is better to wait for Aurora MySQL to be compatible with "MySQL 8.0.33".
Relevant content
- asked 8 months ago
- asked 5 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 9 months ago
- AWS OFFICIALUpdated a year ago
Do you have an ETA on when .33 will be ready? Migrating using a dump will necessitate a long downtime, compared to using binlog replication. I don't think it's possible to downgrade either?
Unfortunately, AWS has not yet announced support for "MySQL 8.0.33" compatibility. Yes, migration using mysqldump will require significant downtime. I don't think downgrading is officially supported by AWS. I think it is possible to downgrade using the method described in StackOverflow below, but it is a little complicated, so I think it is better to wait until Aurora MySQL supports "MySQL 8.0.33" rather than doing this. https://stackoverflow.com/questions/40839113/is-it-possible-to-downgrade-a-aws-rds-from-mysql-5-7-to-lower-version-say-5-6