Mid SQL

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.

More from SQL Server Tutorial

All questions for this course