thisudoriguy/system-design-interviews

intermediate level system design tutorial

• Intermediate System Design
  • Goal
  • References
  • Remaining items in prioritized order
  • Backlog

Intermediate System Design

Goal

• There are so many great system design tutorials for beginners in the market.
  • Grokking the system design interview
  • System design primer
  • System Design Interview
  • System design repo
• The goal of this repo is to
  • Record my learning journey for software architecture.
  • And it serves as an intermediate level tutorial for system design, being more logical and precise.

References

• The summary inside this repo are the result of learning from the following materials:
  • Videos (IMHO Fastest learning path):
    • In Chinese iMooc
    • In Chinese netease cloud
    • InfoQ
  • Text (Could be theoretical, outdated or missing too many details)
    • In Chinese geek time
    • Company engineering blogs
    • DDIA

Remaining items in prioritized order

1. MySQL (2 day to complete all TODOS)
2. RPC (3 days)
3. Nginx (3 days)
4. Multithreading (1 week)
5. ElasticSearch (2 days)
6. Distributed transactions (2 days)
7. Twitter search
8. Online coordination
9. 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

10. Google drive
11. Location
12. File based storage
13. NoSQL
14. newSQL

Backlog

• Database migration
  • https://time.geekbang.org/column/article/221658
  • https://time.geekbang.org/column/article/155138
• Sharding middleware diffs
• Distributed rate limiting - imooc
• API Idempotent - imooc
• Distributed file system - imooc
• Distributed transactions - imooc
• Multithreading
• Keep-alive/Web-Socket
• Web-server
  • Tomcat/Nginx/OpenResty
• 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
• MySQL
  • index and schema design
    • 分析磁盘I/O时间 https://blog.csdn.net/mysteryhaohao/article/details/51719871
  • 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
• 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
• Multi-threaded programming
• Platform management
  • Tracing
  • Resiliency patterns
• Database middleware: 3h
  • requirement:
  • mycat:
  • sharding jdbc:
• Distributed database 2h: https://course.study.163.com/480000006749023/lecture-480000036843500
• https://systeminterview.com/download.php