Purge deleted rows from DB using db-archiving logic
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
- Started by
- Completed by
- Russell Bryant
Related branches
Related bugs
Sprints
Whiteboard
"I am happy to help review this work" --jogo
This the copy paste of our blueprint https:/
And we done already bunch of work https:/
Dropped this blueprint in favor of the other one --russellb
Work Items
Dependency tree
* Blueprints in grey have been implemented.