Scale an AWS Aurora cluster's writer node
13 Mar 2018 - Aaron Dodd
While there is no “autoscaling” for RDS, for adjusting an instance on a schedule, the AWS CLI can be used. For an Aurora cluster, when you resize the primary node (the writer), AWS fails writes over to one of the readers but never switches that role back (see the AWS doc for details on the failover settings and logic). This would leave the cluster in a state where the up-sized node becomes a “reader” and one of the smaller nodes would remain a “writer”.
In this use-case, I needed to increase the capacity of the writer for a few hours a day for a known ingestion event (the fleet of readers could remain the same size and number), but then decrease the writer afterwards. The standard “aws rds modify-db-instance” call works as expected, but after scaling the instance, Aurora still leaves a smaller reader in the cluster as the primary (writer).
Below is a script that does the resizing, then waits until the change has taken effect, then switches the “writer” back to the newly resized node.
Where the parameter is the new shape to apply.
The cluster ID and node names used can be found in the RDS / Cluster page in the AWS console.
This can run as either a cron or part of the ingestion process.
There are likely better ways to actually check for the status.