Add DB2 as an option for backend database

Registered by Thuy Christenson on 2013-01-10

Current OpenStack supports multiple open source database as the backend database, for example: MySQL, SQLite, PostgreSQL are the default supported database for the community.

I plan to contribue changes to Nova to allow the use of DB2 as the backing database, and doing so will require me to:

1. Update Nova project to support DB2 initialization and access by updating the SQLALchemy-migrate code.
2. Run tempest on a DB2 installed environment

Blueprint information

Status:
Complete
Approver:
John Garbutt
Priority:
Low
Drafter:
Matt Riedemann
Direction:
Approved
Assignee:
Matt Riedemann
Definition:
Approved
Series goal:
Accepted for liberty
Implementation:
Implemented
Milestone target:
milestone icon 12.0.0
Started by
Matt Riedemann on 2013-11-19
Completed by
Matt Riedemann on 2015-07-13

Whiteboard

To be clear, I think publicly running CI using DB2 should be a requirement before this can be merged --russellb

Depends on sqlalchemy-migrate DB2 blueprint completion:

https://blueprints.launchpad.net/sqlalchemy-migrate/+spec/add-db2-support

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

Addressed by: https://review.openstack.org/62965
    Use the utils code in the 212 migration script

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

Addressed by: https://review.openstack.org/69046
    DB2: Handle ibm_db_sa in modify_indexes

Addressed by: https://review.openstack.org/69047
    WIP: Add DB2 migration support

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

Currently blocked on getting CI running on this. --russellb

Unapproved - please re-submit via nova-spec --johnthetubagy (20th March 2014)

Removed from next, as next is now reserved for near misses from the last milestone --johnthetubaguyTo be clear, I think publicly running CI using DB2 should be a requirement before this can be merged --russellb

Depends on sqlalchemy-migrate DB2 blueprint completion:

https://blueprints.launchpad.net/sqlalchemy-migrate/+spec/add-db2-support

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

Addressed by: https://review.openstack.org/62965
    Use the utils code in the 212 migration script

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

Addressed by: https://review.openstack.org/69046
    DB2: Handle ibm_db_sa in modify_indexes

Addressed by: https://review.openstack.org/69047
    WIP: Add DB2 migration support

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

Currently blocked on getting CI running on this. --russellb

Unapproved - please re-submit via nova-spec --johnthetubagy (20th March 2014)

Removed from next, as next is now reserved for near misses from the last milestone --johnthetubaguy

Marking this blueprint as definition: Drafting. If you are still working on this, please re-submit via nova-specs. If not, please mark as obsolete, and add a quick comment to describe why. --johnthetubaguy (20th April 2014)To be clear, I think publicly running CI using DB2 should be a requirement before this can be merged --russellb

Depends on sqlalchemy-migrate DB2 blueprint completion:

https://blueprints.launchpad.net/sqlalchemy-migrate/+spec/add-db2-support

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

Addressed by: https://review.openstack.org/62965
    Use the utils code in the 212 migration script

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

Addressed by: https://review.openstack.org/69046
    DB2: Handle ibm_db_sa in modify_indexes

Addressed by: https://review.openstack.org/69047
    WIP: Add DB2 migration support

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

Currently blocked on getting CI running on this. --russellb

Unapproved - please re-submit via nova-spec --johnthetubagy (20th March 2014)

Removed from next, as next is now reserved for near misses from the last milestone --johnthetubaguyTo be clear, I think publicly running CI using DB2 should be a requirement before this can be merged --russellb

Depends on sqlalchemy-migrate DB2 blueprint completion:

https://blueprints.launchpad.net/sqlalchemy-migrate/+spec/add-db2-support

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

Addressed by: https://review.openstack.org/62965
    Use the utils code in the 212 migration script

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

Addressed by: https://review.openstack.org/69046
    DB2: Handle ibm_db_sa in modify_indexes

Addressed by: https://review.openstack.org/69047
    WIP: Add DB2 migration support

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

Currently blocked on getting CI running on this. --russellb

Unapproved - please re-submit via nova-spec --johnthetubagy (20th March 2014)

Removed from next, as next is now reserved for near misses from the last milestone --johnthetubaguy

Marking this blueprint as definition: Drafting. If you are still working on this, please re-submit via nova-specs. If not, please mark as obsolete, and add a quick comment to describe why. --johnthetubaguy (20th April 2014)

Marking this blueprint as definition: Drafting. If you are still working on this, please re-submit via nova-specs. If not, please mark as obsolete, and add a quick comment to describe why. --johnthetubaguy (20th April 2014)

Addressed by: https://review.openstack.org/87096
    Add support for DB2 as a backend database

Addressed by: https://review.openstack.org/97946
    WIP: Enforce unique instance uuid in data model

Its not obvious all the code is actually ready for review here, please tidy up the list of patches before moving back to NeedsCodeReview. Not all the reviews have +2s and are not all are close to approval, so moving to juno-3. But please move this back to juno-2, should you get your patches approved in time. --johnthetubaguy 21st July 2014

Sorry, this does not have enough positive reviews to make it for juno-3, please resubmit for kilo. For more information, please contact me (johnthetubaguy) via IRC or email. --johnthetubaguy 2nd September 2014

Addressed by: https://review.openstack.org/135635
    WIP: Separate test for migration 266

Addressed by: https://review.openstack.org/141097
    (Re)Propose "Add DB2 as an option for backend database"

Addressed by: https://review.openstack.org/182379
    (Re)Propose "Add DB2 as an option for backend database"

(?)

Work Items

Work items:
Unit Tests: INPROGRESS
Migration Scripts: INPROGRESS
Sync oslo-incubator db.api changes: DONE
CI with Tempest: INPROGRESS
User Documentation: TODO

Dependency tree

* Blueprints in grey have been implemented.

This blueprint contains Public information 
Everyone can see this information.