What is horizontal sharding?

What is horizontal sharding?

Approach: Explain splitting a table by rows across multiple databases.

The process of partitioning a large database table into smaller chunks (shards) based on row values. Each shard is stored on a separate server to distribute traffic and storage.

Follow-up: What is the main challenge of picking a shard key?

Key concepts: shard key, load distribution.