educative.io

Educative

Horizontal and Vertical partitioning

Is partitioning the same as sharding?
Vertical sharding (partitioning) - divide columns or tables on the same server while Horizontal sharding (horizontal partitioning) is about dividing everything by multiple instances.

There is a difference between sharding and partitioning. Sharding implies the sharing of data on multiple computers. Whereas partitioning is on the same server. We can call horizontal partitioning as Data sharding.Horizontal partitioning doesn’t mean horizontal sharding