Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

Major Version Upgrades in Aurora Cluster With Replicas - Can it be done in batches ?

0

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."

Document link: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_UpgradeDBInstance.PostgreSQL.html

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 ?

Topics
AnalyticsMigration & ModernizationDatabase
Tags
Aurora PostgreSQLPostgreSQLMigration & ModernizationAmazon Aurora
Language
English
asked 4 years ago3.3K views
2 Answers
0
Accepted Answer

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.

AWS
answered 4 years ago
0

The document link, https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_UpgradeDBInstance.PostgreSQL.html, does not mention anything about upgrading read replicas? Is there any other documentation somewhere that discusses this? Or does it happen automagically (sic) when the Writer gets upgraded?

To safely upgrade the DB instances that make up your cluster, Aurora PostgreSQL uses the pg_upgrade utility. After the writer upgrade completes, each reader instance experiences a brief outage while it's upgraded to the new major version. To learn more about this PostgreSQL utility, see pg_upgrade in the PostgreSQL documentation. You can upgrade your Aurora PostgreSQL DB cluster to a new version by using the AWS Management Console, the AWS CLI, or the RDS API.

Does it mean the Reader gets upgraded automatically too in the process without any other additional steps? It is just saying it uses pg_upgade in the background to do so?

answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Relevant content