Migrating to Microservice Databases - From Relational Monolith to Distributed Data

Explore strategies for migrating from a monolithic relational database to a distributed microservices architecture in this comprehensive conference talk. Learn about zero downtime migrations, consistency models, and various integration techniques including CRUD, CQRS, and Event Sourcing. Discover how to handle persistent state, maintain data integrity, and implement blue-green deployments. Examine different approaches such as Views, Materialized Views, Mirror Tables, Data Virtualization, and Change Data Capture to build a robust microservices ecosystem from legacy systems. Gain insights into database sharding, column management, and referential integrity constraints while addressing the challenges of centralized data management versus the "one database per microservice" paradigm.

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