Database Sharding: Data Partitioning | 10 Min System Design
In this video we learn about
1. Types of Database Partitioning (Horizontal and vertical shards and others)
2. Common Problems around database partition
Data partitioning is a technique to break a big database into many smaller parts.
In this process we split up a DB/table across multiple machines
But why should we split up a DB -
Well, after a certain scale point, it is cheaper and more feasible to scale horizontally by adding more machines than to grow it vertically by adding beefier servers.
By Data partitioning databases can be
1. managed better
2. gives better performance
3. Availability can be increased
and
4. Better load balancing
GET DISCOUNT ON SCALER FEE - Anyone who wants to join Scaler can get in touch with me here for further help and get great discount on fee- https://forms.gle/LZtZsae52mKp1CbP6 Or can connect with me on
LinkedIn
/ rishi-prakash-developer
Instagram
/ rishi.prakash.barawal
Facebook
/ barawal.rishi
Medium
/ studywithrishi
#database #sharding #systemdesign