Interview kitsBlog

Your dream job? Lets Git IT.
Interactive technical interview preparation platform designed for modern developers.

XGitHub

Platform

  • Categories

Resources

  • Blog
  • About the app
  • FAQ
  • Feedback

Legal

  • Privacy Policy
  • Terms of Service

© 2026 LetsGit.IT. All rights reserved.

LetsGit.IT/Categories/Monoliths
Monolithshard

Database split during extraction — what is the hardest part?

Tags
#database#migration#data-ownership
Back to categoryPractice quiz

Answer

Data ownership and consistency: deciding which service owns which tables and how to keep data in sync during the transition (dual writes/outbox/events). The migration must be incremental with a clear cutover and rollback strategy.

Advanced answer

Deep dive

Expanding on the short answer — what usually matters in practice:

  • Context (tags): database, migration, data-ownership
  • Scaling: what scales horizontally vs vertically, where bottlenecks appear.
  • Reliability: retries/circuit breakers/idempotency, observability (logs/metrics/traces).
  • Evolution: keep changes cheap (boundaries, contracts, tests).
  • Explain the "why", not just the "what" (intuition + consequences).
  • Trade-offs: what you gain/lose (time, memory, complexity, risk).
  • Edge cases: empty inputs, large inputs, invalid inputs, concurrency.

Examples

A tiny example (an explanation template):

// Example: discuss trade-offs for "database-split-during-extraction-—-what-is-the-h"
function explain() {
  // Start from the core idea:
  // Data ownership and consistency: deciding which service owns which tables and how to keep d
}

Common pitfalls

  • Too generic: no concrete trade-offs or examples.
  • Mixing average-case and worst-case (e.g., complexity).
  • Ignoring constraints: memory, concurrency, network/disk costs.

Interview follow-ups

  • When would you choose an alternative and why?
  • What production issues show up and how do you diagnose them?
  • How would you test edge cases?

Related questions

Monoliths
Shared database in a monolith: how do you avoid “shared-everything” between modules?
#monoliths#boundaries#database
Monoliths
Multi-tenancy in a monolith: what are common data isolation approaches?
#monolith#multi-tenancy#security
Monoliths
Strangler Fig migration — outline the steps.
#strangler-fig#migration
#microservices
Monoliths
Strategies to migrate from a monolith to microservices?
#migration#strangler-fig#microservices
Databases
Autocommit vs explicit transactions: when does it matter?
#database#transactions#autocommit
Databases
OLTP vs OLAP: what’s the difference?
#database#oltp#olap