🛠️ Database Administration Questions
Master sharding, replication, backup/recovery, locking, and connection pooling
Sharding, replication, backup/recovery, locking, concurrency, and connection pooling
Sharding is horizontal partitioning where data is distributed across multiple databases. Each shard holds a subset of data, enabling horizontal scaling.
Database replication copies data across multiple servers for high availability, disaster recovery, and read scaling.
Backup strategies protect against data loss. Recovery strategies determine how quickly and completely you can restore operations.
Locking mechanisms ensure data integrity when multiple transactions access the same data. Understanding lock types and isolation levels is crucial.
Connection pooling maintains a cache of database connections for reuse, reducing the overhead of creating new connections for each request.
Database Administration Interview Tips
- ✓ Know different sharding strategies and their trade-offs
- ✓ Understand replication types (sync vs async, logical vs physical)
- ✓ Be familiar with backup strategies and the 3-2-1 rule
- ✓ Know RTO and RPO and how they affect backup decisions
- ✓ Understand locking levels and deadlock prevention
- ✓ Know MVCC and how it enables concurrent access
- ✓ Be able to size and configure connection pools
- ✓ Understand CAP theorem and its implications