In a play/test context I found it annoying when my database went to sleep. It gave me a new source of annoying error messages. I solved it by setting the minimum ACU to '1' and the 'Pause after' to 1440 minutes. This worked a treat. It kept warm all day. My calculation is that this would cost $1.44/day.
My question is could/should this technique be used in production? Are there downsides? If this is OK in production you could also add a CloudWatch CRON job to tickle the database every 24 hours. You would have a perpetually warm Aurora.
Thanks
Brian
Top comments (0)