Could anyone tell me if there is any way to auto-scale AWS RDS?. What we are experiencing is that our peaks on RDS are relatively very small. Is there any possibility that we can scale short term on peak and then roll back after it?
What I was thinking is to use AWS cloud watch to get the RDS metric and if it is > 90% then launch an EC2 instance in the auto-scaling group with a database application installed in it and connect it with our architecture and destroy it when peak goes down) is it possible? Thanks in advance!