We are running an EC2 Instance with MySQL and and IOPS Volume. (We will eventually be upgrading to RDS but this is what we have for now)
We have peak times where the IOPS really helps, but the rest of the time it is just costing us extra money to have the IOPS and to be running an m1.large instance.
I have considered writing a BASH script to manage this, but I would have to stop the server, make a snapshot, create a new volume from the snapshot, attach that to the server, delete the old IOPS volume ...
Is there a better way to manage this, so I am only paying for the IOPS when I need it?