What is data sharding and how is it different from partitioning?

Sharding is database-level horizontal splitting, while partitioning is often table or system-level splitting.

Sharding distributes data across multiple database instances, each acting independently. Partitioning may exist within a single database or distributed system. Sharding improves write scalability but introduces complexity in cross-shard joins and transactions.