Migrating to Microservice Databases - From Relational Monolith to Distributed Data

This talk examines how to migrate a legacy relational database toward a microservices architecture without downtime, while maintaining data integrity and consistency. It discusses compatibility during migrations and database integration strategies including views, change data capture, event sourcing, and data virtualization.

Syllabus

Introduction
Interesting facts
Raffle
Zero Downtime
Bluegreen deployments
States
Database Migration
Back and Forward Compatibility
Single Statement Per Migration
Sharding Update Statements
Zero downtime migrations
Scenario 1 The Column
Scenario 2 The Column
Scenario 2 Deletes a Column
What about Constraints
Referential Integrity Constraints
Macroservice Characteristics
Microservice Characteristics
Centralized Data Management
One Database by Microservice
Data has mass
Splitting data
Consistency models
Strong consistency
crud
Secure RS
Secure RS with Separate Data Stores
Secure RS Event Sourcing
Traditional Distributed Architecture
Shared Tables
Database Views
Triggers
Transaction Code
ETL Tools
Data Virtualization
Event Sourcing