Cleanup work with DB in cinder

Registered by Boris Pavlovic

This is the base BP for others BP, that should collect all other BPs around DB.

In Nova we have done a tons work in grizzly around improving DB handling:

1) provide unique constraints
2) shadow tables, to remove deleted rows from table
3) migration tests on all backends with real data
4) improved session handling
5) fully cover by tests cinder

So we should implement all this things in cinder also.

Blueprint information

Status:
Complete
Approver:
John Griffith
Priority:
Medium
Drafter:
Boris Pavlovic
Direction:
Approved
Assignee:
Ivan Kolodyazhny
Definition:
Obsolete
Series goal:
Accepted for future
Implementation:
Started
Milestone target:
milestone icon ongoing
Started by
Boris Pavlovic
Completed by
Sean McGinnis

Related branches

Sprints

Whiteboard

(smcginnis): Marking obsolete as this has been sitting out there for a long time. If this is still needed, please submit a new bp.

There's some debate on the list as to whether this is a good approach for Cinder to adopt. See http://lists.openstack.org/pipermail/openstack-dev/2013-July/thread.html#11412

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

Addressed by: https://review.openstack.org/36648
    Remove unused migration_* methods from db api.

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

By looking into the patch of https://review.openstack.org/36648, it has been merged into Aug 2, 2013.
Should it be marked as implemented?
---- ling-yun 2014-09-21

(?)

Work Items

Dependency tree

* Blueprints in grey have been implemented.

This blueprint contains Public information 
Everyone can see this information.