Migrating to Microservice Databases: From Relational Monolith to Distributed Data

on YouTube ↗01h 05m

" summary

Practical playbook for moving a relational monolith to microservice databases: use zero-downtime migrations composed of many small, back-and-forward-compatible steps (add-column takes four releases, rename needs six), automate with Flyway/Liquibase, shard heavy updates, and prefer CQRS/read-models or event-driven replication over remote CRUD calls. Tools demonstrated: Debezium reading DB transaction logs into Kafka to update read stores (demoed working), materialized views/DB links, ETL and data virtualization. A published repo shows the approach applied end-to-end.

AI-written summary · about

" chapters (35)

1. 0:00Introduction
2. 0:44Interesting facts
3. 1:14Raffle
4. 4:35Zero Downtime
5. 5:00Bluegreen deployments
6. 6:08States
7. 7:22Database Migration
8. 9:07Back and Forward Compatibility
9. 9:28Single Statement Per Migration
10. 10:00Sharding Update Statements
11. 11:12Zero downtime migrations
12. 13:17Scenario 1 The Column
13. 15:53Scenario 2 The Column
14. 17:21Scenario 2 Deletes a Column
15. 18:46What about Constraints
16. 20:31Macroservice Characteristics
17. 20:41Microservice Characteristics
18. 20:53Centralized Data Management
19. 21:16One Database by Microservice
20. 21:35Data has mass
21. 22:04Splitting data
22. 22:35Consistency models
23. 22:53Strong consistency
24. 27:42crud
25. 30:22Secure RS
26. 33:44Secure RS with Separate Data Stores
27. 35:28Secure RS Event Sourcing
28. 40:52Traditional Distributed Architecture
29. 45:26Shared Tables
30. 47:09Database Views
31. 51:47Triggers
32. 52:38Transaction Code
33. 53:23ETL Tools
34. 54:58Data Virtualization
35. 57:40Event Sourcing

" related talks

• 47mMigrating to Microservice DatabasesEdson Yanaga · Oredev 2017
• 46mData in a Microservices world from conundrum to optionsE. Bernard, M. Coulibaly · Voxxed Days Microservices 2018
• 55mThe hardest part of microservices: Your DataChristian Posta · Devoxx US 2017
• 54mFrom a distributed monolith to a microservices solutionJan de Vries · NDC Sydney 2020
• 25mData-Driven Migration from Monoliths to Event-Driven MicroservicesAmlan Ghosh · Site Reliability Engineering (SRE) 2025
• 27mHow Micro-Service Patterns Change When the Database ScalableBrecht De Rooms · Scale By the Bay 2020
• 58mDatabases in the Microservices WorldRob Richardson · Developers Summit 2021
• 31mMonolith to Microservices: A Guide to Seamless TransitionsDaniil Koshelev · Conf42 DevSecOps 2024