Tag: Databases
All the articles with the tag "Databases".
-
Database CPU Is at 100 Percent: How Do You Investigate?
Series: Backend Interview Mastery
Use a production-safe checklist to investigate database CPU at 100 percent: query plans, locks, indexes, connections, replicas, and rollback.
-
Last-Item Inventory Race Condition: Two Customers Buy at Once
Series: Backend Interview Mastery
Solve the last-item inventory race condition in a backend interview with atomic updates, reservations, idempotency, and contention trade-offs.
-
How a Modern Backend Application Works End to End
Series: Practical Backend Engineering
Trace a modern backend application end to end: browser, DNS, CDN, gateway, services, cache, database, Kafka workers, failures, and observability.
-
Consistency Models: Strong, Eventual and Read-Your-Writes
Series: Backend Interview Mastery
Compare strong, eventual, causal, read-your-writes, and monotonic-read consistency models with backend examples and trade-offs.
-
CAP Theorem Explained Without the 'Pick Two' Myth
Series: Backend Interview Mastery
Learn what CAP theorem really says: during a network partition, distributed systems trade consistency for availability, not any two features.
-
Quorum Reads and Writes in Distributed Systems
Series: Backend Interview Mastery
Understand quorum reads and writes, replica overlap, consistency trade-offs, hinted handoff, read repair, and failure behavior in distributed databases.
-
Race Conditions: Detection and Prevention in Backend Systems
Series: Backend Interview Mastery
Understand backend race conditions, see why check-then-act code fails, and learn database, lock, and idempotency patterns that prevent corruption.
-
Two-Phase Commit: Protocol, Blocking and Failure Modes
Series: Backend Interview Mastery
Understand two-phase commit with prepare and commit phases, coordinator failures, blocking participants, and when 2PC is appropriate.
-
Why Is My SQL Query Slow? A Backend Debugging Guide
Series: Backend Interview Mastery
Learn why SQL queries are slow and use EXPLAIN ANALYZE, query plans, indexes, and production evidence to fix them safely.
-
Database Replication: Read Replicas, Lag, and Failover
Series: Backend Interview Mastery
Learn database replication, read replicas, replication lag, stale reads, and failover trade-offs for reliable backend systems.