Amazon System Design | Flipkart System Design | System Design Interview Question

[@ritukothariable]

Thanks for sharing this video. Really appreciate the clarity of thought in your explanation and flow of the design.

[@codeKarle]

Glad you enjoyed it!

[@АнастасияБелова-ч4т]

I work at Ozon (Russian equivalent of Amazon) and yes, our architecture is quite similar

[@aashishsawant3150]

Do you have idea about How item service communicate with Inventory service ?

[@trishulcurtis1810]

Instead of Item service, you can just use inventory service I think@@aashishsawant3150

[@AmanGarg95]

I worked at Flipkart and the architecture described here provides good insights into what we do. Good one. We're more on HBase than Cassandra though.

[@codeKarle]

That's great to hear!!

[@rahulsinghai3033]

@codekarle how can we implement the discount that Flipkart provides that vary time to time

[@Dhundlahai]

Can i get your contact info ???

[@nehasht2]

@@rahulsinghai3033 rule engine 🤔

[@abhimanyunagpal3086]

I have watched multiple videos on system design but the content you have is exactly what is needed to crack the interviews. You are among the best on youtube in terms of content !

[@codeKarle]

Thanks Abhimanyu!! Glad to hear this. Do spread a word about us amongst your friends. It helps everyone :)

[@aashishsawant3150]

I want to know one thing. In which kind of use cases item database mongo-db will be used? as We have already search engine DB for searching items, inventory ? how inventory service and elastic search talk to each other

[@amareshsat]

The improvement what I see in your videos is you keep everything drawn already on the board rather drawing it on the go. That would have been good as to know how you think through the whole system and how you approaching step by step. Also one more thing is the diagram could be more organized so when you talk you run through any flow it should be one functional flow from start to end rather than picking random components.

[@aashishsawant3150]

Anyone has idea about How item service communicate with Inventory service ?

[@neurocat6453]

That would make some of his 1-hour videos 3-hours length though... When everything is prepared he is able to cover more aspects and go more in-depth in shorter time. Anyway, I am not sure if we will see new videos from him.

[@RicardoBuquet]

Having worked in a super large system for 11 years (Groupon) I give this overview a 5 stars.

[@FranciscoGomez-tw1ii]

I have my first interview tomorrow and i was so scared, thanks to your videos i no longer feel like that and i feel like im actually capable of showing of what i learned so far in my career tomorrow. THANK YOU

[@codeKarle]

All the best for your interviews!

[@vadirajjahagirdar9342]

This is at next level. I am making notes of all your videos and recently cracked a company. My best wishes to you brother :) :) God bless you :) :)

[@randomguy4822]

Bro I am also making notes , can we connect on linkedin

[@MakrandGurav]

I've always found Sandeep's videos very detailed and info worthy. I like how he gets to the point and gets it going from there. Thank you!

[@philomath20]

It's not like I am trying to make some comparisons here but I usually prefer watching multiple videos for the same design topic and I can easily say that I find Sandeep's tutorials the most comprehensive and lucid at the same time. Awesome job there Sandeep.

[@codeKarle]

Thanks Apoorv!

[@asg3hb]

Great video as always. I found myself liking the videos in which you draw the system in real time. It gives a much better idea of a system being built to solve multiple levels of problems step by step. It also keeps the viewer more focused on the piece being worked on.

[@aashishsawant3150]

Do you have idea about How ItemService communicate with InventoryService ?

[@harshitjain1]

One of the best system design playlist out there. So underrated!

[@lokesh2800]

This is the very comprehensive and clear explanations of the concepts, I have seen so many videos in platforms like udemy, linkedin learning, Oreilly but I found this explanation and design best for the ecommerce platform.

[@astrostudent2302]

Videos are good and intensive. Also please show rough estimates - traffic estimate, memory estimate, storage estimate etc

[@tyapka]

I really liked the breakdown on how to lock items in inventory and how to deal with expired orders.

[@aashishsawant3150]

Do you have idea about How itemService communicate with InventoryService ?

[@sagarsaumyaprusty7681]

This has been a clear vision for the process with multiple DB depending on the what type of data we are getting saved. It helped me a lot. I have designed one solution. If you have linkedin or similar can we connect. Just for a clarification, like MongoDB, Cassandra and Analytics tool can't we use any ERP based backend like SAP, ARIBA for purchase flow to make it more easy and smoother. These already have best Load balancing. I am a SAP consultant and looking for the similar solution that i have seen for multiple industry in my project experience.

[@juhisweet16]

still go through your videos regularly to brush up/prep for interviews. thank you so much for these

[@7hjoseph]

Best system design video from all what I have watched. Thanks for making this!

[@debs1991]

You speak to common man! Really knowledge booster. Thanks you :)

[@deepakchhabra5932]

Vivid explanation. I would add that where you run the purge and archive what I have seen a heavy use of asynch flows so some kind of queue in between which would delete the data through processing service but dont talk directly with historical service, instead generate all these order events and put them into a queue and the listener on the other end would talk to historical service and finish the rest of the process. Since purge may pull millions of records so expecting archival service to deal with order processing and historical at the same time may cause frequent failures. Very nice content. Thank you.

[@deepakchhabra5932]

One more point - when redis sends the expiry callback to order taking service we can also put a check there to first check the status of the order. if order is placed then ignore the request. Deleting from Redis when payment is confirmed is also good but safeguarding at both ends would be nice in case we fail to delete the record from redis.

[@aashishsawant3150]

I want to know one thing. In which kind of use cases item database mongo-db will be used? as We have already search engine DB for searching items, inventory ? how inventory service and elastic search talk to each other

[@sudhanshukumar-yu7fj]

@@aashishsawant3150 mongo-db is used when you have unstructured data which can have varying attributes yet you need to query them with complex params. For example, you may want to find a shirt of size M and color crayon and has a chinese collar etc. how inventory service and elastic search talk to each other: They don't have to.

[@deepakshukla991]

Buddy your knowledge level and skills are unmatchable. Keep making these videos.

[@codeKarle]

Thanks Deepak! Do spread the word about the channel :)

[@syedmusa8527]

Crystal clear thought process and explanation too. Thanks for the excellent video.

[@ooogabooga5111]

Thank you so much for this, also pls make more videos. The quality of your talk is just too good not to be passed on to others.

[@warnercooler4488]

Best tutorial I have seen so far on this topic. Thank you so much!

[@dorjitshering775]

It was such a clear explanation. I couldn't have understood it more from anywhere else. Thank you so much for the content!!

[@rupas4761]

Thanks for explanation .In all your videos you explain it so simple even the complicated topics with attention to details👍

[@monishchhadwa777]

You deserve a like, subscribe share. Honestly, explained such a complex system in a very short time precisely and clearly

[@TheCodeThoughts]

I think Wish List and Cart service should not be associated with Search service rather it can be directly connected to user pages once he/she is logged in.

[@vaishnavivel3500]

Brilliant and clear explanation.. especially appreciate the reasoning behind the DBs etc.. thanks for sharing

[@rishabhgoel1877]

first person who doesn't teach just for interview purpose but in general how systems are designed, really appreciate you :)

[@srogirala]

All your videos are excellent . Only issue is you are standing infront of the board which contains the architecture. You can stand on the side of the board so that viewers get a clean view of the architecture diagram.

[@vibhorpareek8179]

The videos are spot on. Usually on other videos there are ambiguity in design. Your design stresses on what exactly needs to be done :) Great content!

[@vaibhavkumar903]

Suggestion - Please start with a brute force way to design a system, it gives more confidence to one

[@manveersingh5822]

sir, why have you stopped uploading videos, we all are enjoying your knowledge so much! Please can you upload more of such videos, it will mean a lot to all of us.

[@abrarpapa]

You have explained the CAP theorem so easily which was really challenging to understand. Kudos!!! Keep up the good work.

[@kunalsahu3903]

Superb explanation, Thank you so much for nice detailing, plss keep on posting more in this era. Thanks

[@kushalkhandelwal6267]

Awesome video. Really like your style of explaining the design. Seems very natural and incremental in approach and understanding.

[@codeKarle]

That's great to hear!! Thanks for the kind words :)

[@quangluong5413]

I really like how you go into the details of different components - amazing work!

[@aashishsawant3150]

I want to know one thing. In which kind of use cases item database mongo-db will be used? as We have already search engine DB for searching items, inventory ? how inventory service and elastic search talk to each other

[@architgupta4087]

@CodeKarle Nice explanation. Since the order, payment, and inventory are managed by separate microservices, we may need distributed transactions here. Thinking about cases like we reduced the inventory but the order service failed to persist the order. It would be great to discuss this issue along with different distributed transaction algorithms (Paxos, 2PC, 3PC, Saga etc) in your next video.

[@rujhanarora7892]

Exactly my thoughts. As Sql doesn't provide distributed transactions, the statement made in video is little misleading

[@preetigupta5565]

Right..Also they whole order taking journey is synchronously spanning through multiple microservices. Would that not block the customer?

[@aashishsawant3150]

Archit, Do you have idea about How ItemService communicate with InventoryService ?

[@sudhanshukumar-yu7fj]

Correct, SAGA is way forward here. 2PC and 3PC are quite slow in real world, besides making this process synchronized suffers from late response to the client. A better way in SAGA suggests that we provide an immediate response let the SAGA complete. Once completed or rolled back then confirm the order.

[@FrankMaruf]

That's really awesome. Thanks, sir for sharing this video with us. Love from Bangladesh .

[@idrishsorathiya440]

Nice content and clear explanation. Only one thing that was make me panic during whole video was sound quality. Voice is too low.

[@ri_rs]

Great explanation and well organized content flow in the video. Nicely covered many components of system design. Thanks a lot for creating this video. .

[@SkiesTribune]

I really enjoyed the way you explain things...simple and effective👏🔝 My kind regards from Egypt.

[@Cricket4rLife]

Very nice one! I literally liked and slept at the same time. Appreciate it 😎😎

[@rumtek3559]

Just 1 suggestion, instead of taking these big designs, you can choose smaller things and make a series of videos, then 1 video to just stitch it. The issue I see is that we are going into some things in deep whereas some other important things seem to be missing

[@domnicsatish]

Thank you so much for this video! Appreciate if you also share a transcript of the video in the description. It'll help keeping it handy for reading through the key concepts.

[@arijitghosh3090]

Thanjs for sharing this...however I feel that instead of havign everything drawn out if you had drawn each component at a time will be been better. It would have made clear your thought process and will have been less overwhelming

[@nuralitechie9534]

Thank you. Very quality design, with most of components, edge case cover. Best system design material with real life issue/functionality. One feedback, it would be great if you can show yr whiteboard with diagram without you in between so that one can take screen shot and keep it for future reference. Thank you very much.

[@aashishsawant3150]

I want to know one thing. In which kind of use cases item database mongo-db will be used? as We have already search engine DB for searching items, inventory ? how inventory service and elastic search talk to each other

[@utubesud]

Sandeep, Excellent .... Thanks very much...THis is a very intuituve design I have ever seen...its pretty much covers almost all details....

[@asifiqbal2184]

It's very nice and clean approach. Thanks for all your effort. i would like if you can create a catalog management system video which can cover the master data management for product as admin.

[@srikid100]

I really like your videos! Super informative and easy to understand. Thank You!

[@ZeroInfinityCoder]

Best explanation. Though i have one doubt for "USER PURCHASE FLOW" Instead of "ORDER TAKING SERVICE" and "ORDER PROCESSING SERVICE" can't we just have one "ORDER SERVICE" (which will do 2 things take orders and view live orders) as it seems too much of separation of concern OR is it done to segregate READ and WRITE traffic? Also let "ARCHIVAL SERVICE" talk to "OMS MYSQL DB" for getting orders which are in TERMINAL State. What are your thoughts?

[@rupeshmukherjee852]

Sandeep... design a Recommendation System and designing a distributed key value store would help... Possible to take these up in ur upcoming videos?? BTW.. every video is awesome Sandeep.. best System design videos I have seen so far... very clear and not over the top, very precise yet very detailed.. Awesome work Sandeep..

[@chhaviparasher2917]

Great content and well-organized flow in the video. Thanks a lot for creating this video.

[@Omniman2]

So many use cases covered, awesome design and explanation. Thanks mate!

[@Dhindsa99]

Thanks buddy for such a nice explaination. Since this is Amazon and hence global presence, I had few questions which may be asked in an interview 1. How is the user service Db synched , e.g. user is in India however now he went to US and access US website. Will there be a master Db which will have info about all Users or how will the system sense where to fetch user info from ? 2. If we say the DBs of all regions will sync with some Master DB, how will this sync happen ? 3. Will there be a Load Balancer infront of REDIS (wherever its used ) ? 4. Infact there can be a LB infront of every service component, if not then how are the requests routed as there could be multiple servers running that service ( e.g. Cart Service) ? Could you ( or any other user) please help to provide some guidance on this ? Thanks in advance.

[@aashishsawant3150]

I want to know one thing. In which kind of use cases item database mongo-db will be used? as We have already search engine DB for searching items, inventory ? how inventory service and elastic search talk to each other

[@sudhanshukumar-yu7fj]

Thoda khud se bhi doondh le bhai

[@availkrishmytube]

Great job! There was clarity right throughout

[@nasreenustad7658]

Very clear and well explained all the features.. thanks for sharing, I appreciate your efforts. Could you please make a video on how to design Database schema for e-commerce app in details?

[@holatechm]

This is what I was looking for, really helpful video bro, thanks a lot for your effort

[@AmitKumar-gm8wl]

it is really impressive. Helped me a lot in system design. One request is that please make a video on movie ticket booking system (BookMyShow)

[@sumitbabel5415]

You are amazing, superb explanation and with excellent pace

[@박종선-v8i]

Wow.. e-Commerce system is so complex..

[@HarkiratSaluja]

This is a gem of a video. Learnt a lot. Thank you

[@erichaymer5130]

Great video. Can you please do a follow up video covering OMS system built top of this architecture. Can you also discuss some tradeoff and improvement which can be done. Ex: scalability wise? Thanks.

[@codeKarle]

Sure, we'll try to make that.

[@erichaymer5130]

@@codeKarle thank you. Can't wait to see your follow in-depth design. As always great content. One suggestion: can you also discuss future improvements and tradeoffs of the design and architecture for upcoming videos. I think, that's important to understand as well. Ex: If we go serverless by using lambda, stepfunction, etc

[@iitmvaibhav]

crisp explanation and covered all aspects

[@shivangitomar5557]

Wow! This is very well explained. Thanks!!

[@ssandeepdesai7]

Beautiful & clear explanation. Thanks for this video !

[@igorburilo3937]

Thanks for such detailed and good explanation

[@animeshsharma902]

Great video as always. Thanks for this as it help developing thought process to architecting solution. One thing, no detail as about the Inventory service like from where it data get populated. As we have item service to keep product details. It will great if you put your thought on this to understand the flow. Inventory service is one of the service.

[@aashishsawant3150]

I want to know one thing. In which kind of use cases item database mongo-db will be used? as We have already search engine DB for searching items, inventory ? how inventory service and elastic search talk to each other

[@safarnama4597]

Thanks for nicely explanation of each component in detils.

[@SumanSaurabh]

This is awesome, very granular. I love your videos. Suggestions: 1. I am not able to take a perfect screenshot of the whiteboard, if you can show video like it's the only thing in the screen for like 3 to 4 seconds, it will be very helpful. 2. Checkpoints in the video, so that we can directly go to the specifics. Very much thanks Sandeep for creating such great videos.

[@codeKarle]

Thanks!! You can get some of the screen pics over here, in the individual descriptions: www.codekarle.com/ Not everything is there, but you'll still get some diagrams. Checkpointing is a good idea, we'll try to do that.

[@PawanSharma-le6hk]

Thanks for your awesome videos, really appreciate the effort. Please create a video for the Google Drive kind of service also.

[@VY-zt3ph]

This is not just a system design video. It as entire course on how to divide a usecase into a microservices arhchitecture.

[@siddharthbagai6459]

Great video as always ! very clear thanks ! only one point of improvement if you can use a better mic as sound clarity is not the best

[@SmartEngineers]

Great explanation. It's really worthful to watch.

[@chitralekhadeka7611]

Great video! Would be great if you position yourself without blocking the whiteboard

[@sumondutta1101]

A feature I would love discussed is: Order tracking feature with current delivery time estimation

[@vivekchand19]

Hi Sandeep, Thanks for the amazing videos. They have been very helpful. Would love to see more videos coming like Designing Dropbox, Pastebin, Web Crawler etc & system design patterns.

[@MarimuthuSA]

Great content but easy to understand, Thanks codeKarle.

[@elachichai]

Happy Learning Indeed Sandeep!!! Lot of good points discussed - you talk about choice of components right in the context of design than suggesting a read up. It is also better than a few paid subscription tutorials. One suggestion: I liked the write up on codekarle describing system design which you traded for closed captions/subtitles. Can you add them on your website? Easier for a 2nd go over...

[@rajatahuja4720]

1) I think Wishlist and cart service flow should not go via Search Service. What do you think? 2) Spark ml data should get stored in database ( druid/cassandra) to get consumed by recommendation service

[@codeKarle]

You're right, the APIs to the services you meantioned would be independent anyway, just that the wishlisting/adding to cart usually is done by the users post search results are shown. That's why it follows the search results in the user journey. Functionally, they are totally independent. The recommendation logic can run as a Spark job which then then store the data in any datastore through Recommendation Service. The same service would then consume the data written in that data store to power various recommendation based functionalities.

[@aashishsawant3150]

I want to know one thing. In which kind of use cases item database mongo-db will be used? as We have already search engine DB for searching items, inventory ? how inventory service and elastic search talk to each other

[@namratasukanya8424]

Video is really very helpful. But one suggestion if you can little bit slowdown while describing. :)

[@anushrih.v5515]

This design was so descriptive! Thanks for sharing!

[@subhasisroy9710]

Very helpful video. Thank you so much.

[@YashRaithatha1989]

awesome ! Thanks for explaining it with so much clarity.

[@anastasianaumko923]

Thank you for your work, great job 😌

[@prashanttripathi3957]

Its great explanation of system. I want to know one thing. In which kind of use cases item database mongo-db will be used? as We have already search engine DB for searching items, inventory & Order databases for transactions and Cassandra for historical based queries.

[@aashishsawant3150]

Prashant, I have also the same question. If you got answer could please explain to me ?

[@psk2166]

Thank you for sharing, I've learnt a lot from you :)

[@AI_For_Scientists]

great video, Just the right amount of information, thank you!

[@aashishsawant3150]

I want to know one thing. In which kind of use cases item database mongo-db will be used? as We have already search engine DB for searching items, inventory ? how inventory service and elastic search talk to each other

[@nikitasinghchauhan6239]

Great video and thank you for explaining all the important functionalities.🙂

[@codeKarle]

Thank you!

[@agayevrauf]

Very well explained, thanks!

[@nikita12351]

Thanks for making this video. Detailed explanation!

[@koikahi]

Awesome pace and thought process. Missing critical Pricing service?

[@ganeshkudva817]

Thanks your videos are great. Can you do a video on Coupon Management & Donation website system design's too ?

[@codeKarle]

Thanks!! Coupon Management is on the TODO list. We'll try to do that soon :)

[@girlwhocodesandlifts]

Thanks for the quality of information you provide in your videos. I have below queries wrt Wishlist and cart services being tied to Search Service. 1) If a user adds an item to cart, the add to cart flow won't go through Search Service, right? 2) Also, user can add items from homepage or from some other flow (e.g. affiliate links) as well, so it shouldn't be tied to Search Service.

[@aashishsawant3150]

I want to know one thing. In which kind of use cases item database mongo-db will be used? as We have already search engine DB for searching items, inventory ? how inventory service and elastic search talk to each other

[@ZeroInfinityCoder]

@@girlwhocodesandlifts yes i was also thinking the same it should be directly thru some other service like cart, wishlist service

[@Vivek-je1og]

Thanks for your efforts. Really grateful.

[@nandyad]

This is really so much helpful

[@vdineshkumar7620]

Your videos are really amazing!!Thanks a lot for making them.

[@sridharkulkarni9210]

Amazing videos on system design. Thanks very much. Love your style of explanation. Are you planning to create any videos on System design of cloud storage?

[@sushantkumar8903]

Simple yet very efficient