Mid
From PDF
SQL
SQL & Databases
Sharding:?
- Sharding involves splitting data into smaller, more manageable pieces called
shards. Each shard is stored on a different server (or cluster) to distribute the
load.
- Typically, horizontal partitioning is used in sharding, where rows (rather
than columns) of a database table are distributed across multiple databases.
- Example: A user table could be sharded by user ID, where all users with IDs
1-1000 are stored in one database, 1001-2000 in another, and so on.
Share this Q&A
Share preview image: https://www.toolliyo.com/images/toolliyo-logo.png