What is DATABASE SHARDING?

Sharding a database is a common scalability strategy for designing server-side systems. The server-side system architecture uses concepts like sharding to make systems more scalable, reliable, and performant.

Sharding is the horizontal partitioning of data according to a shard key. This shard key determines which database the entry to be persisted is sent to. Some common strategies for this are reverse proxies.

Database interviews ask for concepts like sharding to make databases more performant and available. This makes horizontal partitioning a logical choice.

Looking to ace your next interview? Try this System Design video course! 🔥

00:00 Introduction
00:52 Sharding - The problem
01:59 Horizontal Partitioning
03:20 Considerations
04:30 Potential Drawbacks
08:46 A challenge!

Video lectures, architecture diagrams, capacity planning, API contracts, and evaluation tests. It's a complete package.

Consistent Hashing:

Sources:

#database #sharding #systemdesign

[UlfAslak]

Notes to self:
* Sharding is basically a hiearchical way to index databases.
* One problem is that you have to split the database somehow. What do you split on?
* You only shard shards when the shard grow too big.
* When shard fails you use the master/slave architecture. Writes always go to master, reads are distributed across the slaves. When the master fails one of the slaves become master.

[stanlyjohnson]

You know you're a programmer when you count pizza slices from zero :P

[pavithranravichandiran]

Can't just believe, you're uploading this for free... Please continue and we sure do want to sponsor the channel if that is in the cards!

[official_roboGOD]

Your System Design Playlist is my favorite. I've got so much to learn.
Thank you!

[juggernaut]

You could be a greater asset to this country if you pour yourself into research. I studied this course from the best of the best faculty in my college, who literally knows things, but you! Hands down man :)

[devanshi]

good precise and short. exactly what is required in tutorial video with a bit of fun element in start.. awesome job

[satyagunnam]

I am a non-tech person, looking to learn system design concepts. You do a phenomenal job explaining these concepts & also super fun. Great job Gaurav & thank you very much!

[sharathkumar]

The initial reaction of you saying sharding and your expression is awesome which makes someone really remember the video and the content by just imagining while asked in interview. Thanks gaurav :)

[lien]

That little skit at the beginning is so funny lol. Thank you for making these system design videos, they're really helpful!

[SupGhostly]

I love this play list and I'm learning so much but it the humor 😂 and your jokes that keep me learning great job man! Do you have a book recommendation on system design?

[pradeeppradyumna]

I like the way you present all the topics. It's so captivating, and it shows how passionate you're at solving System Design problems. Thank you for sharing your knowledge.

[kshitizsharma]

You are simply amazing man.
I used to dread system design, but just because of you, slowly getting comfortable with it.
I have actually allotted a particular share of my daily todo, just to watch your videos everyday.

[ram]

I can't able to resist myself without commenting after I see your enthusiasm to teach to unknown people around the world... Hats off to all the vloggers who are sharing knowledge freely through Youtube.

[sprihadeshpande]

You are one of the best. I can't wait to watch all your tutorials for system design! :) Keep going!

[XenonSchneizel]

Love your vids. The way you deliver your information is really clear and concise. Amazing quality content!

[ecandil]

I don't know how I didn't come across your videos before! What an easy way to learn, well done mate!!

[shivamtiwari]

The topics covered were organized, relevant to me, and easy to follow . I loved it so much

[Toy]

You are a living legend Gaurav! I learned more from your videos than any of my previous teachers

[theonlyarjun]

For the first time in life I'm actually enjoying theory

[davidpham]

Never been so interested into database sharding just from that intro. You rock! Thank you for the videos