What is the difference between Partitioning and Sharding db tables?

Partitioning is a generic term used for dividing a large database table into multiple smaller parts. Sharding is a specific type of partitioning in which data is partitioned horizontally and divided on the basis of a shared key also known as Shard key.

In sharding, schema is replicated across multiple servers. Data is stored on multiple nodes on the basis of a Shard key. Most popular sharding key techniques are by alphabets or digits. Eg. Data from 0-4 in one shard and 5-9 in another shard. Or data from a-m in one shard and n-z in another shard.

Watch more Playlists:
System Design Interview Questions: https://www.youtube.com/playlist?list=PLhkIK_6cR413cN92Zq210U-6hMBCXxeWp
Software Architect Questions: https://www.youtube.com/playlist?list=PLhkIK_6cR412zyIFXSRrquIWuFWRoReDH
Microservices Questions: https://www.youtube.com/playlist?list=PLhkIK_6cR413z9VSNIebNksi1UFl8tkxN
Devops Interview Questions: https://www.youtube.com/playlist?list=PLhkIK_6cR411xXsBNJJpi9Mtdq_v1NKrn

Connect with us:
Facebook: https://www.facebook.com/knowledgepowerhouse
Twitter: https://twitter.com/KnowledgePowe10
Amazon: https://www.amazon.com/Knowledge-Powerhouse/e/B01N5XFZQQ
Site: www.knowledgepowerhouse.com

Видео What is the difference between Partitioning and Sharding db tables? канала Knowledge Powerhouse