System Design Questions - tarunchhabra/parakalo GitHub Wiki

List of real world examples - https://github.com/systemdesign42/system-design

Approach - https://www.youtube.com/watch?v=i7twT3x5yv8

Mental Map or Template for System Design question

Use DNS route 53 Use CDN Use ELB Use API gateway (BFF pattern) Use EKS + Ingress + ALB/NLB Use LB for databases in between service and DB

Follow up : Scale RDBMS - Master Slave replicas (Sync/ Async replication) --> Sharding

https://aws.amazon.com/blogs/database/scaling-your-amazon-rds-instance-vertically-and-horizontally/

https://aws.amazon.com/blogs/database/sharding-with-amazon-relational-database-service/

Store photos : RDBMS + S3 https://www.youtube.com/watch?v=MT-YuUSA0bg Retrieve Photos : https://www.youtube.com/watch?v=M21vVgqekbU

https://www.youtube.com/watch?v=QyY5gqCnCzM

CDN

https://www.youtube.com/watch?v=ZLDcNZ_rXJ4

https://www.youtube.com/watch?v=IxYkEyb1OIo

https://www.youtube.com/watch?v=UssfEJHcPhU

https://www.youtube.com/watch?v=2WyfCTSEpyo

https://www.youtube.com/watch?v=-bo7oVejgRM

https://aws.amazon.com/cloudfront/dynamic-content/

Doubt - so Fb app will get the url of s3 for image or the CDN url ? CDN will pass the S3 url to client

Capacity Estimation

https://www.youtube.com/watch?v=-wFLmGiOWEI

Capacity Estimation for Youtube - https://www.youtube.com/watch?v=0myM0k1mjZw

Photo sharing App Instagram

Facebook Messenger/Whatsapp

http://blog.gainlo.co/index.php/2016/04/19/design-facebook-chat-function/

Top K Songs, Videos, Items, Products

https://www.youtube.com/watch?v=CA-ei3mOCf4

RedBus online Bus Seats booking

https://www.youtube.com/watch?v=-gqaQa9a7E8

https://www.youtube.com/watch?v=Duxrk7ibfRw

IRCTC

https://www.youtube.com/watch?v=8K2_BJpVSjQ

Netflix, Amazon Prime, Youtube - Streaming Data

AWs Reinvent Netflix architecture - https://www.youtube.com/watch?v=0QS1TWLooo0

Video Upload - https://support.google.com/youtube/answer/71673?hl=en&co=GENIE.Platform%3DDesktop#:~:text=By%20default%2C%20you%20can%20upload,videos%20longer%20than%2015%20minutes.

https://www.youtube.com/watch?v=lYoSd2WCJTo&t=907s

Video Processing - https://www.youtube.com/watch?v=x9Hrn0oNmJM

https://www.youtube.com/watch?v=PuU_0esYyhg

https://www.youtube.com/watch?v=jPKTo1iGQiE

https://www.codekarle.com/images/Netflix.png

https://www.youtube.com/watch?v=0myM0k1mjZw

https://www.youtube.com/watch?v=psQzyFfsUGU

https://www.youtube.com/watch?v=hvEDt_XGIWk

https://www.youtube.com/watch?v=HV9ffEMwLM4&t=9s

Dynamic ad insertion (DAI or SSAI) works in Youtube, Facebook, Netflix

-Video Processing steps

https://www.youtube.com/watch?v=raOFSRlKfKw

https://www.youtube.com/watch?v=2xrm19ugDls

Spotify, Apple Music

https://www.youtube.com/watch?v=ks-CS41AiQs

Location based applications

Yelp, TripAdvisor

SQL DB to Geohashing approach-

https://www.youtube.com/watch?v=UCaVJsyq8ac

https://www.youtube.com/watch?v=M4lR_Va97cQ&list=PLCRMIe5FDPseVvwzRiCQBmNOVUIZSSkP8

https://www.youtube.com/watch?v=TCP5iPy8xqo

https://www.youtube.com/watch?v=tu6QKpV7GiI

https://astikanand.github.io/techblogs/high-level-system-design/design-yelp-or-nearby

Food Delivery App

https://www.youtube.com/watch?v=OcUKFIjhKu0

Google Maps

https://www.youtube.com/watch?v=jk3yvVfNvds

https://www.codekarle.com/system-design/Google_Maps-system-design.html

https://www.youtube.com/watch?v=CXdaPETE7iE

Designing a location database

https://www.youtube.com/watch?v=OcUKFIjhKu0&t=824s

Dating App - Tinder

https://www.youtube.com/watch?v=tndzLznxq40

Ola/Uber/Lyft

https://eng.uber.com/gatewayuberapi/

https://www.youtube.com/watch?v=Tp8kpMe-ZKw

https://www.youtube.com/watch?v=J3DY3Te3A_A

https://www.youtube.com/watch?v=KyCYyoGusqs

https://www.youtube.com/watch?v=umWABit-wbk

Google Search - Using Indexing, B Tree

https://www.youtube.com/watch?v=LVV_93mBfSU

https://www.youtube.com/watch?v=_0QOePCkyK4

https://www.google.com/search/howsearchworks/how-search-works/organizing-information/

Detailed - https://www.google.com/search/howsearchworks/

Human Raters - https://www.youtube.com/watch?v=nmo3z8pHX1E

https://www.youtube.com/watch?v=CeGtqouT8eA

Using Tree/Trie Data structure

Google Drive

Auto Suggestion

https://www.youtube.com/watch?v=xrYTjaK5QVM

Google Docs - Collaborative Editor

Part-1 - https://www.youtube.com/watch?v=2auwirNBvGg

Part-2 - https://www.youtube.com/watch?v=U2lVmSlDJhg

Extra - https://www.youtube.com/watch?v=jIR0Ngov7vo

https://www.linkedin.com/pulse/system-design-google-docs-rahul-arram/

https://www.linkedin.com/pulse/google-docs-high-level-system-design-murat-atak/

Web crawler

https://www.youtube.com/watch?v=BKZxZwUgL3Y

https://www.youtube.com/watch?v=vxqjjB3b-Zg

https://github.com/donnemartin/system-design-primer/blob/master/solutions/system_design/web_crawler/README.md

https://courses.systeminterview.com/courses/take/system-design-interview-an-insider-s-guide/texts/14742678-step-2-propose-high-level-design-and-get-buy-in

E-commerce Website - Amazon, Flipkart

With AWS - https://www.youtube.com/watch?v=a0sktLZBGp4

E-commerce Platform - Shopify

https://www.youtube.com/watch?v=N8NWDHgWA28

https://www.youtube.com/watch?v=lEL4F_0J3l8

Payments System for Uber/Booking.com -

https://eng.uber.com/money-scale-strong-data/

https://www.youtube.com/watch?v=5TD8m7w1xE0

https://www.youtube.com/watch?v=mL0fzj7e6WU&t=575s

https://www.linkedin.com/posts/alex-xu-a8131b11_systemdesign-architecture-aws-activity-6871136880562466816-qRZS

https://www.youtube.com/watch?v=Dz6dAZs8Scg

https://www.youtube.com/watch?v=GUurzvS3DlY

https://stripe.com/docs/payments/intents?intent=payment

Stack overflow scale

https://www.infoq.com/news/2015/06/scaling-stack-overflow/