avishekjoy/system-design

Preparing for system design interview questions

• Roadmap
  • October
    • 19-26
    • 27-31
  • August
    • 01-02
    • 03-09
    • 10-16
    • 17-23
    • 24-30
  • September
    • 21-30

Roadmap

October

19-26

• NoSQL
• newSQL
• ElastiSearch
• Database migration
  • https://time.geekbang.org/column/article/221658
  • https://time.geekbang.org/column/article/155138
• Sharing middleware diffs

27-31

• Distributed rate limiting - imooc
• API Idempotent - imooc
• Distributed file system - imooc
• Distributed transactions - imooc
• Multithreading
• System Design interview book grooming

August

01-02

• CDN
• Load balancing
  • Detect failure

03-09

• DNS
• Cookie
• SSL/TLS
• Keep-alive/Web-Socket
• Web-server
  • Tomcat/Nginx/OpenResty
• HTTP protocol
  • long connection
• Api gateway vs Reverse proxy (Nginx)
  • https://time.geekbang.org/course/detail/100031401-109715?utm_source=related_read&utm_medium=article&utm_term=related_read
  • https://www.cnblogs.com/huojg-21442/p/7514848.html
  • https://developer.aliyun.com/article/175294
  • https://github.com/javagrowing/JGrowing/blob/master/%E6%9C%8D%E5%8A%A1%E7%AB%AF%E5%BC%80%E5%8F%91/%E6%B5%85%E6%9E%90%E5%A6%82%E4%BD%95%E8%AE%BE%E8%AE%A1%E4%B8%80%E4%B8%AA%E4%BA%BF%E7%BA%A7%E7%BD%91%E5%85%B3.md
  • https://juejin.im/post/6844903989637562382
  • https://gitbook.cn/books/5bbb3d2a61d11c2d996be26b/index.html
  • https://freecontent.manning.com/the-api-gateway-pattern/
  • Basic functionality for API gateway https://time.geekbang.org/course/detail/100003901-2270
  • Zuul architecture: https://time.geekbang.org/course/detail/100003901-2271
• Multi DC

10-16

• Cache

  • Cache real life applications:
    • seckill
    • social
    • feed

• MySQL

  • index and schema design
    • 分析磁盘I/O时间 https://blog.csdn.net/mysteryhaohao/article/details/51719871
  • high availability
  • read-write separation
  • sharding
  • Problems of mySQL: https://time.geekbang.org/column/article/267741
  • Isolation level: https://time.geekbang.org/column/article/12288
    • Database lock
    • https://github.com/javagrowing/JGrowing/blob/master/%E8%AE%A1%E7%AE%97%E6%9C%BA%E5%9F%BA%E7%A1%80/%E6%95%B0%E6%8D%AE%E5%BA%93/mysql/%E4%B8%BA%E4%BB%80%E4%B9%88%E5%BC%80%E5%8F%91%E4%BA%BA%E5%91%98%E5%BF%85%E9%A1%BB%E8%A6%81%E4%BA%86%E8%A7%A3%E6%95%B0%E6%8D%AE%E5%BA%93%E9%94%81%EF%BC%9F.md

• Storage

  • ElasticSearch
  • NoSQL
    • key value store
      • CP Key value store. https://tech.youzan.com/shi-yong-kai-yuan-ji-zhu-gou-jian-you-zan-fen-bu-shi-kvcun-chu-fu-wu/
  • NewSQL
  • File based storage

• Unique id generator

17-23

• Distributed protocols
• Service discovery
  • https://time.geekbang.org/course/detail/100003901-2269
  • Netflix's microservice architecture: https://time.geekbang.org/course/detail/100003901-2272
• Configuration center / Apollo
  • Appolo architecture: https://time.geekbang.org/course/detail/100003901-2273
• RPC
• Monitoring
  • What are the dimensions of monitoring https://time.geekbang.org/course/detail/100003901-2276
  • Calling chain monitoring https://time.geekbang.org/course/detail/100003901-2277
• Resiliency platform
  • Circuit breaker / rate limiting

24-30

• Multi-threaded programming
• Message queue
• Counter service design
• Platform management
  • Tracing
  • Resiliency patterns

September

21-30

• Api gateway vs Reverse proxy (Nginx)
  • https://time.geekbang.org/course/detail/100031401-109715?utm_source=related_read&utm_medium=article&utm_term=related_read
• 负载均衡 2h：https://course.study.163.com/480000006749023/lecture-480000036687818
• Counter service design in Geek time 2h:
• Database middleware: 3h
  • requirement:
  • mycat:
  • sharding jdbc:
• Distributed database 2h: https://course.study.163.com/480000006749023/lecture-480000036843500
• https://systeminterview.com/download.php