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年前8668ビュー
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.

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ