⌘K
Flycodx

Database Sharding Strategies

Database Sharding Strategies

MediumHLD0% accepted

Explain horizontal sharding strategies: range-based, hash-based, and consistent hashing. Cover shard key selection, cross-shard queries, resharding, and hotspot problems.

Approach

Explain database sharding strategies, shard key selection, and hotspot prevention.

Input

Instagram user with 100M followers - hotspot problem

Output

Key = user_id + random_suffix (0-9); 10 shards each storing 10% of celebrity data; read-time merge

Scenarios & Expected Answers

Sign in to continue

Create a free account to view answers and mark progress.

  • Free forever — no credit card
  • Theory Q&A with detailed answers
  • Points, streaks & leaderboards
Auto Save On