ravish0007/system-design

Preparing for system design interview questions

• Roadmap
  • This sprint
  • Backlog

Roadmap

This sprint

• Seckill
• Twitter search
• Video
• Online coordination
• TopK
  • 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
• Google drive
• Location
• Storage
  • NoSQL
  • newSQL
  • ElastiSearch
  • File based storage

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
  • read-write separation
  • 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