1929910 - Clean up DEV database

Status: NEW

(Webtools :: Bouncer, task)

Description

[William Durand [:willdurand]]

In Bug 1929196 and Bug 1929637, we removed code that was unused as well as db fixtures that weren't used either. Many DB tables were created for/by Tuxedo, which is no longer a thing (Bug 1929048) and others are probably older than that, and also unused.

As of now, the following tables are IN USE on dev:

• mirror_aliases
• mirror_locations
• mirror_os
• mirror_product_langs
• mirror_products
• mirror_mirrors: this one is no longer used either but still referenced in bouncer-admin so we cannot remove it yet: https://github.com/mozilla-services/bouncer-admin/blob/4484c3f3035ed730eb8aefaab258e66694d387d9/nazgul/mysql_model.py#L217

The following tables are UNUSED and should be removed to clean up/simplify the database:

• sentry_log
• mirror_log
• mirror_sessions
• mirror_location_mirror_map
• mirror_lmm_lang_exceptions
• mirror_mirrors_contacts
• mirror_users
• south_migrationhistory
• users_userprofile
• auth_*
• django_*
• geoip_*

This bug is about removing these unused tables in dev only for now. Maybe we should temporarily rename the tables to <table name>_deprecated or something, and if everything looks fine, we can safely remove them.

Comment 1

[William Durand [:willdurand]]

(In reply to William Durand [:willdurand] from comment #0)

• mirror_mirrors: this one is no longer used either but still referenced in bouncer-admin so we cannot remove it yet: https://github.com/mozilla-services/bouncer-admin/blob/4484c3f3035ed730eb8aefaab258e66694d387d9/nazgul/mysql_model.py#L217

I filed https://github.com/mozilla-services/bouncer-admin/issues/145

Comment 2

[William Durand [:willdurand]]

https://github.com/mozilla-services/bouncer-admin/issues/145 has been fixed so once we have that deployed to dev, we can also get rid of the mirror_mirrors table.