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

Database Cluster Blue/Green Deployment on Unsupported Instance Type in Aurora MySQL

0

Issue Overview:

Current Setup: My database cluster is currently running on db.r4.large instance type. and Aurora (MySQL 5.7) 2.11.2
Upgrade Target: I aim to upgrade to Aurora MySQL version 8.0.mysql_aurora.3.06.0.
Challenge: The db.r4.large instance type is not supported for this Aurora MySQL version. My plan was to switch to db.r5.large during the Blue/Green Deployment.

Attempted Solutions and Challenges:

Blue/Green Deployment Strategy: I attempted to use a Blue/Green Deployment approach to mitigate risks associated with direct upgrading. However, I'm unable to specify the db.r5.large instance type during the deployment process.
AWS CLI Efforts: I also tried to specify the db.r5.large instance type for the cluster using AWS CLI, but this approach didn't allow for the change in instance type either.

Enter image description here

Questions:

Are there any known workarounds or strategies to specify a different instance type (db.r5.large) during a Blue/Green Deployment for Aurora MySQL?
Is there an alternative approach or best practice that would allow the instance type change while minimizing risks associated with the upgrade?


Thank you in advance for your support!

질문됨 8달 전181회 조회
1개 답변
0

There are a few options to consider for changing the instance type during a blue/green deployment for an Aurora MySQL cluster:

Take a snapshot of the existing cluster and restore it to a new cluster with the desired instance type. Then perform a switchover to route traffic to the new cluster. This avoids downtime but requires twice the resources during the transition.

Use the AWS Database Migration Service (DMS) to migrate the database from the existing cluster to a new one configured with the target instance type. DMS can minimize downtime during the migration.

If the target instance type is a larger one, scale out the existing cluster by adding instances before performing the switchover. This allows leveraging the existing data without restoring from a snapshot.

For non-production environments, an in-place upgrade is possible by taking an outage during the instance type change. However, this is not recommended for production databases due to the risks.

The best approach would depend on your specific environment and requirements around downtime. AWS documentation provides more details on performing upgrades, migrations and switchovers for Aurora clusters.

profile picture
전문가
답변함 8달 전

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

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

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

관련 콘텐츠