Skip to content

Cloud & DevOps · Major Project

Zero-Downtime Database Migrations in CI

Expand-contract schema changes run by the pipeline while the app stays up

2-3 weeks build

Overview

Renaming a column without taking the site down. Schema changes are split into expand and contract steps, so old and new versions of a Spring Boot app can run against the same database during a rolling release. Flyway migrations run as a pipeline stage against a disposable PostgreSQL first, a traffic generator checks for failed requests during the change, and each step has a written rollback. Runs locally and on free CI minutes.

What makes it stand up

  • 01Expand-contract steps that keep old and new app versions working
  • 02Versioned Flyway migrations applied as a pipeline stage
  • 03Migrations rehearsed on a disposable PostgreSQL container first
  • 04Traffic kept running during each change to catch failed requests
  • 05Rollback plan per step, including what cannot be undone

Module breakdown

  1. 01

    Migrations

    Versioned Flyway scripts with naming and review rules.

  2. 02

    Expand-contract

    Column rename and table split done in safe stages.

  3. 03

    Pipeline

    GitHub Actions stage that validates, rehearses and applies.

  4. 04

    Verification

    Load script that records any errors during a migration.

  5. 05

    Rollback

    Forward-fix versus undo, with a worked example of each.

After this, you will be able to

  • Explain why a single-step rename breaks a rolling deploy
  • Defend how you ordered the expand, migrate and contract steps
  • Demo a column rename with traffic running and no failed requests

Technology stack

  • Flyway
  • PostgreSQL
  • Java
  • Spring Boot
  • GitHub Actions
  • Docker

Complete kit

₹6,899₹11,799
-42%

Delivered in under 48 hours

Level
Major Project
Domain
Cloud & DevOps
Build time
2-3 weeks
Difficulty

You receive

  • Complete, commented source code
  • 60-90 page project report (IEEE format)
  • Editable presentation deck
  • Architecture, ER and UML diagrams
  • Local setup and deployment guide
  • Sample dataset or seed data
  • Viva question bank with answers
  • One 45-minute walkthrough call
  • 30 days of doubt-clearing support
Compare tiers

Keep looking

Students also considered

Capstone

Cloud & DevOps

Cloud-Native CI/CD Platform

GitOps pipeline with Kubernetes, Helm and progressive delivery

  • Kubernetes
  • Docker
  • Helm
  • Argo CD
  • +2
₹5,299₹8,999
4.8/74 reviews
Capstone

Cloud & DevOps

Microservices Observability Stack

Traces, metrics and logs across services that call each other

  • Go
  • Docker
  • OpenTelemetry
  • Prometheus
  • +2
₹5,299₹9,099
4.8/69 reviews
Mini Project

Cloud & DevOps

Package & Deploy an ML Model as an API

Takes a trained model to a versioned, containerised FastAPI service

  • Python
  • scikit-learn
  • FastAPI
  • Docker
  • +1
₹5,899₹9,999