Scheduled Aurora Read Replica Scaling

Hello

Since you mentioned target tracking, I assume you have AutoScaling setup on the Aurora cluster. You can use Scheduled Scaling policies, which are a native part of Application AutoScaling (the service which tells RDS when to scale)

https://docs.aws.amazon.com/cli/latest/reference/application-autoscaling/put-scheduled-action.html

This will be simpler and cheaper (no Lambda costs) than EventBridge -> Lambda. Make sure you select a timezone when you set it up if you live in a country with time changes to account for those.

Summary: if you're only using scheduled actions and not target tracking, just set both the Min and Max in each scheduled action to the same value, and that's what the desired capacity will change to. If you're also using target tracking to handle bursts, you'll want to set the Min to the value you want desired to be at when scaling-out, and have the max be a bit higher to allow for additional scale-out to handle unexpected bursts of traffic

Details: The scheduled action sets the min and/or max values of the scalable target. If the desired capacity would be outside this new min/max range, then it will get dragged along with the new min/max values. A couple quick examples for scale-out, but the same concepts apply for scale-in (first column values before the action; middle column is the min/max set in the scheduled action; last column the values after the scheduled action triggers. NULL means the value wasn't included in the scheduled action)