Database
Sharding, Hot Shards, And Cross-Shard Pain
·3 mins
Database
Database
Database-Scaling
Sharding
Hot-Shard
Multi-Tenant
Shard-key choice as workload design, not just picking a column
Replication Lag And Replica Routing
·14 mins
Database
Database
Database-Scaling
Replication
Read-Replica
Consistency
Database replication as a freshness and routing problem, not just read scaling
Transactions, Isolation, And MVCC
·17 mins
Database
Database
Transactions
Isolation
Mvcc
Locking
Oracle
A practical backend view of ACID, anomalies, MVCC, locks, and retry behavior
Composite Index And Query Triage
·13 mins
Database
Database
Composite-Index
Query-Plan
Oracle
Sargability
Query-Optimization
Reason about composite indexes through predicates, ordering, projection, plan shape, and write cost
B+Tree And Index Internals
·14 mins
Database
Database
Index
Btree
Query-Optimization
Storage-Engine
Query-Plan
Index reasoning through page reads, access paths, selectivity, row fetches, and write tax