Creating an Aurora MySQL v3 cluster from data stored in S3

0

Hi,

I tried following this procedure to import the data of a MySQL 8.0 instance running on my development laptop, through S3, to a new Aurora MySQL v3 cluster. First issue was that I had to use Percona XtraBackup 8.0, since 2.4 does not support MySQL 8.0.

Then, creating the new cluster through the Console gives me the following validation error:

You can't restore to aurora-mysql 8.0.mysql_aurora.3.02.2 from an S3 backup of mysql 8.0.

This used to work from a local MySQL 5.6 to an Aurora MySQL v1, but, unfortunately, that version is now EOL.

I can't see any references to MySQL 8.0 on the page linked above, nor from the similar CLI operation page. Does this mean restoring from S3 is not available for Aurora MySQL v3?

If so, what are the alternatives? My use case is to spin up a replica of our whole production environment, using locally prepared test data, from a single (terraform) command.

Also, maybe it would be good to update the various documentation to explicitly state that MySQL 8.0 is not supported, since I imagine a lot of people had to migrate to it, following the EOL of 5.6.

Cheers, Cyril.

1 Risposta
0
Risposta accettata

Update:

We have already released Aurora MySQL3 support.

There are some limitations before you use this migration path to Aurora MySQL3 from MySQL8.0. More detailed information can be found in the document: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Migrating.ExtMySQL.S3.html

AWS
con risposta 3 giorni fa
  • Thank you. Indeed, I noticed the blog post about it some time ago and already used it successfully!

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande