move legacy DB snapshots to EBS archive?

[rahulbot]

Almost 60% of our last month's AWS bill was EBS volumes. I think those are snapshots of the legacy Postres DB. Can we move those to EBS Snapshots Archive to reduce that ongoing cost? I think at some point we'll be able to delete them, but for right now we still want them in our back pocket. Any thoughts on if this would help @kilemensi and @thepsalmist ?

[rahulbot]

Details on $5,600 Jan bill:

• ongoing storage cost was $2k (>80TB?!?)
• the EBS cost was $3.2k

[philbudne]

My recall of AWS "cold storage" is that it almost always comes with a minimum payment/duration (if you restore sooner than the minimum duration, you still have to pay for the entire minimum duration?), so I would suggest asking the researchers (especially in light of their need for counts in 2018 data) about their near term needs.

[rahulbot]

The DB snapshots are 71TB on EC2. At the quoted EBS archive tier rate of $0.0125 per GB-month keeping those DB snapshots around would cost us $887.5 if archived (current cost $3,500 @ $0.05/GB-month standard tier rate). This is a big reduction of cost and I think worth it for keeping them around while we restore data. Any objections? If not then we should do this via the AWS console.

Relevant notes from their docs:

• minimum storage of 90 days (as @philbudne noted)
• restoring from archive tier to standard costs ($0.03/GB), and can take a few days

[rahulbot]

Agreement to delete the non-database snapshots and move the database snapshots to EBS archive.

[thepsalmist]

Done, moved all the Postgres and Solr snapshots to Archive storage tier