Add ability to limit archiving of deleted instances up to date

Registered by Jake Yip on 2019-04-04

Nova soft-deletes instances and their associated information, which means the database rows are never deleted, but just marked as deleted. In big clouds this can impact DB performance, so an option to archive (move) 'deleted' information to shadow_* tables was implemented. This is great, however, the archival code does not have fine grained control on limiting archive based on date.

Optimally, in our cloud, we would like to keep a records up to a certain number of years (3) for reporting purposes, and archive everything older than that.

We have a patch working for us and would like to gauge if the nova team is interested in merging it. The patch adds an extra option `--before` to `nova-manage db archive_deleted_rows`.

Blueprint information

Status:
Complete
Approver:
Eric Fried
Priority:
Low
Drafter:
Jake Yip
Direction:
Approved
Assignee:
Jake Yip
Definition:
Approved
Series goal:
Accepted for train
Implementation:
Implemented
Milestone target:
milestone icon train-2
Started by
melanie witt on 2019-05-23
Completed by
Matt Riedemann on 2019-06-20

Related branches

Sprints

Whiteboard

Gerrit topic: https://review.openstack.org/#q,topic:bug/1751192,n,z

Addressed by: https://review.openstack.org/556751
    Add --before to nova-manage db archive_deleted_rows

Gerrit topic: https://review.opendev.org/#/q/topic:bug/1751192

Addressed by: https://review.opendev.org/556751
    Add --before to nova-manage db archive_deleted_rows

Looks like this is complete since https://review.opendev.org/#/c/556751/ is merged. -- mriedem 20190620

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.