Purge deleted rows from DB using db-archiving logic

Registered by David Ripton

db-archiving moves soft-deleted rows from the live database tables to shadow tables, using a nova-manage command, that should be called periodically. A limited number of rows are deleted in each call, to avoid overloading the database. The code works, but nobody uses it.

We need similar logic to actually delete soft-deleted rows. And optionally dump the deleted rows to a file, using a format similar to that used by the dump tools of mysql and postgres.

(Another option would be to purge data from the shadow tables, but since nobody actually uses the shadow tables, that doesn't appear to be useful.)

Blueprint information

Status:
Complete
Approver:
Joe Gordon
Priority:
Undefined
Drafter:
David Ripton
Direction:
Approved
Assignee:
David Ripton
Definition:
Superseded
Series goal:
None
Implementation:
Not started
Milestone target:
None
Completed by
Russell Bryant

Related branches

Sprints

Whiteboard

"I am happy to help review this work" --jogo

This the copy paste of our blueprint https://blueprints.launchpad.net/nova/+spec/db-purge-engine
And we done already bunch of work https://review.openstack.org/#/c/57378/ -- boris-42

Dropped this blueprint in favor of the other one --russellb

(?)

Work Items

Dependency tree

* Blueprints in grey have been implemented.

This blueprint contains Public information 
Everyone can see this information.