How to change RDS instance type in Aurora cluster without downtime?

0

I want to change the instance type of the current Reader (PostgreSQL), and I am having 2 Reader instances. I will replace the instance one by one, wait for it to succeed, then replace the next instance. Will this cause downtime for my Aurora Cluster, and if yes, how long will it be?

iamnick
질문됨 2년 전8730회 조회
3개 답변
1

There is no way to change instance class of Aurora instances. It may take up to 15 mins. From this link : "Scaling isn't instantaneous. It can take 15 minutes or more to complete the change to a different DB instance class. We recommend that if use this approach to modify the DB instance class, you apply the change during the next scheduled maintenance window (rather than immediately) to avoid affecting users. "

AWS
Vivek_S
답변함 2년 전
0

OP, your strategy is mostly correct. Instances will become unavailable during the instance modification. With that in mind, you can upgrade your readers one at a time, or if you need at least two readers up at all times to handle load, add additional readers to the cluster in your target instance type and size. Once the readers are upgraded or added, you can fail the writer instance over to one of the upgraded readers. During the failover read and write operations fail with an exception. However, service is typically restored in less than 60 seconds, and often less than 30 seconds. You can improve this process with RDS Proxy. The proxy automatically routes traffic to a new database instance while preserving application connections. It also bypasses Domain Name System (DNS) caches to reduce failover times by up to 66% for Aurora Multi-AZ databases. Once you have three upgraded instances (one writer and two readers), you can delete any additional unnecessary instances. More information about high availability for Amazon Aurora is available in the User Guide.

profile pictureAWS
답변함 2달 전
-1
수락된 답변

Hello,

The following link include information for your use case

Amazon RDS Multi-AZ with two readable standbys: Automatically failover in typically under 35 seconds with zero data loss and with no manual intervention.

https://aws.amazon.com/rds/features/multi-az/#Amazon_RDS_Multi-AZ_with_two_readable_standbys

profile pictureAWS
답변함 2년 전
  • "RDS Multi-AZ with two readable standbys," is a completely different configuration than Aurora.

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

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

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

관련 콘텐츠