What is DATABASE SHARDING?

[@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.

[@rishabhrastogi6076]

Nicely put :)

[@석상주]

I think another important question to ask is what happens if your shard exceeds its capacity. The way it works is that it further splits the shard into smaller shards (DynamoDB does this behind the scenes)

[@sarathbaiju6040]

What will do when both master and slave failed?

[@GvSharmaBKP]

@@sarathbaiju6040 replicate them atleast 3 (general practice)

[@prateekgautam7398]

@@석상주 I just have one question. When we further break a shard into multiple shards, does those shards again go into different database servers? Or they reside in the same database server?

[@satyagunnam6324]

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!

[@gkcs]

Thank you!

[@pavithranravichandiran6720]

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!

[@dhruvilpatel856]

I see 67 likes so far. I doubt all 67 people are going to donate. XD

[@ruhinapatel6530]

Keep doing what you're doing..You explain too nicely...and your channel is the most handy updated and to the point..learning was never so easy..

[@ishannigam7352]

@@dhruvilpatel856 12k likes :)

[@juggernaut420]

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 :)

[@gkcs]

Thanks 😍

[@avinashdwivedi2015]

You should have learned from best in world from internet..

[@martintourneboeuf5282]

He could be a teacher in your University, but I wouldn't see him from Chile. Very nice videos in general. The intro of this one !!! Good job !

[@Shomerful]

lol research. you can be an asset in the industry as well.

[@tusharrebaca]

Now I seriously doubt about your College Quality :P :P :P - You should have more focused during your JEE time. :P

[@official_roboGOD]

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

[@gkcs]

Glad to hear that 😁

[@ashishkumarg5]

You are not only a good teacher, but also a good actor

[@stanlyjohnson5999]

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

[@gkcs]

Hahaha!

[@sardorbekomonkulov6379]

Or really hungry

[@mohammeddanishreza4902]

U r wrong... Person might be a Matlab programmer where count doesn't strts with zero.

[@anktrj]

​@@gkcs Did you said "No we're not going to learn RDBMS" at t=40? BTW a great video Thanks!

[@MattDeLuco]

You know you’re a DBA when you count them from one ;)

[@theonlyarjun]

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

[@AyushRaj-so3zh]

I had to stop the video immediately and come down here in the comments section 😊..what an intro...what a playlist..kudos Gaurav for these amazing videos

[@lien3723]

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

[@AnuragSharma-pk9pr]

I am an Oracle database developer. I loved your content man. Learned something new today. Thanks. Greetings from your new subscriber.👌👌😊

[@sharathkumar1978]

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 :)

[@1125ram]

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 KZbin.

[@kshitizsharma5469]

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.

[@sj_wanders]

You are too good brother. Your passion towards computer science can be clearly seen.

[@gkcs]

Thanks Sandeep!

[@timothy6966]

This channel is a gold mind for entrepreneurs in the pizza-business.

[@davidpham6330]

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

[@gkcs]

😁

[@rajeshseptember09]

I literally lost a system design round by not saying "sharding" when asked for an optimization technique. Not that I didn't know of it, but I couldn't actively think during the interview. Yes, by just saying "sharding" and explaining sharding as a concept, one can make a big impression during the interview.

[@rupal9267]

You make life simple! The intro had me hooked in till the very end! Bravo!!! 👏

[@ecandil]

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

[@2devanshi]

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

[@summasumma]

Nice video. Main problem i faced with Sharding is when you want to scale horizontally without impacting live system performance or creating downtime

[@gkcs]

Absolutely. That's almost as hard as a live DB migration.

[@thenavigtor6867]

Last line is ethusiastically official way of building interest in users...very well explained sir.

[@chandrabhattasriram9475]

The way you slipped the "Like & Subscirbe" part into the video, just one word - S L I C K

[@moulimallina7501]

You are an amazing person with amazing talent. Once you happened to come our clg NIT raipur, that was wonderful lectures. Please make videos frequently

[@gkcs]

Thanks 😁

[@rounakkolya7350]

OMG!!!Today's interview went exactly like this!!!!! except the sharding which led me to this video!!!!!

[@kiran-nambiar]

I got sharing vs partitioning question in an interview. This image & whiteboard notes flashed in my head instantly, I did crack the interview but got better retention offer. Thanks man ! PS - I should've used pizza as an example starting with 0 index, maybe next time...

[@saurabhsharma7123]

That interview clip with doppelganger was awesome!

[@gkcs]

Hahahaha! He's almost as good as me 😋

[@saurabhsharma7123]

He can easily send shivers down the spine of an interviewee, that's for sure 😅

[@samart3010]

Initially I was not able to catch this concept when I watched this video 2-3 years back. But as of now I am with a base knowledge I able to understand. The problem with me was not really a base knowledge, but a lack of perspective towards these system, I was sticked to my perspective and was trying to build over it, so sometimes it is better to gain knowledge with clear slate.

[@pradeeppradyumna601]

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.

[@interviewsortout2165]

First time I was watching some video tutorials and I did not sleep.

[@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?

[@rohan1456]

Your creativity and content just get's better.

[@Hotmustardgas20]

I just discovered your channel and I'm a huge fan. I have been studying to get certified in AWS and your videos have been helping me understand larger concepts.

[@gkcs]

Thanks! Interesting name you have there, Hotmustardgas :P

[@Hotmustardgas20]

@@gkcs Lol thanks I'm glad that you like it. Do you have any experience with the major cloud platforms that are out there? If so you should make a video on them.

[@seanpowers7132]

This cat is smart. Thanks for dumbing it down for me. This is fantastic stuff Gaurav!

[@MohammadbinIsmail]

Went to Yogita"s videos ,came back here again , both are excellent masha allah

[@ypucandeleteit]

I recently found your channel and I just want to say I love your work. Thanks for creating fun informative content like this

[@gkcs]

Thank you 😁

[@catman8623]

Love the explanation. Digestible while still retaining the core information of this utility and its implications.

[@Anurag7376]

Your videos are really good. Editing and delivery are on point! Keep it up.

[@gkcs]

Thanks!

[@0ManishSharma0]

This inspired me to watch all of your videos. Subscribed

[@christophersanders7483]

Thank you for this great video again. Better than many university professors.

[@gkcs]

Thank you!

[@vaibhav1302]

Simple explanation and to the point. Keep up the good work bro. Cheers

[@hidayatullahkhan6194]

Woah opening was super cool

[@aakashjain3498]

I find your videos educating and entertaining as well.... Well done

[@gkcs]

Thank you Aakash!

[@sprihadeshpande2204]

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

[@mohammedzubairkhan3451]

last line was cherry on the top.

[@gkcs]

😋

[@sharthakghosh970]

"indexing is cute" hahahaha

[@saravanprathi6956]

I had to pause the video and laugh for that :D

[@Jonathan-qz9td]

Cracked me up 😂😂😂

[@nikhilkolhe7513]

Me spending days to implement indexes 😭

[@asawari520]

that interview part was toooo good. especially when you say , we are looking for somethig more serious , we have huge hugeeeeee data. :-)

[@shivamtiwari8914]

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

[@paridhijain7062]

Well Explained concept. 👍Understood it easy with those visuals in the starting of this video. It made the concepts more practical to understand. 🙌🙌

[@deeraj3069]

The ending was superb ...Enjoying the series very much

[@ahmadalzoubi769]

I genuinely laughed at the intro! Well done keep it up

[@gkcs]

Thank you :D

[@abbhi1609]

Intro is awesome man!! Love it

[@Toy8610]

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

[@manojmajumdar3815]

I am thinking about the 255 others who have disliked this video, now who on earth would dislike such a well explained video!!!

[@ChocolateMilkCultLeader]

Clean and simple explanation. Great work

[@darshathakkar]

Thank you for sharing this Gaurav. It means a lot.

[@adnanqz4974]

You’ve explained this concept so well! At work, I’ve always heard my manager use this word when explaining his responsibilities with MongoDB but I’d never understand it. Now I do, thanks to you dude! PS: LOVED the ending 😂

[@abhijeetsoni1978]

Clear & crisp, to help understand the core concept of Sharding😊. And no, I wasn't able to click Like & Subscribe at a time, so had to do it sequentially. 😁

[@monikakrishn]

oh god! the reaction when said "Sharding" by interviewee is humourous man :D

[@boopiechot]

That's exactly how my System Design interview went down. I got the job too. 😉

[@gkcs]

Congratulations!

[@kumarshubhesh7382]

What a confidence bro.nd Ur way of teaching Nd expressing is super bro.keep it up 😊😊😊

[@gkcs]

😁

[@umarraza5533]

O bhai kahan sy le aye ho itni age ma itna knowledge. I really wanna know your learning strategies. Great man! Thumbs up, form Pakistan

[@harshdusane8687]

Excellent example to understand sharding.

[@gkcs]

Thanks!

[@akankshagarg2204]

God I so miss eating Pizza in pre-lockdown days!! I have just started watching your videos for an upcoming interview and I am finding them quite useful. Thank you so much :)

[@sumitlahiri209]

I watched this yesterday night. Sorry, couldn't comment then. The explanation is awesome. Liked this video.

[@gkcs]

A Blockchain group doesn't apologize 😉

[@SahilKhan-xn5ne]

Liked the video in the first minute, came over here to comment and then continue the video.

[@krishnagubili1724]

Very simply explained.

[@DeepakSingh-fi9tx]

Hi Gaurav, Your videos are really very helpful. Apart from videos the references you have provided are mind blowing. Thank you so much.

[@rahulshetty3738]

This is really fun to watch!

[@GruntXIII]

"Let's say you have pizza, and you can't have the entire thing by yourself..." you've obviously never seen me eat pizza...

[@rajiv8k]

8:45 🤣 I hit that notification button. The only other channel I have that turned on for is Kurzgesagt.

[@gkcs]

Thank you!

[@NikPnchl7]

Cassandra uses consistent hashing out of the box to reach the shard that contains the data you're looking for. It uses the partition key part of the primary key

[@RahulDevanarayanan]

“The key thing is we couldn’t finish the pizza by ourselves, we needed friends” As an American I feel uniquely equipped to refute this assertion 😂😤😅

[@vibhors]

Bhaai toone toh rock kar diya, thank you , love you

[@deactivated6737]

Amazing explanation on database sharding, thank you for sharing.

[@rembautimes8808]

Actually its a cool cold start. Worth watching. Thanks for this easy intro, btw I am in the corporate sector but a secret programmer by nite.

[@ChandanKumar-wb9vs]

Starting part of the video was cute and hilarious 😂. Keep up that thing.

[@gkcs]

Hahaha thanks!

[@sriharshasamana]

You have made it look easy! Thanks bro. I want to hear more from you :)

[@AnubhavShrivastava]

Wao..role playing an interview is an awesome concept

[@gkcs]

😎

[@AdityaDodda]

The first minute was Killer!

[@sasidharnote6450]

Very nicely explained. Thanks Gaurav.

[@gkcs]

Thanks Sasidhar!

[@ranzort]

Going through some of the videos. I can definitely see they are more entertaining as they go.

[@ranzort]

Hitting like and subscribe button was pretty easy for me therefore sharding is ..?

[@noobninja4882]

First thing, i will never call my friend to help me finish the pizza, i can eat the pizza alone🤣🤣🤣 thanks a lot for such an awesome content for free

[@Surajkocool]

Awesome explanation, expecting more form you. I am big fan your computer science, knowledge...

[@ALOKKUMAR-vt8bs]

Sir,Your Work is too much Valuable and appreciated, Thank you so much for Doing this amazing work.

[@BusinessTechBliss]

editing is too good

[@SwapnadeepMukherjee]

Interesting and helpful video. A smart way to end it. :)

[@greene8595]

This was actually helpful .

[@rajpern]

I am surprised at the number of dislikes you get. I think u are brilliant not only at knowledge but your humble style is also brillent. I can't think of any reasons for dislikes.... I mean if some doesn't like your style they simply move on but to hit the dislike button, there should be a convincing reason and I keep looking for it but haven't found it yet.

[@gkcs]

Thanks, I think the ratio is normal when compared to similar KZbin videos. Cheers 😁

[@rajpern]

@@gkcs I do watch alot on KZbin. Sometimes the influencer is bragging about alot, sometimes the contents are dragged just to extend the length of the video and sometimes the contents are not worth the time spent watching on it and some very good content providers when get famous they kind of just keep uploading the videos without putting much effort in it. And hence become ordinary. But your videos are full of knowledge and you yourself don't feel like being pompous any such thing so I am just baffled that's all... You are much much younger then me yet you are one of guys I look up to. One day I would like to someone like you. Wish you all the best 👍

[@gkcs]

@@rajpern thank you 😁

[@sandipbhaumik]

Awesome video Gauarv

[@srishtijain9458]

lovely start of the video!! haha, mast!!

[@XenonSchneizel]

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

[@amitkumarkit2]

thanx gaurav. great way of explanation.

[@anuritarawat8422]

Thank you soo much bhaiya your video helped me crack the interview in LinkedIn 😁🥳🥳 I don't know how to thank you , you are the best.

[@gkcs]

Thanks Anurita, and congratulations!

[@anuritarawat8422]

Ohhh wow you replied 😍🙈 btw I am Priyanshi 😅 my moms mail id

[@gkcs]

@@anuritarawat8422 Hahaha, thanks Priyanshi 😁

[@AlfredDHull]

Great video! This was informative but also funny!

[@KrishnaDasPC]

Good video here are my questions 1. How do you make a practical application without Joins? 2. Any code example of the concept?

[@suniljokare9958]

unique way to teach , nice

[@nikhilraov100]

Nice video . Keep going young man .