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
- Database Indexing — design from the query, and know what the key costs you
- Connection Pooling — a queue in front of a scarce resource
- Replication — copying the change stream, including your mistakes
- Read Replicas — read capacity with a consistency bill attached
- Sharding — splitting data across independent databases
- Partitioning — one table, many physical pieces, one server
- Transactions — one connection, one outcome, and the cases where you do not know it
- Isolation Levels — same names, different engines, different anomalies
- Schema evolution — the schema must serve two app versions at once
- Zero-downtime migrations — expand, migrate, contract, with a lock budget
Previous: Caching, Redis & Cache Failure Modes · Next: Consistency, Consensus, Locks, Sagas & Event-driven Patterns