search

mitodl / ol-infrastructure

Infrastructure automation code for use by MIT Open Learning
BSD 3-Clause "New" or "Revised" License
44 stars 4 forks source link

Clean up unused Heroku / Artisenal RDS databases that have been migrated to Pulumi RDS #2002

Closed feoh closed 8 months ago

feoh commented 9 months ago

Description/Context

Clean up the XPro databases we're no longer using, and while I'm there, check through my folder of already converted Heroku databases and ensure that the pre-conversion DBs are no longer burning money :)

Examples from XPro:

export HEROKU_DATABASE_URL="postgres://USER:PASS@ec2-35-168-107-75.compute-1.amazonaws.com:5432/d966ficl2h0ecu"
export HEROKU_DATABASE_URL="postgres://USER:PASS@production-apps-rds-postgres-mitxpro.cbnm7ajau6mi.us-east-1.rds.amazonaws.com:5432/mitxpro"
export HEROKU_DATABASE_URL="postgres://USER:PASS@ec2-54-164-40-66.compute-1.amazonaws.com:5432/d4p2bkbdd9l3jk"

Plan/Design

Can probably just use the AWS / Heroku CLI to remove the obsoleted DBs.

feoh commented 8 months ago

Removed Heroku xpro ci and rc databases as well as bootcamp-ecommerce ci and rc heroku databases.

Checked all converted products (bootcamp, xpro, micromasters) and no Heroku billed dataabases remain AFAICT.