Indexes, Pools, Replication, Sharding, Transactions & Migrations

Question bank: fresh angles on indexing, connection pooling, replication, read replicas, sharding, partitioning, transactions, isolation levels, schema evolution and zero-downtime migrations — with Postgres vs MySQL differences called out.

About 120 minutes · 30 exam questions · 21 interview questions · 2 code labs

What you will learn

  1. Database Indexing — design from the query, and know what the key costs you
  2. Connection Pooling — a queue in front of a scarce resource
  3. Replication — copying the change stream, including your mistakes
  4. Read Replicas — read capacity with a consistency bill attached
  5. Sharding — splitting data across independent databases
  6. Partitioning — one table, many physical pieces, one server
  7. Transactions — one connection, one outcome, and the cases where you do not know it
  8. Isolation Levels — same names, different engines, different anomalies
  9. Schema evolution — the schema must serve two app versions at once
  10. Zero-downtime migrations — expand, migrate, contract, with a lock budget

Previous: Caching, Redis & Cache Failure Modes · Next: Consistency, Consensus, Locks, Sagas & Event-driven Patterns