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