How to evolve your database applications entirely online
summary
Claim: evolve database-backed apps without downtime by combining Oracle Cloud CI/CD, SQLcl, Liquibase, OCI wallets and database features. Pipeline clones production, runs Liquibase against the clone, and deploys with rolling app updates; editioning uses Edition-Based Redefinition (editioning views + cross-edition triggers) to present old and new schemas concurrently. DBMS_REDEFINITION copies data, journals changes and swaps tables so a demo splits phone_number into country_code and phone# and drops the old column online with no interruption.
AI-written summary · about
chapters (12)
- 0:00Intro
- 0:43Software Development DevOps concepts
- 1:10OCI DevOps A complete
- 3:06Online Application Upgrades with Rolling Deployments Application containers are usually stateless
- 4:17Online Application Upgrades with Stateful Dependencies Databases are stateful, so what about incompatible schema changes?
- 4:41Pipelining the Database Cloning An example: using Autonomous Database dones
- 5:57Use the Right Tool for SQL Development SQLd integrales perfectly with CVCD pipelines
- 7:21Generate and Apply Consistent and Repeatable Changes Versioning and controlling the schema changes
- 8:22Build and Test at Every Code Merge in the Feature Branches A Partial Example of CI Pipeline Specification
- 11:14Edition-Based Redefinition
- 13:24Non-Editionable Objects Online Operations Optimized for mission-critical application workloads
- 14:15Online Table Redefinition Where normal online operation cannot go, there is DBMS_REDEFINITION
related talks
30mGain confidence in your database changes
33mTips and tricks for the Oracle Database developer
45mEnabling Continuous Delivery with Database Practices
59mNavigating the Challenges of CI /CD for Relational Database Schema Changes
24mRethinking Database Architecture to Embrace Modern App Dev
01h 00mContinuous Integration and Delivery for Databases
31mDevOps Practices for the Database Team
35mDatabase migrations without downtime