Simple DB Purging

Registered by Dan Smith on 2018-03-06

We have no built-in command to purge the database once tables have been archived to shadow. This is not hard, and is something we have been putting off for many years.

Blueprint information

Status:
Complete
Approver:
Matt Riedemann
Priority:
Medium
Drafter:
Dan Smith
Direction:
Approved
Assignee:
Dan Smith
Definition:
Approved
Series goal:
Accepted for rocky
Implementation:
Implemented
Milestone target:
milestone icon rocky-1
Started by
Matt Riedemann on 2018-03-06
Completed by
Matt Riedemann on 2018-03-08

Related branches

Sprints

Whiteboard

Gerrit topic: https://review.openstack.org/#q,topic:bp/purge-db,n,z

Addressed by: https://review.openstack.org/550171
    Add simple db purge command

There is quite a bit of prior art (and at least one approved spec) for this same type of thing:

https://blueprints.launchpad.net/nova/+spec/purge-soft-deleted-rows
https://blueprints.launchpad.net/nova/+spec/database-purge
https://blueprints.launchpad.net/nova/+spec/purge-deleted-instances-cmd

I would have to compare those other proposals to the patch Dan has up to determine the differences, which I likely won't do, but they are all basically after the same goal: hard delete (soft) deleted records from the main tables and the shadow tables, and include an option for how far back to look when performing the delete. I'll mark the other blueprints as superseded against this one. -- mriedem 20180306

Addressed by: https://review.openstack.org/550182
    Add --purge helper flag to archive_deleted_rows

Addressed by: https://review.openstack.org/550194
    Run post-test archive against cell1

Addressed by: https://review.openstack.org/550502
    Make nova-manage db purge take --all-cells

Specless blueprint approved in the March 8 2018 nova meeting. -- mriedem 20180308

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.