AWS Aurora: upgrading to serverless v2 from v1

Question

I've been tasked with upgrading our AWS Aurora engine version from 11.16 to 15.2. We're running a Postgres-compatible engine.

As part of this upgrade, it's also been suggested that we upgrade from Serverless version 1 to Serverless version 2.

From https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-serverless-v2.upgrade.html#aurora-serverless-v2.upgrade-from-serverless-v1-procedure, it looks like I need to do the following:

1. Upgrade Aurora from 11.16 to 13.9;
2. Convert the Serverless v1 cluster to a provisioned Aurora PostgreSQL cluster;
3. Modify the writer DB instance of the provisioned DB cluster to use the Serverless v2 DB instance class;
4. Do a second upgrade of Aurora from 13.9 to 15.2.

I've read through the AWS documentation and it all seems to make sense until I get to point (3) above. The documentation sends me to https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-serverless-v2-administration.html#aurora-serverless-v2-converting-from-provisioned but within that section, it doesn't actually seem to explain what steps I need to take in order to modify the writer instance. There are links to other pages but I get increasingly lost.

Would anyone have an example of how to do step (3) above, please? Perhaps I'm looking for the wrong thing but I can find no examples of how to do this outside of the AWS documentation either.

Thanks in advance for any assistance.

Answer 1

In the end, we only upgraded to Aurora Postgres 13.9 with Serverless v2 due to restrictions in our region.

The process that we found worked was as follows:

• Convert Postgres cluster from 11.16 to 13.9 (serverless v1)
• Remove the Postgres 13.9 (serverless v1) cluster
• Create a new Postgres 13.9 provisioned cluster
• Add 3 provisioned DB instances (1 writer, 2 readers) to the provisioned cluster
• Convert all three of the provisioned DB instances to serverless v2