How to change RDS instance type in Aurora cluster without downtime?
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?
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
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. "
Relevant questions
Upgrading Aurora MySQL 5.6 to 5.7 on cross region replica stuck in pre-upgrade checks and reboots every 30 minutes
asked a month agoHow to change RDS instance type in Aurora cluster without downtime?
Accepted Answerasked a month agocreate simple RDS Aurora instance
asked 2 months agoAurora cluster requires a system update?
asked 3 years agoIs Aurora sure distribution Reader request across the entire Reader instance?
Accepted Answerasked a month agoIs it possible for RDS Proxy to ignore a reader instance?
asked a month agoHow to failback to Original Writer instance after Upgrade
asked 2 months agoHow to determine the precise reasons why two instance types are incompatible?
Accepted Answerasked a month agoUnable to configure Multi AZ deployment for existing Aurora MySQL
Accepted Answerasked 2 months agochange EC2 parameters (cores, RAM) after I have installed a GUI and some softwares
asked 4 months ago