I have a mysql RDS instance that is used only from 9am to 9pm.
To avoid too much charges, I would like to stop it during the night, but I cannot do this because I have Multi-AZ active (I need it during server use).
Does it make sense to schedule this process?
@8:45pm:
- disable multi-AZ
- stop RDS instance
@8:45am:
- start RDS instance
- enable multi-AZ
Sounds like a good cost-cutting move.
You can create a lambda function (or two) that uses an AWS library (like boto3) to perform this disabling/enabling of multi-AZ and of your RDS instance.
Then, use CloudWatch Events to trigger the lambda function at the times you specify.