I'm currently working on a project to phase out a system hosted on AWS, and I have an RDS instance that's costing me $133 a month, along with the "Amazon Relational Database Service Provisioned Storage" which is pricing at $244 per month. While it's easy for me to decrease the database size, I'm struggling to find ways to cut down on storage costs. My database has 2000GiB of gp3 storage and 12000 Provisioned IOPS. However, when I try to edit the instance, it indicates that 2000 GiB is the minimum allowed, and that amount of IOPS is included regardless of the database size. Interestingly, when the database was larger—four times its current size—the minimum and included IOPS were the same. It seems I can adjust the compute resources, but I can't affect the storage. I'm wondering if this is one of those cases like "the printer's cheap, but the ink is expensive"? If there are any configurations that might allow me to change the overly provisioned storage or any other charges I could be facing, I'd appreciate your assistance!
3 Answers
Unfortunately, there's generally no way to directly reduce the provisioned storage for an existing RDS instance. You might want to look into options like blue/green deployments if your database engine supports it—this lets you create a new version of the database with the required reduced storage, and then you can switch over during a maintenance window.
A blue/green deployment with reduced storage could be another route. You could export (dump) your current data and then import it into a new instance that's set up with less storage. There are also extensions, like pg_repack for Postgres, that help with reducing 'used' storage, but for that, you'd need to be running on a new instance first.
Exactly! If you're using Aurora, it handles storage a bit differently by allocating and deallocating storage blocks based on your needs. But that doesn’t apply in your case since you’re using standard RDS. Good luck, and definitely consider those blue/green options!
Related Questions
Can't Load PhpMyadmin On After Server Update
Redirect www to non-www in Apache Conf
How To Check If Your SSL Cert Is SHA 1
Windows TrackPad Gestures