Major Version Upgrades in Aurora Cluster With Replicas - Can it be done in batches ?
For Major version upgrades in Aurora cluster, AWS documentation says: "To safely upgrade your DB instances, Aurora PostgreSQL uses the pg_upgrade utility described in the PostgreSQL documentation. After the writer upgrade completes, each reader instance experiences a brief outage while it's upgraded to the new major version automatically."
If the cluster has 10 replicas is it possible to do the upgrade in batches or one-by-one, so that the clients dependent on the replicas do not experience downtime ?
Unfortunately, no. Aurora manages all the nodes at the cluster level and data replication synchronously across Availability zones, hence it does not provide an option to choose upgrading specific nodes separately. The application will have to be stopped, and once the cluster is entirely upgraded, you can resume the application.
(Serverless) Amazon Aurora MySQL 1 end of life on February 28, 2023asked 2 months ago
Major Version Upgrades in Aurora Cluster With Replicas - Can it be done in batches ?Accepted Answerasked 3 months ago
Upgrade for Amazon Aurora Serverless v1 PostgreSQL-compatible edition 10.x end of support is January 31, 2023asked a month ago
Aurora cluster maintenance window and minor version upgradesasked 4 months ago
RDS Aurora - stop upgrading processAccepted Answerasked a month ago
How to debug In-place upgrade of the engine to the new target version 8.0.mysql_aurora.3.01.0 is not supported.asked 3 months ago
Announcement: Amazon Aurora PostgreSQL 10.x end of support is January 31, 2023asked 4 months ago
Granular per-instance access in an Aurora DB clusterasked a month ago
Cannot upgrade minor version RDS Aurora MySQL ClustersAccepted Answerasked 4 months ago
Major Version Upgrade Aurora PostgreSQL 11asked 2 years ago