AWS re:Post을(를) 사용하면 다음에 동의하게 됩니다. AWS re:Post 이용 약관
AWS re:Postre:Post

Unable to restore Aurora Serverless V1 snapshot to Aurora Provisioned

1

We are attempting to migrate to provisioned aurora as we need to be able to enable binlog.

We have quite a large database so mysqldump and read in is going to require a very hard to arrange amount of downtime for our service.

When we attempt to restore our snapshot to a provisioned instance, we get this message:

The selected instance class 'db.r3.large' is not supported for the engine version of your snapshot. Please retry with an instance type supported by engine version '5.7.mysql_aurora.2.07.1' and then scale-compute to your desired instance type.

The following documentation suggest that the engine is compatible: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Concepts.DBInstanceClass.html

Is there something we are missing that makes this impossible?

We have tried a load of different combinations of instance types. We have searched this forum and other sources and can find no information about migrating in this direction, but can also find no information suggesting it shouldn't work.

주제
분석데이터베이스
태그
아마존 Aurora오로라 MySQL
언어
English
AWS-Hugh-wn
질문됨 2년 전921회 조회
2개 답변
2
수락된 답변

For anyone else looking for an answer to this, we got it to work in the end by using db.t3.small and the latest engine (no other combination works). You can scale to the instance type you want afterwards.

AWS-Hugh-wn
답변함 2년 전
profile picture
전문가
Giovanni Lauria
검토됨 한 달 전
  • AWS-ADolganov
    2년 전

    This is very interesting, I'll try to reproduce this and bring up to the support if confirmed.

  • DaveMendez
    2년 전

    I just had the exact issue described in this post and can also validate that only restoring to a db.t3.small instance type worked. I had a snapshot of an Aurora Serverless v1 that I wanted to restore to a Provisioned cluster, and only selecting the 'db.t3.small' instance would allow the operation to take place. All other instance types produced the same error described in this post.

0

Hello

The DB snapshot must have been made from an Amazon RDS DB instance running MySQL version 5.6 or 5.7.

If you want to migrate a MySQL version 5.6 snapshot to Aurora MySQL version 5.7, you can perform the migration in one of the following ways:

Migrate the MySQL version 5.6 snapshot to Aurora MySQL version 5.6, take a snapshot of the Aurora MySQL version 5.6 DB cluster, and then restore the Aurora MySQL version 5.6 snapshot to Aurora MySQL version 5.7.

Upgrade the MySQL version 5.6 snapshot to MySQL version 5.7, take a snapshot of the MySQL version 5.7 DB instance, and then restore the MySQL version 5.7 snapshot to Aurora MySQL version 5.7.

profile picture
GK
답변함 2년 전
  • AWS-Hugh-wn
    2년 전

    Hi, thanks for taking the time to respond.

    We aren't actually on Amazon RDS, so I'm not sure that link applies. I have read through a couple of times and I cant find anything that is relevant.

    We are on Aurora Serverless 5.7 - engine: 5.7.mysql_aurora.2.07.1 (the only option, so I cant upgrade the engine or mysql version). We are trying to move to Provisioned Aurora using the same engine on an r3 instance type. It is an option of the form when you try to restore the snapshot to use Provisioned Aurora, but there seems to be no way to make it work.

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠