{"id":759,"date":"2026-02-23T20:58:38","date_gmt":"2026-02-23T12:58:38","guid":{"rendered":"https:\/\/blog.itsmygo.uk\/2026\/02\/23\/system-design-was-hard-until-i-learned-these-30-concepts%ef%bd%9c%e5%ad%b8%e6%9c%83%e9%80%99-30-%e5%80%8b%e6%a6%82%e5%bf%b5%e5%be%8c%ef%bc%8c%e7%b3%bb%e7%b5%b1%e8%a8%ad%e8%a8%88%e4%b8%8d%e5%86%8d\/"},"modified":"2026-02-23T20:58:38","modified_gmt":"2026-02-23T12:58:38","slug":"system-design-was-hard-until-i-learned-these-30-concepts%ef%bd%9c%e5%ad%b8%e6%9c%83%e9%80%99-30-%e5%80%8b%e6%a6%82%e5%bf%b5%e5%be%8c%ef%bc%8c%e7%b3%bb%e7%b5%b1%e8%a8%ad%e8%a8%88%e4%b8%8d%e5%86%8d","status":"publish","type":"post","link":"https:\/\/blog.itsmygo.uk\/wordpress\/2026\/02\/23\/system-design-was-hard-until-i-learned-these-30-concepts%ef%bd%9c%e5%ad%b8%e6%9c%83%e9%80%99-30-%e5%80%8b%e6%a6%82%e5%bf%b5%e5%be%8c%ef%bc%8c%e7%b3%bb%e7%b5%b1%e8%a8%ad%e8%a8%88%e4%b8%8d%e5%86%8d\/","title":{"rendered":"System Design was HARD until I Learned these 30 Concepts\uff5c\u5b78\u6703\u9019 30 \u500b\u6982\u5ff5\u5f8c\uff0c\u7cfb\u7d71\u8a2d\u8a08\u4e0d\u518d\u56f0\u96e3"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u9019\u90e8\u5f71\u7247\u7531 AlgoMaster \u983b\u9053\u88fd\u4f5c\uff0c\u6574\u7406\u4e86\u7cfb\u7d71\u8a2d\u8a08\u4e2d\u6700\u91cd\u8981\u7684 30 \u500b\u6838\u5fc3\u6982\u5ff5\u3002\u5f9e\u6700\u57fa\u790e\u7684 Client-Server \u67b6\u69cb\u3001DNS\u3001HTTP \u5354\u8b70\uff0c\u5230\u9032\u968e\u7684\u8cc7\u6599\u5eab\u64f4\u5c55\u7b56\u7565\uff08Replication\u3001Sharding\uff09\u3001\u5feb\u53d6\u3001CDN\u3001\u5fae\u670d\u52d9\u8207\u8a0a\u606f\u4f47\u5217\uff0c\u6db5\u84cb\u4e86\u7cfb\u7d71\u8a2d\u8a08\u9762\u8a66\u548c\u5be6\u969b\u5de5\u7a0b\u4e2d\u53cd\u8986\u51fa\u73fe\u7684\u95dc\u9375\u77e5\u8b58\u3002\u4f5c\u8005\u4ee5\u81ea\u8eab\u5728\u5927\u578b\u79d1\u6280\u516c\u53f8 8 \u5e74\u7684\u7d93\u9a57\u70ba\u57fa\u790e\uff0c\u5c07\u9019\u4e9b\u6982\u5ff5\u4e32\u806f\u6210\u4e00\u500b\u5b8c\u6574\u7684\u5b78\u7fd2\u8def\u5f91\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">\u539f\u5f71\u7247\u9023\u7d50\uff1ahttps:\/\/www.youtube.com\/watch?v=s9Qh9fWeOAk<\/p>\n<\/blockquote>\n\n\n\n<h2 class=\"wp-block-heading\">\u5f71\u7247\u91cd\u9ede<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n\n<li>Client-Server \u67b6\u69cb\u662f\u5e7e\u4e4e\u6240\u6709 Web \u61c9\u7528\u7684\u57fa\u790e\u6a21\u578b<\/li>\n\n\n<li>DNS \u5c07\u4eba\u985e\u53ef\u8b80\u7684\u57df\u540d\u8f49\u63db\u70ba IP \u4f4d\u5740<\/li>\n\n\n<li>Proxy \u8207 Reverse Proxy \u5728\u7cfb\u7d71\u4e2d\u626e\u6f14\u4e0d\u540c\u89d2\u8272<\/li>\n\n\n<li>HTTP\/HTTPS \u662f\u5ba2\u6236\u7aef\u8207\u4f3a\u670d\u5668\u6e9d\u901a\u7684\u6a19\u6e96\u5354\u8b70<\/li>\n\n\n<li>REST \u548c GraphQL \u662f\u5169\u7a2e\u4e3b\u6d41\u7684 API \u8a2d\u8a08\u98a8\u683c<\/li>\n\n\n<li>SQL \u548c NoSQL \u5404\u6709\u9069\u7528\u5834\u666f\uff0c\u73fe\u4ee3\u61c9\u7528\u5e38\u6df7\u5408\u4f7f\u7528<\/li>\n\n\n<li>\u5782\u76f4\u64f4\u5c55\u6709\u4e0a\u9650\uff0c\u6c34\u5e73\u64f4\u5c55\u624d\u662f\u9577\u671f\u65b9\u6848<\/li>\n\n\n<li>\u8cc7\u6599\u5eab\u64f4\u5c55\u6709\u56db\u5927\u6280\u8853\uff1aIndexing\u3001Replication\u3001Sharding\u3001Denormalization<\/li>\n\n\n<li>\u5feb\u53d6\uff08Caching\uff09\u548c CDN \u662f\u63d0\u5347\u6548\u80fd\u7684\u95dc\u9375\u624b\u6bb5<\/li>\n\n\n<li>\u5fae\u670d\u52d9\u67b6\u69cb\u642d\u914d Message Queue \u5be6\u73fe\u670d\u52d9\u89e3\u8026<\/li>\n\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">\u8a73\u7d30\u5167\u5bb9<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">[00:00] Client-Server \u67b6\u69cb<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u5e7e\u4e4e\u6240\u6709\u4f60\u4f7f\u7528\u7684 Web \u61c9\u7528\u90fd\u5efa\u7acb\u5728 Client-Server \u67b6\u69cb\u4e4b\u4e0a\u3002\u5ba2\u6236\u7aef\uff08Client\uff09\u53ef\u4ee5\u662f\u700f\u89bd\u5668\u3001\u884c\u52d5 App \u6216\u4efb\u4f55\u524d\u7aef\u61c9\u7528\uff1b\u4f3a\u670d\u5668\uff08Server\uff09\u5247\u662f\u4e00\u53f0\u6301\u7e8c\u904b\u884c\u7684\u6a5f\u5668\uff0c\u7b49\u5f85\u8655\u7406\u50b3\u5165\u7684\u8acb\u6c42\u3002\u5ba2\u6236\u7aef\u767c\u9001\u8acb\u6c42\u4f86\u5132\u5b58\u3001\u8b80\u53d6\u6216\u4fee\u6539\u8cc7\u6599\uff0c\u4f3a\u670d\u5668\u63a5\u6536\u8acb\u6c42\u5f8c\u9032\u884c\u8655\u7406\uff0c\u4e26\u56de\u50b3\u56de\u61c9\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">[01:10] IP \u4f4d\u5740\u8207 DNS<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u5ba2\u6236\u7aef\u5982\u4f55\u627e\u5230\u4f3a\u670d\u5668\uff1f\u5728\u7db2\u8def\u4e0a\uff0c\u96fb\u8166\u900f\u904e IP \u4f4d\u5740\u4e92\u76f8\u8b58\u5225\uff0c\u5c31\u50cf\u4f3a\u670d\u5668\u7684\u96fb\u8a71\u865f\u78bc\u3002\u4f46\u6211\u5011\u9020\u8a2a\u7db2\u7ad9\u6642\u4e0d\u6703\u8f38\u5165 IP \u4f4d\u5740\uff0c\u800c\u662f\u8f38\u5165\u57df\u540d\u3002DNS\uff08Domain Name System\uff09\u8ca0\u8cac\u5c07\u5bb9\u6613\u8a18\u61b6\u7684\u57df\u540d\u6620\u5c04\u5230\u5c0d\u61c9\u7684 IP \u4f4d\u5740\u3002\u7576\u4f60\u5728\u700f\u89bd\u5668\u8f38\u5165\u57df\u540d\u6642\uff0c\u96fb\u8166\u6703\u5411 DNS \u4f3a\u670d\u5668\u67e5\u8a62\u5c0d\u61c9\u7684 IP\uff0c\u7136\u5f8c\u7528\u9019\u500b IP \u8207\u4f3a\u670d\u5668\u5efa\u7acb\u9023\u7dda\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">[02:20] Proxy \u8207 Reverse Proxy<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u7576\u4f60\u9020\u8a2a\u7db2\u7ad9\u6642\uff0c\u8acb\u6c42\u4e0d\u4e00\u5b9a\u76f4\u63a5\u5230\u9054\u4f3a\u670d\u5668\uff0c\u6709\u6642\u6703\u5148\u7d93\u904e Proxy \u6216 Reverse Proxy\u3002Proxy\uff08\u6b63\u5411\u4ee3\u7406\uff09\u4f5c\u70ba\u4f60\u7684\u88dd\u7f6e\u8207\u7db2\u8def\u4e4b\u9593\u7684\u4e2d\u9593\u4eba\uff0c\u5b83\u6703\u96b1\u85cf\u4f60\u7684 IP \u4f4d\u5740\uff0c\u4fdd\u8b77\u4f60\u7684\u8eab\u4efd\u96b1\u79c1\u3002Reverse Proxy\uff08\u53cd\u5411\u4ee3\u7406\uff09\u5247\u76f8\u53cd\uff0c\u5b83\u6514\u622a\u5ba2\u6236\u7aef\u8acb\u6c42\uff0c\u6839\u64da\u9810\u5b9a\u7fa9\u7684\u898f\u5247\u5c07\u8acb\u6c42\u8f49\u767c\u5230\u5f8c\u7aef\u4f3a\u670d\u5668\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">[03:00] Latency \u8207\u591a\u8cc7\u6599\u4e2d\u5fc3\u90e8\u7f72<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u5ba2\u6236\u7aef\u8207\u4f3a\u670d\u5668\u901a\u8a0a\u6642\u7e3d\u6703\u6709\u5ef6\u9072\u3002\u7269\u7406\u8ddd\u96e2\u662f\u5ef6\u9072\u7684\u6700\u5927\u539f\u56e0\u4e4b\u4e00\u3002\u4f8b\u5982\u4f3a\u670d\u5668\u5728\u7d10\u7d04\uff0c\u4f46\u5370\u5ea6\u7684\u7528\u6236\u767c\u9001\u8acb\u6c42\uff0c\u8cc7\u6599\u9700\u8981\u7a7f\u8d8a\u534a\u500b\u5730\u7403\u5f80\u8fd4\uff0c\u9019\u7a2e\u5f80\u8fd4\u5ef6\u9072\u7a31\u70ba Latency\u3002\u9ad8\u5ef6\u9072\u6703\u8b93\u61c9\u7528\u611f\u89ba\u7de9\u6162\u3002\u89e3\u6c7a\u65b9\u6848\u4e4b\u4e00\u662f\u5728\u5168\u7403\u591a\u500b\u8cc7\u6599\u4e2d\u5fc3\u90e8\u7f72\u670d\u52d9\uff0c\u8b93\u7528\u6236\u9023\u63a5\u5230\u6700\u8fd1\u7684\u4f3a\u670d\u5668\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">[03:45] HTTP \u8207 HTTPS<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u5ba2\u6236\u7aef\u548c\u4f3a\u670d\u5668\u4f7f\u7528 HTTP \u5354\u8b70\u6e9d\u901a\uff0c\u9019\u5c31\u662f\u70ba\u4ec0\u9ebc\u5927\u591a\u6578 URL \u4ee5 HTTP \u6216 HTTPS \u958b\u982d\u3002\u5ba2\u6236\u7aef\u767c\u9001\u7684\u8acb\u6c42\u5305\u542b Header\uff08\u8acb\u6c42\u985e\u578b\u3001\u700f\u89bd\u5668\u8cc7\u8a0a\u3001Cookie \u7b49\uff09\u548c\u6709\u6642\u5305\u542b Body\uff08\u5982\u8868\u55ae\u8f38\u5165\uff09\u3002HTTP \u6709\u4e00\u500b\u91cd\u5927\u5b89\u5168\u6f0f\u6d1e\u2014\u2014\u5b83\u4ee5\u660e\u6587\u50b3\u8f38\u8cc7\u6599\u3002HTTPS \u900f\u904e SSL\/TLS \u5354\u8b70\u52a0\u5bc6\u6240\u6709\u8cc7\u6599\uff0c\u5373\u4f7f\u88ab\u622a\u7372\u4e5f\u7121\u6cd5\u8b80\u53d6\u6216\u7be1\u6539\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">[04:50] API\uff1aREST \u8207 GraphQL<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">HTTP \u53ea\u662f\u8cc7\u6599\u50b3\u8f38\u5354\u8b70\uff0c\u4e26\u6c92\u6709\u5b9a\u7fa9\u8acb\u6c42\u61c9\u5982\u4f55\u7d50\u69cb\u5316\u3002API\uff08Application Programming Interface\uff09\u4f5c\u70ba\u4e2d\u9593\u5c64\uff0c\u8b93\u5ba2\u6236\u7aef\u7121\u9700\u95dc\u5fc3\u5e95\u5c64\u7d30\u7bc0\u5c31\u80fd\u8207\u4f3a\u670d\u5668\u6e9d\u901a\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>REST<\/strong> \u662f\u6700\u5ee3\u6cdb\u4f7f\u7528\u7684 API \u98a8\u683c\u3002\u5b83\u662f\u7121\u72c0\u614b\u7684\uff08\u6bcf\u500b\u8acb\u6c42\u7368\u7acb\uff09\uff0c\u4e00\u5207\u90fd\u88ab\u8996\u70ba\u8cc7\u6e90\uff08users\u3001orders\u3001products\uff09\uff0c\u4f7f\u7528\u6a19\u6e96 HTTP \u65b9\u6cd5\uff08GET\u3001POST\u3001PUT\u3001DELETE\uff09\u3002REST \u7c21\u55ae\u3001\u53ef\u64f4\u5c55\u3001\u5bb9\u6613\u5feb\u53d6\uff0c\u4f46\u5728\u8907\u96dc\u8cc7\u6599\u64f7\u53d6\u6642\u53ef\u80fd\u6548\u7387\u4e0d\u4f73\u2014\u2014\u7aef\u9ede\u5e38\u56de\u50b3\u6bd4\u9700\u8981\u66f4\u591a\u7684\u8cc7\u6599\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>GraphQL<\/strong> \u7531 Facebook \u5728 2015 \u5e74\u63a8\u51fa\uff0c\u8b93\u5ba2\u6236\u7aef\u7cbe\u78ba\u6307\u5b9a\u9700\u8981\u7684\u8cc7\u6599\u3002\u7528 REST \u53d6\u5f97\u7528\u6236\u8cc7\u6599\u53ca\u5176\u6700\u8fd1\u8cbc\u6587\u53ef\u80fd\u9700\u8981\u591a\u6b21\u8acb\u6c42\uff0cGraphQL \u53ef\u4ee5\u5408\u4f75\u70ba\u4e00\u6b21\u67e5\u8a62\u3002\u4f46 GraphQL \u5728\u4f3a\u670d\u5668\u7aef\u9700\u8981\u66f4\u591a\u8655\u7406\uff0c\u4e14\u4e0d\u50cf REST \u90a3\u6a23\u5bb9\u6613\u5feb\u53d6\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">[06:50] \u8cc7\u6599\u5eab\uff1aSQL vs NoSQL<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u5ba2\u6236\u7aef\u901a\u5e38\u9700\u8981\u5132\u5b58\u6216\u8b80\u53d6\u8cc7\u6599\u3002\u73fe\u4ee3\u61c9\u7528\u8655\u7406\u7684\u8cc7\u6599\u91cf\u9060\u8d85\u8a18\u61b6\u9ad4\u6240\u80fd\u6709\u6548\u8655\u7406\u7684\u7bc4\u570d\uff0c\u56e0\u6b64\u9700\u8981\u5c08\u7528\u7684\u8cc7\u6599\u5eab\u4f3a\u670d\u5668\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>SQL \u8cc7\u6599\u5eab<\/strong>\u4ee5\u8868\u683c\u5f62\u5f0f\u5132\u5b58\u8cc7\u6599\uff0c\u6709\u56b4\u683c\u7684\u9810\u5b9a\u7fa9 Schema\uff0c\u9075\u5faa ACID \u7279\u6027\u3002\u9069\u5408\u9700\u8981\u5f37\u4e00\u81f4\u6027\u548c\u7d50\u69cb\u5316\u95dc\u806f\u7684\u61c9\u7528\uff0c\u5982\u9280\u884c\u7cfb\u7d71\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>NoSQL \u8cc7\u6599\u5eab<\/strong>\u4e0d\u9700\u8981\u56fa\u5b9a Schema\uff0c\u5c08\u70ba\u9ad8\u64f4\u5c55\u6027\u548c\u6548\u80fd\u8a2d\u8a08\u3002\u8cc7\u6599\u6a21\u578b\u5305\u62ec Key-Value Store\u3001Document Store\u3001Graph Database \u548c Wide-Column Store\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u8a31\u591a\u73fe\u4ee3\u61c9\u7528\u6703\u540c\u6642\u4f7f\u7528 SQL \u548c NoSQL\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">[08:30] \u5782\u76f4\u64f4\u5c55 vs \u6c34\u5e73\u64f4\u5c55<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u96a8\u8457\u7528\u6236\u589e\u9577\uff0c\u8acb\u6c42\u91cf\u4e5f\u96a8\u4e4b\u589e\u52a0\u3002<strong>\u5782\u76f4\u64f4\u5c55<\/strong>\uff08Vertical Scaling\uff09\u662f\u5347\u7d1a\u73fe\u6709\u4f3a\u670d\u5668\u7684 CPU\u3001RAM \u6216\u5132\u5b58\u7a7a\u9593\uff0c\u8b93\u55ae\u4e00\u6a5f\u5668\u66f4\u5f37\u5927\u3002\u4f46\u5b83\u6709\u660e\u986f\u9650\u5236\uff1a\u6bcf\u53f0\u6a5f\u5668\u90fd\u6709\u786c\u9ad4\u4e0a\u9650\u3001\u9ad8\u898f\u683c\u4f3a\u670d\u5668\u6307\u6578\u7d1a\u6602\u8cb4\u3001\u55ae\u9ede\u6545\u969c\u98a8\u96aa\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>\u6c34\u5e73\u64f4\u5c55<\/strong>\uff08Horizontal Scaling\uff09\u5247\u662f\u589e\u52a0\u66f4\u591a\u4f3a\u670d\u5668\u4f86\u5206\u64d4\u8ca0\u8f09\u3002\u66f4\u591a\u4f3a\u670d\u5668\u4ee3\u8868\u66f4\u591a\u5bb9\u91cf\uff0c\u7cfb\u7d71\u80fd\u66f4\u6709\u6548\u5730\u8655\u7406\u589e\u9577\u7684\u6d41\u91cf\u3002\u5982\u679c\u4e00\u53f0\u4f3a\u670d\u5668\u7576\u6a5f\uff0c\u5176\u4ed6\u4f3a\u670d\u5668\u53ef\u4ee5\u63a5\u624b\uff0c\u63d0\u5347\u53ef\u9760\u6027\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">[09:50] Load Balancer<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u6c34\u5e73\u64f4\u5c55\u5e36\u4f86\u65b0\u6311\u6230\uff1a\u5ba2\u6236\u7aef\u600e\u9ebc\u77e5\u9053\u8a72\u9023\u63a5\u54ea\u53f0\u4f3a\u670d\u5668\uff1f<strong>Load Balancer<\/strong>\uff08\u8ca0\u8f09\u5747\u8861\u5668\uff09\u4f4d\u65bc\u5ba2\u6236\u7aef\u548c\u5f8c\u7aef\u4f3a\u670d\u5668\u4e4b\u9593\uff0c\u4f5c\u70ba\u6d41\u91cf\u7ba1\u7406\u8005\uff0c\u5c07\u8acb\u6c42\u5206\u914d\u5230\u591a\u53f0\u4f3a\u670d\u5668\u3002\u5982\u679c\u67d0\u53f0\u4f3a\u670d\u5668\u639b\u4e86\uff0cLoad Balancer \u6703\u81ea\u52d5\u5c07\u6d41\u91cf\u91cd\u5c0e\u5230\u5176\u4ed6\u5065\u5eb7\u7684\u4f3a\u670d\u5668\u3002\u5e38\u898b\u7684\u8ca0\u8f09\u5747\u8861\u6f14\u7b97\u6cd5\u5305\u62ec Round Robin\u3001Least Connections \u548c IP Hashing\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">[10:40] \u8cc7\u6599\u5eab Indexing<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Indexing<\/strong>\uff08\u7d22\u5f15\uff09\u662f\u52a0\u901f\u8cc7\u6599\u5eab\u8b80\u53d6\u67e5\u8a62\u6700\u5feb\u901f\u6709\u6548\u7684\u65b9\u5f0f\u4e4b\u4e00\u3002\u5c31\u50cf\u66f8\u672b\u7684\u7d22\u5f15\u9801\uff0c\u8b93\u4f60\u76f4\u63a5\u8df3\u5230\u76f8\u95dc\u7ae0\u7bc0\uff0c\u800c\u4e0d\u7528\u7ffb\u95b1\u6bcf\u4e00\u9801\u3002\u7d22\u5f15\u5132\u5b58\u6b04\u4f4d\u503c\u548c\u6307\u5411\u5be6\u969b\u8cc7\u6599\u884c\u7684\u6307\u6a19\u3002\u7d22\u5f15\u901a\u5e38\u5efa\u7acb\u5728\u983b\u7e41\u67e5\u8a62\u7684\u6b04\u4f4d\u4e0a\uff0c\u5982 Primary Key\u3001Foreign Key \u548c\u5e38\u7528\u65bc WHERE \u689d\u4ef6\u7684\u6b04\u4f4d\u3002\u4f46\u7d22\u5f15\u6703\u6e1b\u6162\u5beb\u5165\u901f\u5ea6\uff0c\u56e0\u70ba\u6bcf\u6b21\u8cc7\u6599\u8b8a\u66f4\u90fd\u9700\u8981\u66f4\u65b0\u7d22\u5f15\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">[11:50] \u8cc7\u6599\u5eab Replication<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u7576\u55ae\u4e00\u8cc7\u6599\u5eab\u4f3a\u670d\u5668\u7121\u6cd5\u8655\u7406\u6301\u7e8c\u589e\u9577\u7684\u8b80\u53d6\u8acb\u6c42\u6642\uff0c\u53ef\u4ee5\u4f7f\u7528 <strong>Replication<\/strong>\uff08\u8907\u88fd\uff09\u3002\u67b6\u69cb\u4e0a\u6709\u4e00\u500b Primary\uff08\u4e3b\u8981\u526f\u672c\uff09\u8ca0\u8cac\u6240\u6709\u5beb\u5165\u64cd\u4f5c\uff0c\u591a\u500b Read Replica\uff08\u8b80\u53d6\u526f\u672c\uff09\u8655\u7406\u8b80\u53d6\u67e5\u8a62\u3002\u5beb\u5165 Primary \u7684\u8cc7\u6599\u6703\u88ab\u8907\u88fd\u5230 Read Replica \u4fdd\u6301\u540c\u6b65\u3002Replication \u6539\u5584\u8b80\u53d6\u6548\u80fd\u3001\u63d0\u5347\u53ef\u7528\u6027\u2014\u2014\u5982\u679c Primary \u6545\u969c\uff0cRead Replica \u53ef\u4ee5\u6649\u5347\u70ba\u65b0\u7684 Primary\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">[12:55] Sharding\uff08\u5206\u7247\uff09<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u7576\u670d\u52d9\u64c1\u6709\u6578\u767e\u842c\u7528\u6236\u3001\u8cc7\u6599\u9054\u5230 TB \u7d1a\u5225\u6642\uff0c\u55ae\u4e00\u8cc7\u6599\u5eab\u4f3a\u670d\u5668\u7d42\u5c07\u4e0d\u582a\u8ca0\u8377\u3002<strong>Sharding<\/strong> \u5c07\u8cc7\u6599\u5eab\u5206\u5272\u6210\u66f4\u5c0f\u3001\u66f4\u6613\u7ba1\u7406\u7684\u90e8\u5206\uff08Shard\uff09\uff0c\u5206\u4f48\u5230\u591a\u53f0\u4f3a\u670d\u5668\u4e0a\u3002\u6bcf\u500b Shard \u5305\u542b\u7e3d\u8cc7\u6599\u7684\u5b50\u96c6\uff0c\u8cc7\u6599\u6839\u64da Sharding Key\uff08\u5982 User ID\uff09\u9032\u884c\u5206\u914d\u3002Sharding \u4e5f\u7a31\u70ba\u6c34\u5e73\u5206\u5340\uff08Horizontal Partitioning\uff09\uff0c\u6309\u884c\u5206\u5272\u8cc7\u6599\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">[13:45] Vertical Partitioning\uff08\u5782\u76f4\u5206\u5340\uff09<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u5982\u679c\u554f\u984c\u4e0d\u662f\u884c\u6578\u592a\u591a\uff0c\u800c\u662f\u6b04\u4f4d\u592a\u591a\u5462\uff1f<strong>Vertical Partitioning<\/strong> \u6309\u6b04\u4f4d\u5206\u5272\u8cc7\u6599\u5eab\u3002\u4f8b\u5982\uff0c\u4e00\u500b\u7528\u6236\u8868\u683c\u5132\u5b58\u4e86\u500b\u4eba\u8cc7\u6599\u3001\u767b\u5165\u8a18\u9304\u548c\u5e33\u55ae\u8cc7\u8a0a\uff0c\u53ef\u4ee5\u5c07\u5176\u62c6\u5206\u70ba\u66f4\u5c0f\u3001\u66f4\u805a\u7126\u7684\u8868\u683c\u3002\u9019\u6a23\u6bcf\u6b21\u67e5\u8a62\u53ea\u9700\u6383\u63cf\u76f8\u95dc\u6b04\u4f4d\uff0c\u6e1b\u5c11\u4e0d\u5fc5\u8981\u7684\u78c1\u789f I\/O\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">[14:30] Caching\uff08\u5feb\u53d6\uff09<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u7121\u8ad6\u600e\u9ebc\u512a\u5316\u8cc7\u6599\u5eab\uff0c\u5f9e\u78c1\u789f\u8b80\u53d6\u8cc7\u6599\u7e3d\u6bd4\u5f9e\u8a18\u61b6\u9ad4\u8b80\u53d6\u6162\u3002<strong>Caching<\/strong> \u5c07\u983b\u7e41\u5b58\u53d6\u7684\u8cc7\u6599\u5b58\u5165\u8a18\u61b6\u9ad4\u3002\u6700\u5e38\u898b\u7684\u5feb\u53d6\u7b56\u7565\u662f <strong>Cache-Aside \u6a21\u5f0f<\/strong>\uff1a\u7528\u6236\u8acb\u6c42\u8cc7\u6599\u6642\uff0c\u5148\u6aa2\u67e5\u5feb\u53d6\uff1b\u5982\u679c\u547d\u4e2d\u5c31\u76f4\u63a5\u56de\u50b3\uff1b\u5982\u679c\u672a\u547d\u4e2d\uff0c\u5f9e\u8cc7\u6599\u5eab\u8b80\u53d6\u5f8c\u5b58\u5165\u5feb\u53d6\u518d\u56de\u50b3\u3002\u70ba\u9632\u6b62\u904e\u671f\u8cc7\u6599\u88ab\u56de\u50b3\uff0c\u6703\u8a2d\u5b9a TTL\uff08Time To Live\uff09\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">[15:30] Denormalization\uff08\u53cd\u6b63\u898f\u5316\uff09<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u95dc\u806f\u5f0f\u8cc7\u6599\u5eab\u4f7f\u7528 Normalization \u5c07\u8cc7\u6599\u62c6\u5206\u5230\u4e0d\u540c\u8868\u683c\u4ee5\u6e1b\u5c11\u5197\u9918\uff0c\u4f46\u9019\u5f15\u5165\u4e86 JOIN \u64cd\u4f5c\u3002\u96a8\u8457\u8cc7\u6599\u91cf\u589e\u9577\uff0cJOIN \u6703\u62d6\u6162\u67e5\u8a62\u3002<strong>Denormalization<\/strong> \u900f\u904e\u5c07\u76f8\u95dc\u8cc7\u6599\u5408\u4f75\u5230\u55ae\u4e00\u8868\u683c\u4f86\u6e1b\u5c11 JOIN\uff0c\u5373\u4f7f\u9019\u610f\u5473\u8457\u67d0\u4e9b\u8cc7\u6599\u6703\u88ab\u91cd\u8907\u5132\u5b58\u3002\u9069\u7528\u65bc\u8b80\u53d6\u5bc6\u96c6\u578b\u61c9\u7528\uff0c\u4f46\u4ee3\u50f9\u662f\u589e\u52a0\u5132\u5b58\u7a7a\u9593\u548c\u66f4\u8907\u96dc\u7684\u66f4\u65b0\u64cd\u4f5c\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">[16:30] CAP Theorem<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u7576\u7cfb\u7d71\u64f4\u5c55\u5230\u591a\u53f0\u4f3a\u670d\u5668\u3001\u591a\u500b\u8cc7\u6599\u5eab\u548c\u8cc7\u6599\u4e2d\u5fc3\u6642\uff0c\u5c31\u9032\u5165\u4e86\u5206\u6563\u5f0f\u7cfb\u7d71\u7684\u9818\u57df\u3002<strong>CAP \u5b9a\u7406<\/strong>\u6307\u51fa\uff0c\u6c92\u6709\u4efb\u4f55\u5206\u6563\u5f0f\u7cfb\u7d71\u80fd\u540c\u6642\u5be6\u73fe\u4ee5\u4e0b\u4e09\u8005\uff1aConsistency\uff08\u4e00\u81f4\u6027\uff09\u3001Availability\uff08\u53ef\u7528\u6027\uff09\u3001Partition Tolerance\uff08\u5206\u5340\u5bb9\u932f\u6027\uff09\u3002\u7531\u65bc\u7db2\u8def\u6545\u969c\u662f\u4e0d\u53ef\u907f\u514d\u7684\uff0c\u6211\u5011\u5fc5\u9808\u5728 CP\uff08\u4e00\u81f4\u6027 + \u5206\u5340\u5bb9\u932f\uff09\u548c AP\uff08\u53ef\u7528\u6027 + \u5206\u5340\u5bb9\u932f\uff09\u4e4b\u9593\u505a\u51fa\u9078\u64c7\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">[17:15] Blob Storage \u8207 CDN<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u73fe\u4ee3\u61c9\u7528\u4e0d\u53ea\u8655\u7406\u6587\u5b57\u8a18\u9304\uff0c\u9084\u9700\u8981\u8655\u7406\u5716\u7247\u3001\u5f71\u7247\u3001PDF \u7b49\u5927\u578b\u6a94\u6848\u3002\u50b3\u7d71\u8cc7\u6599\u5eab\u4e0d\u9069\u5408\u5132\u5b58\u5927\u578b\u975e\u7d50\u69cb\u5316\u6a94\u6848\uff0c\u56e0\u6b64\u6211\u5011\u4f7f\u7528 <strong>Blob Storage<\/strong>\uff08\u5982 Amazon S3\uff09\u3002Blob \u5132\u5b58\u5728\u96f2\u7aef\u7684\u5bb9\u5668\uff08Bucket\uff09\u4e2d\uff0c\u6bcf\u500b\u6a94\u6848\u6709\u552f\u4e00\u7684 URL\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u4f46\u76f4\u63a5\u5f9e Blob Storage \u4e32\u6d41\u5f71\u7247\u53ef\u80fd\u5f88\u6162\u3002<strong>CDN<\/strong>\uff08Content Delivery Network\uff09\u662f\u4e00\u500b\u5168\u7403\u5206\u6563\u5f0f\u4f3a\u670d\u5668\u7db2\u8def\uff0c\u6839\u64da\u7528\u6236\u7684\u5730\u7406\u4f4d\u7f6e\u63d0\u4f9b\u5167\u5bb9\u3002\u5167\u5bb9\u5f9e\u6700\u8fd1\u7684 CDN \u4f3a\u670d\u5668\u63d0\u4f9b\uff0c\u7528\u6236\u9ad4\u9a57\u5230\u66f4\u5feb\u7684\u8f09\u5165\u6642\u9593\u548c\u6700\u5c11\u7684\u7de9\u885d\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">[18:50] WebSocket<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u5927\u591a\u6578 Web \u61c9\u7528\u4f7f\u7528 HTTP \u7684\u8acb\u6c42-\u56de\u61c9\u6a21\u578b\u3002\u4f46\u5c0d\u65bc\u5373\u6642\u804a\u5929\u3001\u80a1\u7968\u884c\u60c5\u3001\u7dda\u4e0a\u591a\u4eba\u904a\u6232\u7b49\u5373\u6642\u61c9\u7528\uff0cHTTP \u592a\u6162\u4e14\u4f4e\u6548\u3002\u7528 HTTP \u5be6\u73fe\u5373\u6642\u66f4\u65b0\u53ea\u80fd\u9760 Polling\uff08\u983b\u7e41\u8f2a\u8a62\uff09\uff0c\u4f46\u5927\u90e8\u5206\u56de\u61c9\u662f\u7a7a\u7684\uff0c\u6d6a\u8cbb\u983b\u5bec\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>WebSocket<\/strong> \u5141\u8a31\u5ba2\u6236\u7aef\u548c\u4f3a\u670d\u5668\u4e4b\u9593\u5efa\u7acb\u6301\u4e45\u7684\u96d9\u5411\u9023\u7dda\u3002\u4f3a\u670d\u5668\u53ef\u4ee5\u96a8\u6642\u4e3b\u52d5\u63a8\u9001\u66f4\u65b0\uff0c\u5ba2\u6236\u7aef\u4e5f\u80fd\u5373\u6642\u767c\u9001\u8a0a\u606f\uff0c\u7121\u9700\u8f2a\u8a62\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">[19:50] Webhook<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">WebSocket \u5be6\u73fe\u7684\u662f\u5ba2\u6236\u7aef\u8207\u4f3a\u670d\u5668\u4e4b\u9593\u7684\u5373\u6642\u901a\u8a0a\u3002\u4f46\u5982\u679c\u662f\u4f3a\u670d\u5668\u9700\u8981\u901a\u77e5\u53e6\u4e00\u500b\u4f3a\u670d\u5668\u5462\uff1f\u4f8b\u5982\u7528\u6236\u4ed8\u6b3e\u5f8c\uff0c\u652f\u4ed8\u9598\u9053\u9700\u8981\u5373\u6642\u901a\u77e5\u4f60\u7684\u61c9\u7528\u3002<strong>Webhook<\/strong> \u8b93\u4f3a\u670d\u5668\u5728\u4e8b\u4ef6\u767c\u751f\u6642\uff0c\u4e3b\u52d5\u767c\u9001 HTTP POST \u8acb\u6c42\u5230\u53e6\u4e00\u500b\u4f3a\u670d\u5668\u7684\u6307\u5b9a URL\uff0c\u800c\u4e0d\u662f\u4e0d\u65b7\u8f2a\u8a62 API \u6aa2\u67e5\u4e8b\u4ef6\u662f\u5426\u767c\u751f\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">[20:30] \u5fae\u670d\u52d9\u67b6\u69cb<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u50b3\u7d71\u61c9\u7528\u4f7f\u7528 Monolithic \u67b6\u69cb\uff0c\u6240\u6709\u529f\u80fd\u5728\u4e00\u500b\u5927\u578b\u7a0b\u5f0f\u78bc\u5eab\u4e2d\u3002\u5c0d\u5927\u578b\u7cfb\u7d71\u4f86\u8aaa\uff0cMonolith \u8b8a\u5f97\u96e3\u4ee5\u7ba1\u7406\u3001\u64f4\u5c55\u548c\u90e8\u7f72\u3002<strong>\u5fae\u670d\u52d9\u67b6\u69cb<\/strong>\u5c07\u61c9\u7528\u62c6\u5206\u70ba\u66f4\u5c0f\u7684\u7368\u7acb\u670d\u52d9\uff0c\u6bcf\u500b Microservice \u8ca0\u8cac\u55ae\u4e00\u8077\u8cac\u3001\u6709\u81ea\u5df1\u7684\u8cc7\u6599\u5eab\u548c\u908f\u8f2f\uff0c\u53ef\u4ee5\u7368\u7acb\u64f4\u5c55\uff0c\u900f\u904e API \u6216 Message Queue \u8207\u5176\u4ed6\u670d\u52d9\u6e9d\u901a\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">[21:15] Message Queue<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u7576\u591a\u500b\u5fae\u670d\u52d9\u9700\u8981\u6e9d\u901a\u6642\uff0c\u76f4\u63a5 API \u547c\u53eb\u4e26\u4e0d\u7e3d\u662f\u9ad8\u6548\u7684\u3002\u540c\u6b65\u901a\u8a0a\uff08\u7b49\u5f85\u5373\u6642\u56de\u61c9\uff09\u5728\u5927\u898f\u6a21\u4e0b\u64f4\u5c55\u6027\u5dee\u3002<strong>Message Queue<\/strong> \u8b93\u670d\u52d9\u975e\u540c\u6b65\u6e9d\u901a\uff1aProducer \u5c07\u8a0a\u606f\u653e\u5165\u4f47\u5217\uff0cQueue \u66ab\u5b58\u8a0a\u606f\uff0cConsumer \u53d6\u51fa\u4e26\u8655\u7406\u8a0a\u606f\u3002\u9019\u5be6\u73fe\u4e86\u670d\u52d9\u89e3\u8026\uff0c\u63d0\u5347\u64f4\u5c55\u6027\uff0c\u4e26\u9632\u6b62\u5167\u90e8\u670d\u52d9\u904e\u8f09\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">[22:00] Rate Limiting \u8207 API Gateway<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u5982\u4f55\u9632\u6b62\u516c\u958b API \u88ab\u6feb\u7528\uff1f<strong>Rate Limiting<\/strong> \u9650\u5236\u5ba2\u6236\u7aef\u5728\u7279\u5b9a\u6642\u9593\u7bc4\u570d\u5167\u7684\u8acb\u6c42\u6578\u91cf\u3002\u4f8b\u5982\u6bcf\u5206\u9418 100 \u6b21\u8acb\u6c42\uff0c\u8d85\u904e\u9650\u5236\u5c31\u66ab\u6642\u5c01\u9396\u4e26\u56de\u50b3\u932f\u8aa4\u3002\u5e38\u898b\u7684\u9650\u6d41\u6f14\u7b97\u6cd5\u6709 Fixed Window\u3001Sliding Window \u548c Token Bucket\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>API Gateway<\/strong> \u662f\u4e00\u500b\u96c6\u4e2d\u5f0f\u670d\u52d9\uff0c\u8655\u7406\u8a8d\u8b49\u3001\u9650\u6d41\u3001\u65e5\u8a8c\u3001\u76e3\u63a7\u3001\u8acb\u6c42\u8def\u7531\u7b49\u529f\u80fd\u3002\u5b83\u4f5c\u70ba\u6240\u6709\u5ba2\u6236\u7aef\u8acb\u6c42\u7684\u55ae\u4e00\u5165\u53e3\uff0c\u5c07\u8acb\u6c42\u8def\u7531\u5230\u9069\u7576\u7684\u5fae\u670d\u52d9\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">[23:10] Idempotency\uff08\u51aa\u7b49\u6027\uff09<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u5728\u5206\u6563\u5f0f\u7cfb\u7d71\u4e2d\uff0c\u7db2\u8def\u6545\u969c\u548c\u91cd\u8a66\u5f88\u5e38\u898b\u3002\u5982\u679c\u7528\u6236\u4e0d\u5c0f\u5fc3\u91cd\u65b0\u6574\u7406\u4ed8\u6b3e\u9801\u9762\uff0c\u7cfb\u7d71\u53ef\u80fd\u6536\u5230\u5169\u6b21\u4ed8\u6b3e\u8acb\u6c42\u3002<strong>Idempotency<\/strong>\uff08\u51aa\u7b49\u6027\uff09\u78ba\u4fdd\u91cd\u8907\u8acb\u6c42\u7522\u751f\u8207\u55ae\u6b21\u8acb\u6c42\u76f8\u540c\u7684\u7d50\u679c\u3002\u505a\u6cd5\u662f\u70ba\u6bcf\u500b\u8acb\u6c42\u5206\u914d\u552f\u4e00 ID\uff0c\u8655\u7406\u524d\u5148\u6aa2\u67e5\u8a72\u8acb\u6c42\u662f\u5426\u5df2\u88ab\u8655\u7406\u904e\u2014\u2014\u5982\u679c\u662f\uff0c\u5ffd\u7565\u91cd\u8907\u8acb\u6c42\uff1b\u5982\u679c\u5426\uff0c\u6b63\u5e38\u8655\u7406\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u6211\u7684\u60f3\u6cd5<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u9019\u90e8\u5f71\u7247\u7684\u6700\u5927\u50f9\u503c\u5728\u65bc\u5b83\u63d0\u4f9b\u4e86\u4e00\u500b\u6e05\u6670\u7684\u7cfb\u7d71\u8a2d\u8a08\u300c\u77e5\u8b58\u5730\u5716\u300d\u3002\u5c0d\u521d\u5b78\u8005\u4f86\u8aaa\uff0c\u7cfb\u7d71\u8a2d\u8a08\u6700\u4ee4\u4eba\u632b\u6557\u7684\u4e0d\u662f\u55ae\u4e00\u6982\u5ff5\u6709\u591a\u96e3\uff0c\u800c\u662f\u4e0d\u77e5\u9053\u8a72\u5b78\u4ec0\u9ebc\u3001\u5b78\u5230\u4ec0\u9ebc\u7a0b\u5ea6\u3002\u9019 30 \u500b\u6982\u5ff5\u57fa\u672c\u4e0a\u6db5\u84cb\u4e86\u7cfb\u7d71\u8a2d\u8a08\u9762\u8a66\u548c\u5be6\u969b\u5de5\u7a0b\u4e2d\u6700\u5e38\u898b\u7684\u4e3b\u984c\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u503c\u5f97\u6ce8\u610f\u7684\u662f\uff0c\u5f71\u7247\u5f9e\u6700\u5e95\u5c64\u7684 Client-Server \u958b\u59cb\uff0c\u4e00\u8def\u5f80\u4e0a\u69cb\u5efa\u5230\u5fae\u670d\u52d9\u548c\u5206\u6563\u5f0f\u7cfb\u7d71\uff0c\u9019\u500b\u5b78\u7fd2\u9806\u5e8f\u672c\u8eab\u5c31\u5f88\u6709\u53c3\u8003\u50f9\u503c\u3002\u6bcf\u500b\u6982\u5ff5\u7684\u5f15\u5165\u90fd\u662f\u56e0\u70ba\u524d\u4e00\u500b\u6982\u5ff5\u9047\u5230\u4e86\u74f6\u9838\u2014\u2014\u9700\u8981\u64f4\u5c55\u6240\u4ee5\u5f15\u5165 Load Balancer\uff0c\u8b80\u53d6\u592a\u6162\u6240\u4ee5\u5f15\u5165 Caching\uff0c\u55ae\u9ad4\u67b6\u69cb\u96e3\u4ee5\u7dad\u8b77\u6240\u4ee5\u5f15\u5165\u5fae\u670d\u52d9\u3002\u7406\u89e3\u9019\u500b\u300c\u70ba\u4ec0\u9ebc\u9700\u8981\u5b83\u300d\u7684\u8108\u7d61\uff0c\u6bd4\u55ae\u7d14\u8a18\u4f4f\u6bcf\u500b\u6280\u8853\u662f\u4ec0\u9ebc\u66f4\u91cd\u8981\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u4e0d\u904e\u9019\u90e8\u5f71\u7247\u7562\u7adf\u662f\u9ad8\u5c64\u6b21\u6982\u89bd\uff0c\u6bcf\u500b\u6982\u5ff5\u53ea\u505a\u4e86\u7c21\u8981\u4ecb\u7d39\u3002\u5efa\u8b70\u628a\u5b83\u7576\u4f5c\u5b78\u7fd2\u8def\u7dda\u5716\uff0c\u91dd\u5c0d\u81ea\u5df1\u4e0d\u719f\u6089\u7684\u6982\u5ff5\u518d\u6df1\u5165\u7814\u7a76\u3002\u7279\u5225\u662f CAP Theorem\u3001Sharding \u7b56\u7565\u9078\u64c7\u3001\u5feb\u53d6\u5931\u6548\u7b56\u7565\u9019\u4e9b\u4e3b\u984c\uff0c\u5728\u5be6\u969b\u5de5\u7a0b\u4e2d\u7684\u6c7a\u7b56\u9060\u6bd4\u5f71\u7247\u4e2d\u63cf\u8ff0\u7684\u8907\u96dc\u3002<\/p>\n\n    \n\n<div id=\"quiz-0f1a73a2\">\n<style>\n#quiz-0f1a73a2 .badge {\n        display: inline-block;\n        padding: 4px 10px;\n        border-radius: 12px;\n        font-size: 0.75em;\n        font-weight: bold;\n        margin-left: 8px;\n      }#quiz-0f1a73a2 .badge.scenario {\n        background: #ebf8ff;\n        color: #2b6cb0;\n      }#quiz-0f1a73a2 .badge.debug {\n        background: #fef3c7;\n        color: #92400e;\n      }#quiz-0f1a73a2 .question-adv {\n        background: white;\n        border-radius: 10px;\n        padding: 24px;\n        margin: 20px 0;\n        box-shadow: 0 2px 8px rgba(0, 0, 0, 0.08);\n        border-left: 4px solid #ed8936;\n      }#quiz-0f1a73a2 .question-adv h3 {\n        margin-top: 0;\n        color: #2d3748;\n      }#quiz-0f1a73a2 .code-block {\n        background: #1e1e1e;\n        color: #d4d4d4;\n        padding: 14px;\n        border-radius: 6px;\n        font-family: \"Menlo\", \"Monaco\", \"Courier New\", monospace;\n        font-size: 0.9em;\n        overflow-x: auto;\n        margin: 12px 0;\n        white-space: pre-wrap;\n      }#quiz-0f1a73a2 .options-adv {\n        list-style: none;\n        padding: 0;\n      }#quiz-0f1a73a2 .options-adv li {\n        padding: 14px 16px;\n        margin: 10px 0;\n        border: 2px solid #e2e8f0;\n        border-radius: 8px;\n        cursor: pointer;\n        transition: all 0.2s;\n      }#quiz-0f1a73a2 .options-adv li:hover:not(.disabled) {\n        border-color: #ed8936;\n        background: #fffaf0;\n      }#quiz-0f1a73a2 .options-adv li.disabled {\n        cursor: default;\n        opacity: 0.7;\n      }#quiz-0f1a73a2 .options-adv li.show-answer {\n        border-color: #48bb78;\n        background: #f0fff4;\n      }#quiz-0f1a73a2 .options-adv li.wrong {\n        border-color: #fc8181;\n        background: #fff5f5;\n      }#quiz-0f1a73a2 .feedback-adv {\n        margin-top: 16px;\n        padding: 14px;\n        border-radius: 8px;\n        display: none;\n        line-height: 1.6;\n      }#quiz-0f1a73a2 .feedback-adv.correct {\n        background: #f0fff4;\n        color: #276749;\n        display: block;\n      }#quiz-0f1a73a2 .feedback-adv.wrong {\n        background: #fff5f5;\n        color: #c53030;\n        display: block;\n      }#quiz-0f1a73a2 .feedback-adv \n      .score-adv {\n        text-align: center;\n        font-size: 1.4em;\n        padding: 24px;\n        background: white;\n        border-radius: 10px;\n        margin-top: 24px;\n        box-shadow: 0 2px 8px rgba(0, 0, 0, 0.08);\n      }#quiz-0f1a73a2 .intro {\n        background: #ebf8ff;\n        padding: 16px;\n        border-radius: 8px;\n        margin-bottom: 20px;\n        color: #2c5282;\n      }\n<\/style>\n<h1>\u9032\u968e\u6e2c\u9a57\uff1a\u7cfb\u7d71\u8a2d\u8a08 30 \u500b\u6838\u5fc3\u6982\u5ff5<\/h1>\n    <div class=\"intro\">\n      <strong>\u6e2c\u9a57\u76ee\u6a19\uff1a<\/strong>\u9a57\u8b49\u4f60\u662f\u5426\u80fd\u5728\u5be6\u969b\u60c5\u5883\u4e2d\u61c9\u7528\u7cfb\u7d71\u8a2d\u8a08\u7684\u6838\u5fc3\u6982\u5ff5\u3002<br \/>\n      \u5171 5 \u984c\uff0c\u5305\u542b\u60c5\u5883\u984c\u8207\u932f\u8aa4\u8a3a\u65b7\u984c\u3002\n    <\/div>\n\n    <!-- \u60c5\u5883\u984c 1 -->\n    <div class=\"question-adv\" id=\"qAdv1\">\n      <h3>1. \u4f60\u7684\u96fb\u5546\u5e73\u53f0\u76ee\u524d\u4f7f\u7528\u55ae\u4e00 SQL \u8cc7\u6599\u5eab\uff0c\u8b80\u53d6\u6d41\u91cf\u662f\u5beb\u5165\u7684 10 \u500d\uff0c\u8cc7\u6599\u5eab\u4f3a\u670d\u5668 CPU \u7d93\u5e38\u98c6\u5230 90% \u4ee5\u4e0a\u3002\u4f60\u5e0c\u671b\u5728\u4e0d\u6539\u8b8a\u73fe\u6709\u67b6\u69cb\u592a\u591a\u7684\u60c5\u6cc1\u4e0b\u6539\u5584\u6548\u80fd\u3002\u61c9\u8a72\u512a\u5148\u63a1\u53d6\u54ea\u500b\u65b9\u6848\uff1f <span class=\"badge scenario\">\u60c5\u5883\u984c<\/span><\/h3>\n      <div class=\"code-block\">\u73fe\u6cc1\uff1a\n&#8211; \u55ae\u4e00 PostgreSQL \u8cc7\u6599\u5eab\n&#8211; \u8b80\u5beb\u6bd4\u4f8b\u7d04 10:1\n&#8211; CPU \u4f7f\u7528\u7387\u6301\u7e8c\u504f\u9ad8\n&#8211; \u8cc7\u6599\u91cf\u7d04 50GB\uff0c\u5c1a\u672a\u9054\u5230\u55ae\u6a5f\u5132\u5b58\u4e0a\u9650<\/div>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(1, 'A', 'B')\">A. \u5c07\u8cc7\u6599\u5eab\u9032\u884c Sharding\uff0c\u6309 User ID \u5206\u7247\u5230\u591a\u53f0\u4f3a\u670d\u5668<\/li>\n        <li onclick=\"checkAnswerAdv(1, 'B', 'B')\">B. \u5efa\u7acb Read Replica\uff0c\u5c07\u8b80\u53d6\u67e5\u8a62\u5206\u6563\u5230\u591a\u500b\u526f\u672c<\/li>\n        <li onclick=\"checkAnswerAdv(1, 'C', 'B')\">C. \u5c07\u6574\u500b\u8cc7\u6599\u5eab\u5f9e SQL \u9077\u79fb\u5230 NoSQL \u4ee5\u63d0\u5347\u6548\u80fd<\/li>\n        <li onclick=\"checkAnswerAdv(1, 'D', 'B')\">D. \u5c0d\u6240\u6709\u8cc7\u6599\u8868\u7684\u6240\u6709\u6b04\u4f4d\u5efa\u7acb\u7d22\u5f15<\/li>\n      <\/ul>\n      <div class=\"feedback-adv\" id=\"fbAdv1\"><\/div>\n    <\/div>\n\n    <!-- \u60c5\u5883\u984c 2 -->\n    <div class=\"question-adv\" id=\"qAdv2\">\n      <h3>2. \u4f60\u6b63\u5728\u8a2d\u8a08\u4e00\u500b\u5373\u6642\u80a1\u7968\u884c\u60c5\u770b\u677f\uff0c\u9700\u8981\u4f3a\u670d\u5668\u5728\u80a1\u50f9\u8b8a\u52d5\u6642\u4e3b\u52d5\u5c07\u6700\u65b0\u50f9\u683c\u63a8\u9001\u7d66\u6240\u6709\u9023\u7dda\u4e2d\u7684\u5ba2\u6236\u7aef\u3002\u4ee5\u4e0b\u54ea\u7a2e\u901a\u8a0a\u65b9\u5f0f\u6700\u9069\u5408\uff1f <span class=\"badge scenario\">\u60c5\u5883\u984c<\/span><\/h3>\n      <div class=\"code-block\">\u9700\u6c42\uff1a\n&#8211; \u4f3a\u670d\u5668\u9700\u4e3b\u52d5\u63a8\u9001\u8cc7\u6599\u7d66\u5ba2\u6236\u7aef\n&#8211; \u5ba2\u6236\u7aef\u4e5f\u9700\u8981\u80fd\u5373\u6642\u9001\u51fa\u4ea4\u6613\u8acb\u6c42\n&#8211; \u5ef6\u9072\u8981\u6c42\uff1a\u6beb\u79d2\u7d1a\n&#8211; \u540c\u6642\u9023\u7dda\u7528\u6236\u6578\uff1a\u6578\u5343\u4eba<\/div>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(2, 'A', 'C')\">A. \u4f7f\u7528 REST API \u642d\u914d\u5ba2\u6236\u7aef\u6bcf\u79d2\u8f2a\u8a62\uff08Polling\uff09<\/li>\n        <li onclick=\"checkAnswerAdv(2, 'B', 'C')\">B. \u4f7f\u7528 Webhook \u8b93\u4f3a\u670d\u5668\u901a\u77e5\u5ba2\u6236\u7aef<\/li>\n        <li onclick=\"checkAnswerAdv(2, 'C', 'C')\">C. \u4f7f\u7528 WebSocket \u5efa\u7acb\u6301\u4e45\u96d9\u5411\u9023\u7dda<\/li>\n        <li onclick=\"checkAnswerAdv(2, 'D', 'C')\">D. \u4f7f\u7528 GraphQL Subscription \u642d\u914d HTTP \u9577\u8f2a\u8a62<\/li>\n      <\/ul>\n      <div class=\"feedback-adv\" id=\"fbAdv2\"><\/div>\n    <\/div>\n\n    <!-- \u60c5\u5883\u984c 3 -->\n    <div class=\"question-adv\" id=\"qAdv3\">\n      <h3>3. \u4f60\u7684\u5fae\u670d\u52d9\u67b6\u69cb\u4e2d\uff0c\u8a02\u55ae\u670d\u52d9\u8655\u7406\u5b8c\u8a02\u55ae\u5f8c\u9700\u8981\u901a\u77e5\u5eab\u5b58\u670d\u52d9\u6263\u6e1b\u5eab\u5b58\u3001\u901a\u77e5\u90f5\u4ef6\u670d\u52d9\u767c\u9001\u78ba\u8a8d\u4fe1\u3002\u4f46\u90f5\u4ef6\u670d\u52d9\u5076\u723e\u6703\u56e0\u7b2c\u4e09\u65b9 API \u903e\u6642\u800c\u56de\u61c9\u7de9\u6162\u3002\u4f60\u61c9\u8a72\u5982\u4f55\u8a2d\u8a08\u670d\u52d9\u9593\u7684\u901a\u8a0a\uff1f <span class=\"badge scenario\">\u60c5\u5883\u984c<\/span><\/h3>\n      <div class=\"code-block\">\u73fe\u6709\u67b6\u69cb\uff1a\n&#8211; \u8a02\u55ae\u670d\u52d9\uff08Order Service\uff09\n&#8211; \u5eab\u5b58\u670d\u52d9\uff08Inventory Service\uff09\n&#8211; \u90f5\u4ef6\u670d\u52d9\uff08Email Service\uff09\n\u554f\u984c\uff1a\u90f5\u4ef6\u670d\u52d9\u7684\u5ef6\u9072\u62d6\u6162\u4e86\u6574\u500b\u8a02\u55ae\u6d41\u7a0b<\/div>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(3, 'A', 'B')\">A. \u8b93\u8a02\u55ae\u670d\u52d9\u76f4\u63a5\u547c\u53eb\u5eab\u5b58\u548c\u90f5\u4ef6\u670d\u52d9\u7684 REST API\uff0c\u4e26\u8a2d\u5b9a\u8f03\u9577\u7684\u903e\u6642\u6642\u9593<\/li>\n        <li onclick=\"checkAnswerAdv(3, 'B', 'B')\">B. \u4f7f\u7528 Message Queue\uff0c\u8a02\u55ae\u670d\u52d9\u5c07\u4e8b\u4ef6\u653e\u5165\u4f47\u5217\uff0c\u5eab\u5b58\u548c\u90f5\u4ef6\u670d\u52d9\u5404\u81ea\u6d88\u8cbb\u8655\u7406<\/li>\n        <li onclick=\"checkAnswerAdv(3, 'C', 'B')\">C. \u5c07\u5eab\u5b58\u548c\u90f5\u4ef6\u529f\u80fd\u5408\u4f75\u56de\u8a02\u55ae\u670d\u52d9\uff0c\u6e1b\u5c11\u7db2\u8def\u547c\u53eb<\/li>\n        <li onclick=\"checkAnswerAdv(3, 'D', 'B')\">D. \u4f7f\u7528 WebSocket \u8b93\u8a02\u55ae\u670d\u52d9\u8207\u90f5\u4ef6\u670d\u52d9\u4fdd\u6301\u6301\u4e45\u9023\u7dda<\/li>\n      <\/ul>\n      <div class=\"feedback-adv\" id=\"fbAdv3\"><\/div>\n    <\/div>\n\n    <!-- \u932f\u8aa4\u8a3a\u65b7\u984c 1 -->\n    <div class=\"question-adv\" id=\"qAdv4\">\n      <h3>4. \u5718\u968a\u70ba\u4e86\u52a0\u901f\u67e5\u8a62\uff0c\u5728\u7528\u6236\u8868\u683c\u7684\u6bcf\u500b\u6b04\u4f4d\u90fd\u5efa\u7acb\u4e86\u7d22\u5f15\u3002\u4e0a\u7dda\u5f8c\u767c\u73fe\u5beb\u5165\u6548\u80fd\u53cd\u800c\u5927\u5e45\u4e0b\u964d\uff0c\u65b0\u7528\u6236\u8a3b\u518a\u7684\u56de\u61c9\u6642\u9593\u5f9e 50ms \u589e\u52a0\u5230 500ms\u3002\u6700\u53ef\u80fd\u7684\u539f\u56e0\u662f\u4ec0\u9ebc\uff1f <span class=\"badge debug\">\u932f\u8aa4\u8a3a\u65b7<\/span><\/h3>\n      <div class=\"code-block\">&#8212; \u7528\u6236\u8868\u5efa\u7acb\u4e86\u4ee5\u4e0b\u7d22\u5f15\nCREATE INDEX idx_user_name ON users(name);\nCREATE INDEX idx_user_email ON users(email);\nCREATE INDEX idx_user_phone ON users(phone);\nCREATE INDEX idx_user_address ON users(address);\nCREATE INDEX idx_user_bio ON users(bio);\nCREATE INDEX idx_user_created ON users(created_at);\nCREATE INDEX idx_user_updated ON users(updated_at);\n&#8212; &#8230; \u5c0d\u6bcf\u500b\u6b04\u4f4d\u90fd\u5efa\u4e86\u7d22\u5f15\n\n&#8212; \u8a3b\u518a\u65b0\u7528\u6236\u6642\uff08INSERT \u64cd\u4f5c\uff09\u56de\u61c9\u6642\u9593\u5f9e 50ms \u2192 500ms<\/div>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(4, 'A', 'A')\">A. \u6bcf\u6b21\u5beb\u5165\u8cc7\u6599\u6642\uff0c\u6240\u6709\u7d22\u5f15\u90fd\u9700\u8981\u540c\u6b65\u66f4\u65b0\uff0c\u904e\u591a\u7d22\u5f15\u56b4\u91cd\u62d6\u6162\u5beb\u5165\u901f\u5ea6<\/li>\n        <li onclick=\"checkAnswerAdv(4, 'B', 'A')\">B. \u7d22\u5f15\u4f54\u7528\u4e86\u592a\u591a\u78c1\u789f\u7a7a\u9593\uff0c\u5c0e\u81f4\u8cc7\u6599\u5eab\u5132\u5b58\u4e0d\u8db3<\/li>\n        <li onclick=\"checkAnswerAdv(4, 'C', 'A')\">C. \u7d22\u5f15\u8a9e\u6cd5\u6709\u8aa4\uff0c\u8cc7\u6599\u5eab\u5728\u6bcf\u6b21\u5beb\u5165\u6642\u5617\u8a66\u4fee\u5fa9\u640d\u58de\u7684\u7d22\u5f15<\/li>\n        <li onclick=\"checkAnswerAdv(4, 'D', 'A')\">D. \u5efa\u7acb\u7d22\u5f15\u5f8c\u8cc7\u6599\u5eab\u81ea\u52d5\u555f\u7528\u4e86\u56b4\u683c\u6a21\u5f0f\uff0c\u5c0e\u81f4\u984d\u5916\u7684\u8cc7\u6599\u9a57\u8b49<\/li>\n      <\/ul>\n      <div class=\"feedback-adv\" id=\"fbAdv4\"><\/div>\n    <\/div>\n\n    <!-- \u932f\u8aa4\u8a3a\u65b7\u984c 2 -->\n    <div class=\"question-adv\" id=\"qAdv5\">\n      <h3>5. \u4f60\u7684\u7dda\u4e0a\u652f\u4ed8\u7cfb\u7d71\u6c92\u6709\u5be6\u4f5c\u51aa\u7b49\u6027\uff08Idempotency\uff09\uff0c\u4f7f\u7528\u8005\u5728\u4ed8\u6b3e\u6642\u56e0\u7db2\u8def\u4e0d\u7a69\u5b9a\uff0c\u700f\u89bd\u5668\u81ea\u52d5\u91cd\u8a66\u4e86\u8acb\u6c42\u3002\u7d50\u679c\u4f7f\u7528\u8005\u88ab\u6263\u6b3e\u5169\u6b21\u3002\u4ee5\u4e0b\u54ea\u500b\u4fee\u6b63\u65b9\u6848\u80fd\u6b63\u78ba\u89e3\u6c7a\u9019\u500b\u554f\u984c\uff1f <span class=\"badge debug\">\u932f\u8aa4\u8a3a\u65b7<\/span><\/h3>\n      <div class=\"code-block\">\u554f\u984c\u91cd\u73fe\uff1a\n1. \u4f7f\u7528\u8005\u9ede\u64ca\u300c\u4ed8\u6b3e\u300d\u6309\u9215\n2. \u8acb\u6c42\u9001\u51fa\uff0c\u4f46\u7db2\u8def\u903e\u6642\uff0c\u5ba2\u6236\u7aef\u672a\u6536\u5230\u56de\u61c9\n3. \u5ba2\u6236\u7aef\u81ea\u52d5\u91cd\u8a66\u76f8\u540c\u7684\u4ed8\u6b3e\u8acb\u6c42\n4. \u4f3a\u670d\u5668\u5c07\u5169\u6b21\u8acb\u6c42\u90fd\u7576\u4f5c\u65b0\u7684\u4ed8\u6b3e\u8655\u7406\n5. \u4f7f\u7528\u8005\u88ab\u6263\u6b3e\u5169\u6b21\uff08$100 \u00d7 2 = $200\uff09<\/div>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(5, 'A', 'C')\">A. \u5728\u524d\u7aef\u7981\u7528\u300c\u4ed8\u6b3e\u300d\u6309\u9215\uff0c\u9632\u6b62\u4f7f\u7528\u8005\u91cd\u8907\u9ede\u64ca<\/li>\n        <li onclick=\"checkAnswerAdv(5, 'B', 'C')\">B. \u589e\u52a0 Rate Limiting\uff0c\u9650\u5236\u6bcf\u500b\u4f7f\u7528\u8005\u6bcf\u5206\u9418\u53ea\u80fd\u767c\u9001\u4e00\u6b21\u4ed8\u6b3e\u8acb\u6c42<\/li>\n        <li onclick=\"checkAnswerAdv(5, 'C', 'C')\">C. \u70ba\u6bcf\u7b46\u4ed8\u6b3e\u8acb\u6c42\u7522\u751f\u552f\u4e00\u7684 Idempotency Key\uff0c\u4f3a\u670d\u5668\u8655\u7406\u524d\u5148\u6aa2\u67e5\u8a72 Key \u662f\u5426\u5df2\u8655\u7406\u904e<\/li>\n        <li onclick=\"checkAnswerAdv(5, 'D', 'C')\">D. \u4f7f\u7528 WebSocket \u53d6\u4ee3 HTTP\uff0c\u78ba\u4fdd\u4f3a\u670d\u5668\u80fd\u5373\u6642\u56de\u61c9\u907f\u514d\u91cd\u8a66<\/li>\n      <\/ul>\n      <div class=\"feedback-adv\" id=\"fbAdv5\"><\/div>\n    <\/div>\n\n    <div class=\"score-adv\" id=\"scoreAdv\" style=\"display:none;\"><\/div>\n<script>\n\n      let answeredAdv = 0;\n      let correctAdv = 0;\n      const totalAdv = 5;\n      const explanationsAdv = {\n        1: \"\u5728\u8b80\u5beb\u6bd4 10:1 \u4e14\u8cc7\u6599\u91cf\u5c1a\u672a\u8d85\u51fa\u55ae\u6a5f\u4e0a\u9650\u7684\u60c5\u6cc1\u4e0b\uff0c\u5efa\u7acb Read Replica \u662f\u6700\u76f4\u63a5\u6709\u6548\u7684\u65b9\u6848\u3002Replication \u5c07\u8b80\u53d6\u67e5\u8a62\u5206\u6563\u5230\u591a\u500b\u526f\u672c\uff0c\u5927\u5e45\u964d\u4f4e\u4e3b\u8cc7\u6599\u5eab\u7684\u8ca0\u8f09\u3002Sharding \u9069\u7528\u65bc\u8cc7\u6599\u91cf\u5df2\u8d85\u51fa\u55ae\u6a5f\u4e0a\u9650\u7684\u5834\u666f\uff0c\u76ee\u524d 50GB \u4e26\u4e0d\u9700\u8981\u3002\u9077\u79fb\u5230 NoSQL \u4ee3\u50f9\u592a\u5927\u4e14\u4e0d\u4e00\u5b9a\u9069\u5408\u7d50\u69cb\u5316\u8cc7\u6599\u3002\u5c0d\u6240\u6709\u6b04\u4f4d\u5efa\u7d22\u5f15\u6703\u56b4\u91cd\u62d6\u6162\u5beb\u5165\u6548\u80fd\uff0c\u61c9\u53ea\u5c0d\u983b\u7e41\u67e5\u8a62\u7684\u6b04\u4f4d\u5efa\u7d22\u5f15\u3002\",\n        2: \"WebSocket \u63d0\u4f9b\u6301\u4e45\u7684\u96d9\u5411\u9023\u7dda\uff0c\u4f3a\u670d\u5668\u53ef\u4ee5\u4e3b\u52d5\u63a8\u9001\u8cc7\u6599\uff0c\u5ba2\u6236\u7aef\u4e5f\u80fd\u5373\u6642\u9001\u51fa\u8acb\u6c42\uff0c\u5b8c\u5168\u7b26\u5408\u80a1\u7968\u884c\u60c5\u770b\u677f\u7684\u9700\u6c42\u3002REST Polling \u6703\u9020\u6210\u5927\u91cf\u7121\u6548\u8acb\u6c42\u548c\u5ef6\u9072\u3002Webhook \u662f\u4f3a\u670d\u5668\u5c0d\u4f3a\u670d\u5668\u7684\u901a\u77e5\u6a5f\u5236\uff0c\u4e0d\u9069\u7528\u65bc\u4f3a\u670d\u5668\u5c0d\u700f\u89bd\u5668\u5ba2\u6236\u7aef\u7684\u5834\u666f\u3002HTTP \u9577\u8f2a\u8a62\u96d6\u7136\u53ef\u884c\uff0c\u4f46\u5728\u9700\u8981\u6beb\u79d2\u7d1a\u5ef6\u9072\u548c\u96d9\u5411\u901a\u8a0a\u7684\u5834\u666f\u4e0b\uff0c\u6548\u7387\u9060\u4e0d\u5982 WebSocket\u3002\",\n        3: \"\u4f7f\u7528 Message Queue \u5be6\u73fe\u975e\u540c\u6b65\u901a\u8a0a\u662f\u6b63\u78ba\u505a\u6cd5\u3002\u8a02\u55ae\u670d\u52d9\u5c07\u4e8b\u4ef6\u653e\u5165\u4f47\u5217\u5f8c\u5373\u53ef\u56de\u61c9\u5ba2\u6236\u7aef\uff0c\u4e0d\u9700\u7b49\u5f85\u90f5\u4ef6\u670d\u52d9\u8655\u7406\u5b8c\u6210\u3002\u5eab\u5b58\u548c\u90f5\u4ef6\u670d\u52d9\u5404\u81ea\u5f9e\u4f47\u5217\u6d88\u8cbb\u8a0a\u606f\u4e26\u7368\u7acb\u8655\u7406\uff0c\u5373\u4f7f\u90f5\u4ef6\u670d\u52d9\u66ab\u6642\u7de9\u6162\u4e5f\u4e0d\u6703\u5f71\u97ff\u8a02\u55ae\u6d41\u7a0b\u3002\u76f4\u63a5\u547c\u53eb REST API \u662f\u540c\u6b65\u6a21\u5f0f\uff0c\u6162\u7684\u670d\u52d9\u6703\u62d6\u6162\u6574\u500b\u93c8\u8def\u3002\u5408\u4f75\u670d\u52d9\u9055\u80cc\u5fae\u670d\u52d9\u539f\u5247\u3002WebSocket \u662f\u5ba2\u6236\u7aef-\u4f3a\u670d\u5668\u7684\u5373\u6642\u901a\u8a0a\u65b9\u6848\uff0c\u4e0d\u9069\u5408\u670d\u52d9\u9593\u7684\u975e\u540c\u6b65\u8655\u7406\u3002\",\n        4: \"\u7d22\u5f15\u80fd\u52a0\u901f\u8b80\u53d6\uff0c\u4f46\u6bcf\u6b21\u5beb\u5165\uff08INSERT\u3001UPDATE\u3001DELETE\uff09\u6642\uff0c\u8cc7\u6599\u5eab\u90fd\u5fc5\u9808\u540c\u6b65\u66f4\u65b0\u6240\u6709\u76f8\u95dc\u7d22\u5f15\u3002\u7576\u6bcf\u500b\u6b04\u4f4d\u90fd\u6709\u7d22\u5f15\u6642\uff0c\u4e00\u6b21 INSERT \u64cd\u4f5c\u9700\u8981\u540c\u6642\u66f4\u65b0\u591a\u500b\u7d22\u5f15\u7d50\u69cb\uff0c\u5c0e\u81f4\u5beb\u5165\u6548\u80fd\u5927\u5e45\u4e0b\u964d\u3002\u6b63\u78ba\u505a\u6cd5\u662f\u53ea\u5c0d\u6700\u983b\u7e41\u67e5\u8a62\u7684\u6b04\u4f4d\u5efa\u7acb\u7d22\u5f15\uff08\u5982 email \u7528\u65bc\u767b\u5165\u67e5\u8a62\uff09\uff0c\u800c\u975e\u5c0d\u6240\u6709\u6b04\u4f4d\u90fd\u5efa\u7d22\u5f15\u3002\u9019\u662f Indexing \u7684\u6838\u5fc3\u53d6\u6368\uff1a\u8b80\u53d6\u52a0\u901f vs \u5beb\u5165\u6e1b\u901f\u3002\",\n        5: \"\u51aa\u7b49\u6027\uff08Idempotency\uff09\u7684\u6b63\u78ba\u5be6\u4f5c\u65b9\u5f0f\u662f\u70ba\u6bcf\u500b\u8acb\u6c42\u5206\u914d\u552f\u4e00\u7684 Idempotency Key\u3002\u4f3a\u670d\u5668\u5728\u8655\u7406\u524d\u5148\u6aa2\u67e5\u8a72 Key \u662f\u5426\u5df2\u88ab\u8655\u7406\u904e\uff0c\u5982\u679c\u662f\u5247\u56de\u50b3\u4e4b\u524d\u7684\u7d50\u679c\u800c\u4e0d\u91cd\u8907\u57f7\u884c\u3002\u7981\u7528\u6309\u9215\u53ea\u80fd\u9632\u6b62\u4f7f\u7528\u8005\u624b\u52d5\u91cd\u8907\u9ede\u64ca\uff0c\u7121\u6cd5\u9632\u6b62\u7db2\u8def\u91cd\u8a66\u3002Rate Limiting \u662f\u9650\u5236\u8acb\u6c42\u983b\u7387\u7684\u6a5f\u5236\uff0c\u7121\u6cd5\u7cbe\u78ba\u5224\u65b7\u91cd\u8907\u7684\u5546\u696d\u64cd\u4f5c\u3002WebSocket \u96d6\u7136\u6e1b\u5c11\u4e86\u91cd\u8a66\u7684\u53ef\u80fd\u6027\uff0c\u4f46\u7121\u6cd5\u6839\u672c\u89e3\u6c7a\u5206\u6563\u5f0f\u7cfb\u7d71\u4e2d\u7684\u91cd\u8907\u8acb\u6c42\u554f\u984c\u3002\"\n      };\n\n      function checkAnswerAdv(qNum, selected, correctAns) {\n        const question = document.getElementById(\"qAdv\" + qNum);\n        if (question.classList.contains(\"answered\")) return;\n\n        question.classList.add(\"answered\");\n        answeredAdv++;\n\n        const options = question.querySelectorAll(\".options-adv li\");\n        options.forEach((opt) => {\n          opt.classList.add(\"disabled\");\n          if (opt.textContent.startsWith(correctAns + \".\")) {\n            opt.classList.add(\"show-answer\");\n          }\n        });\n\n        const feedback = document.getElementById(\"fbAdv\" + qNum);\n        if (selected === correctAns) {\n          correctAdv++;\n          feedback.className = \"feedback-adv correct\";\n          feedback.innerHTML = \"\u2713 \u6b63\u78ba\uff01\" + explanationsAdv[qNum];\n        } else {\n          feedback.className = \"feedback-adv wrong\";\n          feedback.innerHTML =\n            \"\u2717 \u932f\u8aa4\u3002\u6b63\u78ba\u7b54\u6848\u662f \" + correctAns + \"\u3002\" + explanationsAdv[qNum];\n          options.forEach((opt) => {\n            if (opt.textContent.startsWith(selected + \".\")) {\n              opt.classList.add(\"wrong\");\n            }\n          });\n        }\n\n        if (answeredAdv === totalAdv) {\n          const scoreDiv = document.getElementById(\"scoreAdv\");\n          scoreDiv.style.display = \"block\";\n          let msg = \"\";\n          if (correctAdv === totalAdv) msg = \"\ud83c\udfaf \u5b8c\u7f8e\uff01\u4f60\u5df2\u7d93\u6e96\u5099\u597d\u5be6\u6230\u4e86\uff01\";\n          else if (correctAdv >= Math.ceil(totalAdv * 0.8))\n            msg = \"\ud83d\udcaa \u5f88\u68d2\uff01\u518d\u8907\u7fd2\u4e00\u4e0b\u932f\u7684\u984c\u76ee\";\n          else if (correctAdv >= Math.ceil(totalAdv * 0.6))\n            msg = \"\ud83d\udcd6 \u5efa\u8b70\u91cd\u8b80\u76f8\u95dc\u6bb5\u843d\u5f8c\u518d\u8a66\u4e00\u6b21\";\n          else msg = \"\ud83d\udd04 \u5efa\u8b70\u91cd\u65b0\u95b1\u8b80\u6587\u4ef6\uff0c\u7279\u5225\u6ce8\u610f\u64cd\u4f5c\u6d41\u7a0b\";\n          scoreDiv.innerHTML =\n            \"\u6e2c\u9a57\u5b8c\u6210\uff01\u5f97\u5206\uff1a\" + correctAdv + \" \/ \" + totalAdv + \"<br>\" + msg;\n        }\n      }\n    \n<\/script>\n<\/div>\n\n\n<div class=\"wp-like-post__wrapper\" style=\"\"><button type=\"button\" class=\"wp-like-post__button \" style=\"height: 30px; color: #000000;\" data-post-id=\"759\" data-total-likes=\"0\" data-likes-from-user=\"0\"><svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" fill=\"none\" viewBox=\"0 0 24 24\" stroke-width=\"1.5\" stroke=\"currentColor\" width=\"30\" height=\"30\"><path stroke-linecap=\"round\" stroke-linejoin=\"round\" d=\"M6.633 10.5c.806 0 1.533-.446 2.031-1.08a9.041 9.041 0 012.861-2.4c.723-.384 1.35-.956 1.653-1.715a4.498 4.498 0 00.322-1.672V3a.75.75 0 01.75-.75A2.25 2.25 0 0116.5 4.5c0 1.152-.26 2.243-.723 3.218-.266.558.107 1.282.725 1.282h3.126c1.026 0 1.945.694 2.054 1.715.045.422.068.85.068 1.285a11.95 11.95 0 01-2.649 7.521c-.388.482-.987.729-1.605.729H13.48c-.483 0-.964-.078-1.423-.23l-3.114-1.04a4.501 4.501 0 00-1.423-.23H5.904M14.25 9h2.25M5.904 18.75c.083.205.173.405.27.602.197.4-.078.898-.523.898h-.908c-.889 0-1.713-.518-1.972-1.368a12 12 0 01-.521-3.507c0-1.553.295-3.036.831-4.398C3.387 10.203 4.167 9.75 5 9.75h1.053c.472 0 .745.556.5.96a8.958 8.958 0 00-1.302 4.665c0 1.194.232 2.333.654 3.375z\" \/><\/svg><\/button><div class=\"wp-like-post__count\"\">0<\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>\u9019\u90e8\u5f71\u7247\u7531 AlgoMaster \u983b\u9053\u88fd\u4f5c\uff0c\u6574\u7406\u4e86\u7cfb\u7d71\u8a2d\u8a08\u4e2d\u6700\u91cd\u8981\u7684 30 \u500b\u6838\u5fc3\u6982\u5ff5\u3002\u5f9e\u6700\u57fa\u790e\u7684 Clien [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":758,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rolpb_likes":0,"footnotes":""},"categories":[700],"tags":[702,293,704,701,703],"class_list":["post-759","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-700","tag-702","tag-293","tag-704","tag-701","tag-703"],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":7}},"_links":{"self":[{"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/posts\/759","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/comments?post=759"}],"version-history":[{"count":0,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/posts\/759\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/media\/758"}],"wp:attachment":[{"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/media?parent=759"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/categories?post=759"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/tags?post=759"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}