Tech Interview Guide
Tech Interview Guide
  • 6
  • 178 133
Database Sharding | System design concept
System Design concepts - Database sharding. It covers:
1. What, why?
2. How - App level sharding, db level sharding
3. Sharding strategy - Hashing, Ranges
4. Real life example - sharding order data
5. Database with support
6. Followups - Hotspotting, Network partition
#sharding #distributed #database
Переглядів: 24 098

Відео

Design Twitter - System Design Interview Question
Переглядів 3,8 тис.4 роки тому
System Design interview question - Design Twitter. It covers following use cases 1. Follow/unfollow user 2. Post tweet 3. Get news feed. We explore multiple approaches for news feed design. We also discuss about APIs, Database model and database choice. Please comment on what should we cover next. #design #twitter
eCommerce Website like Amazon - System Design Interview Question
Переглядів 57 тис.4 роки тому
System Design interview question - eCommerce Website like Amazon. We discuss about 1.Create User Profile 2. List Products 3. Add Products to Cart 4. Purchase all Products from cart 5. Track Orders We also discuss about APIs, Database model and database choice. Please comment on what should we cover next. #design #ecommerce #amazon
Parking Lot - System Design Interview Question
Переглядів 85 тис.4 роки тому
System Design interview question - Parking Lot We cover following use cases 1. Give user ticket when he enters 2. Generate price when user exits. We also discuss about APIs, Database model and database choice. We also discuss on how to make it distributed. We also discuss about concurrency. Please comment on what should we cover next. #design #parkinglot
URL Shortening service - System Design Interview Question
Переглядів 6 тис.4 роки тому
System Design interview question - URL Shortening service We cover following use cases 1. Take url and return shorter url 2. Take a short url and return the original url We discuss scale, create High Level Diagram(HLD), API, data model. We discuss sharding strategy to make it distributed. We compare multiple options to shorten the url. We also discuss about concurrency. Please comment on design...
Design Cache - System Design Interview Question
Переглядів 2,7 тис.5 років тому
System Design interview question - Design Cache Please comment on design video we should do next. #design #cache

КОМЕНТАРІ

  • @AbhishekBalani93
    @AbhishekBalani93 4 місяці тому

    Very bad overall video.

  • @youKnowMe4real
    @youKnowMe4real 5 місяців тому

    enum is not grenerally suggested

  • @happyhappyhome7405
    @happyhappyhome7405 8 місяців тому

    Thanks for using easy-to-understand and simple language. Just a suggestion if you can add a link of the PPT/PDF that you have used while creating videos. It will help to revise concepts easly.

  • @prachingaming3667
    @prachingaming3667 10 місяців тому

    is this Architecture design ?

  • @deepjyotkaurbindra
    @deepjyotkaurbindra Рік тому

    This was beautifully explained! Please continue making such great videos. This was really helpful.

  • @aliquewilliams3080
    @aliquewilliams3080 Рік тому

    You don't need an entire new service just for pricing policy.

  • @dibyadash3356
    @dibyadash3356 Рік тому

    Why do we need three databases can't we make more tables

  • @GauravSingh-le8mq
    @GauravSingh-le8mq Рік тому

    size per sot 1K, 1K what? bits, bytes, be clear na

  • @karthiks8612
    @karthiks8612 Рік тому

    Why no videos ..your videos are good

  • @lankesh870
    @lankesh870 Рік тому

    Simple and elegant solution to start with. This is very helpful for beginners. Can you also create a video on Elevator design problem?

  • @HameedKhan-mq4ve
    @HameedKhan-mq4ve Рік тому

    Excellent work.

  • @DodaGarcia
    @DodaGarcia 2 роки тому

    Calling the use case “giving the user a ticket” is a bit off isn’t it? Nobody uses a parking garage to get a piece of paper, they use it to get a parking spot.

  • @avinashmodi5230
    @avinashmodi5230 2 роки тому

    Hi, Please upload more videos. Your videos are more crisp, clear and brief.

  • @geeksquad9291
    @geeksquad9291 2 роки тому

    Nice ,very short and to the point.

  • @sentinelese6717
    @sentinelese6717 2 роки тому

    best PL system design video

  • @lokeshjain1344
    @lokeshjain1344 2 роки тому

    I think for communicating between cart manager end list manager events should be used instead of normal methods

  • @annusaannspiration9197
    @annusaannspiration9197 2 роки тому

    brilliant

  • @ashishzanwar6259
    @ashishzanwar6259 2 роки тому

    please pronounce it as deta & not data it's detabase & not database

  • @tejass817
    @tejass817 2 роки тому

    Great content

  • @snake1625b
    @snake1625b 2 роки тому

    great video! are each of those yellow blocks its own repo hosted on its own machine?

  • @MackChen7568
    @MackChen7568 2 роки тому

    it is a great video. Thanks. when you talk about "user manager", "list manager" ... are they the microservice?

    • @snake1625b
      @snake1625b 2 роки тому

      yes, those would be called microservices

  • @PujaKumari-im8vm
    @PujaKumari-im8vm 2 роки тому

    What I liked about your video was you discussed about concurrency. I looked this question at multiple places but none actually tried to explain this. Thanks for this.

  • @adityasrivastava5795
    @adityasrivastava5795 2 роки тому

    Great Great Video. SImple and Clear

  • @thetranscriptpresents5439
    @thetranscriptpresents5439 2 роки тому

    Brilliant!

  • @vinaydixit81
    @vinaydixit81 2 роки тому

    I have a comment here, Everything looks ok to me. Except why do we need to track the status of parking. Even though status of parking we can find from ticket#. Whether parking is available or not. In this case we would need to make an unnecessary call to the table. Which is not at all required.

  • @dev-skills
    @dev-skills 3 роки тому

    slot allocation may not be required. This should be discussed with the interviewer as you may want the vehicle to be parked in any available slot.

  • @ngneerin
    @ngneerin 3 роки тому

    Super bulshit solution. Parking lot is a low level design question and not distributed system solution 🤦

  • @mailsnagaraju
    @mailsnagaraju 3 роки тому

    nice info

  • @codeTreeMS
    @codeTreeMS 3 роки тому

    ua-cam.com/video/sdL1fmzFj_w/v-deo.html

  • @abhishekpawar921
    @abhishekpawar921 3 роки тому

    Very good video. Expecting more videos from you, Sir 👍🏻

  • @vikrantsaini6362
    @vikrantsaini6362 3 роки тому

    Great explanation. Really helped a lot to understand low level and high level designs. Please add more videos on low level designs.

  • @MARSSS888
    @MARSSS888 3 роки тому

    You are simply amazing!

  • @arnavsmultiart2133
    @arnavsmultiart2133 3 роки тому

    Basics explained well

  • @AnshumanSingh-gk2md
    @AnshumanSingh-gk2md 3 роки тому

    very well explained

  • @abhisheksitar
    @abhisheksitar 3 роки тому

    Very nice and informative video ! Thanks for sharing this.

  • @PavanMehta
    @PavanMehta 3 роки тому

    Bonus tip: Listen to it in 2x

  • @rishabhrathour2190
    @rishabhrathour2190 3 роки тому

    Thankyou so muchhhhhhh.

  • @virendrasingh5267
    @virendrasingh5267 3 роки тому

    Awesome explanation.

  • @Budulai89
    @Budulai89 3 роки тому

    This is a basic explanation of the service, which is good as a starting point. However, there are many other questions that an interviewer might ask. For example: 1. why do you need to store 10 years of parking lot information ? 2. Why do you need 3 DBs if you have only 4GB of data ? 3. How do you plan to implement the lock ? 4. What happens if a node goes down ? ....

  • @urunovtimes5816
    @urunovtimes5816 3 роки тому

    good approach

  • @irivbogbeidehen5393
    @irivbogbeidehen5393 3 роки тому

    nice been trying to create an ecommerce website

  • @videoway
    @videoway 3 роки тому

    I like how you provided a 'Further Reading' section. Helpful to know what other important concepts to know.

  • @bostonlights2749
    @bostonlights2749 3 роки тому

    You seem like a knowledgeable guy

  • @bostonlights2749
    @bostonlights2749 3 роки тому

    Nice

  • @0shawhat
    @0shawhat 3 роки тому

    Thanks for the video!!

  • @AlikElzin
    @AlikElzin 3 роки тому

    In 3:35, where are the number of vehicles entering per day?

  • @ashikurrahman8874
    @ashikurrahman8874 3 роки тому

    Excellent.

  • @MsJackyjan
    @MsJackyjan 3 роки тому

    Clear Explanation!

  • @CarlaLud
    @CarlaLud 3 роки тому

    Very clearly explained, thank you! Looking forward to seeing more of your videos

  • @mindpower421
    @mindpower421 3 роки тому

    great video