{"id":765,"date":"2026-02-23T21:53:48","date_gmt":"2026-02-23T13:53:48","guid":{"rendered":"https:\/\/blog.itsmygo.uk\/2026\/02\/23\/%e3%80%90%e7%b3%bb%e7%b5%b1%e8%a8%ad%e8%a8%88-30-%e6%a6%82%e5%bf%b5%e3%80%9104-%e8%b3%87%e6%96%99%e5%ba%ab%e5%84%aa%e5%8c%96%e8%88%87%e6%93%b4%e5%b1%95-%e7%b4%a2%e5%bc%95%e3%80%81%e8%a4%87\/"},"modified":"2026-02-23T21:53:48","modified_gmt":"2026-02-23T13:53:48","slug":"%e3%80%90%e7%b3%bb%e7%b5%b1%e8%a8%ad%e8%a8%88-30-%e6%a6%82%e5%bf%b5%e3%80%9104-%e8%b3%87%e6%96%99%e5%ba%ab%e5%84%aa%e5%8c%96%e8%88%87%e6%93%b4%e5%b1%95-%e7%b4%a2%e5%bc%95%e3%80%81%e8%a4%87","status":"publish","type":"post","link":"https:\/\/blog.itsmygo.uk\/wordpress\/2026\/02\/23\/%e3%80%90%e7%b3%bb%e7%b5%b1%e8%a8%ad%e8%a8%88-30-%e6%a6%82%e5%bf%b5%e3%80%9104-%e8%b3%87%e6%96%99%e5%ba%ab%e5%84%aa%e5%8c%96%e8%88%87%e6%93%b4%e5%b1%95-%e7%b4%a2%e5%bc%95%e3%80%81%e8%a4%87\/","title":{"rendered":"\u3010\u7cfb\u7d71\u8a2d\u8a08 30 \u6982\u5ff5\u3011#04 \u8cc7\u6599\u5eab\u512a\u5316\u8207\u64f4\u5c55 \u2014 \u7d22\u5f15\u3001\u8907\u88fd\u3001\u5206\u7247\u8207\u5feb\u53d6"},"content":{"rendered":"\n<div id=\"quiz-c6342635\">\n<style>\n#quiz-c6342635 .question {\n        background: white;\n        border-radius: 8px;\n        padding: 20px;\n        margin: 20px 0;\n        box-shadow: 0 2px 4px rgba(0, 0, 0, 0.1);\n      }#quiz-c6342635 .question h3 {\n        margin-top: 0;\n        color: #333;\n      }#quiz-c6342635 .options {\n        list-style: none;\n        padding: 0;\n      }#quiz-c6342635 .options li {\n        padding: 12px 15px;\n        margin: 8px 0;\n        border: 2px solid #ddd;\n        border-radius: 6px;\n        cursor: pointer;\n        transition: all 0.2s;\n      }#quiz-c6342635 .options li:hover:not(.disabled) {\n        border-color: #4caf50;\n        background: #f0fff0;\n      }#quiz-c6342635 .options li.correct {\n        border-color: #4caf50;\n        background: #e8f5e9;\n      }#quiz-c6342635 .options li.wrong {\n        border-color: #f44336;\n        background: #ffebee;\n      }#quiz-c6342635 .options li.disabled {\n        cursor: default;\n        opacity: 0.7;\n      }#quiz-c6342635 .options li.show-answer {\n        border-color: #4caf50;\n        background: #e8f5e9;\n      }#quiz-c6342635 .feedback {\n        margin-top: 15px;\n        padding: 12px;\n        border-radius: 6px;\n        display: none;\n      }#quiz-c6342635 .feedback.correct {\n        background: #e8f5e9;\n        color: #2e7d32;\n        display: block;\n      }#quiz-c6342635 .feedback.wrong {\n        background: #ffebee;\n        color: #c62828;\n        display: block;\n      }#quiz-c6342635 .score {\n        text-align: center;\n        font-size: 1.5em;\n        padding: 20px;\n        background: white;\n        border-radius: 8px;\n        margin-top: 20px;\n      }#quiz-c6342635 .code-block {\n        background: #1e1e1e;\n        color: #d4d4d4;\n        padding: 14px;\n        border-radius: 6px;\n        font-family: \"Monaco\", \"Consolas\", \"Courier New\", monospace;\n        font-size: 0.9em;\n        overflow-x: auto;\n        margin: 12px 0;\n        white-space: pre-wrap;\n      }\n<\/style>\n<h1>\u6e2c\u9a57\uff1a\u8cc7\u6599\u5eab\u512a\u5316\u8207\u64f4\u5c55 \u2014 \u7d22\u5f15\u3001\u8907\u88fd\u3001\u5206\u7247\u8207\u5feb\u53d6<\/h1>\n    <p>\u5171 5 \u984c\uff0c\u9ede\u9078\u7b54\u6848\u5f8c\u6703\u7acb\u5373\u986f\u793a\u7d50\u679c<\/p>\n\n    <div class=\"question\" id=\"q1\">\n      <h3>1. \u8cc7\u6599\u5eab\u7d22\u5f15\uff08Index\uff09\u6700\u4e3b\u8981\u7684\u4f5c\u7528\u662f\u4ec0\u9ebc\uff1f<\/h3>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(1, 'A', 'B')\">A. \u6e1b\u5c11\u8cc7\u6599\u5eab\u7684\u5132\u5b58\u7a7a\u9593<\/li>\n        <li onclick=\"checkAnswer(1, 'B', 'B')\">B. \u52a0\u901f SELECT \u67e5\u8a62\uff0c\u8b93\u8cc7\u6599\u5eab\u4e0d\u7528\u9010\u7b46\u6383\u63cf<\/li>\n        <li onclick=\"checkAnswer(1, 'C', 'B')\">C. \u52a0\u901f INSERT \u548c UPDATE \u64cd\u4f5c<\/li>\n        <li onclick=\"checkAnswer(1, 'D', 'B')\">D. \u81ea\u52d5\u5c07\u8cc7\u6599\u5099\u4efd\u5230\u591a\u53f0\u4f3a\u670d\u5668<\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb1\"><\/div>\n    <\/div>\n\n    <div class=\"question\" id=\"q2\">\n      <h3>2. Replication\uff08\u8907\u88fd\uff09\u548c Sharding\uff08\u5206\u7247\uff09\u6700\u6838\u5fc3\u7684\u5dee\u7570\u662f\u4ec0\u9ebc\uff1f<\/h3>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(2, 'A', 'C')\">A. Replication \u7528\u65bc\u8b80\u53d6\uff0cSharding \u7528\u65bc\u5beb\u5165<\/li>\n        <li onclick=\"checkAnswer(2, 'B', 'C')\">B. Replication \u9069\u5408\u5c0f\u578b\u7cfb\u7d71\uff0cSharding \u9069\u5408\u5927\u578b\u7cfb\u7d71<\/li>\n        <li onclick=\"checkAnswer(2, 'C', 'C')\">C. Replication \u662f\u6bcf\u53f0\u90fd\u6709\u5168\u90e8\u8cc7\u6599\uff0cSharding \u662f\u6bcf\u53f0\u53ea\u6709\u4e00\u90e8\u5206\u8cc7\u6599<\/li>\n        <li onclick=\"checkAnswer(2, 'D', 'C')\">D. Replication \u4e0d\u9700\u8981 Primary\uff0cSharding \u9700\u8981 Primary<\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb2\"><\/div>\n    <\/div>\n\n    <div class=\"question\" id=\"q3\">\n      <h3>3. \u5728 Cache-Aside \u6a21\u5f0f\u4e2d\uff0c\u7576\u5feb\u53d6\u6c92\u6709\u547d\u4e2d\uff08Cache Miss\uff09\u6642\uff0c\u7cfb\u7d71\u6703\u600e\u9ebc\u505a\uff1f<\/h3>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(3, 'A', 'B')\">A. \u76f4\u63a5\u56de\u50b3\u7a7a\u503c\uff0c\u7b49\u5feb\u53d6\u81ea\u52d5\u66f4\u65b0<\/li>\n        <li onclick=\"checkAnswer(3, 'B', 'B')\">B. \u53bb\u8cc7\u6599\u5eab\u67e5\u8a62\uff0c\u67e5\u5230\u5f8c\u5b58\u9032\u5feb\u53d6\uff0c\u518d\u56de\u50b3\u7d50\u679c<\/li>\n        <li onclick=\"checkAnswer(3, 'C', 'B')\">C. \u901a\u77e5\u6240\u6709 Replica \u540c\u6b65\u6700\u65b0\u8cc7\u6599<\/li>\n        <li onclick=\"checkAnswer(3, 'D', 'B')\">D. \u7b49\u5f85\u5feb\u53d6\u904e\u671f\u5f8c\u91cd\u65b0\u8f09\u5165\u8cc7\u6599<\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb3\"><\/div>\n    <\/div>\n\n    <div class=\"question\" id=\"q4\">\n      <h3>4. \u4e00\u500b\u4f7f\u7528\u8005\u66f4\u65b0\u5927\u982d\u7167\u5f8c\u7acb\u523b\u91cd\u65b0\u6574\u7406\u9801\u9762\uff0c\u537b\u770b\u5230\u820a\u7684\u5927\u982d\u7167\u3002\u9019\u6700\u53ef\u80fd\u662f\u54ea\u500b\u6982\u5ff5\u9020\u6210\u7684\u554f\u984c\uff1f<\/h3>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(4, 'A', 'D')\">A. \u7d22\u5f15\u6c92\u6709\u53ca\u6642\u66f4\u65b0<\/li>\n        <li onclick=\"checkAnswer(4, 'B', 'D')\">B. Sharding Key \u9078\u64c7\u4e0d\u7576<\/li>\n        <li onclick=\"checkAnswer(4, 'C', 'D')\">C. \u53cd\u6b63\u898f\u5316\u5c0e\u81f4\u8cc7\u6599\u4e0d\u4e00\u81f4<\/li>\n        <li onclick=\"checkAnswer(4, 'D', 'D')\">D. Replication Lag \u2014 \u5beb\u5165 Primary \u5f8c Replica \u9084\u6c92\u540c\u6b65\u5b8c\u6210<\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb4\"><\/div>\n    <\/div>\n\n    <div class=\"question\" id=\"q5\">\n      <h3>5. \u9047\u5230\u8cc7\u6599\u5eab\u6548\u80fd\u554f\u984c\u6642\uff0c\u6587\u7ae0\u5efa\u8b70\u7684\u8655\u7406\u512a\u5148\u9806\u5e8f\u70ba\u4f55\uff1f<\/h3>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(5, 'A', 'A')\">A. \u7d22\u5f15 \u2192 \u5feb\u53d6 \u2192 \u8b80\u5beb\u5206\u96e2\uff08Replication\uff09 \u2192 \u5782\u76f4\u5206\u5272\/\u53cd\u6b63\u898f\u5316 \u2192 \u5206\u7247\uff08Sharding\uff09<\/li>\n        <li onclick=\"checkAnswer(5, 'B', 'A')\">B. \u5206\u7247\uff08Sharding\uff09 \u2192 \u5feb\u53d6 \u2192 \u7d22\u5f15 \u2192 \u8b80\u5beb\u5206\u96e2 \u2192 \u53cd\u6b63\u898f\u5316<\/li>\n        <li onclick=\"checkAnswer(5, 'C', 'A')\">C. \u5feb\u53d6 \u2192 \u53cd\u6b63\u898f\u5316 \u2192 \u7d22\u5f15 \u2192 \u5206\u7247 \u2192 \u8b80\u5beb\u5206\u96e2<\/li>\n        <li onclick=\"checkAnswer(5, 'D', 'A')\">D. \u8b80\u5beb\u5206\u96e2 \u2192 \u5206\u7247 \u2192 \u7d22\u5f15 \u2192 \u5feb\u53d6 \u2192 \u5782\u76f4\u5206\u5272<\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb5\"><\/div>\n    <\/div>\n\n    <div class=\"score\" id=\"score\" style=\"display:none;\"><\/div>\n<script>\n\n      let answered = 0;\n      let correct = 0;\n      const total = 5;\n      const explanations = {\n        1: \"\u7d22\u5f15\u5c31\u50cf\u66f8\u7684\u76ee\u9304\uff0c\u8b93\u8cc7\u6599\u5eab\u5728\u67e5\u8a62\u6642\u53ef\u4ee5\u76f4\u63a5\u5b9a\u4f4d\u8cc7\u6599\uff0c\u800c\u4e0d\u9700\u8981\u505a Full Table Scan\uff08\u5168\u8868\u6383\u63cf\uff09\u3002\u7d22\u5f15\u80fd\u5927\u5e45\u52a0\u901f SELECT \u67e5\u8a62\uff0c\u4f46\u4ee3\u50f9\u662f\u6703\u62d6\u6162 INSERT\/UPDATE\uff0c\u56e0\u70ba\u6bcf\u6b21\u5beb\u5165\u90fd\u8981\u540c\u6b65\u66f4\u65b0\u7d22\u5f15\u3002\",\n        2: \"\u6587\u7ae0\u7528\u4e86\u4e00\u500b\u5f88\u597d\u7684\u6bd4\u55bb\uff1aReplication \u5c31\u50cf\u5f71\u5370\u6574\u672c\u66f8\u767c\u7d66\u6bcf\u500b\u4eba\uff08\u6bcf\u53f0\u90fd\u6709\u5b8c\u6574\u8cc7\u6599\uff09\uff0cSharding \u5247\u662f\u628a\u66f8\u6495\u6210\u597d\u5e7e\u4efd\uff08\u6bcf\u53f0\u53ea\u6709\u4e00\u90e8\u5206\u8cc7\u6599\uff09\u3002Replication \u89e3\u6c7a\u8b80\u53d6\u58d3\u529b\uff0cSharding \u89e3\u6c7a\u55ae\u53f0\u5b58\u4e0d\u4e0b\u7684\u554f\u984c\u3002\",\n        3: \"Cache-Aside\uff08\u65c1\u8def\u5feb\u53d6\uff09\u7684\u6d41\u7a0b\u662f\uff1a\u5148\u67e5\u5feb\u53d6 \u2192 Cache Miss \u6642\u53bb\u8cc7\u6599\u5eab\u67e5 \u2192 \u628a\u7d50\u679c\u5b58\u9032\u5feb\u53d6 \u2192 \u56de\u50b3\u7d50\u679c\u3002\u9019\u6a23\u4e0b\u6b21\u76f8\u540c\u67e5\u8a62\u5c31\u80fd\u76f4\u63a5\u5f9e\u5feb\u53d6\u62ff\u5230\u8cc7\u6599\uff08Cache Hit\uff09\u3002\",\n        4: \"\u9019\u662f\u5178\u578b\u7684 Replication Lag \u554f\u984c\u3002\u5beb\u5165\u64cd\u4f5c\u9001\u5230 Primary \u6210\u529f\u4e86\uff0c\u4f46\u4f7f\u7528\u8005\u7acb\u523b\u91cd\u65b0\u6574\u7406\u9801\u9762\u6642\u8b80\u53d6\u7684\u662f Replica\uff0c\u800c Primary \u7684\u8b8a\u66f4\u9084\u6c92\u540c\u6b65\u5230 Replica\uff0c\u6240\u4ee5\u770b\u5230\u7684\u9084\u662f\u820a\u8cc7\u6599\u3002\u9019\u5c31\u662f Eventual Consistency\uff08\u6700\u7d42\u4e00\u81f4\u6027\uff09\u7684\u8868\u73fe\u3002\",\n        5: \"\u6587\u7ae0\u660e\u78ba\u6307\u51fa\u8655\u7406\u9806\u5e8f\u61c9\u8a72\u662f\uff1a\u5148\u52a0\u7d22\u5f15\uff08\u6210\u672c\u6700\u4f4e\u3001\u6548\u679c\u6700\u660e\u986f\uff09\u2192 \u52a0\u5feb\u53d6 \u2192 \u8b80\u5beb\u5206\u96e2 \u2192 \u5782\u76f4\u5206\u5272\/\u53cd\u6b63\u898f\u5316 \u2192 \u6700\u5f8c\u624d\u8003\u616e\u5206\u7247\uff08\u6210\u672c\u6700\u9ad8\u3001\u8907\u96dc\u5ea6\u6700\u5927\uff09\u3002\u4e0d\u8981\u4e00\u958b\u59cb\u5c31\u4e0a Sharding\u3002\"\n      };\n\n      function checkAnswer(qNum, selected, correctAns) {\n        const question = document.getElementById(\"q\" + qNum);\n        if (question.classList.contains(\"answered\")) return;\n\n        question.classList.add(\"answered\");\n        answered++;\n\n        const options = question.querySelectorAll(\".options 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(\"fb\" + qNum);\n        if (selected === correctAns) {\n          correct++;\n          feedback.className = \"feedback correct\";\n          feedback.innerHTML = \"&#10003; \u6b63\u78ba\uff01\" + explanations[qNum];\n        } else {\n          feedback.className = \"feedback wrong\";\n          feedback.innerHTML =\n            \"&#10007; \u932f\u8aa4\u3002\u6b63\u78ba\u7b54\u6848\u662f \" + correctAns + \"\u3002\" + explanations[qNum];\n          options.forEach((opt) => {\n            if (opt.textContent.startsWith(selected + \".\")) {\n              opt.classList.add(\"wrong\");\n            }\n          });\n        }\n\n        if (answered === total) {\n          const scoreDiv = document.getElementById(\"score\");\n          scoreDiv.style.display = \"block\";\n          scoreDiv.innerHTML =\n            \"\u6e2c\u9a57\u5b8c\u6210\uff01\u5f97\u5206\uff1a\" +\n            correct +\n            \" \/ \" +\n            total +\n            (correct === total\n              ? \" &#127881; \u5168\u5c0d\uff01\"\n              : correct >= Math.ceil(total * 0.6)\n                ? \" &#128077; \u4e0d\u932f\uff01\"\n                : \" &#128218; \u518d\u8907\u7fd2\u4e00\u4e0b\u5427\");\n        }\n      }\n    \n<\/script>\n<\/div>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">**\u7cfb\u5217**\uff1a\u7cfb\u7d71\u8a2d\u8a08 30 \u6982\u5ff5\uff08\u7b2c 4 \u7bc7\uff0c\u5171 6 \u7bc7\uff09<br>**\u96e3\u5ea6**\uff1aL2-\u9032\u968e<br>**\u524d\u7f6e\u77e5\u8b58**\uff1a\u672c\u7cfb\u5217\u7b2c 2 \u7bc7\uff08API \u8a2d\u8a08\u8207\u8cc7\u6599\u5132\u5b58\uff09\u3001\u7b2c 3 \u7bc7\uff08\u7cfb\u7d71\u64f4\u5c55\uff09<br>**\u5f71\u7247\u4f86\u6e90**\uff1a*System Design was HARD until I Learned these 30 Concepts* \u2014 Ashish Pratap Singh (YouTube)<\/p>\n<\/blockquote>\n\n\n\n<h2 class=\"wp-block-heading\">\u9019\u7bc7\u5728\u8b1b\u4ec0\u9ebc<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u4e0a\u4e00\u7bc7\u6211\u5011\u804a\u4e86\u300c\u7cfb\u7d71\u600e\u9ebc\u64f4\u5c55\u300d\u3002\u4f46\u64f4\u5c55\u53ea\u662f\u628a\u6a5f\u5668\u52a0\u591a\uff0c\u771f\u6b63\u8981\u8b93\u7cfb\u7d71\u8b8a\u5feb\uff0c\u9084\u5f97\u5f9e<strong>\u8cc7\u6599\u5eab<\/strong>\u4e0b\u624b\u3002\u9019\u7bc7\u6db5\u84cb\u7cfb\u7d71\u8a2d\u8a08 30 \u6982\u5ff5\u4e2d\u7684\u7b2c 15-20 \u500b\uff0c\u5168\u90e8\u570d\u7e5e\u540c\u4e00\u500b\u4e3b\u984c\uff1a<strong>\u600e\u9ebc\u8b93\u8cc7\u6599\u5eab\u53c8\u5feb\u53c8\u7a69<\/strong>\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u8b80\u5b8c\u9019\u7bc7\u4f60\u6703\u77e5\u9053\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n\n<li>Database Indexing \u5982\u4f55\u52a0\u901f\u67e5\u8a62\uff0c\u4ee5\u53ca\u5b83\u7684\u4ee3\u50f9<\/li>\n\n\n<li>Replication \u8207 Sharding \u7684\u5dee\u7570 \u2014 \u4e00\u500b\u662f\u300c\u8907\u88fd\u300d\uff0c\u4e00\u500b\u662f\u300c\u5207\u5272\u300d<\/li>\n\n\n<li>Caching \u548c Denormalization \u5982\u4f55\u72a7\u7272\u4e00\u81f4\u6027\u63db\u53d6\u8b80\u53d6\u6548\u80fd<\/li>\n\n\n<li>Vertical Partitioning \u6309\u6b04\u4f4d\u62c6\u5206\u8cc7\u6599\u8868\u7684\u6982\u5ff5<\/li>\n\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u6982\u5ff5 15\uff1aDatabase Indexing\uff08\u8cc7\u6599\u5eab\u7d22\u5f15\uff09<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u4e00\u53e5\u8a71\u8aaa\u660e<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u7d22\u5f15\u5c31\u662f\u8cc7\u6599\u5eab\u7684\u300c\u76ee\u9304\u300d\uff0c\u8b93\u67e5\u8a62\u4e0d\u7528\u4e00\u7b46\u4e00\u7b46\u7ffb\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u6700\u5c0f\u7bc4\u4f8b<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-1\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\">-- \u6c92\u6709\u7d22\u5f15\uff1a\u8cc7\u6599\u5eab\u8981\u6383\u63cf\u6574\u5f35\u8868\uff0c\u4e00\u884c\u4e00\u884c\u627e\nSELECT * FROM users WHERE email = <span class=\"hljs-string\">'alice@example.com'<\/span>;\n-- \u5982\u679c\u6709 <span class=\"hljs-number\">100<\/span> \u842c\u7b46\uff0c\u6700\u5dee\u8981\u770b <span class=\"hljs-number\">100<\/span> \u842c\u6b21\n\n-- \u5efa\u7acb\u7d22\u5f15\nCREATE INDEX idx_users_email ON users(email);\n\n-- \u6709\u7d22\u5f15\u5f8c\uff1a\u540c\u6a23\u7684\u67e5\u8a62\uff0c\u8cc7\u6599\u5eab\u76f4\u63a5\u300c\u7ffb\u76ee\u9304\u300d\u627e\u5230\u4f4d\u7f6e\nSELECT * FROM users WHERE email = <span class=\"hljs-string\">'alice@example.com'<\/span>;\n-- \u4e0d\u7ba1\u6709\u5e7e\u767e\u842c\u7b46\uff0c\u5e7e\u4e4e\u77ac\u9593\u627e\u5230\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-1\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">\u7528\u66f8\u4f86\u6bd4\u55bb<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u60f3\u50cf\u4e00\u672c 1000 \u9801\u7684\u66f8\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>\u60c5\u5883<\/th>\n<th>\u6c92\u6709\u7d22\u5f15<\/th>\n<th>\u6709\u7d22\u5f15<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>\u627e\u300c\u5feb\u53d6\u300d\u5728\u54ea\u4e00\u9801<\/td>\n<td>\u5f9e\u7b2c 1 \u9801\u7ffb\u5230\u7b2c 1000 \u9801<\/td>\n<td>\u7ffb\u5230\u76ee\u9304\uff0c\u76f4\u63a5\u8df3\u5230\u7b2c 487 \u9801<\/td>\n<\/tr>\n<tr>\n<td>\u8cc7\u6599\u5eab\u64cd\u4f5c<\/td>\n<td>Full Table Scan\uff08\u5168\u8868\u6383\u63cf\uff09<\/td>\n<td>Index Lookup\uff08\u7d22\u5f15\u67e5\u627e\uff09<\/td>\n<\/tr>\n<tr>\n<td>\u901f\u5ea6<\/td>\n<td>O(n) \u2014 \u8cc7\u6599\u8d8a\u591a\u8d8a\u6162<\/td>\n<td>O(log n) \u2014 \u5e7e\u4e4e\u4e0d\u53d7\u8cc7\u6599\u91cf\u5f71\u97ff<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">\u7d22\u5f15\u7684\u4ee3\u50f9<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u7d22\u5f15\u4e0d\u662f\u514d\u8cbb\u7684\u3002\u6bcf\u6b21\u4f60\u65b0\u589e\u3001\u4fee\u6539\u3001\u522a\u9664\u8cc7\u6599\uff0c\u8cc7\u6599\u5eab\u90fd\u8981<strong>\u540c\u6b65\u66f4\u65b0\u7d22\u5f15<\/strong>\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-2\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\">-- \u6bcf\u6b21 INSERT\uff0c\u8cc7\u6599\u5eab\u8981\u505a\u5169\u4ef6\u4e8b\uff1a\n-- <span class=\"hljs-number\">1.<\/span> \u5beb\u5165\u8cc7\u6599\u5230 users \u8868\n-- <span class=\"hljs-number\">2.<\/span> \u66f4\u65b0 idx_users_email \u7d22\u5f15\nINSERT INTO users (name, email) VALUES (<span class=\"hljs-string\">'Bob'<\/span>, <span class=\"hljs-string\">'bob@example.com'<\/span>);\n\n-- \u7d22\u5f15\u8d8a\u591a\uff0c\u5beb\u5165\u8d8a\u6162\n-- \u5982\u679c\u4f60\u5c0d <span class=\"hljs-number\">5<\/span> \u500b\u6b04\u4f4d\u90fd\u5efa\u4e86\u7d22\u5f15\uff0c\u6bcf\u6b21 INSERT \u8981\u66f4\u65b0 <span class=\"hljs-number\">5<\/span> \u500b\u7d22\u5f15\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-2\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>\u767d\u8a71\u7ffb\u8b6f<\/strong>\uff1a\u7d22\u5f15\u5c31\u50cf\u66f8\u7684\u76ee\u9304\u3002\u76ee\u9304\u8b93\u4f60\u67e5\u6771\u897f\u5f88\u5feb\uff0c\u4f46\u6bcf\u6b21\u66f8\u7684\u5167\u5bb9\u6539\u4e86\uff0c\u76ee\u9304\u4e5f\u8981\u8ddf\u8457\u6539\u3002\u76ee\u9304\u8d8a\u591a\uff0c\u6539\u8d77\u4f86\u8d8a\u7d2f\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u4ec0\u9ebc\u6642\u5019\u8a72\u5efa\u7d22\u5f15<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\"><span><code class=\"hljs\">\u5efa\u7d22\u5f15\u7684\u597d\u6642\u6a5f\uff1a\n- WHERE \u5b50\u53e5\u5e38\u7528\u7684\u6b04\u4f4d\uff08\u5982 email\u3001user_id\uff09\n- JOIN \u7684\u6b04\u4f4d\n- ORDER BY \u7684\u6b04\u4f4d\n\n\u4e0d\u9700\u8981\u7d22\u5f15\u7684\u60c5\u6cc1\uff1a\n- \u5f88\u5c11\u67e5\u8a62\u7684\u6b04\u4f4d\n- \u7d93\u5e38\u5927\u91cf INSERT \u7684\u8868\uff08\u7d22\u5f15\u62d6\u6162\u5beb\u5165\uff09\n- \u8cc7\u6599\u91cf\u672c\u8eab\u5c31\u5f88\u5c0f\u7684\u8868\uff08\u5168\u6383\u4e5f\u5f88\u5feb\uff09\n<\/code><\/span><\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">Vibe Coder \u6aa2\u67e5\u9ede<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u770b\u5230\u8cc7\u6599\u5eab\u76f8\u95dc\u7a0b\u5f0f\u78bc\u6642\u78ba\u8a8d\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n\n<li>\u67e5\u8a62\u5f88\u6162\uff1f\u5148\u6aa2\u67e5\u6709\u6c92\u6709\u5c0d WHERE \u689d\u4ef6\u7684\u6b04\u4f4d\u5efa\u7d22\u5f15<\/li>\n\n\n<li>AI \u5e6b\u4f60\u5efa\u4e86\u4e00\u5806\u7d22\u5f15\uff1f\u60f3\u60f3\u90a3\u4e9b\u6b04\u4f4d\u662f\u4e0d\u662f\u771f\u7684\u5e38\u88ab\u67e5<\/li>\n\n\n<li>\u5beb\u5165\u8b8a\u6162\u4e86\uff1f\u6aa2\u67e5\u662f\u4e0d\u662f\u7d22\u5f15\u592a\u591a<\/li>\n\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u6982\u5ff5 16\uff1aReplication\uff08\u8907\u88fd\uff09<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u4e00\u53e5\u8a71\u8aaa\u660e<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u628a\u540c\u4e00\u4efd\u8cc7\u6599\u8907\u88fd\u5230\u591a\u53f0\u4f3a\u670d\u5668\uff0c\u8b80\u53d6\u5206\u6563\u3001\u639b\u4e86\u4e0d\u6015\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u904b\u4f5c\u539f\u7406<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\"><span><code class=\"hljs\">                 \u250c\u2500\u2500\u2500\u2500 Replica 1 \u25c4\u2500\u2500 \u8b80\u53d6\u8acb\u6c42\n                 \u2502     (\u5b8c\u6574\u526f\u672c)\n\u5beb\u5165\u8acb\u6c42 \u2500\u2500\u25ba Primary \u2500\u2500\u2524\n             (\u4e3b\u5eab)    \u2502\n                 \u2514\u2500\u2500\u2500\u2500 Replica 2 \u25c4\u2500\u2500 \u8b80\u53d6\u8acb\u6c42\n                       (\u5b8c\u6574\u526f\u672c)\n<\/code><\/span><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>\u767d\u8a71\u7ffb\u8b6f<\/strong>\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n\n<li><strong>Primary\uff08\u4e3b\u5eab\uff09<\/strong>\uff1a\u552f\u4e00\u8ca0\u8cac\u300c\u5beb\u5165\u300d\u7684\u8cc7\u6599\u5eab<\/li>\n\n\n<li><strong>Replica\uff08\u526f\u672c\uff09<\/strong>\uff1aPrimary \u7684\u5b8c\u6574\u8907\u88fd\u54c1\uff0c\u53ea\u8ca0\u8cac\u300c\u8b80\u53d6\u300d<\/li>\n\n\n<li>\u6240\u6709\u5beb\u5165\u90fd\u9001\u5230 Primary\uff0c\u7136\u5f8c Primary \u628a\u8b8a\u66f4<strong>\u540c\u6b65<\/strong>\u5230\u6240\u6709 Replica<\/li>\n\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\u6700\u5c0f\u7bc4\u4f8b<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u7528\u4e00\u500b Web \u61c9\u7528\u7684\u8a2d\u5b9a\u4f86\u7406\u89e3\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-3\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\"><span class=\"hljs-comment\"># \u865b\u64ec\u78bc\uff1a\u61c9\u7528\u7a0b\u5f0f\u600e\u9ebc\u4f7f\u7528 Replication<\/span>\nDATABASE = {\n    <span class=\"hljs-string\">\"primary\"<\/span>: <span class=\"hljs-string\">\"db-primary.example.com:5432\"<\/span>,    <span class=\"hljs-comment\"># \u5beb\u5165\u7528\u9019\u500b<\/span>\n    <span class=\"hljs-string\">\"replicas\"<\/span>: &#91;\n        <span class=\"hljs-string\">\"db-replica-1.example.com:5432\"<\/span>,          <span class=\"hljs-comment\"># \u8b80\u53d6\u7528\u9019\u4e9b<\/span>\n        <span class=\"hljs-string\">\"db-replica-2.example.com:5432\"<\/span>,\n    ]\n}\n\ndef create_user(name, email):\n    <span class=\"hljs-comment\"># \u5beb\u5165 \u2192 \u9001\u5230 Primary<\/span>\n    primary_db.execute(<span class=\"hljs-string\">\"INSERT INTO users ...\"<\/span>)\n\ndef get_user(user_id):\n    <span class=\"hljs-comment\"># \u8b80\u53d6 \u2192 \u9001\u5230\u4efb\u4e00 Replica\uff08\u5206\u6563\u8ca0\u8f09\uff09<\/span>\n    replica = random.choice(replicas)\n    <span class=\"hljs-keyword\">return<\/span> replica.execute(<span class=\"hljs-string\">\"SELECT * FROM users WHERE id = ?\"<\/span>, user_id)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-3\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">\u70ba\u4ec0\u9ebc\u8981 Replication<\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>\u597d\u8655<\/th>\n<th>\u8aaa\u660e<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>\u8b80\u53d6\u6548\u80fd\u63d0\u5347<\/td>\n<td>3 \u500b Replica \u5206\u64d4\u8b80\u53d6\uff0c\u7b49\u65bc\u8b80\u53d6\u80fd\u529b x3<\/td>\n<\/tr>\n<tr>\n<td>\u9ad8\u53ef\u7528\u6027<\/td>\n<td>Primary \u639b\u4e86\uff0cReplica \u53ef\u4ee5\u5347\u7d1a\u70ba\u65b0\u7684 Primary<\/td>\n<\/tr>\n<tr>\n<td>\u8cc7\u6599\u5099\u4efd<\/td>\n<td>\u8cc7\u6599\u5b58\u5728\u591a\u53f0\u6a5f\u5668\uff0c\u4e0d\u6015\u786c\u789f\u58de\u6389<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">\u8981\u6ce8\u610f\u7684\u5751\uff1aReplication Lag<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\"><span><code class=\"hljs\">\u6642\u9593\u9ede 1\uff1a\u4f7f\u7528\u8005\u66f4\u65b0\u5927\u982d\u7167\n  \u2192 \u5beb\u5165 Primary \u2713\n\n\u6642\u9593\u9ede 2\uff1a\u4f7f\u7528\u8005\u7acb\u523b\u91cd\u65b0\u6574\u7406\u9801\u9762\n  \u2192 \u8b80\u53d6 Replica... \u9084\u662f\u820a\u7684\u5927\u982d\u7167\uff01\n  \u2192 \u56e0\u70ba Primary \u7684\u8b8a\u66f4\u9084\u6c92\u540c\u6b65\u5230 Replica\uff08\u5ef6\u9072\u5e7e\u6beb\u79d2\u5230\u5e7e\u79d2\uff09\n\n\u6642\u9593\u9ede 3\uff1a\u5e7e\u79d2\u5f8c\u518d\u91cd\u65b0\u6574\u7406\n  \u2192 Replica \u540c\u6b65\u5b8c\u6210\uff0c\u770b\u5230\u65b0\u7684\u5927\u982d\u7167 \u2713\n<\/code><\/span><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u9019\u5c31\u662f <strong>Eventual Consistency\uff08\u6700\u7d42\u4e00\u81f4\u6027\uff09<\/strong>\uff1a\u8cc7\u6599\u300c\u6700\u7d42\u300d\u6703\u4e00\u81f4\uff0c\u4f46\u4e2d\u9593\u6709\u4e00\u5c0f\u6bb5\u6642\u9593\u53ef\u80fd\u4e0d\u540c\u6b65\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Vibe Coder \u6aa2\u67e5\u9ede<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u770b\u5230\u7cfb\u7d71\u67b6\u69cb\u5716\u51fa\u73fe\u591a\u500b\u8cc7\u6599\u5eab\u6642\u78ba\u8a8d\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n\n<li>\u8b80\u5beb\u662f\u5426\u5206\u96e2\uff1f\u5beb\u5165\u662f\u4e0d\u662f\u90fd\u8d70 Primary\uff1f<\/li>\n\n\n<li>\u6709\u6c92\u6709\u8003\u616e Replication Lag \u9020\u6210\u7684\u8cc7\u6599\u4e0d\u4e00\u81f4\uff1f<\/li>\n\n\n<li>\u4f7f\u7528\u8005\u525b\u5beb\u5165\u5c31\u8981\u8b80\u53d6\u7684\u5834\u666f\uff0c\u662f\u5426\u76f4\u63a5\u8b80 Primary\uff1f<\/li>\n\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u6982\u5ff5 17\uff1aSharding\uff08\u5206\u7247\uff09<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u4e00\u53e5\u8a71\u8aaa\u660e<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u628a\u4e00\u5f35\u8868\u7684\u8cc7\u6599\u300c\u5207\u6210\u597d\u5e7e\u584a\u300d\uff0c\u5206\u6563\u5b58\u5230\u4e0d\u540c\u4f3a\u670d\u5668\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Replication vs. Sharding \u2014 \u4e00\u5f35\u5716\u641e\u61c2<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\"><span><code class=\"hljs\">Replication\uff08\u8907\u88fd\uff09\uff1a\u6bcf\u53f0\u90fd\u6709\u300c\u5168\u90e8\u300d\u8cc7\u6599\n\u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510  \u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510  \u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510\n\u2502 Primary     \u2502  \u2502 Replica 1   \u2502  \u2502 Replica 2   \u2502\n\u2502 \u7528\u6236 1-100\u842c\u2502  \u2502 \u7528\u6236 1-100\u842c\u2502  \u2502 \u7528\u6236 1-100\u842c\u2502\n\u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518  \u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518  \u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518\n\nSharding\uff08\u5206\u7247\uff09\uff1a\u6bcf\u53f0\u53ea\u6709\u300c\u4e00\u90e8\u5206\u300d\u8cc7\u6599\n\u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510  \u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510  \u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510\n\u2502 Shard 1     \u2502  \u2502 Shard 2     \u2502  \u2502 Shard 3     \u2502\n\u2502 \u7528\u6236 1-33\u842c \u2502  \u2502 \u7528\u6236 34-66\u842c\u2502  \u2502 \u7528\u6236 67-100\u842c\u2502\n\u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518  \u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518  \u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518\n<\/code><\/span><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>\u767d\u8a71\u7ffb\u8b6f<\/strong>\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n\n<li>Replication = \u5f71\u5370\u6574\u672c\u66f8\uff0c\u767c\u7d66\u4e09\u500b\u4eba\u5404\u4e00\u672c\uff08\u6bcf\u4eba\u90fd\u6709\u5b8c\u6574\u7684\u66f8\uff09<\/li>\n\n\n<li>Sharding = \u628a\u66f8\u6495\u6210\u4e09\u4efd\uff0c\u4e00\u4eba\u62ff\u4e00\u4efd\uff08\u6bcf\u4eba\u53ea\u6709\u90e8\u5206\u5167\u5bb9\uff09<\/li>\n\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Sharding Key \u600e\u9ebc\u9078<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Sharding \u7684\u6838\u5fc3\u554f\u984c\u662f\uff1a<strong>\u6309\u4ec0\u9ebc\u898f\u5247\u5207\uff1f<\/strong> \u9019\u500b\u898f\u5247\u5c31\u662f Sharding Key\u3002<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\"><span><code class=\"hljs\">Sharding Key = user_id\n\n\u67e5\u8a62 user_id = 42 \u7684\u8cc7\u6599\uff1a\n  \u2192 42 % 3 = 0 \u2192 \u53bb Shard 0 \u627e\n  \u2192 \u53ea\u67e5\u4e00\u53f0\u4f3a\u670d\u5668\uff0c\u901f\u5ea6\u5feb\n\n\u67e5\u8a62 user_id = 100 \u7684\u8cc7\u6599\uff1a\n  \u2192 100 % 3 = 1 \u2192 \u53bb Shard 1 \u627e\n  \u2192 \u540c\u6a23\u53ea\u67e5\u4e00\u53f0\n<\/code><\/span><\/pre><\/div>\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-4\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\"><span class=\"hljs-comment\"># \u865b\u64ec\u78bc\uff1a\u6839\u64da Sharding Key \u6c7a\u5b9a\u53bb\u54ea\u500b Shard<\/span>\ndef get_shard(user_id, total_shards=<span class=\"hljs-number\">3<\/span>):\n    shard_number = user_id % total_shards\n    <span class=\"hljs-keyword\">return<\/span> shards&#91;shard_number]\n\n<span class=\"hljs-comment\"># \u67e5\u8a62\u6642<\/span>\nshard = get_shard(user_id=<span class=\"hljs-number\">42<\/span>)\nuser = shard.execute(<span class=\"hljs-string\">\"SELECT * FROM users WHERE id = 42\"<\/span>)\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-4\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">Sharding \u7684\u6311\u6230<\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>\u6311\u6230<\/th>\n<th>\u8aaa\u660e<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>\u8de8 Shard \u67e5\u8a62<\/td>\n<td>\u300c\u627e\u51fa\u6240\u6709 25 \u6b72\u7684\u7528\u6236\u300d\u2192 \u8981\u67e5\u5168\u90e8 Shard\uff0c\u7136\u5f8c\u5408\u4f75\u7d50\u679c<\/td>\n<\/tr>\n<tr>\n<td>\u8cc7\u6599\u4e0d\u5747\u52fb<\/td>\n<td>\u5982\u679c\u6309\u5730\u5340\u5206\u7247\uff0c\u71b1\u9580\u5730\u5340\u7684 Shard \u58d3\u529b\u5927\uff08Hot Spot\uff09<\/td>\n<\/tr>\n<tr>\n<td>\u91cd\u65b0\u5206\u7247<\/td>\n<td>\u5f9e 3 \u500b Shard \u64f4\u5c55\u5230 5 \u500b\uff0c\u8981\u642c\u79fb\u5927\u91cf\u8cc7\u6599<\/td>\n<\/tr>\n<tr>\n<td>JOIN \u56f0\u96e3<\/td>\n<td>\u5169\u7b46\u9700\u8981 JOIN \u7684\u8cc7\u6599\u53ef\u80fd\u5728\u4e0d\u540c Shard<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Vibe Coder \u6aa2\u67e5\u9ede<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u770b\u5230 Sharding \u76f8\u95dc\u8a2d\u8a08\u6642\u78ba\u8a8d\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n\n<li>Sharding Key \u9078\u5f97\u5408\u7406\u55ce\uff1f\u5927\u591a\u6578\u67e5\u8a62\u90fd\u6703\u5e36\u9019\u500b\u6b04\u4f4d\u55ce\uff1f<\/li>\n\n\n<li>\u6709\u6c92\u6709\u8de8 Shard \u67e5\u8a62\u7684\u9700\u6c42\uff1f\u5982\u679c\u6709\uff0c\u6548\u80fd\u53ef\u80fd\u5f88\u5dee<\/li>\n\n\n<li>\u8cc7\u6599\u5206\u5e03\u5747\u52fb\u55ce\uff1f\u6703\u4e0d\u6703\u67d0\u500b Shard \u7279\u5225\u5fd9\uff1f<\/li>\n\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u6982\u5ff5 18\uff1aVertical Partitioning\uff08\u5782\u76f4\u5206\u5272\uff09<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u4e00\u53e5\u8a71\u8aaa\u660e<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u6309\u300c\u6b04\u4f4d\u300d\u628a\u4e00\u5f35\u5927\u8868\u62c6\u6210\u597d\u5e7e\u5f35\u5c0f\u8868\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u6700\u5c0f\u7bc4\u4f8b<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-5\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\">-- \u539f\u672c\uff1a\u4e00\u5f35\u4ec0\u9ebc\u90fd\u653e\u7684\u5927\u8868\nCREATE TABLE users (\n    id INT,\n    name VARCHAR(<span class=\"hljs-number\">100<\/span>),       -- \u6bcf\u6b21\u767b\u5165\u90fd\u8981\u8b80\n    email VARCHAR(<span class=\"hljs-number\">200<\/span>),      -- \u6bcf\u6b21\u767b\u5165\u90fd\u8981\u8b80\n    avatar BLOB,             -- \u5f88\u5927\uff0c\u4f46\u4e0d\u5e38\u8b80\n    bio TEXT,                -- \u500b\u4eba\u4ecb\u7d39\uff0c\u5076\u723e\u8b80\n    preferences <span class=\"hljs-built_in\">JSON<\/span>,        -- \u8a2d\u5b9a\u504f\u597d\uff0c\u5f88\u5c11\u8b80\n    created_at TIMESTAMP     -- \u6bcf\u6b21\u767b\u5165\u90fd\u8981\u8b80\n);\n\n-- \u5782\u76f4\u5206\u5272\u5f8c\uff1a\u6309\u8b80\u53d6\u983b\u7387\u62c6\u6210\u5169\u5f35\u8868\nCREATE TABLE users_core (        -- \u5e38\u8b80\u7684\u6b04\u4f4d\n    id INT,\n    name VARCHAR(<span class=\"hljs-number\">100<\/span>),\n    email VARCHAR(<span class=\"hljs-number\">200<\/span>),\n    created_at TIMESTAMP\n);\n\nCREATE TABLE users_profile (     -- \u4e0d\u5e38\u8b80\u7684\u6b04\u4f4d\n    user_id INT,\n    avatar BLOB,\n    bio TEXT,\n    preferences <span class=\"hljs-built_in\">JSON<\/span>\n);\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-5\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">\u70ba\u4ec0\u9ebc\u8981\u9019\u6a23\u62c6<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\"><span><code class=\"hljs\">\u67e5\u8a62\u300c\u7528\u6236\u767b\u5165\u8cc7\u8a0a\u300d\uff1a\n\n\u62c6\u4e4b\u524d\uff1aSELECT * FROM users WHERE id = 42\n\u2192 \u8b80\u51fa name, email, avatar(2MB), bio, preferences, created_at\n\u2192 avatar \u5f88\u5927\u4f46\u6839\u672c\u7528\u4e0d\u5230\uff0c\u6d6a\u8cbb I\/O\n\n\u62c6\u4e4b\u5f8c\uff1aSELECT * FROM users_core WHERE id = 42\n\u2192 \u53ea\u8b80 name, email, created_at\n\u2192 \u8cc7\u6599\u91cf\u5c0f\uff0c\u67e5\u8a62\u5feb\n<\/code><\/span><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>\u767d\u8a71\u7ffb\u8b6f<\/strong>\uff1a\u5c31\u50cf\u628a\u8863\u6ac3\u5206\u6210\u300c\u6bcf\u5929\u7a7f\u7684\u300d\u548c\u300c\u5076\u723e\u7a7f\u7684\u300d\u5169\u500b\u5340\u57df\u3002\u6bcf\u5929\u65e9\u4e0a\u53ea\u7ffb\u5e38\u7a7f\u5340\uff0c\u4e0d\u7528\u628a\u6574\u500b\u8863\u6ac3\u7ffb\u4e00\u904d\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Vertical vs. Horizontal Partitioning<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-6\" data-shcb-language-name=\"CSS\" data-shcb-language-slug=\"css\"><span><code class=\"hljs language-css\">\u539f\u59cb\u8868\uff1a\n\u250c\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510\n\u2502 <span class=\"hljs-selector-tag\">id<\/span> \u2502 <span class=\"hljs-selector-tag\">name<\/span>  \u2502 <span class=\"hljs-selector-tag\">email<\/span> \u2502 <span class=\"hljs-selector-tag\">avatar<\/span>   \u2502\n\u251c\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2524\n\u2502  1 \u2502 <span class=\"hljs-selector-tag\">Alice<\/span> \u2502 <span class=\"hljs-selector-tag\">a<\/span>@... \u2502 &#91;<span class=\"hljs-number\">2<\/span>MB]    \u2502\n\u2502  <span class=\"hljs-number\">2<\/span> \u2502 Bob   \u2502 b@... \u2502 &#91;<span class=\"hljs-number\">1.5<\/span>MB]  \u2502\n\u2502  <span class=\"hljs-number\">3<\/span> \u2502 Carol \u2502 c@... \u2502 &#91;<span class=\"hljs-number\">3<\/span>MB]    \u2502\n\u2514\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518\n\nVertical\uff08\u5782\u76f4\uff09\uff1a\u6309\u6b04\u4f4d\u5207\n\u8868<span class=\"hljs-attribute\">A:<\/span> id, name, email     \u8868<span class=\"hljs-attribute\">B:<\/span> id, avatar\n\u250c\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510   \u250c\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510\n\u2502  <span class=\"hljs-number\">1<\/span> \u2502 Alice \u2502 a@... \u2502   \u2502  <span class=\"hljs-number\">1<\/span> \u2502 &#91;<span class=\"hljs-number\">2<\/span>MB]    \u2502\n\u2502  <span class=\"hljs-number\">2<\/span> \u2502 Bob   \u2502 b@... \u2502   \u2502  <span class=\"hljs-number\">2<\/span> \u2502 &#91;<span class=\"hljs-number\">1.5<\/span>MB]  \u2502\n\u2502  <span class=\"hljs-number\">3<\/span> \u2502 Carol \u2502 c@... \u2502   \u2502  <span class=\"hljs-number\">3<\/span> \u2502 &#91;<span class=\"hljs-number\">3<\/span>MB]    \u2502\n\u2514\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518   \u2514\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518\n\nHorizontal\uff08\u6c34\u5e73\uff09= Sharding\uff1a\u6309\u5217\u5207\nShard <span class=\"hljs-attribute\">A:<\/span> id <span class=\"hljs-number\">1<\/span>-<span class=\"hljs-number\">2<\/span>          Shard <span class=\"hljs-attribute\">B:<\/span> id <span class=\"hljs-number\">3<\/span>\n\u250c\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510   \u250c\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510\n\u2502  <span class=\"hljs-number\">1<\/span> \u2502 Alice \u2502 a@... \u2502   \u2502  <span class=\"hljs-number\">3<\/span> \u2502 Carol \u2502 c@... \u2502\n\u2502  <span class=\"hljs-number\">2<\/span> \u2502 Bob   \u2502 b@... \u2502   \u2514\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518\n\u2514\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-6\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">CSS<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">css<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">Vibe Coder \u6aa2\u67e5\u9ede<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u770b\u5230\u8cc7\u6599\u8868\u8a2d\u8a08\u6642\u78ba\u8a8d\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n\n<li>\u9019\u5f35\u8868\u662f\u4e0d\u662f\u585e\u4e86\u592a\u591a\u6b04\u4f4d\uff1f\u6709\u4e9b\u6b04\u4f4d\u5f88\u5c11\u4e00\u8d77\u7528\uff1f<\/li>\n\n\n<li>\u6709\u6c92\u6709\u5f88\u5927\u7684\u6b04\u4f4d\uff08BLOB\u3001TEXT\uff09\u62d6\u6162\u5e38\u898f\u67e5\u8a62\uff1f<\/li>\n\n\n<li>\u62c6\u8868\u5f8c JOIN \u7684\u6210\u672c\u53ef\u4ee5\u63a5\u53d7\u55ce\uff1f<\/li>\n\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u6982\u5ff5 19\uff1aCaching\uff08\u5feb\u53d6\uff09<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u4e00\u53e5\u8a71\u8aaa\u660e<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u628a\u5e38\u7528\u8cc7\u6599\u5b58\u5728\u8a18\u61b6\u9ad4\u88e1\uff0c\u4e0b\u6b21\u76f4\u63a5\u62ff\uff0c\u4e0d\u7528\u518d\u67e5\u8cc7\u6599\u5eab\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u70ba\u4ec0\u9ebc\u5feb\u53d6\u9019\u9ebc\u91cd\u8981<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\"><span><code class=\"hljs\">\u8b80\u53d6\u901f\u5ea6\u6bd4\u8f03\uff1a\n  \u8a18\u61b6\u9ad4\uff08RAM\uff09\u8b80\u53d6  \u2248 0.1 \u6beb\u79d2\n  SSD \u78c1\u789f\u8b80\u53d6      \u2248 0.1 \u6beb\u79d2\uff08\u96a8\u6a5f\u8b80\u53d6\u53ef\u9054\u6578\u6beb\u79d2\uff09\n  \u8cc7\u6599\u5eab\u67e5\u8a62\uff08\u542b\u7db2\u8def\uff09\u2248 1-10 \u6beb\u79d2\n  \u8de8\u6a5f\u623f\u7db2\u8def\u8acb\u6c42     \u2248 50-150 \u6beb\u79d2\n\n\u5feb\u53d6\u547d\u4e2d = \u7701\u4e0b\u8cc7\u6599\u5eab\u67e5\u8a62\u7684\u6642\u9593\n<\/code><\/span><\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">\u6700\u5c0f\u7bc4\u4f8b\uff1aCache-Aside \u6a21\u5f0f<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u9019\u662f\u6700\u5e38\u898b\u7684\u5feb\u53d6\u7b56\u7565\uff0c\u4e5f\u53eb Lazy Loading\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-7\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">import redis\n\ncache = redis.Redis(host=<span class=\"hljs-string\">'localhost'<\/span>, port=<span class=\"hljs-number\">6379<\/span>)\n\ndef get_user(user_id):\n    <span class=\"hljs-comment\"># \u7b2c\u4e00\u6b65\uff1a\u5148\u53bb\u5feb\u53d6\u627e<\/span>\n    cached = cache.get(f<span class=\"hljs-string\">\"user:{user_id}\"<\/span>)\n    <span class=\"hljs-keyword\">if<\/span> cached:\n        <span class=\"hljs-keyword\">return<\/span> json.loads(cached)     <span class=\"hljs-comment\"># \u5feb\u53d6\u547d\u4e2d\uff01\u76f4\u63a5\u56de\u50b3<\/span>\n\n    <span class=\"hljs-comment\"># \u7b2c\u4e8c\u6b65\uff1a\u5feb\u53d6\u6c92\u6709\uff0c\u53bb\u8cc7\u6599\u5eab\u67e5<\/span>\n    user = db.query(<span class=\"hljs-string\">\"SELECT * FROM users WHERE id = ?\"<\/span>, user_id)\n\n    <span class=\"hljs-comment\"># \u7b2c\u4e09\u6b65\uff1a\u67e5\u5230\u5f8c\u5b58\u9032\u5feb\u53d6\uff0c\u4e0b\u6b21\u5c31\u4e0d\u7528\u518d\u67e5\u8cc7\u6599\u5eab<\/span>\n    cache.set(f<span class=\"hljs-string\">\"user:{user_id}\"<\/span>, json.dumps(user), ex=<span class=\"hljs-number\">300<\/span>)  <span class=\"hljs-comment\"># ex=300 \u8868\u793a 300 \u79d2\u5f8c\u904e\u671f<\/span>\n\n    <span class=\"hljs-keyword\">return<\/span> user\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-7\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>\u767d\u8a71\u7ffb\u8b6f<\/strong>\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\"><span><code class=\"hljs\">\u8981\u627e\u67d0\u7b46\u8cc7\u6599\uff1f\n  \u2192 \u5148\u7ffb\u5feb\u53d6\uff08\u8a18\u61b6\u9ad4\uff09\n    \u2192 \u6709\u627e\u5230\uff08Cache Hit\uff09\u2192 \u76f4\u63a5\u56de\u50b3\uff0c\u8d85\u5feb\n    \u2192 \u6c92\u627e\u5230\uff08Cache Miss\uff09\u2192 \u53bb\u8cc7\u6599\u5eab\u67e5\uff0c\u67e5\u5230\u5f8c\u9806\u4fbf\u5b58\u9032\u5feb\u53d6\n<\/code><\/span><\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">\u4e09\u7a2e\u5e38\u898b\u5feb\u53d6\u7b56\u7565<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\"><span><code class=\"hljs\">1. Cache-Aside\uff08\u65c1\u8def\u5feb\u53d6\uff09\n   \u8b80\uff1a\u5148\u67e5\u5feb\u53d6 \u2192 \u6c92\u6709\u5c31\u67e5 DB \u2192 \u5b58\u9032\u5feb\u53d6\n   \u5beb\uff1a\u76f4\u63a5\u5beb DB \u2192 \u522a\u6389\u5feb\u53d6\uff08\u4e0b\u6b21\u8b80\u6642\u6703\u91cd\u65b0\u8f09\u5165\uff09\n   \u7279\u9ede\uff1a\u6700\u5e38\u898b\uff0c\u61c9\u7528\u7a0b\u5f0f\u81ea\u5df1\u7ba1\u5feb\u53d6\n\n2. Write-Through\uff08\u7a7f\u900f\u5beb\u5165\uff09\n   \u8b80\uff1a\u5148\u67e5\u5feb\u53d6 \u2192 \u6c92\u6709\u5c31\u67e5 DB \u2192 \u5b58\u9032\u5feb\u53d6\n   \u5beb\uff1a\u540c\u6642\u5beb DB \u548c\u5feb\u53d6\n   \u7279\u9ede\uff1a\u5feb\u53d6\u6c38\u9060\u662f\u6700\u65b0\u7684\uff0c\u4f46\u5beb\u5165\u8f03\u6162\n\n3. Write-Behind\uff08\u80cc\u5f8c\u5beb\u5165\uff09\n   \u8b80\uff1a\u5148\u67e5\u5feb\u53d6\n   \u5beb\uff1a\u53ea\u5beb\u5feb\u53d6 \u2192 \u904e\u4e00\u6bb5\u6642\u9593\u518d\u6279\u6b21\u5beb\u5165 DB\n   \u7279\u9ede\uff1a\u5beb\u5165\u8d85\u5feb\uff0c\u4f46\u5982\u679c\u5feb\u53d6\u639b\u4e86\u53ef\u80fd\u4e1f\u8cc7\u6599\n<\/code><\/span><\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">\u5feb\u53d6\u5931\u6548 \u2014 \u96fb\u8166\u79d1\u5b78\u7684\u5169\u5927\u96e3\u984c\u4e4b\u4e00<\/h3>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\">&#8220;There are only two hard things in Computer Science: cache invalidation and naming things.&#8221;<br>\u2014 Phil Karlton<\/p>\n<\/blockquote>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\" aria-describedby=\"shcb-language-8\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\">\u554f\u984c\u5834\u666f\uff1a\n\n<span class=\"hljs-number\">1.<\/span> \u7528\u6236 A \u7684\u8cc7\u6599\u5b58\u5728\u5feb\u53d6\u4e2d\uff08name = <span class=\"hljs-string\">\"Alice\"<\/span>\uff09\n<span class=\"hljs-number\">2.<\/span> \u7528\u6236 A \u6539\u4e86\u540d\u5b57\uff08name = <span class=\"hljs-string\">\"Alicia\"<\/span>\uff09\u2192 \u8cc7\u6599\u5eab\u66f4\u65b0\u4e86\n<span class=\"hljs-number\">3.<\/span> \u4f46\u5feb\u53d6\u88e1\u9084\u662f\u820a\u7684 <span class=\"hljs-string\">\"Alice\"<\/span>\n<span class=\"hljs-number\">4.<\/span> \u5176\u4ed6\u4eba\u67e5\u7528\u6236 A \u2192 \u62ff\u5230\u5feb\u53d6\u88e1\u7684\u820a\u8cc7\u6599 <span class=\"hljs-string\">\"Alice\"<\/span> \u274c\n\n\u5e38\u898b\u89e3\u6cd5\uff1a\n- TTL\uff08Time To Live\uff09\uff1a\u8a2d\u904e\u671f\u6642\u9593\uff0c\u5230\u671f\u81ea\u52d5\u6e05\u9664\n- \u4e3b\u52d5\u5931\u6548\uff1a\u8cc7\u6599\u66f4\u65b0\u6642\uff0c\u9806\u4fbf\u522a\u6389\u5c0d\u61c9\u7684\u5feb\u53d6\n- \u7248\u672c\u865f\uff1a\u5feb\u53d6 key \u5e36\u7248\u672c\u865f\uff0c\u66f4\u65b0\u6642\u7248\u672c +<span class=\"hljs-number\">1<\/span>\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-8\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">Vibe Coder \u6aa2\u67e5\u9ede<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u770b\u5230\u5feb\u53d6\u76f8\u95dc\u7a0b\u5f0f\u78bc\u6642\u78ba\u8a8d\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n\n<li>\u6709\u8a2d TTL\uff08\u904e\u671f\u6642\u9593\uff09\u55ce\uff1f\u6c92\u6709\u7684\u8a71\u5feb\u53d6\u6703\u6c38\u9060\u4e0d\u66f4\u65b0<\/li>\n\n\n<li>\u8cc7\u6599\u66f4\u65b0\u6642\u6709\u6c92\u6709\u6e05\u9664\u5feb\u53d6\uff1f\uff08\u5426\u5247\u6703\u8b80\u5230\u820a\u8cc7\u6599\uff09<\/li>\n\n\n<li>\u5feb\u53d6\u639b\u4e86\u7684\u6642\u5019\uff0c\u7cfb\u7d71\u9084\u80fd\u904b\u4f5c\u55ce\uff1f\uff08\u5feb\u53d6\u61c9\u8a72\u662f\u52a0\u901f\u7528\u7684\uff0c\u4e0d\u662f\u5fc5\u9700\u54c1\uff09<\/li>\n\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u6982\u5ff5 20\uff1aDenormalization\uff08\u53cd\u6b63\u898f\u5316\uff09<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u4e00\u53e5\u8a71\u8aaa\u660e<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u523b\u610f\u5728\u8cc7\u6599\u8868\u4e2d\u5b58\u91cd\u8907\u8cc7\u6599\uff0c\u7528\u7a7a\u9593\u63db\u6642\u9593\uff0c\u907f\u514d JOIN\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u6700\u5c0f\u7bc4\u4f8b<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\"><span><code class=\"hljs\">-- \u6b63\u898f\u5316\u8a2d\u8a08\uff08\u6559\u79d1\u66f8\u5beb\u6cd5\uff09\uff1a\u8cc7\u6599\u4e0d\u91cd\u8907\uff0c\u7528 JOIN \u53d6\u5f97\n-- orders \u8868\n| order_id | user_id | product_id | quantity |\n|----------|---------|------------|----------|\n| 1        | 42      | 101        | 2        |\n\n-- users \u8868\n| user_id | name  |\n|---------|-------|\n| 42      | Alice |\n\n-- products \u8868\n| product_id | name    | price |\n|------------|---------|-------|\n| 101        | T-Shirt | 500   |\n\n-- \u67e5\u8a62\u8a02\u55ae\u8a73\u60c5\u8981 JOIN \u4e09\u5f35\u8868\nSELECT o.order_id, u.name, p.name, p.price, o.quantity\nFROM orders o\nJOIN users u ON o.user_id = u.user_id\nJOIN products p ON o.product_id = p.product_id;\n<\/code><\/span><\/pre><\/div>\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\"><span><code class=\"hljs\">-- \u53cd\u6b63\u898f\u5316\u8a2d\u8a08\uff1a\u8cc7\u6599\u6709\u91cd\u8907\uff0c\u4f46\u4e0d\u9700\u8981 JOIN\n-- orders_denormalized \u8868\n| order_id | user_id | user_name | product_id | product_name | price | quantity |\n|----------|---------|-----------|------------|--------------|-------|----------|\n| 1        | 42      | Alice     | 101        | T-Shirt      | 500   | 2        |\n\n-- \u67e5\u8a62\u8a02\u55ae\u8a73\u60c5\uff0c\u4e00\u5f35\u8868\u641e\u5b9a\nSELECT order_id, user_name, product_name, price, quantity\nFROM orders_denormalized\nWHERE order_id = 1;\n<\/code><\/span><\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">\u6b63\u898f\u5316 vs. \u53cd\u6b63\u898f\u5316<\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>\u6bd4\u8f03<\/th>\n<th>\u6b63\u898f\u5316\uff08Normalization\uff09<\/th>\n<th>\u53cd\u6b63\u898f\u5316\uff08Denormalization\uff09<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>\u8cc7\u6599\u91cd\u8907<\/td>\n<td>\u7121\u91cd\u8907<\/td>\n<td>\u6709\u523b\u610f\u7684\u91cd\u8907<\/td>\n<\/tr>\n<tr>\n<td>\u8b80\u53d6\u901f\u5ea6<\/td>\n<td>\u6162\uff08\u8981 JOIN\uff09<\/td>\n<td>\u5feb\uff08\u4e00\u5f35\u8868\u641e\u5b9a\uff09<\/td>\n<\/tr>\n<tr>\n<td>\u5beb\u5165\u901f\u5ea6<\/td>\n<td>\u5feb\uff08\u53ea\u6539\u4e00\u8655\uff09<\/td>\n<td>\u6162\uff08\u591a\u8655\u90fd\u8981\u6539\uff09<\/td>\n<\/tr>\n<tr>\n<td>\u5132\u5b58\u7a7a\u9593<\/td>\n<td>\u7701<\/td>\n<td>\u8cbb<\/td>\n<\/tr>\n<tr>\n<td>\u8cc7\u6599\u4e00\u81f4\u6027<\/td>\n<td>\u5bb9\u6613\u7dad\u6301<\/td>\n<td>\u8981\u5c0f\u5fc3\u7dad\u8b77<\/td>\n<\/tr>\n<tr>\n<td>\u9069\u7528\u5834\u666f<\/td>\n<td>\u5beb\u591a\u8b80\u5c11<\/td>\n<td>\u8b80\u591a\u5beb\u5c11<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">\u4ec0\u9ebc\u6642\u5019\u7528\u53cd\u6b63\u898f\u5316<\/h3>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\"><span><code class=\"hljs\">\u9069\u5408\u53cd\u6b63\u898f\u5316\u7684\u5834\u666f\uff1a\n- \u96fb\u5546\u7684\u8a02\u55ae\u7d00\u9304\uff08\u5efa\u7acb\u5f8c\u5e7e\u4e4e\u4e0d\u6539\uff0c\u4f46\u5e38\u5e38\u88ab\u67e5\u8a62\uff09\n- \u793e\u7fa4\u5a92\u9ad4\u7684\u8cbc\u6587\uff08\u8b80\u53d6\u91cf\u9060\u5927\u65bc\u5beb\u5165\u91cf\uff09\n- \u5831\u8868\u7cfb\u7d71\uff08\u53ea\u8b80\uff0c\u4e0d\u5beb\uff09\n\n\u4e0d\u9069\u5408\u7684\u5834\u666f\uff1a\n- \u7d93\u5e38\u8b8a\u52d5\u7684\u8cc7\u6599\uff08\u5982\u7528\u6236\u5373\u6642\u72c0\u614b\uff09\n- \u9700\u8981\u56b4\u683c\u4e00\u81f4\u6027\u7684\u7cfb\u7d71\uff08\u5982\u9280\u884c\u5e33\u6236\uff09\n<\/code><\/span><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>\u767d\u8a71\u7ffb\u8b6f<\/strong>\uff1a\u6b63\u898f\u5316\u5c31\u50cf\u628a\u8cc7\u6599\u6574\u7406\u5f97\u4e95\u7136\u6709\u5e8f\uff0c\u6bcf\u6a23\u6771\u897f\u53ea\u653e\u4e00\u500b\u5730\u65b9\u3002\u53cd\u6b63\u898f\u5316\u5c31\u50cf\u5728\u6bcf\u500b\u623f\u9593\u90fd\u653e\u4e00\u628a\u526a\u5200 \u2014 \u96d6\u7136\u6d6a\u8cbb\u526a\u5200\uff0c\u4f46\u4f60\u518d\u4e5f\u4e0d\u7528\u8dd1\u4f86\u8dd1\u53bb\u627e\u4e86\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Vibe Coder \u6aa2\u67e5\u9ede<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u770b\u5230\u8cc7\u6599\u8868\u8a2d\u8a08\u6642\u78ba\u8a8d\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n\n<li>\u5982\u679c\u8b80\u53d6\u9060\u591a\u65bc\u5beb\u5165\uff0c\u6709\u6c92\u6709\u8003\u616e\u53cd\u6b63\u898f\u5316\u4f86\u6e1b\u5c11 JOIN\uff1f<\/li>\n\n\n<li>\u53cd\u6b63\u898f\u5316\u7684\u8cc7\u6599\uff0c\u66f4\u65b0\u6642\u6709\u6c92\u6709\u540c\u6b65\u6240\u6709\u526f\u672c\uff1f<\/li>\n\n\n<li>\u91cd\u8907\u7684\u8cc7\u6599\u91cf\u5927\u55ce\uff1f\u5132\u5b58\u6210\u672c\u80fd\u63a5\u53d7\u55ce\uff1f<\/li>\n\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u516d\u500b\u6982\u5ff5\u7684\u95dc\u4fc2 \u2014 \u5168\u5c40\u89c0<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u9019\u516d\u500b\u6982\u5ff5\u4e0d\u662f\u4e92\u65a5\u7684\uff0c\u5b83\u5011\u7d93\u5e38<strong>\u4e00\u8d77\u4f7f\u7528<\/strong>\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\"><span><code class=\"hljs\">\u4e00\u500b\u5178\u578b\u7684\u9ad8\u6d41\u91cf\u7cfb\u7d71\u53ef\u80fd\u540c\u6642\u7528\u5230\uff1a\n\n                    \u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510\n  \u7528\u6236\u8acb\u6c42 \u2500\u2500\u2500\u2500\u2500\u2500\u25ba  \u2502   \u5feb\u53d6\u5c64     \u2502  \u2190 Concept 19: Caching\n                    \u2502  (Redis)    \u2502     \u5148\u67e5\u5feb\u53d6\uff0c\u547d\u4e2d\u5c31\u56de\n                    \u2514\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2518\n                           \u2502 Cache Miss\n                    \u250c\u2500\u2500\u2500\u2500\u2500\u2500\u25bc\u2500\u2500\u2500\u2500\u2500\u2500\u2510\n                    \u2502   \u8b80\u53d6\u526f\u672c   \u2502  \u2190 Concept 16: Replication\n                    \u2502  (Replica)  \u2502     \u8b80\u53d6\u8d70\u526f\u672c\uff0c\u5206\u6563\u58d3\u529b\n                    \u2514\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2518\n                           \u2502\n              \u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510\n              \u2502            \u2502            \u2502\n       \u250c\u2500\u2500\u2500\u2500\u2500\u2500\u25bc\u2500\u2500\u2510  \u250c\u2500\u2500\u2500\u2500\u2500\u2500\u25bc\u2500\u2500\u2510  \u250c\u2500\u2500\u2500\u2500\u2500\u2500\u25bc\u2500\u2500\u2510\n       \u2502 Shard 1 \u2502  \u2502 Shard 2 \u2502  \u2502 Shard 3 \u2502  \u2190 Concept 17: Sharding\n       \u2502\u7528\u62361-33\u842c\u2502  \u2502\u7528\u623634-66\u842c\u2502 \u2502\u7528\u623667-100\u842c\u2502  \u8cc7\u6599\u5206\u6563\u5230\u591a\u500b\u5206\u7247\n       \u2514\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2518  \u2514\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2518  \u2514\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2518\n            \u2502            \u2502            \u2502\n         \u7d22\u5f15\u52a0\u901f       \u7d22\u5f15\u52a0\u901f      \u7d22\u5f15\u52a0\u901f     \u2190 Concept 15: Indexing\n                                                    \u6bcf\u500b\u5206\u7247\u5167\u7528\u7d22\u5f15\u52a0\u901f\n<\/code><\/span><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u540c\u6642\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n\n<li>\u6bcf\u5f35\u8868\u6309\u6b04\u4f4d\u505a\u4e86 <strong>Vertical Partitioning<\/strong>\uff08\u6982\u5ff5 18\uff09\uff0c\u5e38\u7528\u6b04\u4f4d\u548c\u4e0d\u5e38\u7528\u6b04\u4f4d\u5206\u958b<\/li>\n\n\n<li>\u8b80\u591a\u5beb\u5c11\u7684\u8868\u505a\u4e86 <strong>Denormalization<\/strong>\uff08\u6982\u5ff5 20\uff09\uff0c\u6e1b\u5c11 JOIN<\/li>\n\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\u6c7a\u7b56\u9806\u5e8f<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u9047\u5230\u8cc7\u6599\u5eab\u6548\u80fd\u554f\u984c\u6642\uff0c\u901a\u5e38\u6309\u9019\u500b\u9806\u5e8f\u8655\u7406\uff1a<\/p>\n\n\n<div class=\"cbc-code-wrapper\"><div class=\"cbc-code-bar\"><button class=\"cbc-copy-button\">Copy<\/button><\/div><pre class=\"wp-block-code\"><span><code class=\"hljs\">1. \u5148\u52a0\u7d22\u5f15\uff08Indexing\uff09           \u2190 \u6210\u672c\u6700\u4f4e\uff0c\u6548\u679c\u6700\u660e\u986f\n2. \u52a0\u5feb\u53d6\uff08Caching\uff09              \u2190 \u6e1b\u5c11\u8cc7\u6599\u5eab\u58d3\u529b\n3. \u8b80\u5beb\u5206\u96e2\uff08Replication\uff09         \u2190 \u5206\u6563\u8b80\u53d6\u58d3\u529b\n4. \u5782\u76f4\u5206\u5272 \/ \u53cd\u6b63\u898f\u5316            \u2190 \u512a\u5316\u8cc7\u6599\u7d50\u69cb\n5. \u6700\u5f8c\u624d\u8003\u616e\u5206\u7247\uff08Sharding\uff09      \u2190 \u6210\u672c\u6700\u9ad8\uff0c\u8907\u96dc\u5ea6\u6700\u5927\n<\/code><\/span><\/pre><\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u91cd\u9ede\u6574\u7406<\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>\u6982\u5ff5<\/th>\n<th>\u4e00\u53e5\u8a71<\/th>\n<th>\u89e3\u6c7a\u4ec0\u9ebc\u554f\u984c<\/th>\n<th>\u4ee3\u50f9<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><strong>Indexing<\/strong><\/td>\n<td>\u8cc7\u6599\u5eab\u7684\u76ee\u9304<\/td>\n<td>\u67e5\u8a62\u592a\u6162<\/td>\n<td>\u5beb\u5165\u8b8a\u6162\u3001\u4f54\u7a7a\u9593<\/td>\n<\/tr>\n<tr>\n<td><strong>Replication<\/strong><\/td>\n<td>\u8907\u88fd\u6574\u500b\u8cc7\u6599\u5eab<\/td>\n<td>\u8b80\u53d6\u58d3\u529b\u5927\u3001\u8981\u9ad8\u53ef\u7528<\/td>\n<td>Replication Lag<\/td>\n<\/tr>\n<tr>\n<td><strong>Sharding<\/strong><\/td>\n<td>\u5207\u5272\u8cc7\u6599\u5206\u6563\u5b58<\/td>\n<td>\u55ae\u53f0\u5b58\u4e0d\u4e0b\u3001\u55ae\u53f0\u625b\u4e0d\u4f4f<\/td>\n<td>\u8de8 Shard \u67e5\u8a62\u56f0\u96e3<\/td>\n<\/tr>\n<tr>\n<td><strong>Vertical Partitioning<\/strong><\/td>\n<td>\u6309\u6b04\u4f4d\u62c6\u8868<\/td>\n<td>\u6b04\u4f4d\u592a\u591a\u62d6\u6162\u67e5\u8a62<\/td>\n<td>JOIN \u6210\u672c\u589e\u52a0<\/td>\n<\/tr>\n<tr>\n<td><strong>Caching<\/strong><\/td>\n<td>\u5b58\u8a18\u61b6\u9ad4\u52a0\u901f\u8b80\u53d6<\/td>\n<td>\u8cc7\u6599\u5eab\u88ab\u8b80\u7206<\/td>\n<td>\u5feb\u53d6\u5931\u6548\u554f\u984c<\/td>\n<\/tr>\n<tr>\n<td><strong>Denormalization<\/strong><\/td>\n<td>\u5b58\u91cd\u8907\u8cc7\u6599\u514d JOIN<\/td>\n<td>JOIN \u592a\u591a\u592a\u6162<\/td>\n<td>\u5beb\u5165\u8981\u540c\u6b65\u591a\u8655<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Vibe Coder \u7e3d\u6aa2\u67e5\u9ede<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u7576\u4f60\u5728 AI \u751f\u6210\u7684\u7a0b\u5f0f\u78bc\u6216\u67b6\u69cb\u5716\u4e2d\u770b\u5230\u9019\u4e9b\u6982\u5ff5\u6642\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n\n<li>[ ] <strong>\u7d22\u5f15<\/strong>\uff1a\u662f\u6839\u64da\u5be6\u969b\u67e5\u8a62\u6a21\u5f0f\u5efa\u7684\uff0c\u4e0d\u662f\u96a8\u4fbf\u52a0\u7684\u55ce\uff1f<\/li>\n\n\n<li>[ ] <strong>\u8907\u88fd<\/strong>\uff1a\u8b80\u5beb\u6709\u5206\u96e2\u55ce\uff1f\u6709\u8003\u616e Lag \u55ce\uff1f<\/li>\n\n\n<li>[ ] <strong>\u5206\u7247<\/strong>\uff1aSharding Key \u9078\u5f97\u5408\u7406\u55ce\uff1f\u5927\u591a\u6578\u67e5\u8a62\u90fd\u5e36\u9019\u500b Key \u55ce\uff1f<\/li>\n\n\n<li>[ ] <strong>\u5feb\u53d6<\/strong>\uff1a\u6709\u8a2d\u904e\u671f\u6642\u9593\u55ce\uff1f\u8cc7\u6599\u66f4\u65b0\u6642\u6703\u6e05\u5feb\u53d6\u55ce\uff1f<\/li>\n\n\n<li>[ ] <strong>\u53cd\u6b63\u898f\u5316<\/strong>\uff1a\u91cd\u8907\u7684\u8cc7\u6599\u6709\u540c\u6b65\u66f4\u65b0\u6a5f\u5236\u55ce\uff1f<\/li>\n\n\n<li>[ ] <strong>\u6574\u9ad4<\/strong>\uff1a\u662f\u5426\u6309\u300c\u7d22\u5f15 \u2192 \u5feb\u53d6 \u2192 \u8907\u88fd \u2192 \u5206\u7247\u300d\u7684\u9806\u5e8f\u8655\u7406\uff1f\u5225\u4e00\u958b\u59cb\u5c31\u4e0a Sharding<\/li>\n\n<\/ul>\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\">**\u4e0b\u4e00\u7bc7\u9810\u544a**\uff1a#05 \u5206\u6563\u5f0f\u7cfb\u7d71\u6838\u5fc3\u6311\u6230 \u2014 \u6211\u5011\u6703\u9032\u5165 CAP \u5b9a\u7406\u3001\u4e00\u81f4\u6027\u6a21\u578b\u3001\u5206\u6563\u5f0f\u4ea4\u6613\u7b49\u300c\u5206\u6563\u5f0f\u7cfb\u7d71\u7684\u786c\u6838\u554f\u984c\u300d\u3002<\/p>\n<\/blockquote>\n\n\n\n<div id=\"quiz-f72e9a47\">\n<style>\n#quiz-f72e9a47 .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-f72e9a47 .badge.scenario {\n        background: #ebf8ff;\n        color: #2b6cb0;\n      }#quiz-f72e9a47 .badge.debug {\n        background: #fef3c7;\n        color: #92400e;\n      }#quiz-f72e9a47 .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-f72e9a47 .question-adv h3 {\n        margin-top: 0;\n        color: #2d3748;\n      }#quiz-f72e9a47 .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-f72e9a47 .options-adv {\n        list-style: none;\n        padding: 0;\n      }#quiz-f72e9a47 .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-f72e9a47 .options-adv li:hover:not(.disabled) {\n        border-color: #ed8936;\n        background: #fffaf0;\n      }#quiz-f72e9a47 .options-adv li.disabled {\n        cursor: default;\n        opacity: 0.7;\n      }#quiz-f72e9a47 .options-adv li.show-answer {\n        border-color: #48bb78;\n        background: #f0fff4;\n      }#quiz-f72e9a47 .options-adv li.wrong {\n        border-color: #fc8181;\n        background: #fff5f5;\n      }#quiz-f72e9a47 .feedback-adv {\n        margin-top: 16px;\n        padding: 14px;\n        border-radius: 8px;\n        display: none;\n        line-height: 1.6;\n      }#quiz-f72e9a47 .feedback-adv.correct {\n        background: #f0fff4;\n        color: #276749;\n        display: block;\n      }#quiz-f72e9a47 .feedback-adv.wrong {\n        background: #fff5f5;\n        color: #c53030;\n        display: block;\n      }#quiz-f72e9a47 .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-f72e9a47 .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\u8cc7\u6599\u5eab\u512a\u5316\u8207\u64f4\u5c55 \u2014 \u7d22\u5f15\u3001\u8907\u88fd\u3001\u5206\u7247\u8207\u5feb\u53d6<\/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\u6240\u5b78\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\u8ca0\u8cac\u4e00\u500b\u96fb\u5546\u5e73\u53f0\u7684\u8a02\u55ae\u7cfb\u7d71\u3002\u8a02\u55ae\u8868\u6709 500 \u842c\u7b46\u8cc7\u6599\uff0c\u4ee5\u4e0b\u67e5\u8a62\u57f7\u884c\u6642\u9593\u8d85\u904e 5 \u79d2\uff1a <span class=\"badge scenario\">\u60c5\u5883\u984c<\/span><\/h3>\n      <div class=\"code-block\">SELECT * FROM orders WHERE user_id = 12345 AND status = &#8216;pending&#8217;;\n\n&#8212; \u76ee\u524d orders \u8868\u6c92\u6709\u4efb\u4f55\u7d22\u5f15\uff08\u9664\u4e86 Primary Key\uff09\n&#8212; \u7cfb\u7d71\u4ee5\u8b80\u53d6\u70ba\u4e3b\uff0c\u5beb\u5165\u91cf\u4e0d\u5927<\/div>\n      <p>\u6839\u64da\u6587\u7ae0\u5efa\u8b70\u7684\u6c7a\u7b56\u9806\u5e8f\uff0c\u4f60\u61c9\u8a72<strong>\u512a\u5148<\/strong>\u63a1\u53d6\u4ec0\u9ebc\u63aa\u65bd\uff1f<\/p>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(1, 'A', 'B')\">A. \u5c0e\u5165 Redis \u5feb\u53d6\u5c64\uff0c\u628a\u5e38\u67e5\u7684\u8a02\u55ae\u5b58\u5728\u8a18\u61b6\u9ad4\u88e1<\/li>\n        <li onclick=\"checkAnswerAdv(1, 'B', 'B')\">B. \u5c0d <code>user_id<\/code> \u548c <code>status<\/code> \u5efa\u7acb\u7d22\u5f15<\/li>\n        <li onclick=\"checkAnswerAdv(1, 'C', 'B')\">C. \u628a\u8a02\u55ae\u8868\u505a Sharding\uff0c\u6309 user_id \u5206\u7247\u5230\u591a\u53f0\u4f3a\u670d\u5668<\/li>\n        <li onclick=\"checkAnswerAdv(1, 'D', 'B')\">D. \u8a2d\u5b9a\u8b80\u5beb\u5206\u96e2\uff0c\u589e\u52a0 Replica \u5206\u6563\u8b80\u53d6\u58d3\u529b<\/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\u7684\u793e\u7fa4\u5a92\u9ad4\u61c9\u7528\u8981\u986f\u793a\u8cbc\u6587\u5217\u8868\uff0c\u6bcf\u7bc7\u8cbc\u6587\u9700\u8981\u986f\u793a\u4f5c\u8005\u540d\u7a31\u548c\u5927\u982d\u7167\u3002\u76ee\u524d\u7684\u8a2d\u8a08\u662f\uff1a <span class=\"badge scenario\">\u60c5\u5883\u984c<\/span><\/h3>\n      <div class=\"code-block\">&#8212; \u6bcf\u6b21\u8f09\u5165\u8cbc\u6587\u5217\u8868\u90fd\u8981 JOIN \u5169\u5f35\u8868\nSELECT p.content, p.created_at, u.name, u.avatar_url\nFROM posts p\nJOIN users u ON p.user_id = u.user_id\nORDER BY p.created_at DESC\nLIMIT 20;\n\n&#8212; \u9019\u500b\u67e5\u8a62\u6bcf\u79d2\u88ab\u547c\u53eb\u4e0a\u842c\u6b21\n&#8212; \u7528\u6236\u5f88\u5c11\u6539\u540d\u5b57\u6216\u63db\u5927\u982d\u7167<\/div>\n      <p>\u70ba\u4e86\u63d0\u5347\u9019\u500b\u67e5\u8a62\u7684\u6548\u80fd\uff0c\u6700\u9069\u5408\u7684\u505a\u6cd5\u662f\uff1f<\/p>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(2, 'A', 'C')\">A. \u5c0d posts \u8868\u505a Sharding\uff0c\u6309 user_id \u5206\u7247<\/li>\n        <li onclick=\"checkAnswerAdv(2, 'B', 'C')\">B. \u628a posts \u8868\u505a Vertical Partitioning\uff0c\u628a content \u6b04\u4f4d\u5206\u51fa\u53bb<\/li>\n        <li onclick=\"checkAnswerAdv(2, 'C', 'C')\">C. \u5c0d posts \u8868\u505a\u53cd\u6b63\u898f\u5316\uff0c\u76f4\u63a5\u5728 posts \u8868\u5b58\u5165 user_name \u548c avatar_url<\/li>\n        <li onclick=\"checkAnswerAdv(2, 'D', 'C')\">D. \u589e\u52a0\u66f4\u591a Replica \u4f86\u5206\u6563 JOIN \u67e5\u8a62\u7684\u58d3\u529b<\/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 users \u8868\u5305\u542b\u4ee5\u4e0b\u6b04\u4f4d\uff0c\u6bcf\u6b21\u7528\u6236\u767b\u5165\u90fd\u8981\u67e5\u6574\u5f35\u8868\uff1a <span class=\"badge scenario\">\u60c5\u5883\u984c<\/span><\/h3>\n      <div class=\"code-block\">CREATE TABLE users (\n    id INT PRIMARY KEY,\n    name VARCHAR(100),          &#8212; \u6bcf\u6b21\u767b\u5165\u90fd\u8b80\n    email VARCHAR(200),         &#8212; \u6bcf\u6b21\u767b\u5165\u90fd\u8b80\n    password_hash VARCHAR(256), &#8212; \u6bcf\u6b21\u767b\u5165\u90fd\u8b80\n    avatar BLOB,                &#8212; 3-5MB\uff0c\u53ea\u5728\u500b\u4eba\u9801\u9762\u8b80\n    resume BLOB,                &#8212; 1-10MB\uff0c\u53ea\u5728\u6c42\u8077\u9801\u8b80\n    preferences JSON,           &#8212; \u53ea\u5728\u8a2d\u5b9a\u9801\u8b80\n    activity_log JSON           &#8212; \u53ea\u5728\u7ba1\u7406\u5f8c\u53f0\u8b80\n);\n\n&#8212; \u767b\u5165\u67e5\u8a62\uff1a\nSELECT * FROM users WHERE email = &#8216;alice@example.com&#8217;;<\/div>\n      <p>\u767b\u5165\u67e5\u8a62\u5f88\u6162\uff0c\u6700\u53ef\u80fd\u7684\u539f\u56e0\u548c\u6700\u4f73\u6539\u5584\u65b9\u5f0f\u662f\uff1f<\/p>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(3, 'A', 'B')\">A. \u7f3a\u5c11\u7d22\u5f15\uff0c\u61c9\u5c0d\u6240\u6709\u6b04\u4f4d\u5efa\u7d22\u5f15<\/li>\n        <li onclick=\"checkAnswerAdv(3, 'B', 'B')\">B. SELECT * \u8b80\u53d6\u4e86\u5927\u91cf BLOB \u8cc7\u6599\uff08avatar\u3001resume\uff09\uff0c\u61c9\u505a\u5782\u76f4\u5206\u5272\uff0c\u5c07\u4e0d\u5e38\u7528\u7684\u5927\u6b04\u4f4d\u62c6\u5230\u53e6\u4e00\u5f35\u8868<\/li>\n        <li onclick=\"checkAnswerAdv(3, 'C', 'B')\">C. \u8cc7\u6599\u91cf\u592a\u5927\uff0c\u61c9\u7acb\u5373\u505a Sharding \u5206\u6563\u5230\u591a\u53f0\u4f3a\u670d\u5668<\/li>\n        <li onclick=\"checkAnswerAdv(3, 'D', 'B')\">D. \u61c9\u5c0e\u5165 Write-Behind \u5feb\u53d6\u7b56\u7565\uff0c\u628a\u767b\u5165\u8cc7\u6599\u5beb\u5165\u5feb\u53d6<\/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\u4e00\u5f35\u9ad8\u983b\u5beb\u5165\u7684\u65e5\u8a8c\u8868\uff08log table\uff09\u4e0a\u52a0\u4e86\u5927\u91cf\u7d22\u5f15\u3002\u4ee5\u4e0b\u662f AI \u751f\u6210\u7684 schema\uff1a <span class=\"badge debug\">\u932f\u8aa4\u8a3a\u65b7<\/span><\/h3>\n      <div class=\"code-block\">CREATE TABLE access_logs (\n    id BIGINT AUTO_INCREMENT PRIMARY KEY,\n    user_id INT,\n    action VARCHAR(50),\n    ip_address VARCHAR(45),\n    user_agent TEXT,\n    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP\n);\n\n&#8212; \u6bcf\u79d2\u6709\u6578\u5343\u7b46 INSERT\n&#8212; AI \u5efa\u8b70\u7684\u7d22\u5f15\uff1a\nCREATE INDEX idx_logs_user ON access_logs(user_id);\nCREATE INDEX idx_logs_action ON access_logs(action);\nCREATE INDEX idx_logs_ip ON access_logs(ip_address);\nCREATE INDEX idx_logs_ua ON access_logs(user_agent(100));\nCREATE INDEX idx_logs_time ON access_logs(created_at);\nCREATE INDEX idx_logs_user_action ON access_logs(user_id, action);\nCREATE INDEX idx_logs_user_time ON access_logs(user_id, created_at);<\/div>\n      <p>\u4e0a\u7dda\u5f8c\u767c\u73fe\u5beb\u5165\u6548\u80fd\u56b4\u91cd\u4e0b\u964d\uff0cINSERT \u5ef6\u9072\u5f9e 1ms \u98c6\u5347\u5230 50ms\u3002\u6700\u53ef\u80fd\u7684\u539f\u56e0\u662f\uff1f<\/p>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(4, 'A', 'C')\">A. \u8868\u7684\u6b04\u4f4d\u592a\u591a\uff0c\u61c9\u8a72\u505a Vertical Partitioning<\/li>\n        <li onclick=\"checkAnswerAdv(4, 'B', 'C')\">B. \u6c92\u6709\u4f7f\u7528 Replication \u505a\u8b80\u5beb\u5206\u96e2<\/li>\n        <li onclick=\"checkAnswerAdv(4, 'C', 'C')\">C. \u7d22\u5f15\u592a\u591a\uff087 \u500b\uff09\uff0c\u6bcf\u6b21 INSERT \u90fd\u8981\u540c\u6b65\u66f4\u65b0\u5168\u90e8\u7d22\u5f15\uff0c\u5728\u9ad8\u983b\u5beb\u5165\u7684\u8868\u4e0a\u4ee3\u50f9\u6975\u5927<\/li>\n        <li onclick=\"checkAnswerAdv(4, 'D', 'C')\">D. \u61c9\u8a72\u7528 Write-Through \u5feb\u53d6\u7b56\u7565\u53d6\u4ee3\u8cc7\u6599\u5eab\u5beb\u5165<\/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. \u5718\u968a\u5728\u7cfb\u7d71\u4e2d\u5c0e\u5165\u4e86 Redis \u5feb\u53d6\uff0c\u4f46\u4f7f\u7528\u8005\u53cd\u6620\u300c\u6539\u4e86\u500b\u4eba\u8cc7\u6599\u5f8c\uff0c\u5225\u4eba\u770b\u5230\u7684\u9084\u662f\u820a\u7684\u300d\u3002\u4ee5\u4e0b\u662f\u5feb\u53d6\u76f8\u95dc\u7a0b\u5f0f\u78bc\uff1a <span class=\"badge debug\">\u932f\u8aa4\u8a3a\u65b7<\/span><\/h3>\n      <div class=\"code-block\">def get_user_profile(user_id):\n    cached = cache.get(f&#8221;user:{user_id}&#8221;)\n    if cached:\n        return json.loads(cached)\n\n    user = db.query(&#8220;SELECT * FROM users WHERE id = ?&#8221;, user_id)\n    cache.set(f&#8221;user:{user_id}&#8221;, json.dumps(user))  # \u5b58\u5165\u5feb\u53d6\n    return user\n\ndef update_user_profile(user_id, new_data):\n    db.execute(&#8220;UPDATE users SET &#8230; WHERE id = ?&#8221;, user_id)\n    # \u66f4\u65b0\u5b8c\u6210\uff0c\u56de\u50b3\u6210\u529f\n    return {&#8220;status&#8221;: &#8220;ok&#8221;}<\/div>\n      <p>\u9019\u6bb5\u7a0b\u5f0f\u78bc\u7684\u554f\u984c\u5728\u54ea\u88e1\uff1f<\/p>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(5, 'A', 'D')\">A. <code>get_user_profile<\/code> \u61c9\u8a72\u76f4\u63a5\u67e5\u8cc7\u6599\u5eab\uff0c\u4e0d\u8981\u7528\u5feb\u53d6<\/li>\n        <li onclick=\"checkAnswerAdv(5, 'B', 'D')\">B. \u61c9\u8a72\u7528 Write-Through \u7b56\u7565\uff0c\u5728 <code>cache.set<\/code> \u6642\u540c\u6642\u5beb\u5165\u8cc7\u6599\u5eab<\/li>\n        <li onclick=\"checkAnswerAdv(5, 'C', 'D')\">C. <code>get_user_profile<\/code> \u7f3a\u5c11\u932f\u8aa4\u8655\u7406\uff0c\u61c9\u52a0 try-catch<\/li>\n        <li onclick=\"checkAnswerAdv(5, 'D', 'D')\">D. <code>update_user_profile<\/code> \u66f4\u65b0\u8cc7\u6599\u5eab\u5f8c\u6c92\u6709\u522a\u9664\u6216\u66f4\u65b0\u5feb\u53d6\uff0c\u4e14 <code>cache.set<\/code> \u6c92\u6709\u8a2d\u5b9a TTL\uff08\u904e\u671f\u6642\u9593\uff09\uff0c\u5c0e\u81f4\u820a\u8cc7\u6599\u6c38\u9060\u7559\u5728\u5feb\u53d6\u88e1<\/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: \"\u6587\u7ae0\u660e\u78ba\u6307\u51fa\u8655\u7406\u8cc7\u6599\u5eab\u6548\u80fd\u554f\u984c\u7684\u512a\u5148\u9806\u5e8f\uff1a\u5148\u52a0\u7d22\u5f15\uff08\u6210\u672c\u6700\u4f4e\u3001\u6548\u679c\u6700\u660e\u986f\uff09\u3002\u9019\u500b\u67e5\u8a62\u7684 WHERE \u689d\u4ef6\u662f <code>user_id<\/code> \u548c <code>status<\/code>\uff0c\u5c0d\u9019\u5169\u500b\u6b04\u4f4d\u5efa\u7d22\u5f15\u5c31\u80fd\u5f9e Full Table Scan \u8b8a\u6210 Index Lookup\uff0c\u5927\u5e45\u52a0\u901f\u67e5\u8a62\u3002\u5feb\u53d6\u3001Replication\u3001Sharding \u90fd\u662f\u66f4\u9032\u968e\u7684\u624b\u6bb5\uff0c\u5728\u7d22\u5f15\u90fd\u6c92\u52a0\u7684\u60c5\u6cc1\u4e0b\u4e0d\u61c9\u8a72\u5148\u8003\u616e\u3002\",\n        2: \"\u9019\u662f\u5178\u578b\u9069\u5408\u53cd\u6b63\u898f\u5316\uff08Denormalization\uff09\u7684\u5834\u666f\uff1a\u8b80\u53d6\u91cf\u9060\u5927\u65bc\u5beb\u5165\u91cf\uff08\u6bcf\u79d2\u4e0a\u842c\u6b21\u67e5\u8a62\uff09\uff0c\u4e14\u7528\u6236\u540d\u7a31\u548c\u5927\u982d\u7167\u5f88\u5c11\u8b8a\u52d5\u3002\u76f4\u63a5\u5728 posts \u8868\u4e2d\u5b58\u5165 <code>user_name<\/code> \u548c <code>avatar_url<\/code>\uff0c\u5c31\u4e0d\u9700\u8981\u6bcf\u6b21\u90fd JOIN users \u8868\u3002Sharding \u548c Replica \u7121\u6cd5\u89e3\u6c7a JOIN \u672c\u8eab\u7684\u554f\u984c\uff0cVertical Partitioning \u662f\u62c6\u6b04\u4f4d\u800c\u975e\u89e3\u6c7a JOIN\u3002\",\n        3: \"\u554f\u984c\u51fa\u5728 <code>SELECT *<\/code> \u6703\u8b80\u53d6\u6240\u6709\u6b04\u4f4d\uff0c\u5305\u62ec\u5169\u500b\u5de8\u5927\u7684 BLOB \u6b04\u4f4d\uff08avatar 3-5MB\u3001resume 1-10MB\uff09\u3002\u5373\u4f7f\u53ea\u9700\u8981\u767b\u5165\u9a57\u8b49\u7528\u7684 name\u3001email\u3001password_hash\uff0c\u537b\u88ab\u8feb\u8b80\u53d6\u4e86\u5341\u5e7e MB \u7684\u7121\u7528\u8cc7\u6599\u3002\u6587\u7ae0\u63d0\u5230\u7684 Vertical Partitioning\uff08\u5782\u76f4\u5206\u5272\uff09\u6b63\u662f\u89e3\u6c7a\u9019\u500b\u554f\u984c\uff1a\u628a\u5e38\u8b80\u7684\u5c0f\u6b04\u4f4d\u548c\u4e0d\u5e38\u8b80\u7684\u5927\u6b04\u4f4d\u62c6\u5230\u4e0d\u540c\u7684\u8868\u3002\u5c0d\u6240\u6709\u6b04\u4f4d\u5efa\u7d22\u5f15\u662f\u932f\u8aa4\u7684\u505a\u6cd5\uff0c\u7d22\u5f15\u4e0d\u89e3\u6c7a\u300c\u8b80\u53d6\u904e\u591a\u6b04\u4f4d\u300d\u7684\u554f\u984c\u3002\",\n        4: \"\u6587\u7ae0\u660e\u78ba\u6307\u51fa\uff1a\u7d22\u5f15\u4e0d\u662f\u514d\u8cbb\u7684\uff0c\u6bcf\u6b21 INSERT \u90fd\u8981\u540c\u6b65\u66f4\u65b0\u6240\u6709\u7d22\u5f15\u3002\u5982\u679c\u5c0d 5 \u500b\u6b04\u4f4d\u90fd\u5efa\u4e86\u7d22\u5f15\uff0c\u6bcf\u6b21 INSERT \u5c31\u8981\u66f4\u65b0 5 \u500b\u7d22\u5f15\u3002\u9019\u500b\u65e5\u8a8c\u8868\u6bcf\u79d2\u6709\u6578\u5343\u7b46 INSERT\uff0c\u537b\u5efa\u4e86 7 \u500b\u7d22\u5f15\uff0c\u6bcf\u6b21\u5beb\u5165\u90fd\u8981\u66f4\u65b0 7 \u500b\u7d22\u5f15\u7d50\u69cb\uff0c\u9019\u5c31\u662f\u5beb\u5165\u5ef6\u9072\u98c6\u5347\u7684\u6839\u672c\u539f\u56e0\u3002\u6587\u7ae0\u7279\u5225\u63d0\u9192\u300c\u7d93\u5e38\u5927\u91cf INSERT \u7684\u8868\u300d\u4e0d\u9069\u5408\u52a0\u592a\u591a\u7d22\u5f15\u3002\u6b63\u78ba\u505a\u6cd5\u662f\u53ea\u4fdd\u7559\u771f\u6b63\u5e38\u67e5\u8a62\u7684\u7d22\u5f15\uff0c\u79fb\u9664\u4e0d\u5fc5\u8981\u7684\u3002\",\n        5: \"\u9019\u6bb5\u7a0b\u5f0f\u78bc\u6709\u5169\u500b\u554f\u984c\uff0c\u90fd\u662f\u6587\u7ae0\u63d0\u5230\u7684\u5feb\u53d6\u5e38\u898b\u932f\u8aa4\u3002\u7b2c\u4e00\uff0c<code>update_user_profile<\/code> \u66f4\u65b0\u8cc7\u6599\u5eab\u5f8c\u5b8c\u5168\u6c92\u6709\u8655\u7406\u5feb\u53d6 \u2014 \u6587\u7ae0\u6307\u51fa\u5728 Cache-Aside \u6a21\u5f0f\u4e2d\uff0c\u5beb\u5165\u6642\u61c9\u8a72\u300c\u76f4\u63a5\u5beb DB\uff0c\u7136\u5f8c\u522a\u6389\u5feb\u53d6\u300d\uff0c\u9019\u6a23\u4e0b\u6b21\u8b80\u53d6\u6642\u6703\u91cd\u65b0\u5f9e\u8cc7\u6599\u5eab\u8f09\u5165\u6700\u65b0\u8cc7\u6599\u3002\u7b2c\u4e8c\uff0c<code>cache.set<\/code> \u6c92\u6709\u8a2d\u5b9a <code>ex<\/code>\uff08TTL \u904e\u671f\u6642\u9593\uff09\u2014 \u6587\u7ae0\u7684 Vibe Coder \u6aa2\u67e5\u9ede\u7279\u5225\u5f37\u8abf\uff1a\u6c92\u6709 TTL \u7684\u5feb\u53d6\u6c38\u9060\u4e0d\u6703\u81ea\u52d5\u66f4\u65b0\u3002\u9019\u5169\u500b\u554f\u984c\u5408\u5728\u4e00\u8d77\uff0c\u5c31\u5c0e\u81f4\u4e86\u820a\u8cc7\u6599\u6c38\u9060\u7559\u5728\u5feb\u53d6\u88e1\u7684 bug\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 = \"&#10003; \u6b63\u78ba\uff01\" + explanationsAdv[qNum];\n        } else {\n          feedback.className = \"feedback-adv wrong\";\n          feedback.innerHTML =\n            \"&#10007; \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 = \"&#127919; \u5b8c\u7f8e\uff01\u4f60\u5df2\u7d93\u6e96\u5099\u597d\u5be6\u6230\u4e86\uff01\";\n          else if (correctAdv >= Math.ceil(totalAdv * 0.8))\n            msg = \"&#128170; \u5f88\u68d2\uff01\u518d\u8907\u7fd2\u4e00\u4e0b\u932f\u7684\u984c\u76ee\";\n          else if (correctAdv >= Math.ceil(totalAdv * 0.6))\n            msg = \"&#128214; \u5efa\u8b70\u91cd\u8b80\u76f8\u95dc\u6bb5\u843d\u5f8c\u518d\u8a66\u4e00\u6b21\";\n          else msg = \"&#128260; \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","protected":false},"excerpt":{"rendered":"<p>\u6e2c\u9a57\uff1a\u8cc7\u6599\u5eab\u512a\u5316\u8207\u64f4\u5c55 \u2014 \u7d22\u5f15\u3001\u8907\u88fd\u3001\u5206\u7247\u8207\u5feb\u53d6 \u5171 5 \u984c\uff0c\u9ede\u9078\u7b54\u6848\u5f8c\u6703\u7acb\u5373\u986f\u793a\u7d50\u679c 1. \u8cc7\u6599\u5eab\u7d22\u5f15\uff08I [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rolpb_likes":0,"footnotes":""},"categories":[711],"tags":[727,724,728,725,726,701],"class_list":["post-765","post","type-post","status-publish","format-standard","hentry","category-711","tag-caching","tag-database-indexing","tag-denormalization","tag-replication","tag-sharding","tag-701"],"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\/765","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=765"}],"version-history":[{"count":0,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/posts\/765\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/media?parent=765"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/categories?post=765"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/tags?post=765"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}