nova db purge util

Registered by Abel Lopez

This blueprint has been superseded. See the newer blueprint "Simple DB Purging" for updated plans.

Adding functionality to `nova-manage db` to safely purge "deleted" data. This will have non-optional argument of nDays.
For example `nova-manage db purge 60` will go into the nova db, and delete from each table where 'deleted =! 0 and deleted_at > date_sub(NOW(), interval 60 day);'

This is a useful feature as Openstack matures and operators/admins are upgrading over time.

Blueprint information

Status:
Complete
Approver:
None
Priority:
Undefined
Drafter:
Abel Lopez
Direction:
Needs approval
Assignee:
Abel Lopez
Definition:
Superseded
Series goal:
None
Implementation:
Unknown
Milestone target:
None
Completed by
Matt Riedemann

Related branches

Sprints

Whiteboard

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

Addressed by: https://review.openstack.org/132656
    Database purge deleted spec

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.