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:    • System Design Interview Questions  
Software Architect Questions:    • Software Architect Interview Questions  
Microservices Questions:    • Microservices Interview Questions  
Devops Interview Questions:    • DevOps Interview Questions  

Connect with us:
Facebook:   / knowledgepowerhouse  
Twitter:   / knowledgepowe10  
Amazon: https://www.amazon.com/Knowledge-Powe...
Site: www.knowledgepowerhouse.com