How to asynchronously scale aurora serverless v2 replicas

0

I have an aurora postgresql serverless v2 cluster with 2 instances, one writer and another reader and would like them to scale independently. According to documentation, if the reader instance is in a Failover priority other than 0 or 1. They SHOULD scale independently but still no matter what I do, they always scale synchronously. I have a workload that runs twice a day and demands the higher acu count but the reader instance has very low usage, so I would like them to scale independently to save on costs. In my use case it is not a problem if there is a longer downtime for the reader instance to scale and take over in case of failure.

Thanks

asked a year ago280 views
2 Answers
0

The documentation says "When they are idle, they can scale down to the minimum" - have you confirmed in CloudWatch that they really are idle? Handling replication from a busy writer will put some load on a reader but you would hope not too much. Still it's worth looking how busy it is.

EXPERT
answered a year ago
0

I checked and they are not busy as the writer on the heavy workloads. as an experiment I created a provisioned aurora server (with more resources than the serverless ones had), failed over to it and removed one of the serverless instances. and now the serverless instance hasn't gone past 8 acu a single time. if I get the metrics of serverless capacity of the past 24 hours we can clearly see the difference on acu allocation after the changes. And about replication, I might be wrong but my understanding is that with aurora, replication is done at the storage layer and wouldn't put any pressure on reader instances.

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.

Guidelines for Answering Questions