Lesson 01
Production Database Engineering Systems Explained
Trace an order request through pool, transaction, engine, replication, backup, and recovery boundaries.
Production Database topic cluster
Production Database Engineering
Engineer PostgreSQL 18 and MySQL 8.4 InnoDB systems across transactions, concurrency, capacity, change, recovery, and production incidents.
16 reading lessons ยท 1 capstone guide
Connect transaction correctness to verified recovery.
Every item names the shared relational contract and the evidence boundaries that differ between PostgreSQL 18 and MySQL 8.4 InnoDB.
Lesson 02
PostgreSQL and MySQL Storage Engines and MVCC Explained
Compare pages, logs, tuple visibility, undo, vacuum, and purge without inventing a shared engine.
Lesson 03
Database Transactions Explained
Place local order invariants inside explicit commit and ambiguity boundaries.
Lesson 04
Database Isolation Levels Explained
Choose isolation from anomalies and engine behavior rather than level names alone.
Lesson 05
Database Deadlocks Explained
Prevent avoidable cycles and diagnose each engine's victim evidence.
Lesson 06
Optimistic Locking Explained
Reject stale order updates with bounded conflict handling.
Lesson 07
Database Indexes Explained
Choose indexes from measured predicates, plans, writes, and engine DDL boundaries.
Lesson 08
Database Connection Pooling Explained
Budget Spring connection ownership against finite database capacity.
Lesson 09
PostgreSQL and MySQL Query Plans and Statistics Explained
Read estimates and runtime plan evidence using each engine's documented semantics.
Lesson 10
Database Migration and Rollback Explained
Sequence expand, migrate, verify, and contract across mixed application versions.
Lesson 11
Database Read Replicas Explained
Route reads by freshness needs and prove replica state separately for each engine.
Lesson 12
Database Backup and Restore Explained
Prove recoverability with isolated restore and durable order invariants.
Lesson 13
PostgreSQL and MySQL Replication and Failover Explained
Separate replication, promotion, fencing, routing, and ambiguous write evidence.
Lesson 14
Database Sharding Explained
Choose routing and resharding only after measuring the current engine boundary.
Lesson 15
PostgreSQL and MySQL Observability and Capacity Explained
Correlate bounded demand, sessions, transactions, locks, plans, I/O, and replica evidence.
Lesson 16
Production Database Incident Troubleshooting
Move from user impact and recent change to reversible mitigation and verified recovery.
Capstone lab
Database Connection Contention and Recovery Lab
Run six deterministic capacity, lock, replica, and failover scenarios entirely in the browser.