{"id":781,"date":"2026-02-23T22:59:46","date_gmt":"2026-02-23T14:59:46","guid":{"rendered":"https:\/\/blog.itsmygo.uk\/2026\/02\/23\/%e3%80%90%e7%b3%bb%e7%b5%b1%e8%a8%ad%e8%a8%88%e7%99%bd%e8%a9%b1%e6%96%87%e3%80%9105-%e8%b3%87%e6%96%99%e5%ba%ab%e8%a8%ad%e8%a8%88%e8%88%87%e6%93%b4%e5%b1%95%e7%ad%96%e7%95%a5-%e5%88%86\/"},"modified":"2026-02-23T22:59:46","modified_gmt":"2026-02-23T14:59:46","slug":"%e3%80%90%e7%b3%bb%e7%b5%b1%e8%a8%ad%e8%a8%88%e7%99%bd%e8%a9%b1%e6%96%87%e3%80%9105-%e8%b3%87%e6%96%99%e5%ba%ab%e8%a8%ad%e8%a8%88%e8%88%87%e6%93%b4%e5%b1%95%e7%ad%96%e7%95%a5-%e5%88%86","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%e7%99%bd%e8%a9%b1%e6%96%87%e3%80%9105-%e8%b3%87%e6%96%99%e5%ba%ab%e8%a8%ad%e8%a8%88%e8%88%87%e6%93%b4%e5%b1%95%e7%ad%96%e7%95%a5-%e5%88%86\/","title":{"rendered":"\u3010\u7cfb\u7d71\u8a2d\u8a08\u767d\u8a71\u6587\u3011#05 \u8cc7\u6599\u5eab\u8a2d\u8a08\u8207\u64f4\u5c55\u7b56\u7565 \u2014 \u5206\u7247\u3001\u8907\u88fd\u8207 ACID"},"content":{"rendered":"\n<div id=\"quiz-885133ee\">\n<style>\n#quiz-885133ee .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-885133ee .question h3 {\n        margin-top: 0;\n        color: #333;\n      }#quiz-885133ee .options {\n        list-style: none;\n        padding: 0;\n      }#quiz-885133ee .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-885133ee .options li:hover:not(.disabled) {\n        border-color: #4caf50;\n        background: #f0fff0;\n      }#quiz-885133ee .options li.correct {\n        border-color: #4caf50;\n        background: #e8f5e9;\n      }#quiz-885133ee .options li.wrong {\n        border-color: #f44336;\n        background: #ffebee;\n      }#quiz-885133ee .options li.disabled {\n        cursor: default;\n        opacity: 0.7;\n      }#quiz-885133ee .options li.show-answer {\n        border-color: #4caf50;\n        background: #e8f5e9;\n      }#quiz-885133ee .feedback {\n        margin-top: 15px;\n        padding: 12px;\n        border-radius: 6px;\n        display: none;\n      }#quiz-885133ee .feedback.correct {\n        background: #e8f5e9;\n        color: #2e7d32;\n        display: block;\n      }#quiz-885133ee .feedback.wrong {\n        background: #ffebee;\n        color: #c62828;\n        display: block;\n      }#quiz-885133ee .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-885133ee .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\u8a2d\u8a08\u8207\u64f4\u5c55\u7b56\u7565 \u2014 \u5206\u7247\u3001\u8907\u88fd\u8207 ACID<\/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. ACID \u4e2d\u7684\u300c\u539f\u5b50\u6027\uff08Atomicity\uff09\u300d\u662f\u4ec0\u9ebc\u610f\u601d\uff1f<\/h3>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(1, 'A', 'B')\">A. \u8cc7\u6599\u5eab\u7684\u64cd\u4f5c\u901f\u5ea6\u8981\u50cf\u539f\u5b50\u4e00\u6a23\u5feb<\/li>\n        <li onclick=\"checkAnswer(1, 'B', 'B')\">B. \u4e00\u500b\u4ea4\u6613\u88e1\u7684\u6240\u6709\u64cd\u4f5c\uff0c\u8981\u561b\u5168\u90e8\u5b8c\u6210\uff0c\u8981\u561b\u5168\u90e8\u53d6\u6d88<\/li>\n        <li onclick=\"checkAnswer(1, 'C', 'B')\">C. \u6bcf\u6b21\u4ea4\u6613\u53ea\u80fd\u64cd\u4f5c\u4e00\u7b46\u8cc7\u6599<\/li>\n        <li onclick=\"checkAnswer(1, 'D', 'B')\">D. \u8cc7\u6599\u5b8c\u6210\u5beb\u5165\u5f8c\u5c31\u6c38\u4e45\u4fdd\u5b58\uff0c\u4e0d\u6703\u907a\u5931<\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb1\"><\/div>\n    <\/div>\n\n    <div class=\"question\" id=\"q2\">\n      <h3>2. \u5782\u76f4\u64f4\u5c55\uff08Scale Up\uff09\u548c\u6c34\u5e73\u64f4\u5c55\uff08Scale Out\uff09\u7684\u4e3b\u8981\u5340\u5225\u662f\u4ec0\u9ebc\uff1f<\/h3>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(2, 'A', 'C')\">A. \u5782\u76f4\u64f4\u5c55\u52a0\u66f4\u591a\u6a5f\u5668\uff0c\u6c34\u5e73\u64f4\u5c55\u5347\u7d1a\u55ae\u53f0\u6a5f\u5668<\/li>\n        <li onclick=\"checkAnswer(2, 'B', 'C')\">B. \u5782\u76f4\u64f4\u5c55\u53ea\u80fd\u7528\u5728\u8cc7\u6599\u5eab\uff0c\u6c34\u5e73\u64f4\u5c55\u9069\u7528\u65bc\u6240\u6709\u7cfb\u7d71<\/li>\n        <li onclick=\"checkAnswer(2, 'C', 'C')\">C. \u5782\u76f4\u64f4\u5c55\u662f\u5347\u7d1a\u55ae\u53f0\u6a5f\u5668\u7684\u786c\u9ad4\uff0c\u6c34\u5e73\u64f4\u5c55\u662f\u589e\u52a0\u66f4\u591a\u6a5f\u5668<\/li>\n        <li onclick=\"checkAnswer(2, 'D', 'C')\">D. \u5782\u76f4\u64f4\u5c55\u6c92\u6709\u4e0a\u9650\uff0c\u6c34\u5e73\u64f4\u5c55\u6709\u786c\u9ad4\u74f6\u9838<\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb2\"><\/div>\n    <\/div>\n\n    <div class=\"question\" id=\"q3\">\n      <h3>3. \u5728\u8cc7\u6599\u5eab\u8907\u88fd\u7684\u4e3b\u5f9e\u67b6\u69cb\u4e2d\uff0c\u8b80\u5beb\u5206\u96e2\u70ba\u4ec0\u9ebc\u80fd\u63d0\u5347\u6548\u80fd\uff1f<\/h3>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(3, 'A', 'D')\">A. \u56e0\u70ba\u5f9e\u5eab\u7684\u786c\u9ad4\u6bd4\u4e3b\u5eab\u66f4\u597d<\/li>\n        <li onclick=\"checkAnswer(3, 'B', 'D')\">B. \u56e0\u70ba\u5beb\u5165\u64cd\u4f5c\u6bd4\u8b80\u53d6\u64cd\u4f5c\u6d88\u8017\u66f4\u591a\u8cc7\u6e90<\/li>\n        <li onclick=\"checkAnswer(3, 'C', 'D')\">C. \u56e0\u70ba\u4e3b\u5eab\u548c\u5f9e\u5eab\u4f7f\u7528\u4e0d\u540c\u7684\u8cc7\u6599\u5eab\u8edf\u9ad4<\/li>\n        <li onclick=\"checkAnswer(3, 'D', 'D')\">D. \u56e0\u70ba\u5927\u90e8\u5206\u61c9\u7528\u8b80\u591a\u5beb\u5c11\uff0c\u8b80\u53d6\u58d3\u529b\u53ef\u4ee5\u5206\u6563\u5230\u591a\u53f0\u5f9e\u5eab<\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb3\"><\/div>\n    <\/div>\n\n    <div class=\"question\" id=\"q4\">\n      <h3>4. Hash-based \u5206\u7247\u7b56\u7565\u7684\u4e3b\u8981\u512a\u9ede\u548c\u7f3a\u9ede\u5206\u5225\u662f\u4ec0\u9ebc\uff1f<\/h3>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(4, 'A', 'B')\">A. \u512a\u9ede\u662f\u7bc4\u570d\u67e5\u8a62\u6548\u7387\u9ad8\uff0c\u7f3a\u9ede\u662f\u8cc7\u6599\u5206\u4f48\u4e0d\u5747<\/li>\n        <li onclick=\"checkAnswer(4, 'B', 'B')\">B. \u512a\u9ede\u662f\u8cc7\u6599\u5206\u4f48\u5747\u52fb\uff0c\u7f3a\u9ede\u662f\u7bc4\u570d\u67e5\u8a62\u56f0\u96e3\u4e14\u589e\u6e1b\u5206\u7247\u6642\u9700\u5927\u91cf\u8cc7\u6599\u642c\u9077<\/li>\n        <li onclick=\"checkAnswer(4, 'C', 'B')\">C. \u512a\u9ede\u662f\u6700\u9748\u6d3b\u53ef\u96a8\u610f\u8abf\u6574\uff0c\u7f3a\u9ede\u662f\u5c0d\u7167\u8868\u6210\u70ba\u55ae\u9ede\u6545\u969c<\/li>\n        <li onclick=\"checkAnswer(4, 'D', 'B')\">D. \u512a\u9ede\u662f\u5be6\u4f5c\u7c21\u55ae\uff0c\u7f3a\u9ede\u662f\u53ea\u9069\u7528\u65bc\u6578\u5b57\u578b\u614b\u7684\u8cc7\u6599<\/li>\n      <\/ul>\n      <div class=\"feedback\" id=\"fb4\"><\/div>\n    <\/div>\n\n    <div class=\"question\" id=\"q5\">\n      <h3>5. \u67d0\u96fb\u5546\u5e73\u53f0\u7684\u8a02\u55ae\u7cfb\u7d71\u9700\u8981\u9078\u64c7\u8907\u88fd\u7b56\u7565\u3002\u8a02\u55ae\u91d1\u984d\u5fc5\u9808\u7cbe\u78ba\u3001\u4e0d\u80fd\u6709\u5ef6\u9072\u8aa4\u5dee\u3002\u61c9\u8a72\u9078\u64c7\u54ea\u7a2e\u8907\u88fd\u65b9\u5f0f\uff1f<\/h3>\n      <ul class=\"options\">\n        <li onclick=\"checkAnswer(5, 'A', 'A')\">A. \u540c\u6b65\u8907\u88fd\uff0c\u56e0\u70ba\u4e3b\u5eab\u6703\u7b49\u6240\u6709\u5f9e\u5eab\u78ba\u8a8d\u5f8c\u624d\u56de\u8986\u6210\u529f\uff0c\u78ba\u4fdd\u8cc7\u6599\u5f37\u4e00\u81f4<\/li>\n        <li onclick=\"checkAnswer(5, 'B', 'A')\">B. \u975e\u540c\u6b65\u8907\u88fd\uff0c\u56e0\u70ba\u901f\u5ea6\u66f4\u5feb\uff0c\u4f7f\u7528\u8005\u9ad4\u9a57\u66f4\u597d<\/li>\n        <li onclick=\"checkAnswer(5, 'C', 'A')\">C. \u975e\u540c\u6b65\u8907\u88fd\uff0c\u56e0\u70ba\u6700\u7d42\u4e00\u81f4\u6027\u5c0d\u8a02\u55ae\u7cfb\u7d71\u5df2\u7d93\u8db3\u5920<\/li>\n        <li onclick=\"checkAnswer(5, 'D', 'A')\">D. \u5169\u7a2e\u90fd\u53ef\u4ee5\uff0c\u8907\u88fd\u65b9\u5f0f\u4e0d\u5f71\u97ff\u8cc7\u6599\u6b63\u78ba\u6027<\/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: \"\u539f\u5b50\u6027\u7684\u300c\u539f\u5b50\u300d\u610f\u601d\u662f\u300c\u4e0d\u53ef\u5206\u5272\u300d\u3002\u4e00\u500b\u4ea4\u6613\u88e1\u7684\u6240\u6709\u64cd\u4f5c\u8981\u561b\u5168\u90e8\u5b8c\u6210\uff0c\u8981\u561b\u5168\u90e8\u53d6\u6d88\uff0c\u4e0d\u6703\u6709\u300c\u505a\u4e00\u534a\u300d\u7684\u60c5\u6cc1\u3002\u9078\u9805 D \u63cf\u8ff0\u7684\u5176\u5be6\u662f\u300c\u6301\u4e45\u6027\uff08Durability\uff09\u300d\u3002\",\n        2: \"\u5782\u76f4\u64f4\u5c55\uff08Scale Up\uff09\u662f\u8b93\u4e00\u53f0\u6a5f\u5668\u66f4\u5f37\uff08\u52a0 CPU\u3001\u52a0 RAM\uff09\uff0c\u7c21\u55ae\u4f46\u6709\u786c\u9ad4\u4e0a\u9650\uff1b\u6c34\u5e73\u64f4\u5c55\uff08Scale Out\uff09\u662f\u52a0\u66f4\u591a\u6a5f\u5668\uff0c\u7406\u8ad6\u4e0a\u7121\u4e0a\u9650\u4f46\u67b6\u69cb\u66f4\u8907\u96dc\u3002\u9078\u9805 A \u6070\u597d\u8aaa\u53cd\u4e86\u3002\",\n        3: \"\u5927\u90e8\u5206\u61c9\u7528\u7684\u8b80\u5beb\u6bd4\u4f8b\u5927\u7d04\u662f 80% \u8b80\u300120% \u5beb\u3002\u900f\u904e\u8b80\u5beb\u5206\u96e2\uff0c\u8b80\u53d6\u8acb\u6c42\u53ef\u4ee5\u5206\u6563\u5230\u591a\u53f0\u5f9e\u5eab\uff0c\u4f8b\u5982 3 \u53f0\u5f9e\u5eab\u5c31\u80fd\u8b93\u8b80\u53d6\u80fd\u529b\u63d0\u5347 3 \u500d\u3002\u95dc\u9375\u4e0d\u5728\u786c\u9ad4\u5dee\u7570\uff0c\u800c\u5728\u6d41\u91cf\u7684\u5206\u6563\u3002\",\n        4: \"Hash-based \u5206\u7247\u900f\u904e\u96dc\u6e4a\u51fd\u5f0f\u8b93\u8cc7\u6599\u5747\u52fb\u5206\u4f48\u5230\u5404\u5206\u7247\uff0c\u9019\u662f\u5b83\u7684\u4e3b\u8981\u512a\u9ede\u3002\u4f46\u56e0\u70ba\u8cc7\u6599\u88ab\u6253\u6563\u4e86\uff0c\u7bc4\u570d\u67e5\u8a62\uff08\u4f8b\u5982\u627e id 100~200 \u7684\u4f7f\u7528\u8005\uff09\u6703\u8b8a\u56f0\u96e3\uff0c\u800c\u4e14\u589e\u6e1b\u5206\u7247\u6642\u9700\u8981\u91cd\u65b0\u8a08\u7b97\u96dc\u6e4a\uff0c\u9020\u6210\u5927\u91cf\u8cc7\u6599\u642c\u9077\u3002\u9078\u9805 A \u63cf\u8ff0\u7684\u662f Range-based\uff0c\u9078\u9805 C \u63cf\u8ff0\u7684\u662f Directory-based\u3002\",\n        5: \"\u8a02\u55ae\u91d1\u984d\u5fc5\u9808\u7cbe\u78ba\uff0c\u4e0d\u80fd\u6709\u5ef6\u9072\u8aa4\u5dee\uff0c\u9019\u5c6c\u65bc\u300c\u4e0d\u80fd\u51fa\u932f\u7684\u5834\u666f\u300d\u3002\u540c\u6b65\u8907\u88fd\u6703\u8b93\u4e3b\u5eab\u7b49\u6240\u6709\u5f9e\u5eab\u78ba\u8a8d\u5f8c\u624d\u56de\u8986\u6210\u529f\uff0c\u78ba\u4fdd\u5f9e\u5eab\u7684\u8cc7\u6599\u6c38\u9060\u548c\u4e3b\u5eab\u4e00\u81f4\uff08\u5f37\u4e00\u81f4\u6027\uff09\u3002\u975e\u540c\u6b65\u8907\u88fd\u96d6\u7136\u901f\u5ea6\u8f03\u5feb\uff0c\u4f46\u5f9e\u5eab\u53ef\u80fd\u77ed\u66ab\u843d\u5f8c\uff0c\u4e0d\u9069\u5408\u5c0d\u8cc7\u6599\u7cbe\u78ba\u5ea6\u8981\u6c42\u6975\u9ad8\u7684\u5834\u666f\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\u767d\u8a71\u6587\uff08\u7b2c 5 \u7bc7\uff0c\u5171 5 \u7bc7 \u2014 \u7cfb\u5217\u6700\u7d42\u7bc7\uff09<br>**\u96e3\u5ea6**\uff1aL2-\u9032\u968e<br>**\u524d\u7f6e\u77e5\u8b58**\uff1a\u3010\u7cfb\u7d71\u8a2d\u8a08\u767d\u8a71\u6587\u3011#04 \u5feb\u53d6\u3001CDN \u8207\u6d41\u91cf\u7ba1\u7406<br>**\u5f71\u7247\u4f86\u6e90**\uff1a[freeCodeCamp \u2014 System Design Concepts Course and Interview Prep\uff08Hayk Simonyan\uff09](https:\/\/www.youtube.com\/watch?v=F2FmTdLtb_4)<\/p>\n<\/blockquote>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u4e00\u53e5\u8a71\u8aaa\u660e<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u8cc7\u6599\u5eab\u662f\u7cfb\u7d71\u7684\u300c\u8a18\u61b6\u300d\uff0cACID \u78ba\u4fdd\u8cc7\u6599\u6b63\u78ba\uff0c\u5206\u7247\u548c\u8907\u88fd\u8b93\u8cc7\u6599\u5eab\u6490\u4f4f\u5927\u6d41\u91cf\u3002<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u9019\u7bc7\u5728\u8b1b\u4ec0\u9ebc\uff1f<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u524d\u56db\u7bc7\u6211\u5011\u5f9e\u786c\u9ad4\u3001\u7db2\u8def\u3001\u5354\u5b9a\u3001\u5feb\u53d6\u4e00\u8def\u8d70\u4f86\u3002\u4f46\u4e0d\u7ba1\u4f60\u600e\u9ebc\u5feb\u53d6\u3001\u600e\u9ebc\u505a CDN\uff0c\u6700\u7d42\u8cc7\u6599\u90fd\u8981\u843d\u5730\u5230\u8cc7\u6599\u5eab\u3002\u7576\u4f60\u7684\u4f7f\u7528\u8005\u5f9e 100 \u4eba\u6210\u9577\u5230 1000 \u842c\u4eba\uff0c\u4e00\u53f0\u8cc7\u6599\u5eab\u4f3a\u670d\u5668\u9072\u65e9\u6703\u625b\u4e0d\u4f4f\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u9019\u7bc7\u8981\u56de\u7b54\u4e09\u500b\u554f\u984c\uff1a<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n\n<li><strong>\u600e\u9ebc\u78ba\u4fdd\u8cc7\u6599\u4e0d\u6703\u5beb\u58de\uff1f<\/strong> \u2192 ACID<\/li>\n\n\n<li><strong>\u4e00\u53f0\u4e0d\u5920\u600e\u9ebc\u8fa6\uff1f<\/strong> \u2192 \u64f4\u5c55\u7b56\u7565\uff08\u5782\u76f4 vs \u6c34\u5e73\uff09<\/li>\n\n\n<li><strong>\u8cc7\u6599\u592a\u591a\u600e\u9ebc\u5207\uff1f\u8b80\u53d6\u592a\u6162\u600e\u9ebc\u5206\uff1f<\/strong> \u2192 \u5206\u7247\uff08Sharding\uff09\u8207\u8907\u88fd\uff08Replication\uff09<\/li>\n\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">ACID\uff1a\u8cc7\u6599\u5eab\u7684\u56db\u5927\u4fdd\u8b49<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">\u767d\u8a71\u7248\uff1a\u9280\u884c\u8f49\u5e33\u7684\u6545\u4e8b<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u60f3\u50cf\u4f60\u8981\u5f9e\u5e33\u6236 A \u8f49 1000 \u5143\u5230\u5e33\u6236 B\u3002\u9019\u500b\u64cd\u4f5c\u6d89\u53ca\u5169\u6b65\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\">\u6b65\u9a5f 1\uff1a\u5e33\u6236 A \u6263 1000 \u5143\n\u6b65\u9a5f 2\uff1a\u5e33\u6236 B \u52a0 1000 \u5143\n<\/code><\/span><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u5982\u679c\u6b65\u9a5f 1 \u505a\u5b8c\u3001\u6b65\u9a5f 2 \u9084\u6c92\u505a\uff0c\u7cfb\u7d71\u5c31\u7576\u6a5f\u4e86\u5462\uff1f1000 \u5143\u5c31\u300c\u6191\u7a7a\u6d88\u5931\u300d\u4e86\u3002ACID \u5c31\u662f\u70ba\u4e86\u9632\u6b62\u9019\u7a2e\u4e8b\u767c\u751f\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u56db\u5927\u7279\u6027\u4e00\u6b21\u770b\u61c2<\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>\u7279\u6027<\/th>\n<th>\u82f1\u6587<\/th>\n<th>\u767d\u8a71\u7ffb\u8b6f<\/th>\n<th>\u9280\u884c\u8f49\u5e33\u7684\u4f8b\u5b50<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><strong>\u539f\u5b50\u6027<\/strong><\/td>\n<td>Atomicity<\/td>\n<td>\u5168\u505a\u6216\u5168\u4e0d\u505a<\/td>\n<td>\u6263\u6b3e\u548c\u5165\u5e33\u8981\u561b\u90fd\u6210\u529f\uff0c\u8981\u561b\u90fd\u4e0d\u505a<\/td>\n<\/tr>\n<tr>\n<td><strong>\u4e00\u81f4\u6027<\/strong><\/td>\n<td>Consistency<\/td>\n<td>\u4ea4\u6613\u524d\u5f8c\u8cc7\u6599\u90fd\u5408\u7406<\/td>\n<td>\u8f49\u5e33\u524d\u5f8c\uff0cA + B \u7684\u7e3d\u984d\u4e0d\u8b8a<\/td>\n<\/tr>\n<tr>\n<td><strong>\u9694\u96e2\u6027<\/strong><\/td>\n<td>Isolation<\/td>\n<td>\u540c\u6642\u4ea4\u6613\u4e92\u4e0d\u5e72\u64fe<\/td>\n<td>\u4f60\u8f49\u5e33\u7684\u540c\u6642\uff0c\u5225\u4eba\u4e5f\u5728\u8f49\uff0c\u5f7c\u6b64\u4e0d\u6703\u641e\u6df7<\/td>\n<\/tr>\n<tr>\n<td><strong>\u6301\u4e45\u6027<\/strong><\/td>\n<td>Durability<\/td>\n<td>\u5b8c\u6210\u5c31\u6c38\u4e45\u4fdd\u5b58<\/td>\n<td>\u8f49\u5e33\u6210\u529f\u5f8c\u5c31\u7b97\u65b7\u96fb\uff0c\u8cc7\u6599\u9084\u662f\u5728<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">\u9010\u500b\u62c6\u89e3<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Atomicity\uff08\u539f\u5b50\u6027\uff09\u2014\u2014 \u5168\u505a\u6216\u5168\u4e0d\u505a<\/strong><\/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\">\u4ea4\u6613\u958b\u59cb\n  \u5e33\u6236 A: 5000 \u2192 4000  \uff08\u6263 1000\uff09\n  \u5e33\u6236 B: 3000 \u2192 4000  \uff08\u52a0 1000\uff09\n\u4ea4\u6613\u7d50\u675f \u2705\n\n\u5982\u679c\u4e2d\u9014\u5931\u6557\uff1a\n  \u5e33\u6236 A: 5000 \u2192 5000  \uff08\u56de\u6efe\uff0c\u7576\u4f5c\u4ec0\u9ebc\u90fd\u6c92\u767c\u751f\uff09\n  \u5e33\u6236 B: 3000 \u2192 3000  \uff08\u56de\u6efe\uff09\n<\/code><\/span><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u300c\u539f\u5b50\u300d\u5c31\u662f\u300c\u4e0d\u53ef\u5206\u5272\u300d\u3002\u4e00\u500b\u4ea4\u6613\u88e1\u7684\u6240\u6709\u64cd\u4f5c\uff0c\u8981\u561b\u5168\u90e8\u5b8c\u6210\uff0c\u8981\u561b\u5168\u90e8\u53d6\u6d88\u3002\u4e0d\u6703\u6709\u300c\u505a\u4e00\u534a\u300d\u7684\u60c5\u6cc1\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Consistency\uff08\u4e00\u81f4\u6027\uff09\u2014\u2014 \u8cc7\u6599\u59cb\u7d42\u5408\u7406<\/strong><\/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\">\u8f49\u5e33\u524d\uff1aA(5000) + B(3000) = 8000\n\u8f49\u5e33\u5f8c\uff1aA(4000) + B(4000) = 8000  \u2705 \u7e3d\u984d\u6c92\u8b8a\n\n\u4e0d\u5408\u7406\u7684\u60c5\u6cc1\uff1a\n\u8f49\u5e33\u5f8c\uff1aA(4000) + B(3000) = 7000  \u274c \u5c11\u4e86 1000 \u584a\uff01\n<\/code><\/span><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u4e00\u81f4\u6027\u78ba\u4fdd\u6bcf\u6b21\u4ea4\u6613\u90fd\u8b93\u8cc7\u6599\u5f9e\u300c\u4e00\u500b\u5408\u7406\u7684\u72c0\u614b\u300d\u8f49\u79fb\u5230\u300c\u53e6\u4e00\u500b\u5408\u7406\u7684\u72c0\u614b\u300d\u3002\u9055\u53cd\u696d\u52d9\u898f\u5247\u7684\u64cd\u4f5c\u6703\u88ab\u62d2\u7d55\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Isolation\uff08\u9694\u96e2\u6027\uff09\u2014\u2014 \u4ea4\u6613\u4e4b\u9593\u4e92\u4e0d\u6253\u64fe<\/strong><\/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-1\" data-shcb-language-name=\"CSS\" data-shcb-language-slug=\"css\"><span><code class=\"hljs language-css\">\u6642\u9593\u7dda\uff1a\n<span class=\"hljs-selector-tag\">User<\/span> <span class=\"hljs-selector-tag\">X<\/span>: <span class=\"hljs-selector-attr\">&#91;\u958b\u59cb\u8f49\u5e33 A\u2192B]<\/span> <span class=\"hljs-selector-tag\">--------<\/span> <span class=\"hljs-selector-attr\">&#91;\u5b8c\u6210]<\/span>\n<span class=\"hljs-selector-tag\">User<\/span> <span class=\"hljs-selector-tag\">Y<\/span>:     <span class=\"hljs-selector-attr\">&#91;\u958b\u59cb\u8f49\u5e33 A\u2192C]<\/span> <span class=\"hljs-selector-tag\">--------<\/span> <span class=\"hljs-selector-attr\">&#91;\u5b8c\u6210]<\/span>\n\n\u9694\u96e2\u6027\u78ba\u4fdd\uff1a\n\u5373\u4f7f <span class=\"hljs-selector-tag\">X<\/span> \u548c <span class=\"hljs-selector-tag\">Y<\/span> \u540c\u6642\u64cd\u4f5c\u5e33\u6236 <span class=\"hljs-selector-tag\">A<\/span>\uff0c\n\u5169\u7b46\u4ea4\u6613\u770b\u5230\u7684\u5e33\u6236\u9918\u984d\u4e0d\u6703\u4e92\u76f8\u5e72\u64fe\u3002\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-1\"><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<p class=\"wp-block-paragraph\">\u6c92\u6709\u9694\u96e2\u6027\u7684\u8a71\uff0c\u5169\u500b\u4eba\u540c\u6642\u8b80\u5230 A \u6709 5000 \u5143\uff0c\u5404\u8f49 3000 \u5143\u51fa\u53bb\uff0c\u5e33\u6236 A \u5c31\u6703\u8b8a\u6210 -1000 \u5143\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Durability\uff08\u6301\u4e45\u6027\uff09\u2014\u2014 \u5beb\u4e86\u5c31\u4e0d\u6703\u4e1f<\/strong><\/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\">\u4ea4\u6613\u5b8c\u6210 \u2192 \u5beb\u5165\u78c1\u789f \u2192 \u56de\u8986\u300c\u6210\u529f\u300d\n\n\u5373\u4f7f\u4e0b\u4e00\u79d2\uff1a\n- \u65b7\u96fb \u26a1 \u2192 \u91cd\u555f\u5f8c\u8cc7\u6599\u9084\u5728\n- \u4f3a\u670d\u5668\u7576\u6a5f \ud83d\udca5 \u2192 \u6062\u5fa9\u5f8c\u8cc7\u6599\u9084\u5728\n<\/code><\/span><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u8cc7\u6599\u5eab\u4e0d\u662f\u53ea\u628a\u8cc7\u6599\u653e\u5728\u8a18\u61b6\u9ad4\u88e1\u3002\u4e00\u65e6\u4ea4\u6613\u5b8c\u6210\uff0c\u8cc7\u6599\u5c31\u5df2\u7d93\u5b89\u5168\u5730\u5beb\u5165\u4e86\u6c38\u4e45\u5132\u5b58\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u5fc5\u770b\u61c2 vs \u77e5\u9053\u5c31\u597d<\/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\">\u2705 \u5fc5\u770b\u61c2\uff08\u9762\u8a66\u3001\u8a2d\u8a08\u90fd\u6703\u7528\u5230\uff09\uff1a\n- \u539f\u5b50\u6027\uff1a\u5168\u505a\u6216\u5168\u4e0d\u505a\n- \u4e00\u81f4\u6027\uff1a\u8cc7\u6599\u524d\u5f8c\u90fd\u5408\u7406\n- \u9694\u96e2\u6027\uff1a\u540c\u6642\u64cd\u4f5c\u4e0d\u4e92\u76f8\u5e72\u64fe\n- \u6301\u4e45\u6027\uff1a\u5b8c\u6210\u5c31\u6c38\u4e45\u4fdd\u5b58\n\n\ud83d\udccc \u77e5\u9053\u5c31\u597d\uff08\u9047\u5230\u518d\u67e5\uff09\uff1a\n- \u9694\u96e2\u7d1a\u5225\uff08Read Uncommitted, Read Committed, Repeatable Read, Serializable\uff09\n- WAL\uff08Write-Ahead Logging\uff09\u7684\u5be6\u4f5c\u7d30\u7bc0\n- MVCC\uff08\u591a\u7248\u672c\u4e26\u767c\u63a7\u5236\uff09\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\">\u64f4\u5c55\u7b56\u7565\uff1a\u4e00\u53f0\u4e0d\u5920\uff0c\u600e\u9ebc\u52a0\uff1f<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u7576\u8cc7\u6599\u5eab\u6490\u4e0d\u4f4f\u4e86\uff0c\u6709\u5169\u7a2e\u65b9\u5411\u53ef\u4ee5\u8d70\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u5782\u76f4\u64f4\u5c55\uff08Scale Up\uff09\uff1a\u8b93\u4e00\u53f0\u6a5f\u5668\u66f4\u5f37<\/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\">\u5347\u7d1a\u524d\uff1a                    \u5347\u7d1a\u5f8c\uff1a\n\u250c\u2500\u2500\u2500\u2500\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\u2500\u2500\u2500\u2500\u2510\n\u2502  DB Server      \u2502       \u2502  DB Server      \u2502\n\u2502  4 CPU          \u2502  \u2192    \u2502  32 CPU         \u2502\n\u2502  16 GB RAM      \u2502       \u2502  256 GB RAM     \u2502\n\u2502  500 GB SSD     \u2502       \u2502  4 TB NVMe SSD  \u2502\n\u2514\u2500\u2500\u2500\u2500\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\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\u539f\u672c\u7684\u96fb\u8166\u4e0d\u5920\u5feb\uff1f\u63db\u4e00\u53f0\u66f4\u597d\u7684\u3002<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>\u512a\u9ede<\/th>\n<th>\u7f3a\u9ede<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>\u7c21\u55ae\uff0c\u4e0d\u7528\u6539\u7a0b\u5f0f<\/td>\n<td>\u6709\u786c\u9ad4\u4e0a\u9650\uff08\u518d\u8cb4\u4e5f\u8cb7\u4e0d\u5230\u7121\u9650 RAM\uff09<\/td>\n<\/tr>\n<tr>\n<td>\u8cc7\u6599\u4e0d\u7528\u642c\u5bb6<\/td>\n<td>\u55ae\u9ede\u6545\u969c\uff08\u9019\u53f0\u639b\u4e86\u5168\u639b\uff09<\/td>\n<\/tr>\n<tr>\n<td>\u4e0d\u6703\u6709\u8cc7\u6599\u4e00\u81f4\u6027\u554f\u984c<\/td>\n<td>\u8d8a\u9ad8\u968e\u8d8a\u8cb4\uff0c\u50f9\u683c\u975e\u7dda\u6027\u6210\u9577<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">\u6c34\u5e73\u64f4\u5c55\uff08Scale Out\uff09\uff1a\u52a0\u66f4\u591a\u6a5f\u5668<\/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\">\u64f4\u5c55\u524d\uff1a                    \u64f4\u5c55\u5f8c\uff1a\n\u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510              \u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510\n\u2502 DB Server\u2502              \u2502 DB Server 1 \u2502\n\u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518              \u251c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2524\n                          \u2502 DB Server 2 \u2502\n     1 \u53f0                 \u251c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2524\n                          \u2502 DB Server 3 \u2502\n                          \u251c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2524\n                          \u2502 DB Server 4 \u2502\n                          \u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518\n                               4 \u53f0\n<\/code><\/span><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>\u767d\u8a71\u7ffb\u8b6f<\/strong>\uff1a\u4e00\u500b\u4eba\u642c\u4e0d\u52d5\uff1f\u627e\u66f4\u591a\u4eba\u4e00\u8d77\u642c\u3002<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>\u512a\u9ede<\/th>\n<th>\u7f3a\u9ede<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>\u7406\u8ad6\u4e0a\u7121\u4e0a\u9650<\/td>\n<td>\u67b6\u69cb\u8907\u96dc\u5ea6\u5927\u589e<\/td>\n<\/tr>\n<tr>\n<td>\u6c92\u6709\u55ae\u9ede\u6545\u969c<\/td>\n<td>\u8de8\u6a5f\u5668\u7684\u8cc7\u6599\u4e00\u81f4\u6027\u96e3\u8655\u7406<\/td>\n<\/tr>\n<tr>\n<td>\u53ef\u4ee5\u7528\u4fbf\u5b9c\u7684\u6a5f\u5668<\/td>\n<td>\u9700\u8981\u6c7a\u5b9a\u300c\u8cc7\u6599\u653e\u54ea\u53f0\u300d<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">\u600e\u9ebc\u9078\uff1f<\/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-2\" data-shcb-language-name=\"HTML, XML\" data-shcb-language-slug=\"xml\"><span><code class=\"hljs language-xml\">\u4f7f\u7528\u8005 <span class=\"hljs-tag\">&lt; <span class=\"hljs-attr\">10<\/span> \u842c\uff1a\u5782\u76f4\u64f4\u5c55\u901a\u5e38\u5c31\u5920\u4e86\n\u4f7f\u7528\u8005 &gt;<\/span> 100 \u842c\uff1a\u8a72\u8003\u616e\u6c34\u5e73\u64f4\u5c55\u4e86\n\u5be6\u969b\u4e0a\uff1a\u5927\u90e8\u5206\u7cfb\u7d71\u5169\u8005\u90fd\u6703\u7528\uff0c\u5148\u5782\u76f4\u518d\u6c34\u5e73\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-2\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">HTML, XML<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">xml<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre><\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u5206\u7247\uff08Sharding\uff09\uff1a\u628a\u8cc7\u6599\u5207\u958b\u653e\u5230\u591a\u53f0\u6a5f\u5668<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u5206\u7247\u662f\u6c34\u5e73\u64f4\u5c55\u7684\u6838\u5fc3\u624b\u6bb5\u3002\u628a\u4e00\u5f35\u5927\u8868\u7684\u8cc7\u6599\uff0c\u6309\u7167\u67d0\u500b\u898f\u5247\uff0c\u5206\u6563\u5230\u591a\u53f0\u6a5f\u5668\u4e0a\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u4e00\u770b\u5c31\u61c2\u7684\u6bd4\u55bb<\/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\">\u6c92\u6709\u5206\u7247\uff1a\n\u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510\n\u2502 \u5168\u6821 3000 \u500b\u5b78\u751f\u7684\u8cc7\u6599      \u2502\n\u2502 \u5168\u90e8\u653e\u5728\u4e00\u500b\u6a94\u6848\u6ac3\u88e1        \u2502  \u2190 \u627e\u8cc7\u6599\u5f88\u6162\n\u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518\n\n\u6709\u5206\u7247\uff1a\n\u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510 \u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510 \u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510\n\u2502 A ~ H \u59d3\u6c0f\u2502 \u2502 I ~ P \u59d3\u6c0f\u2502 \u2502 Q ~ Z \u59d3\u6c0f\u2502\n\u2502 1000 \u4eba   \u2502 \u2502 1000 \u4eba   \u2502 \u2502 1000 \u4eba   \u2502\n\u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518 \u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518 \u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518\n  Shard 1       Shard 2       Shard 3\n                                \u2190 \u6bcf\u500b\u6ac3\u5b50\u53ea\u9700\u8981\u7ffb 1\/3 \u7684\u8cc7\u6599\n<\/code><\/span><\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">\u4e09\u7a2e\u5206\u7247\u7b56\u7565<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>1. Range-based\uff08\u7bc4\u570d\u5206\u7247\uff09<\/strong><\/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\">\u6309 user_id \u7684\u7bc4\u570d\u5207\uff1a\n\nShard 1: user_id 1 ~ 1,000,000\nShard 2: user_id 1,000,001 ~ 2,000,000\nShard 3: user_id 2,000,001 ~ 3,000,000\n<\/code><\/span><\/pre><\/div>\n\n\n<ul class=\"wp-block-list\">\n\n<li><strong>\u512a\u9ede<\/strong>\uff1a\u76f4\u89ba\uff0c\u7bc4\u570d\u67e5\u8a62\u6548\u7387\u9ad8\uff08\u4f8b\u5982\u300c\u627e id 100~200 \u7684\u4f7f\u7528\u8005\u300d\uff09<\/li>\n\n\n<li><strong>\u7f3a\u9ede<\/strong>\uff1a\u5bb9\u6613\u4e0d\u5747\u52fb\u3002\u5982\u679c\u65b0\u8a3b\u518a\u7684\u4f7f\u7528\u8005\u6bd4\u8f03\u6d3b\u8e8d\uff0cShard 3 \u7684\u6d41\u91cf\u6703\u9060\u5927\u65bc Shard 1<\/li>\n\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>2. Hash-based\uff08\u96dc\u6e4a\u5206\u7247\uff09<\/strong><\/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\">hash(user_id) % \u5206\u7247\u6578 = \u8981\u653e\u5230\u54ea\u500b\u5206\u7247\n\nhash(12345) % 3 = 0  \u2192 Shard 1\nhash(67890) % 3 = 1  \u2192 Shard 2\nhash(11111) % 3 = 2  \u2192 Shard 3\n<\/code><\/span><\/pre><\/div>\n\n\n<ul class=\"wp-block-list\">\n\n<li><strong>\u512a\u9ede<\/strong>\uff1a\u8cc7\u6599\u5206\u4f48\u5747\u52fb<\/li>\n\n\n<li><strong>\u7f3a\u9ede<\/strong>\uff1a\u7bc4\u570d\u67e5\u8a62\u8b8a\u56f0\u96e3\uff08id 100~200 \u7684\u4f7f\u7528\u8005\u53ef\u80fd\u6563\u843d\u5728\u4e0d\u540c\u5206\u7247\uff09\uff0c\u589e\u6e1b\u5206\u7247\u6642\u9700\u8981\u5927\u91cf\u8cc7\u6599\u642c\u9077<\/li>\n\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>3. Directory-based\uff08\u76ee\u9304\u5206\u7247\uff09<\/strong><\/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\">\u7dad\u8b77\u4e00\u500b\u5c0d\u7167\u8868\uff1a\n\n\u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510\n\u2502 user_id  \u2502  shard  \u2502\n\u251c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2524\n\u2502 12345    \u2502 Shard 2 \u2502\n\u2502 67890    \u2502 Shard 1 \u2502\n\u2502 11111    \u2502 Shard 3 \u2502\n\u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518\n\n\u67e5\u8a62\u6642\u5148\u67e5\u5c0d\u7167\u8868\uff0c\u518d\u53bb\u5c0d\u61c9\u7684\u5206\u7247\u627e\u8cc7\u6599\n<\/code><\/span><\/pre><\/div>\n\n\n<ul class=\"wp-block-list\">\n\n<li><strong>\u512a\u9ede<\/strong>\uff1a\u6700\u9748\u6d3b\uff0c\u53ef\u4ee5\u96a8\u610f\u8abf\u6574<\/li>\n\n\n<li><strong>\u7f3a\u9ede<\/strong>\uff1a\u5c0d\u7167\u8868\u672c\u8eab\u6210\u70ba\u74f6\u9838\u548c\u55ae\u9ede\u6545\u969c<\/li>\n\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\u4e09\u7a2e\u7b56\u7565\u6bd4\u4e00\u6bd4<\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>\u7b56\u7565<\/th>\n<th>\u5206\u4f48\u5747\u52fb\u5ea6<\/th>\n<th>\u7bc4\u570d\u67e5\u8a62<\/th>\n<th>\u9748\u6d3b\u5ea6<\/th>\n<th>\u8907\u96dc\u5ea6<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>Range-based<\/td>\n<td>\u53ef\u80fd\u4e0d\u5747<\/td>\n<td>\u5f88\u597d<\/td>\n<td>\u4e2d<\/td>\n<td>\u4f4e<\/td>\n<\/tr>\n<tr>\n<td>Hash-based<\/td>\n<td>\u5747\u52fb<\/td>\n<td>\u4e0d\u597d<\/td>\n<td>\u4f4e<\/td>\n<td>\u4e2d<\/td>\n<\/tr>\n<tr>\n<td>Directory-based<\/td>\n<td>\u53ef\u63a7<\/td>\n<td>\u4f9d\u8a2d\u8a08<\/td>\n<td>\u9ad8<\/td>\n<td>\u9ad8<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">\u5206\u7247\u7684\u6311\u6230<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u5206\u7247\u4e0d\u662f\u514d\u8cbb\u7684\u5348\u9910\uff0c\u5b83\u5e36\u4f86\u9019\u4e9b\u554f\u984c\uff1a<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>1. \u8de8\u5206\u7247\u67e5\u8a62\uff08Cross-shard Query\uff09<\/strong><\/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\">\u300c\u627e\u51fa\u6240\u6709\u8d85\u904e 30 \u6b72\u7684\u4f7f\u7528\u8005\u300d\n\n\u6c92\u5206\u7247\uff1a\u4e00\u689d SQL \u641e\u5b9a\n\u6709\u5206\u7247\uff1a\u8981\u5c0d\u6bcf\u500b\u5206\u7247\u90fd\u67e5\u4e00\u6b21\uff0c\u518d\u628a\u7d50\u679c\u5408\u4f75\n\nShard 1 \u2192 \u67e5\u8a62 \u2192 \u7d50\u679c A\nShard 2 \u2192 \u67e5\u8a62 \u2192 \u7d50\u679c B    \u2192 \u5408\u4f75 \u2192 \u6700\u7d42\u7d50\u679c\nShard 3 \u2192 \u67e5\u8a62 \u2192 \u7d50\u679c C\n<\/code><\/span><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>2. \u8cc7\u6599\u91cd\u65b0\u5e73\u8861\uff08Rebalancing\uff09<\/strong><\/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=\"CSS\" data-shcb-language-slug=\"css\"><span><code class=\"hljs language-css\">\u539f\u672c 3 \u500b\u5206\u7247\uff0c\u73fe\u5728\u8981\u64f4\u5c55\u5230 5 \u500b\uff1a\n\n\u820a\uff1a<span class=\"hljs-selector-attr\">&#91;Shard 1]<\/span> <span class=\"hljs-selector-attr\">&#91;Shard 2]<\/span> <span class=\"hljs-selector-attr\">&#91;Shard 3]<\/span>\n\u65b0\uff1a<span class=\"hljs-selector-attr\">&#91;Shard 1]<\/span> <span class=\"hljs-selector-attr\">&#91;Shard 2]<\/span> <span class=\"hljs-selector-attr\">&#91;Shard 3]<\/span> <span class=\"hljs-selector-attr\">&#91;Shard 4]<\/span> <span class=\"hljs-selector-attr\">&#91;Shard 5]<\/span>\n\n\u9700\u8981\u628a\u90e8\u5206\u8cc7\u6599\u5f9e\u820a\u5206\u7247\u642c\u5230\u65b0\u5206\u7247\uff0c\n\u642c\u9077\u671f\u9593\u7cfb\u7d71\u9084\u8981\u7e7c\u7e8c\u904b\u4f5c \u2192 \u975e\u5e38\u8907\u96dc\n<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-3\"><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<p class=\"wp-block-paragraph\"><strong>3. \u8de8\u5206\u7247\u7684 JOIN \u64cd\u4f5c<\/strong><\/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\">\u300c\u627e\u51fa\u4f7f\u7528\u8005\u548c\u4ed6\u7684\u8a02\u55ae\u300d\n\n\u5982\u679c User \u5728 Shard 1\uff0cOrder \u5728 Shard 3\uff1a\n\u2192 \u7121\u6cd5\u7528\u4e00\u822c\u7684 SQL JOIN\n\u2192 \u9700\u8981\u5728\u61c9\u7528\u5c64\u81ea\u5df1\u5408\u4f75\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\">\u8907\u88fd\uff08Replication\uff09\uff1a\u540c\u6a23\u7684\u8cc7\u6599\uff0c\u591a\u5b58\u5e7e\u4efd<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u5206\u7247\u662f\u628a\u8cc7\u6599\u300c\u5207\u958b\u300d\uff0c\u8907\u88fd\u662f\u628a\u8cc7\u6599\u300c\u8907\u88fd\u300d\u3002\u5169\u8005\u89e3\u6c7a\u4e0d\u540c\u554f\u984c\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\">\u5206\u7247\uff08Sharding\uff09\uff1a\u8cc7\u6599 A \u5728\u6a5f\u5668 1\uff0c\u8cc7\u6599 B \u5728\u6a5f\u5668 2  \u2192 \u89e3\u6c7a\u300c\u8cc7\u6599\u91cf\u592a\u5927\u300d\n\u8907\u88fd\uff08Replication\uff09\uff1a\u8cc7\u6599 A \u5728\u6a5f\u5668 1\uff0c\u8cc7\u6599 A \u4e5f\u5728\u6a5f\u5668 2  \u2192 \u89e3\u6c7a\u300c\u8b80\u53d6\u592a\u6162\u300d\u548c\u300c\u53ef\u9760\u6027\u300d\n<\/code><\/span><\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">\u4e3b\u5f9e\u67b6\u69cb\uff08Primary-Replica\uff09<\/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\">                    \u5beb\u5165\n\u4f7f\u7528\u8005 \u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2192 \u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510\n                    \u2502  Primary \u2502 \u2500\u2500\u2500\u2500 \u540c\u6b65 \u2500\u2500\u2500\u2500\u2192 \u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510\n                    \u2502 \uff08\u4e3b\u5eab\uff09  \u2502                  \u2502 Replica 1\u2502\n                    \u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518 \u2500\u2500\u2500\u2500 \u540c\u6b65 \u2500\u2500\u2500\u2500\u2192 \u2502 \uff08\u5f9e\u5eab\uff09  \u2502\n                                                  \u251c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2524\n\u4f7f\u7528\u8005 \u2190\u2500\u2500 \u8b80\u53d6 \u2500\u2500\u2500 Replica 1                    \u2502 Replica 2\u2502\n\u4f7f\u7528\u8005 \u2190\u2500\u2500 \u8b80\u53d6 \u2500\u2500\u2500 Replica 2                    \u2502 \uff08\u5f9e\u5eab\uff09  \u2502\n                                                  \u2514\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>\u6838\u5fc3\u539f\u5247<\/strong>\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n\n<li><strong>\u5beb\u5165<\/strong>\uff1a\u53ea\u5beb\u5230\u4e3b\u5eab\uff08Primary\uff09<\/li>\n\n\n<li><strong>\u8b80\u53d6<\/strong>\uff1a\u5f9e\u4efb\u4f55\u4e00\u500b\u5f9e\u5eab\uff08Replica\uff09\u8b80<\/li>\n\n\n<li><strong>\u540c\u6b65<\/strong>\uff1a\u4e3b\u5eab\u7684\u8b8a\u66f4\u6703\u540c\u6b65\u5230\u6240\u6709\u5f9e\u5eab<\/li>\n\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">\u8b80\u5beb\u5206\u96e2\uff1a\u70ba\u4ec0\u9ebc\u6709\u7528\uff1f<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u5927\u90e8\u5206\u61c9\u7528\u7684\u8b80\u5beb\u6bd4\u4f8b\u5927\u7d04\u662f <strong>80% \u8b80\u300120% \u5beb<\/strong>\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\">\u6c92\u6709\u8b80\u5beb\u5206\u96e2\uff1a\n\u6240\u6709\u8b80 + \u6240\u6709\u5beb \u2192 1 \u53f0 DB \u2192 \u625b\u4e0d\u4f4f\n\n\u6709\u8b80\u5beb\u5206\u96e2\uff1a\n\u6240\u6709\u5beb \u2192 Primary\uff081 \u53f0\uff09\n\u6240\u6709\u8b80 \u2192 Replica\uff083 \u53f0\u5206\u6524\uff09  \u2192 \u8b80\u53d6\u80fd\u529b\u63d0\u5347 3 \u500d\n<\/code><\/span><\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">\u9019\u5c31\u662f\u70ba\u4ec0\u9ebc\u8907\u88fd\u53ef\u4ee5\u5927\u5e45\u63d0\u5347\u6548\u80fd \u2014 \u56e0\u70ba\u300c\u8b80\u300d\u7684\u58d3\u529b\u5206\u6563\u5230\u4e86\u591a\u53f0\u6a5f\u5668\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">\u540c\u6b65 vs \u975e\u540c\u6b65\u8907\u88fd<\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>\u540c\u6b65\u8907\u88fd<\/th>\n<th>\u975e\u540c\u6b65\u8907\u88fd<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><strong>\u505a\u6cd5<\/strong><\/td>\n<td>\u4e3b\u5eab\u7b49\u6240\u6709\u5f9e\u5eab\u78ba\u8a8d\u624d\u56de\u8986\u300c\u6210\u529f\u300d<\/td>\n<td>\u4e3b\u5eab\u5beb\u5b8c\u7acb\u523b\u56de\u8986\u300c\u6210\u529f\u300d\uff0c\u80cc\u666f\u540c\u6b65<\/td>\n<\/tr>\n<tr>\n<td><strong>\u901f\u5ea6<\/strong><\/td>\n<td>\u8f03\u6162\uff08\u8981\u7b49\uff09<\/td>\n<td>\u8f03\u5feb\uff08\u4e0d\u7b49\uff09<\/td>\n<\/tr>\n<tr>\n<td><strong>\u4e00\u81f4\u6027<\/strong><\/td>\n<td>\u5f37\u4e00\u81f4\uff08\u5f9e\u5eab\u6c38\u9060\u6700\u65b0\uff09<\/td>\n<td>\u6700\u7d42\u4e00\u81f4\uff08\u5f9e\u5eab\u53ef\u80fd\u77ed\u66ab\u843d\u5f8c\uff09<\/td>\n<\/tr>\n<tr>\n<td><strong>\u9069\u5408<\/strong><\/td>\n<td>\u91d1\u878d\u3001\u8a02\u55ae\u7b49\u4e0d\u80fd\u51fa\u932f\u7684\u5834\u666f<\/td>\n<td>\u793e\u7fa4\u52d5\u614b\u3001\u6587\u7ae0\u700f\u89bd\u6578\u7b49\u5141\u8a31\u77ed\u66ab\u5ef6\u9072\u7684\u5834\u666f<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\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\">\u540c\u6b65\u8907\u88fd\u7684\u6642\u9593\u7dda\uff1a\nClient \u2192 Primary\uff08\u5beb\u5165\uff09 \u2192 Replica 1\uff08\u78ba\u8a8d\uff09 \u2192 Replica 2\uff08\u78ba\u8a8d\uff09 \u2192 \u56de\u8986 Client \u2705\n                                                                      \u2191 \u5168\u90e8\u78ba\u8a8d\u624d\u56de\u8986\n\n\u975e\u540c\u6b65\u8907\u88fd\u7684\u6642\u9593\u7dda\uff1a\nClient \u2192 Primary\uff08\u5beb\u5165\uff09 \u2192 \u56de\u8986 Client \u2705\n                          \u2193\uff08\u80cc\u666f\u6162\u6162\u540c\u6b65\uff09\n                     Replica 1... Replica 2...\n                                  \u2191 \u53ef\u80fd\u6709\u5e7e\u6beb\u79d2\u5230\u5e7e\u79d2\u7684\u5ef6\u9072\n<\/code><\/span><\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">\u5fc5\u770b\u61c2 vs \u77e5\u9053\u5c31\u597d<\/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\">\u2705 \u5fc5\u770b\u61c2\uff1a\n- \u4e3b\u5f9e\u67b6\u69cb\uff1a\u4e00\u53f0\u5beb\uff0c\u591a\u53f0\u8b80\n- \u8b80\u5beb\u5206\u96e2\uff1a\u8b80\u591a\u5beb\u5c11\u6642\u6548\u679c\u6700\u597d\n- \u540c\u6b65 vs \u975e\u540c\u6b65\uff1a\u901f\u5ea6\u548c\u4e00\u81f4\u6027\u7684\u53d6\u6368\n\n\ud83d\udccc \u77e5\u9053\u5c31\u597d\uff1a\n- Multi-Primary\uff08\u591a\u4e3b\u67b6\u69cb\uff09\uff1a\u591a\u53f0\u90fd\u80fd\u5beb\uff0c\u885d\u7a81\u8655\u7406\u66f4\u8907\u96dc\n- \u534a\u540c\u6b65\u8907\u88fd\uff08Semi-synchronous\uff09\uff1a\u53ea\u7b49\u4e00\u53f0\u5f9e\u5eab\u78ba\u8a8d\n- \u6545\u969c\u8f49\u79fb\uff08Failover\uff09\uff1a\u4e3b\u5eab\u639b\u4e86\uff0c\u81ea\u52d5\u8b93\u5f9e\u5eab\u5347\u7d1a\u70ba\u4e3b\u5eab\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\">\u5206\u7247 + \u8907\u88fd\uff1a\u5be6\u6230\u4e2d\u7684\u7d44\u5408\u6280<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u771f\u5be6\u4e16\u754c\u4e0d\u6703\u53ea\u7528\u4e00\u7a2e\u7b56\u7565\u3002\u5206\u7247\u548c\u8907\u88fd\u901a\u5e38\u4e00\u8d77\u4f7f\u7528\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\">\u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510\n\u2502                  \u61c9\u7528\u7a0b\u5f0f                  \u2502\n\u2502                    \u2502                      \u2502\n\u2502         \u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510           \u2502\n\u2502         \u25bc                    \u25bc            \u2502\n\u2502   \u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510        \u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510       \u2502\n\u2502   \u2502 Shard 1  \u2502        \u2502 Shard 2  \u2502       \u2502\n\u2502   \u2502 (A ~ M)  \u2502        \u2502 (N ~ Z)  \u2502       \u2502\n\u2502   \u2514\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2518        \u2514\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2518       \u2502\n\u2502   \u250c\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2510        \u250c\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2510       \u2502\n\u2502   \u2502 Primary  \u2502        \u2502 Primary  \u2502       \u2502\n\u2502   \u2502 Replica1 \u2502        \u2502 Replica1 \u2502       \u2502\n\u2502   \u2502 Replica2 \u2502        \u2502 Replica2 \u2502       \u2502\n\u2502   \u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518        \u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518       \u2502\n\u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518\n\n\u6bcf\u500b\u5206\u7247\u90fd\u6709\u81ea\u5df1\u7684\u4e3b\u5f9e\u67b6\u69cb\n\u2192 \u540c\u6642\u89e3\u6c7a\u300c\u8cc7\u6599\u91cf\u5927\u300d\u548c\u300c\u8b80\u53d6\u591a\u300d\u7684\u554f\u984c\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\">Vibe Coder \u6aa2\u67e5\u9ede<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u7576\u4f60\u5728\u770b\u7cfb\u7d71\u67b6\u69cb\u5716\u6216\u8b80\u7a0b\u5f0f\u78bc\u6642\uff0c\u770b\u5230\u8cc7\u6599\u5eab\u76f8\u95dc\u7684\u8a2d\u8a08\uff0c\u78ba\u8a8d\u4ee5\u4e0b\u5e7e\u9ede\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n\n<li>[ ] \u770b\u5230\u300cTransaction\u300d\u6216\u300c\u4ea4\u6613\u300d\u2192 \u60f3\u5230 ACID\uff0c\u9019\u6bb5\u64cd\u4f5c\u662f\u5426\u9700\u8981\u5168\u505a\u6216\u5168\u4e0d\u505a\uff1f<\/li>\n\n\n<li>[ ] \u770b\u5230\u8cc7\u6599\u5eab\u9023\u7dda\u8a2d\u5b9a\u6709\u591a\u500b host \u2192 \u53ef\u80fd\u662f\u8b80\u5beb\u5206\u96e2\uff0c\u4e3b\u5eab\u5beb\u3001\u5f9e\u5eab\u8b80<\/li>\n\n\n<li>[ ] \u770b\u5230 <code>shard_key<\/code> \u6216 <code>partition<\/code> \u2192 \u6b63\u5728\u505a\u5206\u7247\uff0c\u6ce8\u610f\u8de8\u5206\u7247\u67e5\u8a62\u7684\u9650\u5236<\/li>\n\n\n<li>[ ] \u770b\u5230 <code>read_replica<\/code> \u6216 <code>readonly<\/code> \u7684\u9023\u7dda \u2192 \u8b80\u5beb\u5206\u96e2\uff0c\u9019\u4e9b\u9023\u7dda\u53ea\u80fd\u8b80<\/li>\n\n\n<li>[ ] \u770b\u5230\u300ceventually consistent\u300d\u2192 \u7528\u7684\u662f\u975e\u540c\u6b65\u8907\u88fd\uff0c\u8cc7\u6599\u53ef\u80fd\u6709\u77ed\u66ab\u5ef6\u9072<\/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\">\u7cfb\u5217\u7e3d\u7d50\uff1a\u4e94\u7bc7\u4e32\u6210\u4e00\u5f35\u77e5\u8b58\u5730\u5716<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">\u606d\u559c\u4f60\u8d70\u5230\u4e86\u7cfb\u5217\u6700\u7d42\u7bc7\u3002\u8b93\u6211\u5011\u628a\u4e94\u7bc7\u6587\u7ae0\u4e32\u8d77\u4f86\uff0c\u770b\u770b\u6574\u500b\u7cfb\u7d71\u8a2d\u8a08\u7684\u5168\u8c8c\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-4\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">\u4f7f\u7528\u8005\u767c\u51fa\u8acb\u6c42\n     \u2502\n     \u25bc\n \u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510\n \u2502  <span class=\"hljs-comment\">#01 \u786c\u9ad4\u8207\u4f5c\u696d\u7cfb\u7d71\u57fa\u790e               \u2502<\/span>\n \u2502  CPU\u3001\u8a18\u61b6\u9ad4\u3001\u786c\u789f\u3001\u7a0b\u5e8f\u8207\u57f7\u884c\u7dd2       \u2502\n \u2502  \u2192 \u7406\u89e3\u300c\u96fb\u8166\u600e\u9ebc\u8dd1\u7a0b\u5f0f\u300d              \u2502\n \u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518\n                 \u2502 \u8acb\u6c42\u900f\u904e\u7db2\u8def\u50b3\u9001\n                 \u25bc\n \u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510\n \u2502  <span class=\"hljs-comment\">#02 \u7db2\u8def\u57fa\u790e\u8207 DNS                   \u2502<\/span>\n \u2502  IP\u3001TCP\/UDP\u3001DNS \u89e3\u6790                \u2502\n \u2502  \u2192 \u7406\u89e3\u300c\u8acb\u6c42\u600e\u9ebc\u5230\u9054\u4f3a\u670d\u5668\u300d          \u2502\n \u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518\n                 \u2502 \u4f3a\u670d\u5668\u6536\u5230\u8acb\u6c42\n                 \u25bc\n \u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510\n \u2502  <span class=\"hljs-comment\">#03 API \u8207\u901a\u8a0a\u5354\u5b9a                   \u2502<\/span>\n \u2502  HTTP\u3001REST\u3001GraphQL\u3001WebSocket       \u2502\n \u2502  \u2192 \u7406\u89e3\u300c\u524d\u5f8c\u7aef\u600e\u9ebc\u6e9d\u901a\u300d              \u2502\n \u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518\n                 \u2502 \u8981\u8655\u7406\u5927\u91cf\u8acb\u6c42\n                 \u25bc\n \u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510\n \u2502  <span class=\"hljs-comment\">#04 \u5feb\u53d6\u3001CDN \u8207\u6d41\u91cf\u7ba1\u7406              \u2502<\/span>\n \u2502  \u5feb\u53d6\u7b56\u7565\u3001CDN\u3001\u8ca0\u8f09\u5747\u8861               \u2502\n \u2502  \u2192 \u7406\u89e3\u300c\u600e\u9ebc\u8b93\u7cfb\u7d71\u66f4\u5feb\u66f4\u7a69\u300d          \u2502\n \u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u252c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518\n                 \u2502 \u8cc7\u6599\u8981\u5b58\u8d77\u4f86\n                 \u25bc\n \u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510\n \u2502  <span class=\"hljs-comment\">#05 \u8cc7\u6599\u5eab\u8a2d\u8a08\u8207\u64f4\u5c55\u7b56\u7565\uff08\u672c\u7bc7\uff09      \u2502<\/span>\n \u2502  ACID\u3001\u5206\u7247\u3001\u8907\u88fd\u3001\u8b80\u5beb\u5206\u96e2            \u2502\n \u2502  \u2192 \u7406\u89e3\u300c\u600e\u9ebc\u5b89\u5168\u53c8\u5feb\u901f\u5730\u5b58\u53d6\u8cc7\u6599\u300d    \u2502\n \u2514\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2518\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\">\u95dc\u9375\u6982\u5ff5\u4e00\u89bd\u8868<\/h3>\n\n\n\n<figure class=\"wp-block-table\"><table>\n<thead>\n<tr>\n<th>\u7bc7\u7ae0<\/th>\n<th>\u6838\u5fc3\u554f\u984c<\/th>\n<th>\u95dc\u9375\u6982\u5ff5<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>#01 \u786c\u9ad4\u57fa\u790e<\/td>\n<td>\u96fb\u8166\u600e\u9ebc\u8dd1\u7a0b\u5f0f\uff1f<\/td>\n<td>CPU\u3001RAM\u3001\u7a0b\u5e8f\u3001\u57f7\u884c\u7dd2<\/td>\n<\/tr>\n<tr>\n<td>#02 \u7db2\u8def\u57fa\u790e<\/td>\n<td>\u8acb\u6c42\u600e\u9ebc\u5230\u9054\u4f3a\u670d\u5668\uff1f<\/td>\n<td>IP\u3001TCP\u3001DNS<\/td>\n<\/tr>\n<tr>\n<td>#03 API \u5354\u5b9a<\/td>\n<td>\u524d\u5f8c\u7aef\u600e\u9ebc\u6e9d\u901a\uff1f<\/td>\n<td>REST\u3001GraphQL\u3001WebSocket<\/td>\n<\/tr>\n<tr>\n<td>#04 \u6548\u80fd\u512a\u5316<\/td>\n<td>\u600e\u9ebc\u8b93\u7cfb\u7d71\u66f4\u5feb\u66f4\u7a69\uff1f<\/td>\n<td>\u5feb\u53d6\u3001CDN\u3001\u8ca0\u8f09\u5747\u8861<\/td>\n<\/tr>\n<tr>\n<td>#05 \u8cc7\u6599\u5c64<\/td>\n<td>\u600e\u9ebc\u5b89\u5168\u5feb\u901f\u5b58\u53d6\u8cc7\u6599\uff1f<\/td>\n<td>ACID\u3001\u5206\u7247\u3001\u8907\u88fd<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">\u4e0b\u4e00\u6b65\u600e\u9ebc\u8d70\uff1f<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">\u9019\u4e94\u7bc7\u6db5\u84cb\u4e86\u7cfb\u7d71\u8a2d\u8a08\u7684\u57fa\u790e\u77e5\u8b58\u3002\u5982\u679c\u4f60\u60f3\u7e7c\u7e8c\u6df1\u5165\uff0c\u53ef\u4ee5\u5f80\u9019\u4e9b\u65b9\u5411\u63a2\u7d22\uff1a<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n\n<li><strong>\u8a0a\u606f\u4f47\u5217\uff08Message Queue\uff09<\/strong>\uff1a\u7cfb\u7d71\u4e4b\u9593\u7684\u975e\u540c\u6b65\u6e9d\u901a<\/li>\n\n\n<li><strong>\u5fae\u670d\u52d9\u67b6\u69cb\uff08Microservices\uff09<\/strong>\uff1a\u628a\u4e00\u500b\u5927\u7cfb\u7d71\u62c6\u6210\u591a\u500b\u5c0f\u670d\u52d9<\/li>\n\n\n<li><strong>\u5206\u6563\u5f0f\u7cfb\u7d71\u7684\u53d6\u6368\uff08CAP \u5b9a\u7406\uff09<\/strong>\uff1a\u4e00\u81f4\u6027\u3001\u53ef\u7528\u6027\u3001\u5206\u5340\u5bb9\u932f\u4e0d\u53ef\u517c\u5f97<\/li>\n\n\n<li><strong>\u76e3\u63a7\u8207\u53ef\u89c0\u6e2c\u6027\uff08Observability\uff09<\/strong>\uff1a\u600e\u9ebc\u77e5\u9053\u7cfb\u7d71\u662f\u5426\u5065\u5eb7<\/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\">\u672c\u7bc7\u91cd\u9ede\u56de\u9867<\/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\u7e3d\u7d50<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>ACID<\/td>\n<td>\u8cc7\u6599\u5eab\u7684\u56db\u5927\u5b89\u5168\u4fdd\u8b49\uff1a\u5168\u505a\u6216\u5168\u4e0d\u505a\u3001\u8cc7\u6599\u5408\u7406\u3001\u4ea4\u6613\u4e0d\u5e72\u64fe\u3001\u5beb\u4e86\u4e0d\u4e1f<\/td>\n<\/tr>\n<tr>\n<td>\u5782\u76f4\u64f4\u5c55<\/td>\n<td>\u63db\u66f4\u597d\u7684\u6a5f\u5668\uff0c\u7c21\u55ae\u4f46\u6709\u4e0a\u9650<\/td>\n<\/tr>\n<tr>\n<td>\u6c34\u5e73\u64f4\u5c55<\/td>\n<td>\u52a0\u66f4\u591a\u6a5f\u5668\uff0c\u7121\u4e0a\u9650\u4f46\u8907\u96dc<\/td>\n<\/tr>\n<tr>\n<td>\u5206\u7247<\/td>\n<td>\u628a\u8cc7\u6599\u5207\u5230\u591a\u53f0\u6a5f\u5668\uff0c\u89e3\u6c7a\u8cc7\u6599\u91cf\u592a\u5927\u7684\u554f\u984c<\/td>\n<\/tr>\n<tr>\n<td>\u8907\u88fd<\/td>\n<td>\u540c\u6a23\u7684\u8cc7\u6599\u591a\u5b58\u5e7e\u4efd\uff0c\u89e3\u6c7a\u8b80\u53d6\u592a\u6162\u548c\u53ef\u9760\u6027\u7684\u554f\u984c<\/td>\n<\/tr>\n<tr>\n<td>\u8b80\u5beb\u5206\u96e2<\/td>\n<td>\u4e3b\u5eab\u8ca0\u8cac\u5beb\u3001\u5f9e\u5eab\u8ca0\u8cac\u8b80\uff0c\u9069\u5408\u8b80\u591a\u5beb\u5c11\u7684\u5834\u666f<\/td>\n<\/tr>\n<\/tbody>\n<\/table><\/figure>\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\u7d71\u8a2d\u8a08\u4e0d\u662f\u80cc\u8aa6\u7b54\u6848\uff0c\u800c\u662f\u7406\u89e3\u6bcf\u500b\u9078\u64c7\u80cc\u5f8c\u7684\u53d6\u6368\u3002\u6c92\u6709\u5b8c\u7f8e\u7684\u67b6\u69cb\uff0c\u53ea\u6709\u9069\u5408\u7576\u524d\u9700\u6c42\u7684\u67b6\u69cb\u3002<\/p>\n<\/blockquote>\n\n\n\n<div id=\"quiz-3e7a8c58\">\n<style>\n#quiz-3e7a8c58 .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-3e7a8c58 .badge.scenario {\n        background: #ebf8ff;\n        color: #2b6cb0;\n      }#quiz-3e7a8c58 .badge.debug {\n        background: #fef3c7;\n        color: #92400e;\n      }#quiz-3e7a8c58 .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-3e7a8c58 .question-adv h3 {\n        margin-top: 0;\n        color: #2d3748;\n      }#quiz-3e7a8c58 .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-3e7a8c58 .options-adv {\n        list-style: none;\n        padding: 0;\n      }#quiz-3e7a8c58 .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-3e7a8c58 .options-adv li:hover:not(.disabled) {\n        border-color: #ed8936;\n        background: #fffaf0;\n      }#quiz-3e7a8c58 .options-adv li.disabled {\n        cursor: default;\n        opacity: 0.7;\n      }#quiz-3e7a8c58 .options-adv li.show-answer {\n        border-color: #48bb78;\n        background: #f0fff4;\n      }#quiz-3e7a8c58 .options-adv li.wrong {\n        border-color: #fc8181;\n        background: #fff5f5;\n      }#quiz-3e7a8c58 .feedback-adv {\n        margin-top: 16px;\n        padding: 14px;\n        border-radius: 8px;\n        display: none;\n        line-height: 1.6;\n      }#quiz-3e7a8c58 .feedback-adv.correct {\n        background: #f0fff4;\n        color: #276749;\n        display: block;\n      }#quiz-3e7a8c58 .feedback-adv.wrong {\n        background: #fff5f5;\n        color: #c53030;\n        display: block;\n      }#quiz-3e7a8c58 .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-3e7a8c58 .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\u8a2d\u8a08\u8207\u64f4\u5c55\u7b56\u7565 \u2014 \u5206\u7247\u3001\u8907\u88fd\u8207 ACID<\/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\u6b63\u5728\u8a2d\u8a08\u4e00\u500b\u793e\u7fa4\u5a92\u9ad4\u5e73\u53f0\u7684\u8cc7\u6599\u5eab\u67b6\u69cb\u3002\u76ee\u524d\u4f7f\u7528\u8005\u6709 500 \u842c\u4eba\uff0c\u9810\u8a08\u4e00\u5e74\u5167\u6210\u9577\u5230 5000 \u842c\u4eba\u3002\u8b80\u53d6\u6d41\u91cf\u9060\u5927\u65bc\u5beb\u5165\uff08\u7d04 90% \u8b80\u300110% \u5beb\uff09\uff0c\u4f46\u55ae\u53f0\u8cc7\u6599\u5eab\u5df2\u7d93\u6490\u4e0d\u4f4f\u4e86\u3002\u4f60\u7684\u7b2c\u4e00\u6b65\u64f4\u5c55\u7b56\u7565\u61c9\u8a72\u662f\u4ec0\u9ebc\uff1f <span class=\"badge scenario\">\u60c5\u5883\u984c<\/span><\/h3>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(1, 'A', 'B')\">A. \u76f4\u63a5\u5c0d\u8cc7\u6599\u505a\u5206\u7247\uff08Sharding\uff09\uff0c\u5c07\u4f7f\u7528\u8005\u8cc7\u6599\u5207\u5206\u5230\u591a\u53f0\u6a5f\u5668<\/li>\n        <li onclick=\"checkAnswerAdv(1, 'B', 'B')\">B. \u5148\u505a\u8cc7\u6599\u5eab\u8907\u88fd\uff08Replication\uff09\u52a0\u8b80\u5beb\u5206\u96e2\uff0c\u7528\u5f9e\u5eab\u5206\u6524\u8b80\u53d6\u58d3\u529b<\/li>\n        <li onclick=\"checkAnswerAdv(1, 'C', 'B')\">C. \u5782\u76f4\u64f4\u5c55\uff0c\u76f4\u63a5\u628a\u4f3a\u670d\u5668\u5347\u7d1a\u5230\u6700\u9ad8\u898f\u683c<\/li>\n        <li onclick=\"checkAnswerAdv(1, 'D', 'B')\">D. \u540c\u6642\u505a\u5206\u7247\u548c\u8907\u88fd\uff0c\u4e00\u6b21\u5230\u4f4d\u907f\u514d\u4e8c\u6b21\u6539\u9020<\/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\u8ca0\u8cac\u4e00\u500b\u96fb\u5546\u5e73\u53f0\u7684\u8a02\u55ae\u8cc7\u6599\u5eab\uff0c\u76ee\u524d\u6709 3 \u5104\u7b46\u8a02\u55ae\u8cc7\u6599\u3002\u5718\u968a\u6c7a\u5b9a\u63a1\u7528\u5206\u7247\u7b56\u7565\u3002\u8a02\u55ae\u8cc7\u6599\u7684\u4e3b\u8981\u67e5\u8a62\u6a21\u5f0f\u662f\uff1a(1) \u6309\u4f7f\u7528\u8005 ID \u67e5\u8a62\u8a72\u4f7f\u7528\u8005\u7684\u6240\u6709\u8a02\u55ae (2) \u5076\u723e\u9700\u8981\u6309\u65e5\u671f\u7bc4\u570d\u67e5\u8a62\u6240\u6709\u8a02\u55ae\u3002\u4f60\u6703\u9078\u64c7\u54ea\u7a2e\u5206\u7247\u7b56\u7565\uff1f <span class=\"badge scenario\">\u60c5\u5883\u984c<\/span><\/h3>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(2, 'A', 'C')\">A. Range-based\uff0c\u6309\u8a02\u55ae\u5efa\u7acb\u65e5\u671f\u7bc4\u570d\u5206\u7247<\/li>\n        <li onclick=\"checkAnswerAdv(2, 'B', 'C')\">B. Directory-based\uff0c\u7dad\u8b77\u4e00\u5f35\u5c0d\u7167\u8868\u8a18\u9304\u6bcf\u7b46\u8a02\u55ae\u5728\u54ea\u500b\u5206\u7247<\/li>\n        <li onclick=\"checkAnswerAdv(2, 'C', 'C')\">C. Hash-based\uff0c\u6309\u4f7f\u7528\u8005 ID \u505a\u96dc\u6e4a\u5206\u7247\uff0c\u8b93\u540c\u4e00\u4f7f\u7528\u8005\u7684\u8a02\u55ae\u843d\u5728\u540c\u4e00\u5206\u7247<\/li>\n        <li onclick=\"checkAnswerAdv(2, 'D', 'C')\">D. Hash-based\uff0c\u6309\u8a02\u55ae ID \u505a\u96dc\u6e4a\u5206\u7247\uff0c\u78ba\u4fdd\u8cc7\u6599\u5747\u52fb\u5206\u4f48<\/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\u5718\u968a\u6b63\u5728\u70ba\u4e00\u500b\u7dda\u4e0a\u9280\u884c\u7cfb\u7d71\u9078\u64c7\u8cc7\u6599\u5eab\u8907\u88fd\u7b56\u7565\u3002\u7cfb\u7d71\u9700\u8981\u8655\u7406\u8f49\u5e33\u4ea4\u6613\uff0c\u5e33\u6236\u9918\u984d\u5fc5\u9808\u5373\u6642\u6e96\u78ba\u3002\u540c\u6642\uff0c\u7cfb\u7d71\u4e5f\u6709\u4e00\u500b\u5831\u8868\u529f\u80fd\uff0c\u7528\u4f86\u751f\u6210\u6bcf\u65e5\u4ea4\u6613\u7d71\u8a08\u3002\u4f60\u6703\u5982\u4f55\u8a2d\u8a08\u8907\u88fd\u67b6\u69cb\uff1f <span class=\"badge scenario\">\u60c5\u5883\u984c<\/span><\/h3>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(3, 'A', 'D')\">A. \u5168\u90e8\u4f7f\u7528\u540c\u6b65\u8907\u88fd\uff0c\u78ba\u4fdd\u6240\u6709\u8cc7\u6599\u90fd\u5f37\u4e00\u81f4<\/li>\n        <li onclick=\"checkAnswerAdv(3, 'B', 'D')\">B. \u5168\u90e8\u4f7f\u7528\u975e\u540c\u6b65\u8907\u88fd\uff0c\u63d0\u5347\u7cfb\u7d71\u56de\u61c9\u901f\u5ea6<\/li>\n        <li onclick=\"checkAnswerAdv(3, 'C', 'D')\">C. \u4e0d\u505a\u8907\u88fd\uff0c\u53ea\u7528\u4e00\u53f0\u8cc7\u6599\u5eab\u78ba\u4fdd\u8cc7\u6599\u4e00\u81f4\u6027<\/li>\n        <li onclick=\"checkAnswerAdv(3, 'D', 'D')\">D. \u4ea4\u6613\u76f8\u95dc\u7528\u540c\u6b65\u8907\u88fd\u78ba\u4fdd\u9918\u984d\u7cbe\u78ba\uff0c\u5831\u8868\u67e5\u8a62\u5c0e\u5411\u975e\u540c\u6b65\u8907\u88fd\u7684\u5f9e\u5eab\u4ee5\u5206\u6563\u58d3\u529b<\/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. \u4e00\u500b\u96fb\u5546\u7db2\u7ad9\u4f7f\u7528 Hash-based \u5206\u7247\uff0c\u539f\u672c\u6709 3 \u500b\u5206\u7247\u3002\u56e0\u70ba\u696d\u52d9\u6210\u9577\uff0c\u5718\u968a\u65b0\u589e\u4e86\u7b2c 4 \u500b\u5206\u7247\uff0c\u4f46\u4e0a\u7dda\u5f8c\u767c\u73fe\u5927\u91cf\u4f7f\u7528\u8005\u67e5\u4e0d\u5230\u81ea\u5df1\u7684\u6b77\u53f2\u8a02\u55ae\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\">\u539f\u672c\uff1ahash(user_id) % 3 = \u5206\u7247\u7de8\u865f\n\u65b0\u589e\u5f8c\uff1ahash(user_id) % 4 = \u5206\u7247\u7de8\u865f\n\n\u4f8b\u5982 user_id = 12345\uff1a\n  \u539f\u672c\uff1ahash(12345) % 3 = 1  \u2192 \u8cc7\u6599\u5728 Shard 2\n  \u65b0\u589e\u5f8c\uff1ahash(12345) % 4 = 3  \u2192 \u53bb Shard 4 \u627e \u2192 \u627e\u4e0d\u5230\uff01<\/div>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(4, 'A', 'B')\">A. \u65b0\u7684\u5206\u7247\u4f3a\u670d\u5668\u786c\u9ad4\u898f\u683c\u4e0d\u540c\uff0c\u5c0e\u81f4\u96dc\u6e4a\u8a08\u7b97\u7d50\u679c\u4e0d\u4e00\u81f4<\/li>\n        <li onclick=\"checkAnswerAdv(4, 'B', 'B')\">B. \u5206\u7247\u6578\u5f9e 3 \u8b8a\u6210 4\uff0c\u96dc\u6e4a\u53d6\u9918\u7684\u7d50\u679c\u6539\u8b8a\uff0c\u5c0e\u81f4\u67e5\u8a62\u88ab\u5c0e\u5411\u932f\u8aa4\u7684\u5206\u7247\uff0c\u4f46\u8cc7\u6599\u4ecd\u5728\u820a\u5206\u7247\u4e0a<\/li>\n        <li onclick=\"checkAnswerAdv(4, 'C', 'B')\">C. \u65b0\u5206\u7247\u7684\u8cc7\u6599\u5eab\u7d22\u5f15\u5c1a\u672a\u5efa\u7acb\u5b8c\u6210<\/li>\n        <li onclick=\"checkAnswerAdv(4, 'D', 'B')\">D. \u4f7f\u7528\u8005\u7684\u9023\u7dda\u88ab\u8ca0\u8f09\u5747\u8861\u5668\u5c0e\u5411\u4e86\u932f\u8aa4\u7684\u4f3a\u670d\u5668<\/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. \u4e00\u500b\u793e\u7fa4\u5e73\u53f0\u4f7f\u7528\u4e3b\u5f9e\u8907\u88fd\u52a0\u8b80\u5beb\u5206\u96e2\u3002\u4f7f\u7528\u8005\u56de\u5831\uff1a\u300c\u6211\u525b\u767c\u4e86\u4e00\u5247\u8cbc\u6587\uff0c\u91cd\u65b0\u6574\u7406\u9801\u9762\u537b\u770b\u4e0d\u5230\uff0c\u904e\u5e7e\u79d2\u518d\u5237\u65b0\u624d\u51fa\u73fe\u3002\u300d\u7cfb\u7d71\u67b6\u69cb\u5982\u4e0b\u6240\u793a\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\">\u5beb\u5165\u8def\u5f91\uff1a\u4f7f\u7528\u8005\u767c\u6587 \u2192 Primary\uff08\u4e3b\u5eab\uff09\n\u8b80\u53d6\u8def\u5f91\uff1a\u4f7f\u7528\u8005\u5237\u65b0 \u2192 Replica\uff08\u5f9e\u5eab\uff09\n\u8907\u88fd\u6a21\u5f0f\uff1a\u975e\u540c\u6b65\u8907\u88fd<\/div>\n      <ul class=\"options-adv\">\n        <li onclick=\"checkAnswerAdv(5, 'A', 'C')\">A. Primary \u4e3b\u5eab\u7684\u5beb\u5165\u64cd\u4f5c\u5931\u6557\u4e86\uff0c\u8cc7\u6599\u6c92\u6709\u6210\u529f\u5beb\u5165<\/li>\n        <li onclick=\"checkAnswerAdv(5, 'B', 'C')\">B. \u4f7f\u7528\u8005\u7684\u700f\u89bd\u5668\u5feb\u53d6\u4e86\u820a\u9801\u9762\uff0c\u6c92\u6709\u767c\u51fa\u65b0\u7684\u8acb\u6c42<\/li>\n        <li onclick=\"checkAnswerAdv(5, 'C', 'C')\">C. \u975e\u540c\u6b65\u8907\u88fd\u6709\u5ef6\u9072\uff0c\u4f7f\u7528\u8005\u5beb\u5165\u4e3b\u5eab\u5f8c\u7acb\u5373\u5f9e\u5f9e\u5eab\u8b80\u53d6\uff0c\u4f46\u5f9e\u5eab\u5c1a\u672a\u540c\u6b65\u5230\u6700\u65b0\u8cc7\u6599<\/li>\n        <li onclick=\"checkAnswerAdv(5, 'D', 'C')\">D. ACID \u7684\u9694\u96e2\u6027\u5c0e\u81f4\u5176\u4ed6\u4f7f\u7528\u8005\u7684\u4ea4\u6613\u963b\u64cb\u4e86\u9019\u7b46\u5beb\u5165<\/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\u591a\u5beb\u5c11\u7684\u5834\u666f\uff0890% \u8b80\u300110% \u5beb\uff09\uff0c\u6700\u6709\u6548\u7684\u7b2c\u4e00\u6b65\u662f\u505a\u8cc7\u6599\u5eab\u8907\u88fd\u52a0\u8b80\u5beb\u5206\u96e2\u3002\u9019\u6a23\u53ef\u4ee5\u7528\u591a\u53f0\u5f9e\u5eab\u5206\u6524\u8b80\u53d6\u58d3\u529b\uff0c\u800c\u4e0d\u9700\u8981\u52d5\u5230\u8cc7\u6599\u7d50\u69cb\u3002\u76f4\u63a5\u5206\u7247\uff08\u9078\u9805 A\uff09\u96d6\u7136\u4e5f\u80fd\u89e3\u6c7a\u554f\u984c\uff0c\u4f46\u8907\u96dc\u5ea6\u9ad8\u5f88\u591a\uff0c\u5305\u62ec\u8de8\u5206\u7247\u67e5\u8a62\u3001\u8cc7\u6599\u91cd\u65b0\u5e73\u8861\u7b49\u6311\u6230\u3002\u5782\u76f4\u64f4\u5c55\uff08\u9078\u9805 C\uff09\u6709\u786c\u9ad4\u4e0a\u9650\u4e14\u662f\u55ae\u9ede\u6545\u969c\u3002\u4e00\u6b21\u5168\u505a\uff08\u9078\u9805 D\uff09\u9055\u53cd\u4e86\u6f38\u9032\u5f0f\u64f4\u5c55\u7684\u539f\u5247\uff0c\u589e\u52a0\u4e86\u4e0d\u5fc5\u8981\u7684\u98a8\u96aa\u3002\",\n        2: \"\u4e3b\u8981\u67e5\u8a62\u6a21\u5f0f\u662f\u300c\u6309\u4f7f\u7528\u8005 ID \u67e5\u8a72\u4f7f\u7528\u8005\u7684\u6240\u6709\u8a02\u55ae\u300d\uff0c\u56e0\u6b64\u61c9\u8a72\u7528\u4f7f\u7528\u8005 ID \u4f5c\u70ba\u5206\u7247\u9375\u3002Hash-based \u6309 user_id \u5206\u7247\u53ef\u4ee5\u78ba\u4fdd\u540c\u4e00\u4f7f\u7528\u8005\u7684\u8a02\u55ae\u90fd\u5728\u540c\u4e00\u5206\u7247\u4e0a\uff0c\u907f\u514d\u8de8\u5206\u7247\u67e5\u8a62\u3002\u9078\u9805 A \u6309\u65e5\u671f\u7bc4\u570d\u5206\u7247\u96d6\u7136\u5229\u65bc\u65e5\u671f\u67e5\u8a62\uff0c\u4f46\u540c\u4e00\u4f7f\u7528\u8005\u7684\u8a02\u55ae\u6703\u6563\u843d\u5728\u4e0d\u540c\u5206\u7247\uff0c\u4e3b\u8981\u67e5\u8a62\u6a21\u5f0f\u7684\u6548\u7387\u6703\u5f88\u5dee\u3002\u9078\u9805 B \u7684 Directory-based \u5c0d 3 \u5104\u7b46\u8cc7\u6599\u4f86\u8aaa\uff0c\u5c0d\u7167\u8868\u672c\u8eab\u5c31\u6703\u6210\u70ba\u74f6\u9838\u3002\u9078\u9805 D \u6309\u8a02\u55ae ID \u5206\u7247\u6703\u8b93\u540c\u4e00\u4f7f\u7528\u8005\u7684\u8a02\u55ae\u6563\u843d\u5404\u8655\uff0c\u6bcf\u6b21\u67e5\u4f7f\u7528\u8005\u8a02\u55ae\u90fd\u8981\u8de8\u5206\u7247\u3002\",\n        3: \"\u9019\u662f\u4e00\u500b\u9700\u8981\u6df7\u5408\u7b56\u7565\u7684\u5178\u578b\u5834\u666f\u3002\u8f49\u5e33\u4ea4\u6613\u6d89\u53ca\u91d1\u984d\uff0c\u5fc5\u9808\u7cbe\u78ba\u7121\u8aa4\uff0c\u9069\u5408\u540c\u6b65\u8907\u88fd\u78ba\u4fdd\u5f37\u4e00\u81f4\u6027\u3002\u4f46\u5831\u8868\u529f\u80fd\u662f\u7d71\u8a08\u6027\u8cea\u7684\uff0c\u5141\u8a31\u77ed\u66ab\u7684\u5ef6\u9072\uff0c\u53ef\u4ee5\u7528\u975e\u540c\u6b65\u8907\u88fd\u7684\u5f9e\u5eab\u4f86\u8655\u7406\uff0c\u9019\u6a23\u4e0d\u6703\u62d6\u6162\u4ea4\u6613\u7684\u56de\u61c9\u901f\u5ea6\u3002\u5168\u90e8\u540c\u6b65\uff08\u9078\u9805 A\uff09\u6703\u8b93\u5831\u8868\u67e5\u8a62\u62d6\u6162\u4ea4\u6613\u6548\u80fd\u3002\u5168\u90e8\u975e\u540c\u6b65\uff08\u9078\u9805 B\uff09\u7121\u6cd5\u4fdd\u8b49\u5e33\u6236\u9918\u984d\u7684\u5373\u6642\u6e96\u78ba\u3002\u4e0d\u505a\u8907\u88fd\uff08\u9078\u9805 C\uff09\u5931\u53bb\u4e86\u53ef\u9760\u6027\u548c\u8b80\u53d6\u5206\u6563\u7684\u597d\u8655\u3002\",\n        4: \"\u9019\u662f Hash-based \u5206\u7247\u589e\u6e1b\u5206\u7247\u6642\u7684\u7d93\u5178\u554f\u984c\u3002\u7576\u5206\u7247\u6578\u5f9e 3 \u8b8a\u6210 4\uff0c<code>hash(user_id) % N<\/code> \u7684 N \u6539\u8b8a\u4e86\uff0c\u5927\u90e8\u5206\u4f7f\u7528\u8005\u7684\u96dc\u6e4a\u53d6\u9918\u7d50\u679c\u90fd\u6703\u4e0d\u540c\u3002\u7cfb\u7d71\u6703\u53bb\u65b0\u8a08\u7b97\u51fa\u7684\u5206\u7247\u7de8\u865f\u627e\u8cc7\u6599\uff0c\u4f46\u8cc7\u6599\u5be6\u969b\u4e0a\u9084\u5728\u820a\u5206\u7247\u4e0a\uff0c\u6240\u4ee5\u627e\u4e0d\u5230\u3002\u9019\u5c31\u662f\u6587\u7ae0\u4e2d\u63d0\u5230\u7684\u300c\u589e\u6e1b\u5206\u7247\u6642\u9700\u8981\u5927\u91cf\u8cc7\u6599\u642c\u9077\u300d\u7684\u539f\u56e0\u3002\u6b63\u78ba\u505a\u6cd5\u662f\u5728\u5207\u63db\u524d\u5148\u5b8c\u6210\u8cc7\u6599\u91cd\u65b0\u5e73\u8861\uff08Rebalancing\uff09\uff0c\u628a\u53d7\u5f71\u97ff\u7684\u8cc7\u6599\u642c\u5230\u6b63\u78ba\u7684\u65b0\u5206\u7247\u3002\",\n        5: \"\u9019\u662f\u975e\u540c\u6b65\u8907\u88fd\u7684\u5178\u578b\u526f\u4f5c\u7528\u3002\u4f7f\u7528\u8005\u7684\u8cbc\u6587\u6210\u529f\u5beb\u5165\u4e86\u4e3b\u5eab\uff08Primary\uff09\uff0c\u4e3b\u5eab\u7acb\u5373\u56de\u8986\u6210\u529f\u3002\u4f46\u56e0\u70ba\u662f\u975e\u540c\u6b65\u8907\u88fd\uff0c\u5f9e\u5eab\uff08Replica\uff09\u53ef\u80fd\u9084\u6c92\u6536\u5230\u9019\u7b46\u65b0\u8cc7\u6599\u3002\u7576\u4f7f\u7528\u8005\u7acb\u5373\u5237\u65b0\u9801\u9762\u6642\uff0c\u8b80\u53d6\u8acb\u6c42\u88ab\u5c0e\u5411\u5f9e\u5eab\uff0c\u800c\u5f9e\u5eab\u5c1a\u672a\u540c\u6b65\uff0c\u6240\u4ee5\u770b\u4e0d\u5230\u525b\u767c\u7684\u8cbc\u6587\u3002\u904e\u5e7e\u79d2\u5f8c\u5f9e\u5eab\u5b8c\u6210\u540c\u6b65\uff0c\u518d\u5237\u65b0\u5c31\u80fd\u770b\u5230\u4e86\u3002\u9019\u5c31\u662f\u300c\u6700\u7d42\u4e00\u81f4\u6027\u300d\u7684\u8868\u73fe \u2014 \u8cc7\u6599\u6700\u7d42\u6703\u4e00\u81f4\uff0c\u4f46\u4e2d\u9593\u53ef\u80fd\u6709\u77ed\u66ab\u5ef6\u9072\u3002\u6587\u7ae0\u4e2d\u63d0\u5230\u9019\u9069\u5408\u300c\u793e\u7fa4\u52d5\u614b\u3001\u6587\u7ae0\u700f\u89bd\u6578\u7b49\u5141\u8a31\u77ed\u66ab\u5ef6\u9072\u7684\u5834\u666f\u300d\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\u8a2d\u8a08\u8207\u64f4\u5c55\u7b56\u7565 \u2014 \u5206\u7247\u3001\u8907\u88fd\u8207 ACID \u5171 5 \u984c\uff0c\u9ede\u9078\u7b54\u6848\u5f8c\u6703\u7acb\u5373\u986f\u793a\u7d50\u679c 1. ACID  [&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":[757],"tags":[746,723,781,779,780],"class_list":["post-781","post","type-post","status-publish","format-standard","hentry","category-757","tag-acid","tag-723","tag-781","tag-779","tag-780"],"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\/781","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=781"}],"version-history":[{"count":0,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/posts\/781\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/media?parent=781"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/categories?post=781"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.itsmygo.uk\/wordpress\/wp-json\/wp\/v2\/tags?post=781"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}