csmberkeley / csm_web

Web applications for CS Mentors.
https://scheduler.csmentors.org/
MIT License
15 stars 10 forks source link

Convert old RDS snapshots to data files #482

Open edwardneo opened 1 month ago

edwardneo commented 1 month ago

Currently, AWS RDS snapshots are costing us a lot of money. We should look to convert these into the cheaper data files that we have been using to backup data anyways by uploading it to S3. This would require applying the snapshots to the staging database, then running the data dump commands, getting the local .sql and .json files, and uploading them to S3. Then we can clear the snapshots and save costs.