Amazon/Flipkart Ecommerce Design Deep Dive with Google SWE! | Systems Design Interview Question 18 

6:08 Search index - partitioning issues 8:22 Adding items to carts: Real time updates, Version vectors, CRDTs 13:42 Placing an order: Writeback Cache 16:35 Streaming/batch stock updates 17:55 Architecture

I liked just for the intro.

Great content! It's been a productive summer for you Jordan Love the jokes too

Jordan, your content is super authentic and your style of presenting is very practical without any bullshit. Keep up the great work!!!

I dig your vibe throughout this video bro! Looking forward to more of this.

Hi jordan , in the product table (mongoDB) you talked about , are you sharding the product table itself or you are sharding the search cluster built over this product table? Also is this doable to shard the cluster indexes in mongodb.

After this intro I neeeeed the AWS system Design Video! Time to sub and wait Edit: Also am a big fan of the the references to other videos

Would a cache be a decent option for the management of carts? A) it’s transient data B) updates and fetching would be quick 3) Cost is not going to be a huge problem considering that we’re storing pretty less data on the cache

Can I mention DB locking to deal with concurrent editing on the shopping carts? Although lower throughput.

Great content. I am learning the design and have a question : Whenever the order service in the diagram (since 17:54) receives a order request, does it require another (relational) database for saving the order first, and then push the same order to Kafka queue for inventory function (which includes another set of databases) ? so in the diagram there would be another link from `order service block` to `SQL DB icon` with `Kafkaqueue icon` side by side, does that make sense ? thanks

version technique update is called optimistic locking

Hey Jordan, love your channel! This is my first time ever doing system design and your vids help so much. One question -- The way that the diagram has the LB is a little confusing, wouldn't an API gateway direct traffic to the correct service, and then LB placed in front of each service to handle distributing traffic between the replicated server instances? Or can a load balancer alone accomplish traffic directing too?

Hi Jordan, when would you prefer CRDT vs version vectors for merging data between nodes?

Great video Jordan! Keep going! I have some questions tho. Why did you use MYSQL to store the orders? How about something like Mongo? Also, if SQL is the choice, how would the schema look like since we are partitioning the Kafka queue by product id? Thank you 🙂

If someone made order then I think we should reduce amount of orders in product DB but how to do that?

When is the AWS System Design video coming ? We could have a series on AWS where you do an in-depth coverage of various AWS services.

Hey Jordan, Thanks for all these videos! I had a question regarding the choice of technologies in the architecture. At my job, I have used things like MongoDB, Dynamo, MySQL etc. but the applications that I have worked on usually had less than 1k users per day so we didn't really run into many concurrency or scaling issues. Now that I know about stuff like Riak, Flink etc. it makes sense to use them but in practice I have no idea how to implement them. In this case, do you think it would be a good idea to even talk about them in the interview? What if the interviewer asks me to double click on one of these technologies? I probably wouldn't know the answer... Wondering if it will be a good idea to stick with what I know and mention stuff like "btw, I heard some technologies that support X, I would love to explore them." etc. during the interview.

like your attitude to those asking to design AWS. 😄

Hey Jordan, I'm reviewing this design and have a question about the usage of message broker, specifically in the product update/search part. The product service updates the mongoDB table which then sends change-data to a Kafka queue to update the search index. Why do we use a message queue there between MongoDB and Search Index, but we don't use it between the product service and MongoDB? I'm trying to understand when to use a message queue and how to justify the usage. Again thanks for the great content, this video is specially clear and I learned a lot.

Hey jordan can you do a system design for something like shopify?

Can you recommend other resources for system design?

New potential topic to cover: eBay (Auction System)?

I understand shit about system design, here only to enjoy jerk jokes

Keep the jokes. Don'e be a chicken.

I am the first viewer. So what are the to-make videos? Options: - Payment like digit wallet or Paypal as an example of using transactions. - Real-time gaming leaderboard ...