/
2022-01-11 - ONAP: Database Upgrade and Rollback in Policy Framework

2022-01-11 - ONAP: Database Upgrade and Rollback in Policy Framework

Topic Leader(s)

  • @Kevin Timoney

  • @Adheli Tavares

Topic Description

30m @Kevin Timoney

Upgrade and rollback of database objects to work with required ONAP release 

Topic Overview

Investigation of available technologies (liquibase and flyway) and why we chose our own solution.

Overview of how "policy-db-migrator" works - easy to use shell scripting solution which was easy to integrate with OOM.

"policy-db-migrator" features : Automatic version detection. Partial upgrade/downgrade in case of failure.

How implementing "policy-db-migrator" helped the project - benefits of pre-installed schema over JPA.

Looking forward - success in this area has led to us taking on other database related work - back up and restore, high availability and making control loop/policy framework database agnostic in the future to allow user to choose between mariadb and postgres. 

Slides & Recording

YouTube



  • Demo

ONAP Database Upgrade and Rollback in Policy Framework.mp4

Don't publish to  YouTube.

Demo



Agenda

Awesome presentation

  • Overview of  new upgrade/rollback functionality / Demo

Minutes



Action Items