{"id":112466,"date":"2026-10-03T20:01:06","date_gmt":"2026-10-03T12:01:06","guid":{"rendered":"https:\/\/www.wsisp.com\/helps\/112466.html"},"modified":"2026-10-03T20:01:06","modified_gmt":"2026-10-03T12:01:06","slug":"java-%e9%a1%b9%e7%9b%ae%e5%ae%9e%e6%88%98-%e5%a4%96%e5%8d%96%e5%b9%b3%e5%8f%b0%e4%bc%98%e5%8c%96-shardingjdbc%e8%af%bb%e5%86%99%e5%88%86%e7%a6%bb%e9%85%8d%e7%bd%ae%e4%b8%8ebean%e5%ae%9a%e4%b9%89","status":"publish","type":"post","link":"https:\/\/www.wsisp.com\/helps\/112466.html","title":{"rendered":"Java \u9879\u76ee\u5b9e\u6218: \u5916\u5356\u5e73\u53f0\u4f18\u5316-ShardingJDBC\u8bfb\u5199\u5206\u79bb\u914d\u7f6e\u4e0eBean\u5b9a\u4e49\u51b2\u7a81"},"content":{"rendered":"<h2>\u8bfb\u5199\u5206\u79bb: Sharding-JDBC \u8bfb\u5199\u5206\u79bb\u914d\u7f6e\u4e0e Bean \u5b9a\u4e49\u51b2\u7a81\u89e3\u51b3<\/h2>\n<h3>\u7eb2\u8981<\/h3>\n<ul>\n<li>\u51c6\u5907\u6570\u636e\u5e93\u73af\u5883&#xff1a;\u5728\u4e3b\u5e93\u5efa rw \u5e93\u4e0e user \u8868&#xff0c;\u9760\u4e3b\u4ece\u590d\u5236\u81ea\u52a8\u540c\u6b65\u5230\u4ece\u5e93<\/li>\n<li>\u4e09\u6b65\u914d\u7f6e&#xff1a;\u5bfc\u5165\u5750\u6807 \u2192 \u914d\u7f6e application.yml \u8bfb\u5199\u5206\u79bb\u89c4\u5219 \u2192 \u52a0 allow-bean-definition-overriding<\/li>\n<li>Bean \u5b9a\u4e49\u51b2\u7a81&#xff1a;Sharding-JDBC \u4e0e Druid \u90fd\u8981\u521b\u5efa DataSource&#xff0c;\u4e3a\u4ec0\u4e48\u4f1a\u51b2\u7a81\u3001\u5982\u4f55\u89e3\u51b3<\/li>\n<li>\u9a8c\u8bc1\u8def\u7531&#xff1a;\u65ad\u70b9\u89c2\u5bdf MasterSlaveDataSource&#xff0c;\u65e5\u5fd7\u786e\u8ba4 SELECT \u8d70 slave\u3001INSERT \u8d70 master<\/li>\n<li>\u8e29\u5751&#xff1a;user \u8868 id \u7528 int \u5bfc\u81f4\u96ea\u82b1 ID \u8d8a\u754c&#xff0c;\u9700\u6539\u4e3a bigint<\/li>\n<\/ul>\n<p>#mermaid-svg-fxxxXgffTmE5sttV{font-family:\\&#8221;trebuchet ms\\&#8221;,verdana,arial,sans-serif;font-size:16px;fill:#333;}@keyframes edge-animation-frame{from{stroke-dashoffset:0;}}@keyframes dash{to{stroke-dashoffset:0;}}#mermaid-svg-fxxxXgffTmE5sttV .edge-animation-slow{stroke-dasharray:9,5!important;stroke-dashoffset:900;animation:dash 50s linear infinite;stroke-linecap:round;}#mermaid-svg-fxxxXgffTmE5sttV .edge-animation-fast{stroke-dasharray:9,5!important;stroke-dashoffset:900;animation:dash 20s linear infinite;stroke-linecap:round;}#mermaid-svg-fxxxXgffTmE5sttV .error-icon{fill:#552222;}#mermaid-svg-fxxxXgffTmE5sttV .error-text{fill:#552222;stroke:#552222;}#mermaid-svg-fxxxXgffTmE5sttV .edge-thickness-normal{stroke-width:1px;}#mermaid-svg-fxxxXgffTmE5sttV .edge-thickness-thick{stroke-width:3.5px;}#mermaid-svg-fxxxXgffTmE5sttV .edge-pattern-solid{stroke-dasharray:0;}#mermaid-svg-fxxxXgffTmE5sttV .edge-thickness-invisible{stroke-width:0;fill:none;}#mermaid-svg-fxxxXgffTmE5sttV .edge-pattern-dashed{stroke-dasharray:3;}#mermaid-svg-fxxxXgffTmE5sttV .edge-pattern-dotted{stroke-dasharray:2;}#mermaid-svg-fxxxXgffTmE5sttV .marker{fill:#333333;stroke:#333333;}#mermaid-svg-fxxxXgffTmE5sttV .marker.cross{stroke:#333333;}#mermaid-svg-fxxxXgffTmE5sttV svg{font-family:\\&#8221;trebuchet ms\\&#8221;,verdana,arial,sans-serif;font-size:16px;}#mermaid-svg-fxxxXgffTmE5sttV p{margin:0;}#mermaid-svg-fxxxXgffTmE5sttV .label{font-family:\\&#8221;trebuchet ms\\&#8221;,verdana,arial,sans-serif;color:#333;}#mermaid-svg-fxxxXgffTmE5sttV .cluster-label text{fill:#333;}#mermaid-svg-fxxxXgffTmE5sttV .cluster-label span{color:#333;}#mermaid-svg-fxxxXgffTmE5sttV .cluster-label span p{background-color:transparent;}#mermaid-svg-fxxxXgffTmE5sttV .label text,#mermaid-svg-fxxxXgffTmE5sttV span{fill:#333;color:#333;}#mermaid-svg-fxxxXgffTmE5sttV .node rect,#mermaid-svg-fxxxXgffTmE5sttV .node circle,#mermaid-svg-fxxxXgffTmE5sttV .node ellipse,#mermaid-svg-fxxxXgffTmE5sttV .node polygon,#mermaid-svg-fxxxXgffTmE5sttV .node path{fill:#ECECFF;stroke:#9370DB;stroke-width:1px;}#mermaid-svg-fxxxXgffTmE5sttV .rough-node .label text,#mermaid-svg-fxxxXgffTmE5sttV .node .label text,#mermaid-svg-fxxxXgffTmE5sttV .image-shape .label,#mermaid-svg-fxxxXgffTmE5sttV .icon-shape .label{text-anchor:middle;}#mermaid-svg-fxxxXgffTmE5sttV .node .katex path{fill:#000;stroke:#000;stroke-width:1px;}#mermaid-svg-fxxxXgffTmE5sttV .rough-node .label,#mermaid-svg-fxxxXgffTmE5sttV .node .label,#mermaid-svg-fxxxXgffTmE5sttV .image-shape .label,#mermaid-svg-fxxxXgffTmE5sttV .icon-shape .label{text-align:center;}#mermaid-svg-fxxxXgffTmE5sttV .node.clickable{cursor:pointer;}#mermaid-svg-fxxxXgffTmE5sttV .root .anchor path{fill:#333333!important;stroke-width:0;stroke:#333333;}#mermaid-svg-fxxxXgffTmE5sttV .arrowheadPath{fill:#333333;}#mermaid-svg-fxxxXgffTmE5sttV .edgePath .path{stroke:#333333;stroke-width:2.0px;}#mermaid-svg-fxxxXgffTmE5sttV .flowchart-link{stroke:#333333;fill:none;}#mermaid-svg-fxxxXgffTmE5sttV .edgeLabel{background-color:rgba(232,232,232, 0.8);text-align:center;}#mermaid-svg-fxxxXgffTmE5sttV .edgeLabel p{background-color:rgba(232,232,232, 0.8);}#mermaid-svg-fxxxXgffTmE5sttV .edgeLabel rect{opacity:0.5;background-color:rgba(232,232,232, 0.8);fill:rgba(232,232,232, 0.8);}#mermaid-svg-fxxxXgffTmE5sttV .labelBkg{background-color:rgba(232, 232, 232, 0.5);}#mermaid-svg-fxxxXgffTmE5sttV .cluster rect{fill:#ffffde;stroke:#aaaa33;stroke-width:1px;}#mermaid-svg-fxxxXgffTmE5sttV .cluster text{fill:#333;}#mermaid-svg-fxxxXgffTmE5sttV .cluster span{color:#333;}#mermaid-svg-fxxxXgffTmE5sttV div.mermaidTooltip{position:absolute;text-align:center;max-width:200px;padding:2px;font-family:\\&#8221;trebuchet ms\\&#8221;,verdana,arial,sans-serif;font-size:12px;background:hsl(80, 100%, 96.2745098039%);border:1px solid #aaaa33;border-radius:2px;pointer-events:none;z-index:100;}#mermaid-svg-fxxxXgffTmE5sttV .flowchartTitleText{text-anchor:middle;font-size:18px;fill:#333;}#mermaid-svg-fxxxXgffTmE5sttV rect.text{fill:none;stroke-width:0;}#mermaid-svg-fxxxXgffTmE5sttV .icon-shape,#mermaid-svg-fxxxXgffTmE5sttV .image-shape{background-color:rgba(232,232,232, 0.8);text-align:center;}#mermaid-svg-fxxxXgffTmE5sttV .icon-shape p,#mermaid-svg-fxxxXgffTmE5sttV .image-shape p{background-color:rgba(232,232,232, 0.8);padding:2px;}#mermaid-svg-fxxxXgffTmE5sttV .icon-shape .label rect,#mermaid-svg-fxxxXgffTmE5sttV .image-shape .label rect{opacity:0.5;background-color:rgba(232,232,232, 0.8);fill:rgba(232,232,232, 0.8);}#mermaid-svg-fxxxXgffTmE5sttV .label-icon{display:inline-block;height:1em;overflow:visible;vertical-align:-0.125em;}#mermaid-svg-fxxxXgffTmE5sttV .node .label-icon path{fill:currentColor;stroke:revert;stroke-width:revert;}#mermaid-svg-fxxxXgffTmE5sttV :root{&#8211;mermaid-font-family:\\&#8221;trebuchet ms\\&#8221;,verdana,arial,sans-serif;}<span class=\"edgeLabel\"><\/span><span class=\"edgeLabel\"><\/span><span class=\"edgeLabel\"><\/span><span class=\"edgeLabel\"><\/span><span class=\"edgeLabel\"><\/p>\n<p>BeanDefinitionOverrideException<\/p>\n<p><\/span><span class=\"edgeLabel\"><\/span><span class=\"edgeLabel\"><\/p>\n<p>\u6210\u529f<\/p>\n<p><\/span><span class=\"edgeLabel\"><\/span><span class=\"nodeLabel\"><\/p>\n<p>\u4e3b\u5e93\u5efa rw \u5e93\u4e0e user \u8868<\/p>\n<p><\/span><span class=\"nodeLabel\"><\/p>\n<p>\u4e3b\u4ece\u590d\u5236\u81ea\u52a8\u540c\u6b65\u5230\u4ece\u5e93<\/p>\n<p><\/span><span class=\"nodeLabel\"><\/p>\n<p>\u5bfc\u5165 sharding-jdbc-spring-boot-starter<\/p>\n<p><\/span><span class=\"nodeLabel\"><\/p>\n<p>\u914d\u7f6e datasource \/ masterslave \/ props.sql.show<\/p>\n<p><\/span><span class=\"nodeLabel\"><\/p>\n<p>\u542f\u52a8<\/p>\n<p><\/span><span class=\"nodeLabel\"><\/p>\n<p>\u914d\u7f6e allow-bean-definition-overriding: true<\/p>\n<p><\/span><span class=\"nodeLabel\"><\/p>\n<p>\u542f\u52a8\u6210\u529f\u521b\u5efa 2 \u4e2a\u6570\u636e\u6e90<\/p>\n<p><\/span><span class=\"nodeLabel\"><\/p>\n<p>Postman \u9a8c\u8bc1 SELECT \u2192 slaveINSERT \u2192 master<\/p>\n<p><\/span><\/p>\n<h3>\u4e00\u3001\u51c6\u5907\u6570\u636e\u5e93\u73af\u5883<\/h3>\n<h4>\u5728\u4e3b\u5e93\u521b\u5efa\u6570\u636e\u5e93<\/h4>\n<p><span class=\"token comment\">&#8212; \u5728\u4e3b\u5e93 192.168.138.100 \u6267\u884c<\/span><br \/>\n<span class=\"token keyword\">CREATE<\/span> <span class=\"token keyword\">DATABASE<\/span> rw <span class=\"token keyword\">DEFAULT<\/span> <span class=\"token keyword\">CHARACTER<\/span> <span class=\"token keyword\">SET<\/span> utf8mb4<span class=\"token punctuation\">;<\/span><\/p>\n<p>rw \u5373 read-write&#xff08;\u8bfb\u5199&#xff09;\u3002\u7531\u4e8e\u4e3b\u4ece\u590d\u5236\u5df2\u914d\u7f6e&#xff0c;\u4ece\u5e93\u4f1a\u81ea\u52a8\u540c\u6b65\u51fa\u540c\u540d\u6570\u636e\u5e93\u2014\u2014\u4e0d\u9700\u8981\u5728\u4ece\u5e93\u624b\u5de5\u521b\u5efa\u3002<\/p>\n<h4>\u521b\u5efa user \u8868<\/h4>\n<p><span class=\"token keyword\">USE<\/span> rw<span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token keyword\">CREATE<\/span> <span class=\"token keyword\">TABLE<\/span> <span class=\"token keyword\">user<\/span> <span class=\"token punctuation\">(<\/span><br \/>\n    id      <span class=\"token keyword\">BIGINT<\/span> <span class=\"token keyword\">PRIMARY<\/span> <span class=\"token keyword\">KEY<\/span> <span class=\"token keyword\">AUTO_INCREMENT<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    name    <span class=\"token keyword\">VARCHAR<\/span><span class=\"token punctuation\">(<\/span><span class=\"token number\">50<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    age     <span class=\"token keyword\">INT<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    address <span class=\"token keyword\">VARCHAR<\/span><span class=\"token punctuation\">(<\/span><span class=\"token number\">200<\/span><span class=\"token punctuation\">)<\/span><br \/>\n<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p>\u8bfe\u7a0b\u91cc\u7684\u8e29\u5751&#xff1a;\u6700\u521d id \u5efa\u6210\u4e86 INT&#xff0c;\u63d2\u5165\u65f6\u62a5 Out of range value for column &#039;id&#039;\u3002\u539f\u56e0\u662f MyBatis-Plus \u7684 ASSIGN_ID \u7b56\u7565\u751f\u6210 19 \u4f4d\u96ea\u82b1 ID&#xff0c;\u8fdc\u8d85 INT \u7684\u6700\u5927\u503c 2147483647\u3002\u6539\u6210 BIGINT \u540e\u6b63\u5e38\u3002<\/p>\n<p>\u4fee\u6539\u540e\u4ece\u5e93\u4e5f\u81ea\u52a8\u8ddf\u7740\u53d8\u4e86&#xff08;\u56e0\u4e3a ALTER TABLE \u4e5f\u5728 binlog \u91cc&#xff09;\u2014\u2014\u8fd9\u4e2a\u73b0\u8c61\u672c\u8eab\u5c31\u662f\u4e3b\u4ece\u590d\u5236\u751f\u6548\u7684\u8bc1\u660e\u3002<\/p>\n<p>\u5b57\u6bb5\u89c4\u5212&#xff1a;<\/p>\n<table>\n<tr>\u5b57\u6bb5\u7c7b\u578b\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>id<\/td>\n<td>BIGINT<\/td>\n<td>\u4e3b\u952e\u3002\u7528\u96ea\u82b1 ID \u65f6\u5fc5\u987b BIGINT&#xff0c;INT \u8d8a\u754c<\/td>\n<\/tr>\n<tr>\n<td>name<\/td>\n<td>VARCHAR(50)<\/td>\n<td>\u59d3\u540d<\/td>\n<\/tr>\n<tr>\n<td>age<\/td>\n<td>INT<\/td>\n<td>\u5e74\u9f84<\/td>\n<\/tr>\n<tr>\n<td>address<\/td>\n<td>VARCHAR(200)<\/td>\n<td>\u5730\u5740<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>\u4e8c\u3001\u5bfc\u5165\u521d\u59cb\u5de5\u7a0b<\/h3>\n<p>\u8bfe\u7a0b\u63d0\u4f9b\u4e86 rw_demo \u521d\u59cb\u5de5\u7a0b\u3002\u5b83\u7684\u7279\u70b9&#xff1a;<\/p>\n<table>\n<tr>\u6587\u4ef6\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>pom.xml<\/td>\n<td>\u5e38\u89c4 Spring Boot \u4f9d\u8d56&#xff0c;\u5c1a\u672a\u5f15\u5165 Sharding-JDBC<\/td>\n<\/tr>\n<tr>\n<td>application.yml<\/td>\n<td>\u53ea\u6709\u7aef\u53e3\u4e0e mybatis-plus \u914d\u7f6e&#xff0c;\u6ca1\u6709\u6570\u636e\u6e90\u914d\u7f6e<\/td>\n<\/tr>\n<tr>\n<td>User \/ UserMapper \/ UserService<\/td>\n<td>\u6807\u51c6 MyBatis-Plus \u4e09\u5c42<\/td>\n<\/tr>\n<tr>\n<td>UserController<\/td>\n<td>\u589e\u5220\u6539\u67e5\u4e94\u4e2a\u65b9\u6cd5&#xff0c;\u6ce8\u5165\u4e86 DataSource&#xff08;\u7528\u4e8e\u8c03\u8bd5\u89c2\u5bdf&#xff09;<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u4e3a\u4ec0\u4e48\u521d\u59cb\u5de5\u7a0b\u4e0d\u914d\u6570\u636e\u6e90&#xff1f;<\/p>\n<p>\u56e0\u4e3a\u6570\u636e\u6e90\u5c06\u7531 Sharding-JDBC \u63d0\u4f9b\u3002Sharding-JDBC \u7684\u81ea\u52a8\u914d\u7f6e\u7c7b\u4f1a\u8bfb\u53d6 spring.shardingsphere.* \u914d\u7f6e\u5e76\u521b\u5efa MasterSlaveDataSource&#xff0c;\u6ce8\u518c\u4e3a DataSource \u7c7b\u578b\u7684 Bean\u3002\u5982\u679c\u6b64\u65f6\u8fd8\u5199\u4e86 spring.datasource.*&#xff0c;\u53cd\u800c\u4f1a\u51b2\u7a81\u3002<\/p>\n<h3>\u4e09\u3001\u7b2c\u4e00\u6b65&#xff1a;\u5bfc\u5165 Maven \u5750\u6807<\/h3>\n<p><span class=\"token tag\"><span class=\"token tag\"><span class=\"token punctuation\">&lt;<\/span>dependency<\/span><span class=\"token punctuation\">&gt;<\/span><\/span><br \/>\n    <span class=\"token tag\"><span class=\"token tag\"><span class=\"token punctuation\">&lt;<\/span>groupId<\/span><span class=\"token punctuation\">&gt;<\/span><\/span>org.apache.shardingsphere<span class=\"token tag\"><span class=\"token tag\"><span class=\"token punctuation\">&lt;\/<\/span>groupId<\/span><span class=\"token punctuation\">&gt;<\/span><\/span><br \/>\n    <span class=\"token tag\"><span class=\"token tag\"><span class=\"token punctuation\">&lt;<\/span>artifactId<\/span><span class=\"token punctuation\">&gt;<\/span><\/span>sharding-jdbc-spring-boot-starter<span class=\"token tag\"><span class=\"token tag\"><span class=\"token punctuation\">&lt;\/<\/span>artifactId<\/span><span class=\"token punctuation\">&gt;<\/span><\/span><br \/>\n    <span class=\"token tag\"><span class=\"token tag\"><span class=\"token punctuation\">&lt;<\/span>version<\/span><span class=\"token punctuation\">&gt;<\/span><\/span>4.1.1<span class=\"token tag\"><span class=\"token tag\"><span class=\"token punctuation\">&lt;\/<\/span>version<\/span><span class=\"token punctuation\">&gt;<\/span><\/span><br \/>\n<span class=\"token tag\"><span class=\"token tag\"><span class=\"token punctuation\">&lt;\/<\/span>dependency<\/span><span class=\"token punctuation\">&gt;<\/span><\/span><\/p>\n<h3>\u56db\u3001\u7b2c\u4e8c\u6b65&#xff1a;\u914d\u7f6e\u8bfb\u5199\u5206\u79bb\u89c4\u5219<\/h3>\n<p><span class=\"token key atrule\">spring<\/span><span class=\"token punctuation\">:<\/span><br \/>\n  <span class=\"token key atrule\">shardingsphere<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token key atrule\">datasource<\/span><span class=\"token punctuation\">:<\/span><br \/>\n      <span class=\"token key atrule\">names<\/span><span class=\"token punctuation\">:<\/span> master<span class=\"token punctuation\">,<\/span>slave<\/p>\n<p>      <span class=\"token comment\"># \u4e3b\u5e93\u6570\u636e\u6e90<\/span><br \/>\n      <span class=\"token key atrule\">master<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token key atrule\">type<\/span><span class=\"token punctuation\">:<\/span> com.alibaba.druid.pool.DruidDataSource<br \/>\n        <span class=\"token key atrule\">driver-class-name<\/span><span class=\"token punctuation\">:<\/span> com.mysql.cj.jdbc.Driver<br \/>\n        <span class=\"token key atrule\">url<\/span><span class=\"token punctuation\">:<\/span> jdbc<span class=\"token punctuation\">:<\/span>mysql<span class=\"token punctuation\">:<\/span>\/\/192.168.138.100<span class=\"token punctuation\">:<\/span>3306\/rw<span class=\"token punctuation\">?<\/span>characterEncoding&#061;utf<span class=\"token punctuation\">&#8211;<\/span><span class=\"token number\">8<\/span><br \/>\n        <span class=\"token key atrule\">username<\/span><span class=\"token punctuation\">:<\/span> root<br \/>\n        <span class=\"token key atrule\">password<\/span><span class=\"token punctuation\">:<\/span> root<\/p>\n<p>      <span class=\"token comment\"># \u4ece\u5e93\u6570\u636e\u6e90<\/span><br \/>\n      <span class=\"token key atrule\">slave<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token key atrule\">type<\/span><span class=\"token punctuation\">:<\/span> com.alibaba.druid.pool.DruidDataSource<br \/>\n        <span class=\"token key atrule\">driver-class-name<\/span><span class=\"token punctuation\">:<\/span> com.mysql.cj.jdbc.Driver<br \/>\n        <span class=\"token key atrule\">url<\/span><span class=\"token punctuation\">:<\/span> jdbc<span class=\"token punctuation\">:<\/span>mysql<span class=\"token punctuation\">:<\/span>\/\/192.168.138.101<span class=\"token punctuation\">:<\/span>3306\/rw<span class=\"token punctuation\">?<\/span>characterEncoding&#061;utf<span class=\"token punctuation\">&#8211;<\/span><span class=\"token number\">8<\/span><br \/>\n        <span class=\"token key atrule\">username<\/span><span class=\"token punctuation\">:<\/span> root<br \/>\n        <span class=\"token key atrule\">password<\/span><span class=\"token punctuation\">:<\/span> root<\/p>\n<p>    <span class=\"token key atrule\">masterslave<\/span><span class=\"token punctuation\">:<\/span><br \/>\n      <span class=\"token comment\"># \u4ece\u5e93\u8d1f\u8f7d\u5747\u8861\u7b56\u7565&#xff1a;\u8f6e\u8be2<\/span><br \/>\n      <span class=\"token key atrule\">load-balance-algorithm-type<\/span><span class=\"token punctuation\">:<\/span> round_robin<br \/>\n      <span class=\"token comment\"># \u6700\u7ec8\u6570\u636e\u6e90\u7684\u540d\u79f0<\/span><br \/>\n      <span class=\"token key atrule\">name<\/span><span class=\"token punctuation\">:<\/span> dataSource<br \/>\n      <span class=\"token comment\"># \u4e3b\u5e93\u6570\u636e\u6e90\u540d\u79f0<\/span><br \/>\n      <span class=\"token key atrule\">master-data-source-name<\/span><span class=\"token punctuation\">:<\/span> master<br \/>\n      <span class=\"token comment\"># \u4ece\u5e93\u6570\u636e\u6e90\u540d\u79f0\u5217\u8868&#xff0c;\u591a\u4e2a\u7528\u9017\u53f7\u5206\u9694<\/span><br \/>\n      <span class=\"token key atrule\">slave-data-source-names<\/span><span class=\"token punctuation\">:<\/span> slave<\/p>\n<p>    <span class=\"token key atrule\">props<\/span><span class=\"token punctuation\">:<\/span><br \/>\n      <span class=\"token key atrule\">sql<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token key atrule\">show<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token boolean important\">true<\/span>    <span class=\"token comment\"># \u5f00\u542f SQL \u663e\u793a&#xff0c;\u9ed8\u8ba4 false<\/span><\/p>\n<p>  <span class=\"token key atrule\">main<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token key atrule\">allow-bean-definition-overriding<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token boolean important\">true<\/span><\/p>\n<h4>\u914d\u7f6e\u9879\u9010\u9879\u62c6\u89e3<\/h4>\n<h5>datasource.names<\/h5>\n<p><span class=\"token key atrule\">names<\/span><span class=\"token punctuation\">:<\/span> master<span class=\"token punctuation\">,<\/span>slave<\/p>\n<p>\u58f0\u660e\u6709\u4e24\u4e2a\u6570\u636e\u6e90&#xff0c;\u540d\u79f0\u5206\u522b\u4e3a master \u4e0e slave\u3002\u8fd9\u4e24\u4e2a\u540d\u5b57\u53ef\u4ee5\u968f\u4fbf\u8d77\u2014\u2014\u53eb ds0\u3001ds1 \u4e5f\u884c&#xff0c;\u53ea\u8981\u4e0a\u4e0b\u5bf9\u5e94&#xff1a;<\/p>\n<p><span class=\"token comment\"># \u5408\u6cd5\u793a\u4f8b&#xff1a;\u6539\u4e86\u540d\u5b57&#xff0c;\u4e0b\u9762\u6240\u6709\u5f15\u7528\u90fd\u8981\u8ddf\u7740\u6539<\/span><br \/>\n<span class=\"token key atrule\">names<\/span><span class=\"token punctuation\">:<\/span> primary<span class=\"token punctuation\">,<\/span>replica<br \/>\n<span class=\"token key atrule\">primary<\/span><span class=\"token punctuation\">:<\/span><br \/>\n  <span class=\"token key atrule\">url<\/span><span class=\"token punctuation\">:<\/span> jdbc<span class=\"token punctuation\">:<\/span>mysql<span class=\"token punctuation\">:<\/span>\/\/192.168.138.100<span class=\"token punctuation\">:<\/span>3306\/rw<br \/>\n<span class=\"token key atrule\">replica<\/span><span class=\"token punctuation\">:<\/span><br \/>\n  <span class=\"token key atrule\">url<\/span><span class=\"token punctuation\">:<\/span> jdbc<span class=\"token punctuation\">:<\/span>mysql<span class=\"token punctuation\">:<\/span>\/\/192.168.138.101<span class=\"token punctuation\">:<\/span>3306\/rw<br \/>\n<span class=\"token key atrule\">masterslave<\/span><span class=\"token punctuation\">:<\/span><br \/>\n  <span class=\"token key atrule\">master-data-source-name<\/span><span class=\"token punctuation\">:<\/span> primary<br \/>\n  <span class=\"token key atrule\">slave-data-source-names<\/span><span class=\"token punctuation\">:<\/span> replica<\/p>\n<p>\u6ce8\u610f&#xff1a;\u540d\u5b57\u53eb master \u4e0d\u4ee3\u8868\u5b83\u5c31\u662f\u4e3b\u5e93\u3002\u771f\u6b63\u51b3\u5b9a\u8c01\u662f\u4e3b\u5e93\u7684\u662f master-data-source-name\u3002<\/p>\n<h5>datasource.master \/ datasource.slave<\/h5>\n<p>\u4e24\u4e2a\u6570\u636e\u6e90\u7684\u8fde\u63a5\u4fe1\u606f\u3002\u4e0e\u666e\u901a Spring Boot \u6570\u636e\u6e90\u914d\u7f6e\u7684\u533a\u522b&#xff1a;<\/p>\n<table>\n<tr>\u9879Sharding-JDBC \u5199\u6cd5\u666e\u901a Spring Boot \u5199\u6cd5<\/tr>\n<tbody>\n<tr>\n<td>\u524d\u7f00<\/td>\n<td>spring.shardingsphere.datasource.&lt;name&gt;<\/td>\n<td>spring.datasource<\/td>\n<\/tr>\n<tr>\n<td>\u9a71\u52a8<\/td>\n<td>driver-class-name<\/td>\n<td>driver-class-name<\/td>\n<\/tr>\n<tr>\n<td>\u8fde\u63a5\u6c60<\/td>\n<td>\u9700\u663e\u5f0f\u6307\u5b9a type<\/td>\n<td>\u81ea\u52a8\u63a8\u65ad<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>type: com.alibaba.druid.pool.DruidDataSource \u663e\u5f0f\u6307\u5b9a\u7528 Druid \u8fde\u63a5\u6c60\u3002\u4e0d\u6307\u5b9a\u7684\u8bdd Sharding-JDBC 4.x \u9ed8\u8ba4\u7528 HikariCP&#xff08;\u5982\u679c classpath \u91cc\u6709&#xff09;\u3002<\/p>\n<h5>masterslave<\/h5>\n<table>\n<tr>\u914d\u7f6e\u503c\u8bf4\u660e<\/tr>\n<tbody>\n<tr>\n<td>load-balance-algorithm-type<\/td>\n<td>round_robin<\/td>\n<td>\u4ece\u5e93\u8f6e\u8be2&#xff08;\u4e5f\u53ef random&#xff09;<\/td>\n<\/tr>\n<tr>\n<td>name<\/td>\n<td>dataSource<\/td>\n<td>\u5bf9\u5916\u66b4\u9732\u7684 DataSource Bean \u540d\u79f0<\/td>\n<\/tr>\n<tr>\n<td>master-data-source-name<\/td>\n<td>master<\/td>\n<td>\u6307\u5b9a\u54ea\u4e2a\u662f\u4e3b\u5e93<\/td>\n<\/tr>\n<tr>\n<td>slave-data-source-names<\/td>\n<td>slave<\/td>\n<td>\u6307\u5b9a\u54ea\u4e9b\u662f\u4ece\u5e93&#xff0c;\u591a\u4e2a\u9017\u53f7\u5206\u9694<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u591a\u4ece\u5e93\u7684\u5199\u6cd5&#xff1a;<\/p>\n<p><span class=\"token key atrule\">datasource<\/span><span class=\"token punctuation\">:<\/span><br \/>\n  <span class=\"token key atrule\">names<\/span><span class=\"token punctuation\">:<\/span> master<span class=\"token punctuation\">,<\/span>slave1<span class=\"token punctuation\">,<\/span>slave2<br \/>\n  <span class=\"token key atrule\">master<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token key atrule\">url<\/span><span class=\"token punctuation\">:<\/span> jdbc<span class=\"token punctuation\">:<\/span>mysql<span class=\"token punctuation\">:<\/span>\/\/192.168.138.100<span class=\"token punctuation\">:<\/span>3306\/rw<br \/>\n  <span class=\"token key atrule\">slave1<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token key atrule\">url<\/span><span class=\"token punctuation\">:<\/span> jdbc<span class=\"token punctuation\">:<\/span>mysql<span class=\"token punctuation\">:<\/span>\/\/192.168.138.101<span class=\"token punctuation\">:<\/span>3306\/rw<br \/>\n  <span class=\"token key atrule\">slave2<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token key atrule\">url<\/span><span class=\"token punctuation\">:<\/span> jdbc<span class=\"token punctuation\">:<\/span>mysql<span class=\"token punctuation\">:<\/span>\/\/192.168.138.102<span class=\"token punctuation\">:<\/span>3306\/rw<br \/>\n<span class=\"token key atrule\">masterslave<\/span><span class=\"token punctuation\">:<\/span><br \/>\n  <span class=\"token key atrule\">master-data-source-name<\/span><span class=\"token punctuation\">:<\/span> master<br \/>\n  <span class=\"token key atrule\">slave-data-source-names<\/span><span class=\"token punctuation\">:<\/span> slave1<span class=\"token punctuation\">,<\/span>slave2<br \/>\n  <span class=\"token key atrule\">load-balance-algorithm-type<\/span><span class=\"token punctuation\">:<\/span> round_robin<\/p>\n<p>\u4e09\u4e2a\u6570\u636e\u6e90&#xff0c;\u4e00\u4e3b\u4e24\u4ece&#xff0c;\u8bfb\u8bf7\u6c42\u5728 slave1 \u4e0e slave2 \u4e4b\u95f4\u8f6e\u8be2\u3002<\/p>\n<h5>props.sql.show<\/h5>\n<p><span class=\"token key atrule\">props<\/span><span class=\"token punctuation\">:<\/span><br \/>\n  <span class=\"token key atrule\">sql<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token key atrule\">show<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token boolean important\">true<\/span><\/p>\n<p>\u5f00\u542f\u540e\u63a7\u5236\u53f0\u4f1a\u6253\u5370 SQL \u4ee5\u53ca\u5b83\u5b9e\u9645\u8def\u7531\u5230\u7684\u6570\u636e\u6e90\u540d\u79f0&#xff0c;\u8fd9\u662f\u9a8c\u8bc1\u8bfb\u5199\u5206\u79bb\u6700\u76f4\u63a5\u7684\u624b\u6bb5&#xff1a;<\/p>\n<p>[main] INFO  ShardingSphere-SQL &#8211; Rule Type: master-slave<br \/>\n[main] INFO  ShardingSphere-SQL &#8211; SQL: SELECT &#8230; FROM user WHERE id&#061;? ::: DataSources: slave<\/p>\n<h5>main.allow-bean-definition-overriding<\/h5>\n<p>\u89c1\u4e0b\u4e00\u8282\u3002<\/p>\n<h3>\u4e94\u3001\u7b2c\u4e09\u6b65&#xff1a;\u89e3\u51b3 Bean \u5b9a\u4e49\u51b2\u7a81<\/h3>\n<h4>\u62a5\u9519\u73b0\u8c61<\/h4>\n<p>\u914d\u5b8c yml \u76f4\u63a5\u542f\u52a8&#xff0c;\u62a5&#xff1a;<\/p>\n<p>org.springframework.beans.factory.support.BeanDefinitionOverrideException:<br \/>\nInvalid bean definition with name &#039;dataSource&#039; defined in class path resource<br \/>\n[org\/apache\/shardingsphere\/shardingjdbc\/spring\/boot\/SpringBootConfiguration.class]:<br \/>\nCannot register bean definition &#8230; since there is already<br \/>\n[Root bean: class [com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceAutoConfigure]] bound.<\/p>\n<h4>\u6839\u56e0<\/h4>\n<p>#mermaid-svg-7HLdmLL518keRkYb{font-family:\\&#8221;trebuchet ms\\&#8221;,verdana,arial,sans-serif;font-size:16px;fill:#333;}@keyframes edge-animation-frame{from{stroke-dashoffset:0;}}@keyframes dash{to{stroke-dashoffset:0;}}#mermaid-svg-7HLdmLL518keRkYb .edge-animation-slow{stroke-dasharray:9,5!important;stroke-dashoffset:900;animation:dash 50s linear infinite;stroke-linecap:round;}#mermaid-svg-7HLdmLL518keRkYb .edge-animation-fast{stroke-dasharray:9,5!important;stroke-dashoffset:900;animation:dash 20s linear infinite;stroke-linecap:round;}#mermaid-svg-7HLdmLL518keRkYb .error-icon{fill:#552222;}#mermaid-svg-7HLdmLL518keRkYb .error-text{fill:#552222;stroke:#552222;}#mermaid-svg-7HLdmLL518keRkYb .edge-thickness-normal{stroke-width:1px;}#mermaid-svg-7HLdmLL518keRkYb .edge-thickness-thick{stroke-width:3.5px;}#mermaid-svg-7HLdmLL518keRkYb .edge-pattern-solid{stroke-dasharray:0;}#mermaid-svg-7HLdmLL518keRkYb .edge-thickness-invisible{stroke-width:0;fill:none;}#mermaid-svg-7HLdmLL518keRkYb .edge-pattern-dashed{stroke-dasharray:3;}#mermaid-svg-7HLdmLL518keRkYb .edge-pattern-dotted{stroke-dasharray:2;}#mermaid-svg-7HLdmLL518keRkYb .marker{fill:#333333;stroke:#333333;}#mermaid-svg-7HLdmLL518keRkYb .marker.cross{stroke:#333333;}#mermaid-svg-7HLdmLL518keRkYb svg{font-family:\\&#8221;trebuchet ms\\&#8221;,verdana,arial,sans-serif;font-size:16px;}#mermaid-svg-7HLdmLL518keRkYb p{margin:0;}#mermaid-svg-7HLdmLL518keRkYb .label{font-family:\\&#8221;trebuchet ms\\&#8221;,verdana,arial,sans-serif;color:#333;}#mermaid-svg-7HLdmLL518keRkYb .cluster-label text{fill:#333;}#mermaid-svg-7HLdmLL518keRkYb .cluster-label span{color:#333;}#mermaid-svg-7HLdmLL518keRkYb .cluster-label span p{background-color:transparent;}#mermaid-svg-7HLdmLL518keRkYb .label text,#mermaid-svg-7HLdmLL518keRkYb span{fill:#333;color:#333;}#mermaid-svg-7HLdmLL518keRkYb .node rect,#mermaid-svg-7HLdmLL518keRkYb .node circle,#mermaid-svg-7HLdmLL518keRkYb .node ellipse,#mermaid-svg-7HLdmLL518keRkYb .node polygon,#mermaid-svg-7HLdmLL518keRkYb .node path{fill:#ECECFF;stroke:#9370DB;stroke-width:1px;}#mermaid-svg-7HLdmLL518keRkYb .rough-node .label text,#mermaid-svg-7HLdmLL518keRkYb .node .label text,#mermaid-svg-7HLdmLL518keRkYb .image-shape .label,#mermaid-svg-7HLdmLL518keRkYb .icon-shape .label{text-anchor:middle;}#mermaid-svg-7HLdmLL518keRkYb .node .katex path{fill:#000;stroke:#000;stroke-width:1px;}#mermaid-svg-7HLdmLL518keRkYb .rough-node .label,#mermaid-svg-7HLdmLL518keRkYb .node .label,#mermaid-svg-7HLdmLL518keRkYb .image-shape .label,#mermaid-svg-7HLdmLL518keRkYb .icon-shape .label{text-align:center;}#mermaid-svg-7HLdmLL518keRkYb .node.clickable{cursor:pointer;}#mermaid-svg-7HLdmLL518keRkYb .root .anchor path{fill:#333333!important;stroke-width:0;stroke:#333333;}#mermaid-svg-7HLdmLL518keRkYb .arrowheadPath{fill:#333333;}#mermaid-svg-7HLdmLL518keRkYb .edgePath .path{stroke:#333333;stroke-width:2.0px;}#mermaid-svg-7HLdmLL518keRkYb .flowchart-link{stroke:#333333;fill:none;}#mermaid-svg-7HLdmLL518keRkYb .edgeLabel{background-color:rgba(232,232,232, 0.8);text-align:center;}#mermaid-svg-7HLdmLL518keRkYb .edgeLabel p{background-color:rgba(232,232,232, 0.8);}#mermaid-svg-7HLdmLL518keRkYb .edgeLabel rect{opacity:0.5;background-color:rgba(232,232,232, 0.8);fill:rgba(232,232,232, 0.8);}#mermaid-svg-7HLdmLL518keRkYb .labelBkg{background-color:rgba(232, 232, 232, 0.5);}#mermaid-svg-7HLdmLL518keRkYb .cluster rect{fill:#ffffde;stroke:#aaaa33;stroke-width:1px;}#mermaid-svg-7HLdmLL518keRkYb .cluster text{fill:#333;}#mermaid-svg-7HLdmLL518keRkYb .cluster span{color:#333;}#mermaid-svg-7HLdmLL518keRkYb div.mermaidTooltip{position:absolute;text-align:center;max-width:200px;padding:2px;font-family:\\&#8221;trebuchet ms\\&#8221;,verdana,arial,sans-serif;font-size:12px;background:hsl(80, 100%, 96.2745098039%);border:1px solid #aaaa33;border-radius:2px;pointer-events:none;z-index:100;}#mermaid-svg-7HLdmLL518keRkYb .flowchartTitleText{text-anchor:middle;font-size:18px;fill:#333;}#mermaid-svg-7HLdmLL518keRkYb rect.text{fill:none;stroke-width:0;}#mermaid-svg-7HLdmLL518keRkYb .icon-shape,#mermaid-svg-7HLdmLL518keRkYb .image-shape{background-color:rgba(232,232,232, 0.8);text-align:center;}#mermaid-svg-7HLdmLL518keRkYb .icon-shape p,#mermaid-svg-7HLdmLL518keRkYb .image-shape p{background-color:rgba(232,232,232, 0.8);padding:2px;}#mermaid-svg-7HLdmLL518keRkYb .icon-shape .label rect,#mermaid-svg-7HLdmLL518keRkYb .image-shape .label rect{opacity:0.5;background-color:rgba(232,232,232, 0.8);fill:rgba(232,232,232, 0.8);}#mermaid-svg-7HLdmLL518keRkYb .label-icon{display:inline-block;height:1em;overflow:visible;vertical-align:-0.125em;}#mermaid-svg-7HLdmLL518keRkYb .node .label-icon path{fill:currentColor;stroke:revert;stroke-width:revert;}#mermaid-svg-7HLdmLL518keRkYb :root{&#8211;mermaid-font-family:\\&#8221;trebuchet ms\\&#8221;,verdana,arial,sans-serif;}<span class=\"edgeLabel\"><\/span><span class=\"edgeLabel\"><\/span><span class=\"edgeLabel\"><\/span><span class=\"edgeLabel\"><\/span><span class=\"edgeLabel\"><\/span><span class=\"edgeLabel\"><\/span><span class=\"edgeLabel\"><\/span><span class=\"edgeLabel\"><\/p>\n<p>false&#xff08;\u9ed8\u8ba4&#xff09;<\/p>\n<p><\/span><span class=\"edgeLabel\"><\/p>\n<p>true<\/p>\n<p><\/span><span class=\"nodeLabel\"><\/p>\n<p>\u5e94\u7528\u542f\u52a8<\/p>\n<p><\/span><span class=\"nodeLabel\"><\/p>\n<p>Sharding-JDBC \u7684SpringBootConfiguration<\/p>\n<p><\/span><span class=\"nodeLabel\"><\/p>\n<p>Druid \u7684DruidDataSourceAutoConfigure<\/p>\n<p><\/span><span class=\"nodeLabel\"><\/p>\n<p>&#064;Bean dataSource\u521b\u5efa MasterSlaveDataSource<\/p>\n<p><\/span><span class=\"nodeLabel\"><\/p>\n<p>&#064;Bean dataSource\u521b\u5efa DruidDataSource<\/p>\n<p><\/span><span class=\"nodeLabel\"><\/p>\n<p>\u4e24\u4e2a Bean \u540c\u540d\u90fd\u662f dataSource<\/p>\n<p><\/span><span class=\"nodeLabel\"><\/p>\n<p>allow-bean-definition-overriding<\/p>\n<p><\/span><span class=\"nodeLabel\"><\/p>\n<p>BeanDefinitionOverrideException<\/p>\n<p><\/span><span class=\"nodeLabel\"><\/p>\n<p>\u540e\u8005\u8986\u76d6\u524d\u8005\u542f\u52a8\u6210\u529f<\/p>\n<p><\/span><\/p>\n<p>\u4e24\u4e2a\u81ea\u52a8\u914d\u7f6e\u7c7b\u90fd\u8981\u521b\u5efa\u540d\u4e3a dataSource \u7684 Bean&#xff1a;<\/p>\n<table>\n<tr>\u6765\u6e90\u914d\u7f6e\u7c7b\u521b\u5efa\u7684 Bean<\/tr>\n<tbody>\n<tr>\n<td>Sharding-JDBC<\/td>\n<td>SpringBootConfiguration<\/td>\n<td>MasterSlaveDataSource<\/td>\n<\/tr>\n<tr>\n<td>Druid starter<\/td>\n<td>DruidDataSourceAutoConfigure<\/td>\n<td>DruidDataSource<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>Spring Boot 2.1 \u8d77&#xff0c;allow-bean-definition-overriding \u7684\u9ed8\u8ba4\u503c\u4ece true \u6539\u6210\u4e86 false\u2014\u2014\u4e0d\u5141\u8bb8 Bean \u5b9a\u4e49\u8986\u76d6&#xff0c;\u91cd\u590d\u5b9a\u4e49\u76f4\u63a5\u629b\u5f02\u5e38&#xff08;2.0 \u53ca\u4ee5\u524d\u53ea\u662f\u6253\u4e00\u6761 WARN \u65e5\u5fd7&#xff09;\u3002<\/p>\n<h4>\u89e3\u51b3\u65b9\u6848<\/h4>\n<p><span class=\"token key atrule\">spring<\/span><span class=\"token punctuation\">:<\/span><br \/>\n  <span class=\"token key atrule\">main<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token key atrule\">allow-bean-definition-overriding<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token boolean important\">true<\/span><\/p>\n<p>\u5141\u8bb8\u540e\u521b\u5efa\u7684 Bean \u8986\u76d6\u5148\u521b\u5efa\u7684\u3002\u7531\u4e8e Sharding-JDBC \u7684\u914d\u7f6e\u7c7b\u6392\u5728 Druid \u4e4b\u540e\u52a0\u8f7d&#xff0c;\u6700\u7ec8\u5bb9\u5668\u91cc\u7684 dataSource \u662f MasterSlaveDataSource\u2014\u2014\u8fd9\u6b63\u662f\u6211\u4eec\u60f3\u8981\u7684\u3002<\/p>\n<h4>\u66f4\u5f7b\u5e95\u7684\u65b9\u6848&#xff1a;\u6392\u9664 Druid \u81ea\u52a8\u914d\u7f6e<\/h4>\n<p>\u5982\u679c\u4e0d\u5e0c\u671b\u9760&#034;\u8986\u76d6&#034;\u8fd9\u79cd\u9690\u5f0f\u884c\u4e3a&#xff0c;\u53ef\u4ee5\u5728\u542f\u52a8\u7c7b\u4e0a\u6392\u9664 Druid \u7684\u6570\u636e\u6e90\u81ea\u52a8\u914d\u7f6e&#xff1a;<\/p>\n<p><span class=\"token annotation punctuation\">&#064;SpringBootApplication<\/span><span class=\"token punctuation\">(<\/span>exclude <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">{<\/span><span class=\"token class-name\">DruidDataSourceAutoConfigure<\/span><span class=\"token punctuation\">.<\/span><span class=\"token keyword\">class<\/span><span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">)<\/span><br \/>\n<span class=\"token keyword\">public<\/span> <span class=\"token keyword\">class<\/span> <span class=\"token class-name\">Application<\/span> <span class=\"token punctuation\">{<\/span><br \/>\n    <span class=\"token keyword\">public<\/span> <span class=\"token keyword\">static<\/span> <span class=\"token keyword\">void<\/span> <span class=\"token function\">main<\/span><span class=\"token punctuation\">(<\/span><span class=\"token class-name\">String<\/span><span class=\"token punctuation\">[<\/span><span class=\"token punctuation\">]<\/span> args<span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{<\/span><br \/>\n        <span class=\"token class-name\">SpringApplication<\/span><span class=\"token punctuation\">.<\/span><span class=\"token function\">run<\/span><span class=\"token punctuation\">(<\/span><span class=\"token class-name\">Application<\/span><span class=\"token punctuation\">.<\/span><span class=\"token keyword\">class<\/span><span class=\"token punctuation\">,<\/span> args<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><br \/>\n    <span class=\"token punctuation\">}<\/span><br \/>\n<span class=\"token punctuation\">}<\/span><\/p>\n<p>\u4e24\u79cd\u65b9\u5f0f\u5bf9\u6bd4&#xff1a;<\/p>\n<table>\n<tr>\u65b9\u6848\u4f18\u70b9\u7f3a\u70b9<\/tr>\n<tbody>\n<tr>\n<td>allow-bean-definition-overriding: true<\/td>\n<td>\u914d\u7f6e\u7b80\u5355&#xff0c;\u4e00\u884c\u641e\u5b9a<\/td>\n<td>\u5168\u5c40\u653e\u5f00\u8986\u76d6&#xff0c;\u53ef\u80fd\u63a9\u76d6\u5176\u4ed6\u771f\u5b9e\u7684 Bean \u51b2\u7a81<\/td>\n<\/tr>\n<tr>\n<td>exclude &#061; DruidDataSourceAutoConfigure.class<\/td>\n<td>\u7cbe\u51c6\u6392\u9664&#xff0c;\u8bed\u4e49\u6e05\u6670<\/td>\n<td>\u9700\u8981\u77e5\u9053\u5177\u4f53\u7c7b\u540d&#xff1b;Druid \u7684\u76d1\u63a7\u529f\u80fd\u4f1a\u53d7\u5f71\u54cd<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u8bfe\u7a0b\u7528\u524d\u8005\u3002\u751f\u4ea7\u5efa\u8bae\u540e\u8005\u2014\u2014\u5168\u5c40\u653e\u5f00 Bean \u8986\u76d6\u662f\u4e2a\u5371\u9669\u5f00\u5173&#xff0c;\u4f1a\u8ba9\u4f60\u5728\u771f\u6b63\u51fa\u73b0\u610f\u5916\u8986\u76d6\u65f6\u4e5f\u6536\u4e0d\u5230\u62a5\u9519\u3002<\/p>\n<p>Druid \u76d1\u63a7\u9875&#xff1a;\u5982\u679c\u6392\u9664\u4e86 DruidDataSourceAutoConfigure&#xff0c;Druid \u7684 StatViewServlet&#xff08;\/druid\/index.html&#xff09;\u9700\u8981\u5355\u72ec\u914d\u7f6e\u3002\u4f46\u6ce8\u610f&#xff1a;\u4f7f\u7528 Sharding-JDBC \u540e&#xff0c;Druid \u76d1\u63a7\u770b\u5230\u7684\u662f\u4e24\u4e2a\u5185\u90e8\u6570\u636e\u6e90&#xff08;master\/slave&#xff09;&#xff0c;\u800c\u4e0d\u662f\u90a3\u4e2a MasterSlaveDataSource\u3002<\/p>\n<h3>\u516d\u3001\u542f\u52a8\u9a8c\u8bc1<\/h3>\n<p>\u914d\u7f6e\u5b8c\u6210\u540e\u542f\u52a8&#xff0c;\u65e5\u5fd7\u4e2d\u53ef\u4ee5\u770b\u5230&#xff1a;<\/p>\n<p>[main] INFO  &#8230; &#8211; Data sources: 2<br \/>\n[main] INFO  &#8230; &#8211; datasource-1: DruidDataSource (jdbc:mysql:\/\/192.168.138.100:3306\/rw)<br \/>\n[main] INFO  &#8230; &#8211; datasource-2: DruidDataSource (jdbc:mysql:\/\/192.168.138.101:3306\/rw)<\/p>\n<p>\u521b\u5efa\u4e86\u4e24\u4e2a\u6570\u636e\u6e90&#xff0c;\u5206\u522b\u8fde\u4e3b\u5e93\u548c\u4ece\u5e93\u3002<\/p>\n<h3>\u4e03\u3001\u529f\u80fd\u6d4b\u8bd5<\/h3>\n<h4>\u6d4b\u8bd5\u4e00&#xff1a;\u67e5\u8be2\u8d70\u4ece\u5e93<\/h4>\n<p>\u5728 UserController.getById \u6253\u65ad\u70b9&#xff0c;Postman \u53d1&#xff1a;<\/p>\n<p>GET http:\/\/localhost:8080\/user\/12345<\/p>\n<h5>\u89c2\u5bdf\u6ce8\u5165\u7684 DataSource<\/h5>\n<p>\u65ad\u70b9\u505c\u4f4f\u540e&#xff0c;\u628a\u5149\u6807\u653e\u5728 dataSource \u4e0a&#xff0c;\u53ef\u4ee5\u770b\u5230&#xff1a;<\/p>\n<table>\n<tr>\u5c5e\u6027\u503c<\/tr>\n<tbody>\n<tr>\n<td>\u5b9e\u9645\u7c7b\u578b<\/td>\n<td>MasterSlaveDataSource&#xff08;Sharding-JDBC \u63d0\u4f9b&#xff09;<\/td>\n<\/tr>\n<tr>\n<td>dataSourceMap<\/td>\n<td>size &#061; 2&#xff0c;\u5305\u542b master \u4e0e slave<\/td>\n<\/tr>\n<tr>\n<td>master \u7684 jdbcUrl<\/td>\n<td>jdbc:mysql:\/\/192.168.138.100:3306\/rw<\/td>\n<\/tr>\n<tr>\n<td>slave \u7684 jdbcUrl<\/td>\n<td>jdbc:mysql:\/\/192.168.138.101:3306\/rw<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u5c5e\u6027\u5d4c\u5957\u5f88\u6df1&#xff0c;\u9700\u8981\u9010\u5c42\u5c55\u5f00\u67e5\u627e jdbcUrl\u3002\u8fd9\u4e2a\u89c2\u5bdf\u8bc1\u660e\u4e86&#xff1a;\u4e1a\u52a1\u4ee3\u7801\u6ce8\u5165\u7684 DataSource \u5df2\u7ecf\u4e0d\u662f Druid \u7684\u4e86&#xff0c;\u800c\u662f Sharding-JDBC \u5c01\u88c5\u7684\u8bfb\u5199\u5206\u79bb\u6570\u636e\u6e90\u3002<\/p>\n<h5>\u89c2\u5bdf\u63a7\u5236\u53f0\u65e5\u5fd7<\/h5>\n<p>\u653e\u884c\u540e\u63a7\u5236\u53f0\u8f93\u51fa&#xff1a;<\/p>\n<p>ShardingSphere-SQL : Rule Type: master-slave<br \/>\nShardingSphere-SQL : SQL: SELECT id,name,age,address FROM user WHERE id&#061;? ::: DataSources: slave<\/p>\n<p>DataSources: slave \u2014\u2014 \u67e5\u8be2\u786e\u5b9e\u8d70\u4e86\u4ece\u5e93\u3002<\/p>\n<h4>\u6d4b\u8bd5\u4e8c&#xff1a;\u65b0\u589e\u8d70\u4e3b\u5e93<\/h4>\n<p>POST http:\/\/localhost:8080\/user<br \/>\nContent-Type: application\/x-www-form-urlencoded<\/p>\n<p><span class=\"token assign-left variable\">name<\/span><span class=\"token operator\">&#061;<\/span>\u5f20\u4e09<span class=\"token operator\">&amp;<\/span><span class=\"token assign-left variable\">age<\/span><span class=\"token operator\">&#061;<\/span><span class=\"token number\">20<\/span><\/p>\n<p>\u63a7\u5236\u53f0&#xff1a;<\/p>\n<p>ShardingSphere-SQL : Rule Type: master-slave<br \/>\nShardingSphere-SQL : SQL: INSERT INTO user ( id, name, age ) VALUES ( ?, ?, ? ) ::: DataSources: master<\/p>\n<p>DataSources: master \u2014\u2014 \u5199\u64cd\u4f5c\u8d70\u4e3b\u5e93\u3002<\/p>\n<h4>\u6d4b\u8bd5\u4e09&#xff1a;\u6570\u636e\u540c\u6b65\u9a8c\u8bc1<\/h4>\n<p>#mermaid-svg-LMwpLVJ9nIHYtVag{font-family:\\&#8221;trebuchet ms\\&#8221;,verdana,arial,sans-serif;font-size:16px;fill:#333;}@keyframes edge-animation-frame{from{stroke-dashoffset:0;}}@keyframes dash{to{stroke-dashoffset:0;}}#mermaid-svg-LMwpLVJ9nIHYtVag .edge-animation-slow{stroke-dasharray:9,5!important;stroke-dashoffset:900;animation:dash 50s linear infinite;stroke-linecap:round;}#mermaid-svg-LMwpLVJ9nIHYtVag .edge-animation-fast{stroke-dasharray:9,5!important;stroke-dashoffset:900;animation:dash 20s linear infinite;stroke-linecap:round;}#mermaid-svg-LMwpLVJ9nIHYtVag .error-icon{fill:#552222;}#mermaid-svg-LMwpLVJ9nIHYtVag .error-text{fill:#552222;stroke:#552222;}#mermaid-svg-LMwpLVJ9nIHYtVag .edge-thickness-normal{stroke-width:1px;}#mermaid-svg-LMwpLVJ9nIHYtVag .edge-thickness-thick{stroke-width:3.5px;}#mermaid-svg-LMwpLVJ9nIHYtVag .edge-pattern-solid{stroke-dasharray:0;}#mermaid-svg-LMwpLVJ9nIHYtVag .edge-thickness-invisible{stroke-width:0;fill:none;}#mermaid-svg-LMwpLVJ9nIHYtVag .edge-pattern-dashed{stroke-dasharray:3;}#mermaid-svg-LMwpLVJ9nIHYtVag .edge-pattern-dotted{stroke-dasharray:2;}#mermaid-svg-LMwpLVJ9nIHYtVag .marker{fill:#333333;stroke:#333333;}#mermaid-svg-LMwpLVJ9nIHYtVag .marker.cross{stroke:#333333;}#mermaid-svg-LMwpLVJ9nIHYtVag svg{font-family:\\&#8221;trebuchet ms\\&#8221;,verdana,arial,sans-serif;font-size:16px;}#mermaid-svg-LMwpLVJ9nIHYtVag p{margin:0;}#mermaid-svg-LMwpLVJ9nIHYtVag .label{font-family:\\&#8221;trebuchet ms\\&#8221;,verdana,arial,sans-serif;color:#333;}#mermaid-svg-LMwpLVJ9nIHYtVag .cluster-label text{fill:#333;}#mermaid-svg-LMwpLVJ9nIHYtVag .cluster-label span{color:#333;}#mermaid-svg-LMwpLVJ9nIHYtVag .cluster-label span p{background-color:transparent;}#mermaid-svg-LMwpLVJ9nIHYtVag .label text,#mermaid-svg-LMwpLVJ9nIHYtVag span{fill:#333;color:#333;}#mermaid-svg-LMwpLVJ9nIHYtVag .node rect,#mermaid-svg-LMwpLVJ9nIHYtVag .node circle,#mermaid-svg-LMwpLVJ9nIHYtVag .node ellipse,#mermaid-svg-LMwpLVJ9nIHYtVag .node polygon,#mermaid-svg-LMwpLVJ9nIHYtVag .node path{fill:#ECECFF;stroke:#9370DB;stroke-width:1px;}#mermaid-svg-LMwpLVJ9nIHYtVag .rough-node .label text,#mermaid-svg-LMwpLVJ9nIHYtVag .node .label text,#mermaid-svg-LMwpLVJ9nIHYtVag .image-shape .label,#mermaid-svg-LMwpLVJ9nIHYtVag .icon-shape .label{text-anchor:middle;}#mermaid-svg-LMwpLVJ9nIHYtVag .node .katex path{fill:#000;stroke:#000;stroke-width:1px;}#mermaid-svg-LMwpLVJ9nIHYtVag .rough-node .label,#mermaid-svg-LMwpLVJ9nIHYtVag .node .label,#mermaid-svg-LMwpLVJ9nIHYtVag .image-shape .label,#mermaid-svg-LMwpLVJ9nIHYtVag .icon-shape .label{text-align:center;}#mermaid-svg-LMwpLVJ9nIHYtVag .node.clickable{cursor:pointer;}#mermaid-svg-LMwpLVJ9nIHYtVag .root .anchor path{fill:#333333!important;stroke-width:0;stroke:#333333;}#mermaid-svg-LMwpLVJ9nIHYtVag .arrowheadPath{fill:#333333;}#mermaid-svg-LMwpLVJ9nIHYtVag .edgePath .path{stroke:#333333;stroke-width:2.0px;}#mermaid-svg-LMwpLVJ9nIHYtVag .flowchart-link{stroke:#333333;fill:none;}#mermaid-svg-LMwpLVJ9nIHYtVag .edgeLabel{background-color:rgba(232,232,232, 0.8);text-align:center;}#mermaid-svg-LMwpLVJ9nIHYtVag .edgeLabel p{background-color:rgba(232,232,232, 0.8);}#mermaid-svg-LMwpLVJ9nIHYtVag .edgeLabel rect{opacity:0.5;background-color:rgba(232,232,232, 0.8);fill:rgba(232,232,232, 0.8);}#mermaid-svg-LMwpLVJ9nIHYtVag .labelBkg{background-color:rgba(232, 232, 232, 0.5);}#mermaid-svg-LMwpLVJ9nIHYtVag .cluster rect{fill:#ffffde;stroke:#aaaa33;stroke-width:1px;}#mermaid-svg-LMwpLVJ9nIHYtVag .cluster text{fill:#333;}#mermaid-svg-LMwpLVJ9nIHYtVag .cluster span{color:#333;}#mermaid-svg-LMwpLVJ9nIHYtVag div.mermaidTooltip{position:absolute;text-align:center;max-width:200px;padding:2px;font-family:\\&#8221;trebuchet ms\\&#8221;,verdana,arial,sans-serif;font-size:12px;background:hsl(80, 100%, 96.2745098039%);border:1px solid #aaaa33;border-radius:2px;pointer-events:none;z-index:100;}#mermaid-svg-LMwpLVJ9nIHYtVag .flowchartTitleText{text-anchor:middle;font-size:18px;fill:#333;}#mermaid-svg-LMwpLVJ9nIHYtVag rect.text{fill:none;stroke-width:0;}#mermaid-svg-LMwpLVJ9nIHYtVag .icon-shape,#mermaid-svg-LMwpLVJ9nIHYtVag .image-shape{background-color:rgba(232,232,232, 0.8);text-align:center;}#mermaid-svg-LMwpLVJ9nIHYtVag .icon-shape p,#mermaid-svg-LMwpLVJ9nIHYtVag .image-shape p{background-color:rgba(232,232,232, 0.8);padding:2px;}#mermaid-svg-LMwpLVJ9nIHYtVag .icon-shape .label rect,#mermaid-svg-LMwpLVJ9nIHYtVag .image-shape .label rect{opacity:0.5;background-color:rgba(232,232,232, 0.8);fill:rgba(232,232,232, 0.8);}#mermaid-svg-LMwpLVJ9nIHYtVag .label-icon{display:inline-block;height:1em;overflow:visible;vertical-align:-0.125em;}#mermaid-svg-LMwpLVJ9nIHYtVag .node .label-icon path{fill:currentColor;stroke:revert;stroke-width:revert;}#mermaid-svg-LMwpLVJ9nIHYtVag :root{&#8211;mermaid-font-family:\\&#8221;trebuchet ms\\&#8221;,verdana,arial,sans-serif;}<span class=\"edgeLabel\"><\/span><span class=\"edgeLabel\"><\/p>\n<p>\u4e3b\u4ece\u590d\u5236 binlog \u540c\u6b65<\/p>\n<p><\/span><span class=\"edgeLabel\"><\/span><span class=\"nodeLabel\"><\/p>\n<p>POST \/userINSERT \u8d70 master<\/p>\n<p><\/span><span class=\"nodeLabel\"><\/p>\n<p>\u4e3b\u5e93 user \u8868\u6709\u65b0\u6570\u636e<\/p>\n<p><\/span><span class=\"nodeLabel\"><\/p>\n<p>\u4ece\u5e93 user \u8868\u4e5f\u6709\u65b0\u6570\u636e<\/p>\n<p><\/span><span class=\"nodeLabel\"><\/p>\n<p>GET \/user\/{id} \u8d70 slave\u80fd\u67e5\u5230\u521a\u63d2\u5165\u7684\u6570\u636e<\/p>\n<p><\/span><\/p>\n<p>\u67e5\u8be2\u4e3b\u5e93&#xff1a;SELECT * FROM user \u80fd\u770b\u5230\u65b0\u8bb0\u5f55 \u2705<br \/>\n\u67e5\u8be2\u4ece\u5e93&#xff1a;SELECT * FROM user \u4e5f\u80fd\u770b\u5230 \u2705&#xff08;\u4e3b\u4ece\u590d\u5236\u540c\u6b65\u8fc7\u6765\u7684&#xff09;<\/p>\n<p>\u8fd9\u8bf4\u660e\u8bfb\u5199\u5206\u79bb &#043; \u4e3b\u4ece\u590d\u5236\u914d\u5408\u5de5\u4f5c&#xff1a;\u5199\u4e3b\u5e93 \u2192 \u81ea\u52a8\u540c\u6b65\u5230\u4ece\u5e93 \u2192 \u8bfb\u4ece\u5e93\u80fd\u67e5\u5230\u3002<\/p>\n<h3>\u516b\u3001\u5b8c\u6574\u4ee3\u7801<\/h3>\n<h4>application.yml&#xff08;\u5b8c\u6574\u7248&#xff09;<\/h4>\n<p><span class=\"token key atrule\">server<\/span><span class=\"token punctuation\">:<\/span><br \/>\n  <span class=\"token key atrule\">port<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token number\">8080<\/span><\/p>\n<p><span class=\"token key atrule\">spring<\/span><span class=\"token punctuation\">:<\/span><br \/>\n  <span class=\"token key atrule\">shardingsphere<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token key atrule\">datasource<\/span><span class=\"token punctuation\">:<\/span><br \/>\n      <span class=\"token comment\"># \u6570\u636e\u6e90\u540d\u79f0\u5217\u8868&#xff0c;\u9017\u53f7\u5206\u9694<\/span><br \/>\n      <span class=\"token key atrule\">names<\/span><span class=\"token punctuation\">:<\/span> master<span class=\"token punctuation\">,<\/span>slave<\/p>\n<p>      <span class=\"token comment\"># \u4e3b\u5e93\u6570\u636e\u6e90<\/span><br \/>\n      <span class=\"token key atrule\">master<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token key atrule\">type<\/span><span class=\"token punctuation\">:<\/span> com.alibaba.druid.pool.DruidDataSource<br \/>\n        <span class=\"token key atrule\">driver-class-name<\/span><span class=\"token punctuation\">:<\/span> com.mysql.cj.jdbc.Driver<br \/>\n        <span class=\"token key atrule\">url<\/span><span class=\"token punctuation\">:<\/span> jdbc<span class=\"token punctuation\">:<\/span>mysql<span class=\"token punctuation\">:<\/span>\/\/192.168.138.100<span class=\"token punctuation\">:<\/span>3306\/rw<span class=\"token punctuation\">?<\/span>characterEncoding&#061;utf<span class=\"token punctuation\">&#8211;<\/span><span class=\"token number\">8<\/span><br \/>\n        <span class=\"token key atrule\">username<\/span><span class=\"token punctuation\">:<\/span> root<br \/>\n        <span class=\"token key atrule\">password<\/span><span class=\"token punctuation\">:<\/span> root<\/p>\n<p>      <span class=\"token comment\"># \u4ece\u5e93\u6570\u636e\u6e90<\/span><br \/>\n      <span class=\"token key atrule\">slave<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token key atrule\">type<\/span><span class=\"token punctuation\">:<\/span> com.alibaba.druid.pool.DruidDataSource<br \/>\n        <span class=\"token key atrule\">driver-class-name<\/span><span class=\"token punctuation\">:<\/span> com.mysql.cj.jdbc.Driver<br \/>\n        <span class=\"token key atrule\">url<\/span><span class=\"token punctuation\">:<\/span> jdbc<span class=\"token punctuation\">:<\/span>mysql<span class=\"token punctuation\">:<\/span>\/\/192.168.138.101<span class=\"token punctuation\">:<\/span>3306\/rw<span class=\"token punctuation\">?<\/span>characterEncoding&#061;utf<span class=\"token punctuation\">&#8211;<\/span><span class=\"token number\">8<\/span><br \/>\n        <span class=\"token key atrule\">username<\/span><span class=\"token punctuation\">:<\/span> root<br \/>\n        <span class=\"token key atrule\">password<\/span><span class=\"token punctuation\">:<\/span> root<\/p>\n<p>    <span class=\"token key atrule\">masterslave<\/span><span class=\"token punctuation\">:<\/span><br \/>\n      <span class=\"token comment\"># \u4ece\u5e93\u8d1f\u8f7d\u5747\u8861\u7b56\u7565&#xff1a;round_robin \u8f6e\u8be2 \/ random \u968f\u673a<\/span><br \/>\n      <span class=\"token key atrule\">load-balance-algorithm-type<\/span><span class=\"token punctuation\">:<\/span> round_robin<br \/>\n      <span class=\"token comment\"># \u6700\u7ec8\u5bf9\u5916\u66b4\u9732\u7684\u6570\u636e\u6e90\u540d\u79f0<\/span><br \/>\n      <span class=\"token key atrule\">name<\/span><span class=\"token punctuation\">:<\/span> dataSource<br \/>\n      <span class=\"token comment\"># \u4e3b\u5e93\u6570\u636e\u6e90\u540d\u79f0&#xff08;\u5bf9\u5e94 datasource \u4e0b\u5b9a\u4e49\u7684\u540d\u5b57&#xff09;<\/span><br \/>\n      <span class=\"token key atrule\">master-data-source-name<\/span><span class=\"token punctuation\">:<\/span> master<br \/>\n      <span class=\"token comment\"># \u4ece\u5e93\u6570\u636e\u6e90\u540d\u79f0\u5217\u8868&#xff0c;\u591a\u4e2a\u7528\u9017\u53f7\u5206\u9694<\/span><br \/>\n      <span class=\"token key atrule\">slave-data-source-names<\/span><span class=\"token punctuation\">:<\/span> slave<\/p>\n<p>    <span class=\"token key atrule\">props<\/span><span class=\"token punctuation\">:<\/span><br \/>\n      <span class=\"token key atrule\">sql<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token key atrule\">show<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token boolean important\">true<\/span>    <span class=\"token comment\"># \u6253\u5370 SQL \u53ca\u8def\u7531\u5230\u7684\u6570\u636e\u6e90&#xff0c;\u4fbf\u4e8e\u9a8c\u8bc1<\/span><\/p>\n<p>  <span class=\"token comment\"># \u5141\u8bb8 Bean \u5b9a\u4e49\u8986\u76d6&#xff1a;\u89e3\u51b3 Sharding-JDBC \u4e0e Druid \u90fd\u521b\u5efa dataSource \u7684\u51b2\u7a81<\/span><br \/>\n  <span class=\"token key atrule\">main<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token key atrule\">allow-bean-definition-overriding<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token boolean important\">true<\/span><\/p>\n<p><span class=\"token key atrule\">mybatis-plus<\/span><span class=\"token punctuation\">:<\/span><br \/>\n  <span class=\"token key atrule\">configuration<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token key atrule\">map-underscore-to-camel-case<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token boolean important\">true<\/span><br \/>\n    <span class=\"token key atrule\">log-impl<\/span><span class=\"token punctuation\">:<\/span> org.apache.ibatis.logging.stdout.StdOutImpl<br \/>\n  <span class=\"token key atrule\">global-config<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token key atrule\">db-config<\/span><span class=\"token punctuation\">:<\/span><br \/>\n      <span class=\"token key atrule\">id-type<\/span><span class=\"token punctuation\">:<\/span> ASSIGN_ID    <span class=\"token comment\"># \u96ea\u82b1\u7b97\u6cd5\u751f\u6210 ID&#xff0c;\u9700 19 \u4f4d&#xff0c;\u6570\u636e\u5e93\u5b57\u6bb5\u5fc5\u987b BIGINT<\/span><\/p>\n<h4>Application&#xff08;\u6392\u9664 Druid \u81ea\u52a8\u914d\u7f6e\u7684\u5199\u6cd5&#xff09;<\/h4>\n<p><span class=\"token keyword\">package<\/span> <span class=\"token namespace\">com<span class=\"token punctuation\">.<\/span>itheima<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token keyword\">import<\/span> <span class=\"token import\"><span class=\"token namespace\">com<span class=\"token punctuation\">.<\/span>alibaba<span class=\"token punctuation\">.<\/span>druid<span class=\"token punctuation\">.<\/span>spring<span class=\"token punctuation\">.<\/span>boot<span class=\"token punctuation\">.<\/span>autoconfigure<span class=\"token punctuation\">.<\/span><\/span><span class=\"token class-name\">DruidDataSourceAutoConfigure<\/span><\/span><span class=\"token punctuation\">;<\/span><br \/>\n<span class=\"token keyword\">import<\/span> <span class=\"token import\"><span class=\"token namespace\">lombok<span class=\"token punctuation\">.<\/span>extern<span class=\"token punctuation\">.<\/span>slf4j<span class=\"token punctuation\">.<\/span><\/span><span class=\"token class-name\">Slf4j<\/span><\/span><span class=\"token punctuation\">;<\/span><br \/>\n<span class=\"token keyword\">import<\/span> <span class=\"token import\"><span class=\"token namespace\">org<span class=\"token punctuation\">.<\/span>springframework<span class=\"token punctuation\">.<\/span>boot<span class=\"token punctuation\">.<\/span><\/span><span class=\"token class-name\">SpringApplication<\/span><\/span><span class=\"token punctuation\">;<\/span><br \/>\n<span class=\"token keyword\">import<\/span> <span class=\"token import\"><span class=\"token namespace\">org<span class=\"token punctuation\">.<\/span>springframework<span class=\"token punctuation\">.<\/span>boot<span class=\"token punctuation\">.<\/span>autoconfigure<span class=\"token punctuation\">.<\/span><\/span><span class=\"token class-name\">SpringBootApplication<\/span><\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token comment\">\/**<br \/>\n * \u8bfb\u5199\u5206\u79bb\u6848\u4f8b\u542f\u52a8\u7c7b<br \/>\n *<br \/>\n * &lt;p&gt;exclude &#061; DruidDataSourceAutoConfigure.class \u7684\u4f5c\u7528&#xff1a;<br \/>\n * \u6392\u9664 Druid \u7684\u6570\u636e\u6e90\u81ea\u52a8\u914d\u7f6e&#xff0c;\u907f\u514d\u5b83\u4e0e Sharding-JDBC \u7684<br \/>\n * SpringBootConfiguration \u4e89\u62a2\u540d\u4e3a dataSource \u7684 Bean\u3002<br \/>\n * \u8fd9\u662f\u6bd4 allow-bean-definition-overriding&#061;true \u66f4\u7cbe\u51c6\u7684\u505a\u6cd5\u3002&lt;\/p&gt;<br \/>\n *<br \/>\n * &lt;p&gt;\u6ce8\u610f&#xff1a;\u5982\u679c\u91c7\u7528\u6392\u9664\u65b9\u5f0f&#xff0c;yml \u4e2d\u7684 allow-bean-definition-overriding \u53ef\u4ee5\u53bb\u6389\u3002&lt;\/p&gt;<br \/>\n *\/<\/span><br \/>\n<span class=\"token annotation punctuation\">&#064;Slf4j<\/span><br \/>\n<span class=\"token annotation punctuation\">&#064;SpringBootApplication<\/span><span class=\"token punctuation\">(<\/span>exclude <span class=\"token operator\">&#061;<\/span> <span class=\"token punctuation\">{<\/span><span class=\"token class-name\">DruidDataSourceAutoConfigure<\/span><span class=\"token punctuation\">.<\/span><span class=\"token keyword\">class<\/span><span class=\"token punctuation\">}<\/span><span class=\"token punctuation\">)<\/span><br \/>\n<span class=\"token keyword\">public<\/span> <span class=\"token keyword\">class<\/span> <span class=\"token class-name\">Application<\/span> <span class=\"token punctuation\">{<\/span><\/p>\n<p>    <span class=\"token keyword\">public<\/span> <span class=\"token keyword\">static<\/span> <span class=\"token keyword\">void<\/span> <span class=\"token function\">main<\/span><span class=\"token punctuation\">(<\/span><span class=\"token class-name\">String<\/span><span class=\"token punctuation\">[<\/span><span class=\"token punctuation\">]<\/span> args<span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{<\/span><br \/>\n        <span class=\"token class-name\">SpringApplication<\/span><span class=\"token punctuation\">.<\/span><span class=\"token function\">run<\/span><span class=\"token punctuation\">(<\/span><span class=\"token class-name\">Application<\/span><span class=\"token punctuation\">.<\/span><span class=\"token keyword\">class<\/span><span class=\"token punctuation\">,<\/span> args<span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><br \/>\n        log<span class=\"token punctuation\">.<\/span><span class=\"token function\">info<\/span><span class=\"token punctuation\">(<\/span><span class=\"token string\">&#034;\u8bfb\u5199\u5206\u79bb\u6848\u4f8b\u542f\u52a8\u6210\u529f&#8230;&#034;<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><br \/>\n    <span class=\"token punctuation\">}<\/span><br \/>\n<span class=\"token punctuation\">}<\/span><\/p>\n<h4>\u5efa\u8868 SQL<\/h4>\n<p><span class=\"token comment\">&#8212; \u5728\u4e3b\u5e93 192.168.138.100 \u6267\u884c&#xff0c;\u4ece\u5e93\u4f1a\u901a\u8fc7\u4e3b\u4ece\u590d\u5236\u81ea\u52a8\u540c\u6b65<\/span><br \/>\n<span class=\"token keyword\">CREATE<\/span> <span class=\"token keyword\">DATABASE<\/span> <span class=\"token keyword\">IF<\/span> <span class=\"token operator\">NOT<\/span> <span class=\"token keyword\">EXISTS<\/span> rw <span class=\"token keyword\">DEFAULT<\/span> <span class=\"token keyword\">CHARACTER<\/span> <span class=\"token keyword\">SET<\/span> utf8mb4<span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token keyword\">USE<\/span> rw<span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token keyword\">DROP<\/span> <span class=\"token keyword\">TABLE<\/span> <span class=\"token keyword\">IF<\/span> <span class=\"token keyword\">EXISTS<\/span> <span class=\"token keyword\">user<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token keyword\">CREATE<\/span> <span class=\"token keyword\">TABLE<\/span> <span class=\"token keyword\">user<\/span> <span class=\"token punctuation\">(<\/span><br \/>\n    id      <span class=\"token keyword\">BIGINT<\/span><span class=\"token punctuation\">(<\/span><span class=\"token number\">20<\/span><span class=\"token punctuation\">)<\/span>   <span class=\"token operator\">NOT<\/span> <span class=\"token boolean\">NULL<\/span> <span class=\"token keyword\">COMMENT<\/span> <span class=\"token string\">&#039;\u4e3b\u952e&#xff0c;\u96ea\u82b1ID\u5fc5\u987bBIGINT&#039;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    name    <span class=\"token keyword\">VARCHAR<\/span><span class=\"token punctuation\">(<\/span><span class=\"token number\">50<\/span><span class=\"token punctuation\">)<\/span>  <span class=\"token keyword\">DEFAULT<\/span> <span class=\"token boolean\">NULL<\/span> <span class=\"token keyword\">COMMENT<\/span> <span class=\"token string\">&#039;\u59d3\u540d&#039;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    age     <span class=\"token keyword\">INT<\/span><span class=\"token punctuation\">(<\/span><span class=\"token number\">11<\/span><span class=\"token punctuation\">)<\/span>      <span class=\"token keyword\">DEFAULT<\/span> <span class=\"token boolean\">NULL<\/span> <span class=\"token keyword\">COMMENT<\/span> <span class=\"token string\">&#039;\u5e74\u9f84&#039;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    address <span class=\"token keyword\">VARCHAR<\/span><span class=\"token punctuation\">(<\/span><span class=\"token number\">200<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">DEFAULT<\/span> <span class=\"token boolean\">NULL<\/span> <span class=\"token keyword\">COMMENT<\/span> <span class=\"token string\">&#039;\u5730\u5740&#039;<\/span><span class=\"token punctuation\">,<\/span><br \/>\n    <span class=\"token keyword\">PRIMARY<\/span> <span class=\"token keyword\">KEY<\/span> <span class=\"token punctuation\">(<\/span><span class=\"token identifier\"><span class=\"token punctuation\">&#096;<\/span>id<span class=\"token punctuation\">&#096;<\/span><\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">USING<\/span> <span class=\"token keyword\">BTREE<\/span><br \/>\n<span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">ENGINE<\/span><span class=\"token operator\">&#061;<\/span><span class=\"token keyword\">InnoDB<\/span> <span class=\"token keyword\">DEFAULT<\/span> <span class=\"token keyword\">CHARSET<\/span><span class=\"token operator\">&#061;<\/span>utf8mb4 <span class=\"token keyword\">COMMENT<\/span><span class=\"token operator\">&#061;<\/span><span class=\"token string\">&#039;\u7528\u6237\u8868&#039;<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<h4>\u9a8c\u8bc1\u811a\u672c<\/h4>\n<p><span class=\"token shebang important\">#!\/bin\/bash<\/span><br \/>\n<span class=\"token comment\"># \u8bfb\u5199\u5206\u79bb\u9a8c\u8bc1\u811a\u672c<\/span><\/p>\n<p><span class=\"token builtin class-name\">echo<\/span> <span class=\"token string\">&#034;&#061;&#061;&#061;&#061;&#061; 1. \u65b0\u589e&#xff08;\u5e94\u8d70 master&#xff09; &#061;&#061;&#061;&#061;&#061;&#034;<\/span><br \/>\n<span class=\"token function\">curl<\/span> <span class=\"token parameter variable\">-X<\/span> POST <span class=\"token string\">&#034;http:\/\/localhost:8080\/user&#034;<\/span> <span class=\"token parameter variable\">-d<\/span> <span class=\"token string\">&#034;name&#061;\u5f20\u4e09&#034;<\/span> <span class=\"token parameter variable\">-d<\/span> <span class=\"token string\">&#034;age&#061;20&#034;<\/span> <span class=\"token parameter variable\">-d<\/span> <span class=\"token string\">&#034;address&#061;\u5317\u4eac&#034;<\/span><\/p>\n<p><span class=\"token builtin class-name\">echo<\/span> <span class=\"token string\">&#034;&#034;<\/span><br \/>\n<span class=\"token builtin class-name\">echo<\/span> <span class=\"token string\">&#034;&#061;&#061;&#061;&#061;&#061; 2. \u67e5\u8be2\u5217\u8868&#xff08;\u5e94\u8d70 slave&#xff09; &#061;&#061;&#061;&#061;&#061;&#034;<\/span><br \/>\n<span class=\"token function\">curl<\/span> <span class=\"token string\">&#034;http:\/\/localhost:8080\/user\/list?name&#061;\u5f20\u4e09&#034;<\/span><\/p>\n<p><span class=\"token builtin class-name\">echo<\/span> <span class=\"token string\">&#034;&#034;<\/span><br \/>\n<span class=\"token builtin class-name\">echo<\/span> <span class=\"token string\">&#034;&#061;&#061;&#061;&#061;&#061; 3. \u4e3b\u5e93\u67e5\u8be2 &#061;&#061;&#061;&#061;&#061;&#034;<\/span><br \/>\nmysql <span class=\"token parameter variable\">-h<\/span> <span class=\"token number\">192.168<\/span>.138.100 <span class=\"token parameter variable\">-uroot<\/span> <span class=\"token parameter variable\">-proot<\/span> <span class=\"token parameter variable\">-e<\/span> <span class=\"token string\">&#034;SELECT * FROM rw.user;&#034;<\/span><\/p>\n<p><span class=\"token builtin class-name\">echo<\/span> <span class=\"token string\">&#034;&#061;&#061;&#061;&#061;&#061; 4. \u4ece\u5e93\u67e5\u8be2&#xff08;\u5e94\u4e0e\u4e3b\u5e93\u4e00\u81f4&#xff09; &#061;&#061;&#061;&#061;&#061;&#034;<\/span><br \/>\nmysql <span class=\"token parameter variable\">-h<\/span> <span class=\"token number\">192.168<\/span>.138.101 <span class=\"token parameter variable\">-uroot<\/span> <span class=\"token parameter variable\">-proot<\/span> <span class=\"token parameter variable\">-e<\/span> <span class=\"token string\">&#034;SELECT * FROM rw.user;&#034;<\/span><\/p>\n<h3>\u4e5d\u3001\u5e38\u89c1\u95ee\u9898<\/h3>\n<table>\n<tr>\u73b0\u8c61\u539f\u56e0\u89e3\u51b3<\/tr>\n<tbody>\n<tr>\n<td>BeanDefinitionOverrideException<\/td>\n<td>Druid \u4e0e Sharding-JDBC \u62a2 dataSource<\/td>\n<td>\u52a0 allow-bean-definition-overriding: true \u6216\u6392\u9664 DruidDataSourceAutoConfigure<\/td>\n<\/tr>\n<tr>\n<td>Out of range value for column &#039;id&#039;<\/td>\n<td>id \u5b57\u6bb5\u662f INT&#xff0c;\u96ea\u82b1 ID \u8d8a\u754c<\/td>\n<td>ALTER TABLE user MODIFY id BIGINT;<\/td>\n<\/tr>\n<tr>\n<td>\u542f\u52a8\u65f6\u62a5\u6570\u636e\u6e90\u8fde\u63a5\u5931\u8d25<\/td>\n<td>IP\/\u5e93\u540d\/\u8d26\u53f7\u5bc6\u7801\u9519<\/td>\n<td>\u7528 mysql -h IP -u user -p \u5b9e\u6d4b\u8fde\u901a\u6027<\/td>\n<\/tr>\n<tr>\n<td>\u6240\u6709 SQL \u90fd\u8d70 master<\/td>\n<td>\u65b9\u6cd5\u4e0a\u6709 &#064;Transactional&#xff1b;\u6216 SELECT &#8230; FOR UPDATE<\/td>\n<td>\u68c0\u67e5\u4e8b\u52a1\u6ce8\u89e3\u8303\u56f4<\/td>\n<\/tr>\n<tr>\n<td>\u4ece\u5e93\u67e5\u4e0d\u5230\u521a\u63d2\u5165\u7684\u6570\u636e<\/td>\n<td>\u4e3b\u4ece\u5ef6\u8fdf<\/td>\n<td>\u7528 HintManager \u5f3a\u5236\u8d70\u4e3b\u5e93&#xff1b;\u6216\u68c0\u67e5 Seconds_Behind_Master<\/td>\n<\/tr>\n<tr>\n<td>DataSources \u65e5\u5fd7\u4e0d\u6253\u5370<\/td>\n<td>props.sql.show \u672a\u8bbe\u4e3a true<\/td>\n<td>\u68c0\u67e5\u914d\u7f6e\u5c42\u7ea7\u662f\u5426\u4e3a shardingsphere.props.sql.show<\/td>\n<\/tr>\n<tr>\n<td>Slave_IO_Running: No<\/td>\n<td>\u4e3b\u4ece\u590d\u5236\u65ad\u4e86<\/td>\n<td>\u91cd\u65b0\u914d\u7f6e CHANGE MASTER TO&#xff08;\u89c1\u7b2c 58 \u7bc7&#xff09;<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>API \u901f\u89c8<\/h3>\n<table>\n<tr>API \/ \u914d\u7f6e\u9879\u6240\u5728\u5305 \/ \u6587\u4ef6\u4f5c\u7528<\/tr>\n<tbody>\n<tr>\n<td>sharding-jdbc-spring-boot-starter<\/td>\n<td>Maven \u5750\u6807<\/td>\n<td>Sharding-JDBC starter&#xff08;4.1.1&#xff09;<\/td>\n<\/tr>\n<tr>\n<td>spring.shardingsphere.datasource.names<\/td>\n<td>application.yml<\/td>\n<td>\u6570\u636e\u6e90\u540d\u79f0\u5217\u8868<\/td>\n<\/tr>\n<tr>\n<td>spring.shardingsphere.datasource.&lt;name&gt;.type<\/td>\n<td>application.yml<\/td>\n<td>\u8fde\u63a5\u6c60\u5b9e\u73b0\u7c7b<\/td>\n<\/tr>\n<tr>\n<td>spring.shardingsphere.datasource.&lt;name&gt;.url<\/td>\n<td>application.yml<\/td>\n<td>JDBC \u8fde\u63a5\u4e32<\/td>\n<\/tr>\n<tr>\n<td>spring.shardingsphere.masterslave.name<\/td>\n<td>application.yml<\/td>\n<td>\u5bf9\u5916\u6570\u636e\u6e90 Bean \u540d<\/td>\n<\/tr>\n<tr>\n<td>spring.shardingsphere.masterslave.master-data-source-name<\/td>\n<td>application.yml<\/td>\n<td>\u6307\u5b9a\u4e3b\u5e93<\/td>\n<\/tr>\n<tr>\n<td>spring.shardingsphere.masterslave.slave-data-source-names<\/td>\n<td>application.yml<\/td>\n<td>\u6307\u5b9a\u4ece\u5e93&#xff08;\u591a\u4e2a\u9017\u53f7\u5206\u9694&#xff09;<\/td>\n<\/tr>\n<tr>\n<td>spring.shardingsphere.masterslave.load-balance-algorithm-type<\/td>\n<td>application.yml<\/td>\n<td>round_robin \/ random<\/td>\n<\/tr>\n<tr>\n<td>spring.shardingsphere.props.sql.show<\/td>\n<td>application.yml<\/td>\n<td>\u6253\u5370 SQL \u53ca\u8def\u7531\u6570\u636e\u6e90<\/td>\n<\/tr>\n<tr>\n<td>spring.main.allow-bean-definition-overriding<\/td>\n<td>application.yml<\/td>\n<td>\u5141\u8bb8 Bean \u5b9a\u4e49\u8986\u76d6<\/td>\n<\/tr>\n<tr>\n<td>&#064;SpringBootApplication(exclude&#061;&#8230;)<\/td>\n<td>org.springframework.boot.autoconfigure<\/td>\n<td>\u6392\u9664\u6307\u5b9a\u81ea\u52a8\u914d\u7f6e\u7c7b<\/td>\n<\/tr>\n<tr>\n<td>DruidDataSourceAutoConfigure<\/td>\n<td>com.alibaba.druid.spring.boot.autoconfigure<\/td>\n<td>Druid \u6570\u636e\u6e90\u81ea\u52a8\u914d\u7f6e\u7c7b<\/td>\n<\/tr>\n<tr>\n<td>MasterSlaveDataSource<\/td>\n<td>org.apache.shardingsphere.shardingjdbc.jdbc.core.datasource<\/td>\n<td>\u8bfb\u5199\u5206\u79bb\u6570\u636e\u6e90<\/td>\n<\/tr>\n<tr>\n<td>getDataSourceMap()<\/td>\n<td>MasterSlaveDataSource<\/td>\n<td>\u83b7\u53d6\u5185\u90e8\u6570\u636e\u6e90 Map<\/td>\n<\/tr>\n<tr>\n<td>id-type: ASSIGN_ID<\/td>\n<td>mybatis-plus.global-config.db-config<\/td>\n<td>\u96ea\u82b1\u7b97\u6cd5 ID \u751f\u6210\u7b56\u7565<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>\u5b98\u65b9\u6587\u6863<\/h3>\n<table>\n<tr>\u4e3b\u9898\u94fe\u63a5<\/tr>\n<tbody>\n<tr>\n<td>Sharding-JDBC \u8bfb\u5199\u5206\u79bb&#xff08;4.x&#xff09;<\/td>\n<td>https:\/\/shardingsphere.apache.org\/document\/4.1.1\/cn\/manual\/sharding-jdbc\/usage\/read-write-splitting\/<\/td>\n<\/tr>\n<tr>\n<td>Spring Boot \u914d\u7f6e\u9879<\/td>\n<td>https:\/\/shardingsphere.apache.org\/document\/4.1.1\/cn\/manual\/sharding-jdbc\/configuration\/config-spring-boot\/<\/td>\n<\/tr>\n<tr>\n<td>Spring Boot 2.1 Bean \u8986\u76d6\u53d8\u66f4<\/td>\n<td>https:\/\/github.com\/spring-projects\/spring-boot\/wiki\/Spring-Boot-2.1-Release-Notes#bean-overriding<\/td>\n<\/tr>\n<tr>\n<td>MyBatis-Plus ID \u751f\u6210\u7b56\u7565<\/td>\n<td>https:\/\/baomidou.com\/pages\/e131bd\/<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>\u603b\u7ed3<\/h3>\n<p>Sharding-JDBC \u5b9e\u73b0\u8bfb\u5199\u5206\u79bb\u53ea\u9700\u8981\u4e09\u6b65&#xff0c;\u5168\u7a0b\u4e0d\u5199\u4e00\u884c Java \u4ee3\u7801&#xff1a;\u5bfc\u5750\u6807\u3001\u914d yml\u3001\u5141\u8bb8 Bean \u8986\u76d6\u3002<\/p>\n<p>\u914d\u7f6e\u7684\u6838\u5fc3\u662f\u628a\u4e09\u4ef6\u4e8b\u8bf4\u6e05\u695a&#xff1a;\u6709\u51e0\u4e2a\u6570\u636e\u6e90&#xff08;datasource.names&#xff09;\u3001\u6bcf\u4e2a\u6570\u636e\u6e90\u8fde\u54ea\u91cc&#xff08;datasource.&lt;name&gt;.*&#xff09;\u3001\u8c01\u662f\u4e3b\u8c01\u662f\u4ece&#xff08;masterslave.master-data-source-name \/ slave-data-source-names&#xff09;\u3002\u6570\u636e\u6e90\u540d\u5b57\u53ef\u4ee5\u968f\u4fbf\u8d77&#xff0c;\u4f46\u5fc5\u987b\u4e0a\u4e0b\u5bf9\u5e94\u2014\u2014\u540d\u5b57\u53eb master \u4e0d\u4ee3\u8868\u5b83\u662f\u4e3b\u5e93&#xff0c;\u771f\u6b63\u51b3\u5b9a\u8eab\u4efd\u7684\u662f master-data-source-name\u3002<\/p>\n<p>Bean \u5b9a\u4e49\u51b2\u7a81\u662f\u4e2a\u5fc5\u8e29\u7684\u5751&#xff1a;Sharding-JDBC \u7684 SpringBootConfiguration \u548c Druid \u7684 DruidDataSourceAutoConfigure \u90fd\u8981\u521b\u5efa\u540d\u4e3a dataSource \u7684 Bean&#xff0c;\u800c Spring Boot 2.1&#043; \u9ed8\u8ba4\u7981\u6b62\u8986\u76d6\u3002\u4e24\u79cd\u89e3\u6cd5\u2014\u2014\u52a0 allow-bean-definition-overriding: true&#xff08;\u8bfe\u7a0b\u505a\u6cd5&#xff0c;\u7b80\u5355&#xff09;&#xff0c;\u6216 &#064;SpringBootApplication(exclude &#061; DruidDataSourceAutoConfigure.class)&#xff08;\u63a8\u8350&#xff0c;\u7cbe\u51c6\u4e14\u4e0d\u4f1a\u63a9\u76d6\u5176\u4ed6\u771f\u5b9e\u51b2\u7a81&#xff09;\u3002<\/p>\n<p>\u9a8c\u8bc1\u65b9\u6cd5\u6709\u4e24\u6761&#xff1a;\u65ad\u70b9\u89c2\u5bdf\u6ce8\u5165\u7684 DataSource \u5df2\u53d8\u6210 MasterSlaveDataSource \u4e14 dataSourceMap.size &#061; 2&#xff1b;\u63a7\u5236\u53f0\u65e5\u5fd7\u91cc DataSources: slave&#xff08;SELECT&#xff09;\u4e0e DataSources: master&#xff08;INSERT&#xff09;&#xff0c;\u8fd9\u662f\u6700\u76f4\u63a5\u7684\u8bc1\u636e\u3002<\/p>\n<p>\u8e29\u5751\u63d0\u9192&#xff1a;user.id \u5fc5\u987b\u7528 BIGINT\u3002MyBatis-Plus \u7684 ASSIGN_ID \u751f\u6210 19 \u4f4d\u96ea\u82b1 ID&#xff0c;INT \u5b57\u6bb5\u4f1a Out of range\u3002<\/p>\n<p>\u6700\u540e\u91cd\u7533\u4e00\u4e2a\u5bb9\u6613\u8ba9\u8bfb\u5199\u5206\u79bb\u5931\u6548\u7684\u673a\u5236&#xff1a;\u4e8b\u52a1\u5185\u6240\u6709 SQL \u90fd\u8d70\u4e3b\u5e93\u3002\u9a8c\u8bc1\u65f6\u5982\u679c\u770b\u5230 SELECT \u4e5f\u8d70 master&#xff0c;\u5148\u67e5\u65b9\u6cd5\u4e0a\u6709\u6ca1\u6709 &#064;Transactional\u3002<\/p>\n<p>\u4e0b\u4e00\u7bc7\u628a\u8bfb\u5199\u5206\u79bb\u6539\u9020\u843d\u5230\u5916\u5356\u5e73\u53f0\u4e3b\u9879\u76ee\u4e0a\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u8bfb\u5199\u5206\u79bb: Sharding-JDBC \u8bfb\u5199\u5206\u79bb\u914d\u7f6e\u4e0e Bean \u5b9a\u4e49\u51b2\u7a81\u89e3\u51b3<br \/>\n\u7eb2\u8981<br \/>\n\u51c6\u5907\u6570\u636e\u5e93\u73af\u5883&#xff1a;\u5728\u4e3b\u5e93\u5efa rw \u5e93\u4e0e user \u8868&#xff0c;\u9760\u4e3b\u4ece\u590d\u5236\u81ea\u52a8\u540c\u6b65\u5230\u4ece\u5e93\u4e09\u6b65\u914d\u7f6e&#xff1a;\u5bfc\u5165\u5750\u6807 \u2192 \u914d\u7f6e application.yml \u8bfb\u5199\u5206\u79bb\u89c4\u5219 \u2192 \u52a0 allow-bean-definition-overridingBean \u5b9a\u4e49\u51b2\u7a81&#xff1a;Sharding-JDBC \u4e0e Druid \u90fd\u8981\u521b\u5efa DataSource&#xff0c;\u4e3a\u4ec0<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[99,190],"topic":[],"class_list":["post-112466","post","type-post","status-publish","format-standard","hentry","category-server","tag-java","tag-190"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Java \u9879\u76ee\u5b9e\u6218: \u5916\u5356\u5e73\u53f0\u4f18\u5316-ShardingJDBC\u8bfb\u5199\u5206\u79bb\u914d\u7f6e\u4e0eBean\u5b9a\u4e49\u51b2\u7a81 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wsisp.com\/helps\/112466.html\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Java \u9879\u76ee\u5b9e\u6218: \u5916\u5356\u5e73\u53f0\u4f18\u5316-ShardingJDBC\u8bfb\u5199\u5206\u79bb\u914d\u7f6e\u4e0eBean\u5b9a\u4e49\u51b2\u7a81 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"og:description\" content=\"\u8bfb\u5199\u5206\u79bb: Sharding-JDBC \u8bfb\u5199\u5206\u79bb\u914d\u7f6e\u4e0e Bean \u5b9a\u4e49\u51b2\u7a81\u89e3\u51b3 \u7eb2\u8981 \u51c6\u5907\u6570\u636e\u5e93\u73af\u5883&#xff1a;\u5728\u4e3b\u5e93\u5efa rw \u5e93\u4e0e user \u8868&#xff0c;\u9760\u4e3b\u4ece\u590d\u5236\u81ea\u52a8\u540c\u6b65\u5230\u4ece\u5e93\u4e09\u6b65\u914d\u7f6e&#xff1a;\u5bfc\u5165\u5750\u6807 \u2192 \u914d\u7f6e application.yml \u8bfb\u5199\u5206\u79bb\u89c4\u5219 \u2192 \u52a0 allow-bean-definition-overridingBean \u5b9a\u4e49\u51b2\u7a81&#xff1a;Sharding-JDBC \u4e0e Druid \u90fd\u8981\u521b\u5efa DataSource&#xff0c;\u4e3a\u4ec0\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wsisp.com\/helps\/112466.html\" \/>\n<meta property=\"og:site_name\" content=\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"article:published_time\" content=\"2026-10-03T12:01:06+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"13 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/112466.html\",\"url\":\"https:\/\/www.wsisp.com\/helps\/112466.html\",\"name\":\"Java \u9879\u76ee\u5b9e\u6218: \u5916\u5356\u5e73\u53f0\u4f18\u5316-ShardingJDBC\u8bfb\u5199\u5206\u79bb\u914d\u7f6e\u4e0eBean\u5b9a\u4e49\u51b2\u7a81 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"isPartOf\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\"},\"datePublished\":\"2026-10-03T12:01:06+00:00\",\"dateModified\":\"2026-10-03T12:01:06+00:00\",\"author\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/112466.html#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wsisp.com\/helps\/112466.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/112466.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.wsisp.com\/helps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Java \u9879\u76ee\u5b9e\u6218: \u5916\u5356\u5e73\u53f0\u4f18\u5316-ShardingJDBC\u8bfb\u5199\u5206\u79bb\u914d\u7f6e\u4e0eBean\u5b9a\u4e49\u51b2\u7a81\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\",\"url\":\"https:\/\/www.wsisp.com\/helps\/\",\"name\":\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"description\":\"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"contentUrl\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"caption\":\"admin\"},\"sameAs\":[\"http:\/\/wp.wsisp.com\"],\"url\":\"https:\/\/www.wsisp.com\/helps\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Java \u9879\u76ee\u5b9e\u6218: \u5916\u5356\u5e73\u53f0\u4f18\u5316-ShardingJDBC\u8bfb\u5199\u5206\u79bb\u914d\u7f6e\u4e0eBean\u5b9a\u4e49\u51b2\u7a81 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.wsisp.com\/helps\/112466.html","og_locale":"zh_CN","og_type":"article","og_title":"Java \u9879\u76ee\u5b9e\u6218: \u5916\u5356\u5e73\u53f0\u4f18\u5316-ShardingJDBC\u8bfb\u5199\u5206\u79bb\u914d\u7f6e\u4e0eBean\u5b9a\u4e49\u51b2\u7a81 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","og_description":"\u8bfb\u5199\u5206\u79bb: Sharding-JDBC \u8bfb\u5199\u5206\u79bb\u914d\u7f6e\u4e0e Bean \u5b9a\u4e49\u51b2\u7a81\u89e3\u51b3 \u7eb2\u8981 \u51c6\u5907\u6570\u636e\u5e93\u73af\u5883&#xff1a;\u5728\u4e3b\u5e93\u5efa rw \u5e93\u4e0e user \u8868&#xff0c;\u9760\u4e3b\u4ece\u590d\u5236\u81ea\u52a8\u540c\u6b65\u5230\u4ece\u5e93\u4e09\u6b65\u914d\u7f6e&#xff1a;\u5bfc\u5165\u5750\u6807 \u2192 \u914d\u7f6e application.yml \u8bfb\u5199\u5206\u79bb\u89c4\u5219 \u2192 \u52a0 allow-bean-definition-overridingBean \u5b9a\u4e49\u51b2\u7a81&#xff1a;Sharding-JDBC \u4e0e Druid \u90fd\u8981\u521b\u5efa DataSource&#xff0c;\u4e3a\u4ec0","og_url":"https:\/\/www.wsisp.com\/helps\/112466.html","og_site_name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","article_published_time":"2026-10-03T12:01:06+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"admin","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"13 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wsisp.com\/helps\/112466.html","url":"https:\/\/www.wsisp.com\/helps\/112466.html","name":"Java \u9879\u76ee\u5b9e\u6218: \u5916\u5356\u5e73\u53f0\u4f18\u5316-ShardingJDBC\u8bfb\u5199\u5206\u79bb\u914d\u7f6e\u4e0eBean\u5b9a\u4e49\u51b2\u7a81 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","isPartOf":{"@id":"https:\/\/www.wsisp.com\/helps\/#website"},"datePublished":"2026-10-03T12:01:06+00:00","dateModified":"2026-10-03T12:01:06+00:00","author":{"@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41"},"breadcrumb":{"@id":"https:\/\/www.wsisp.com\/helps\/112466.html#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wsisp.com\/helps\/112466.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.wsisp.com\/helps\/112466.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.wsisp.com\/helps"},{"@type":"ListItem","position":2,"name":"Java \u9879\u76ee\u5b9e\u6218: \u5916\u5356\u5e73\u53f0\u4f18\u5316-ShardingJDBC\u8bfb\u5199\u5206\u79bb\u914d\u7f6e\u4e0eBean\u5b9a\u4e49\u51b2\u7a81"}]},{"@type":"WebSite","@id":"https:\/\/www.wsisp.com\/helps\/#website","url":"https:\/\/www.wsisp.com\/helps\/","name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","description":"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41","name":"admin","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/","url":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","contentUrl":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","caption":"admin"},"sameAs":["http:\/\/wp.wsisp.com"],"url":"https:\/\/www.wsisp.com\/helps\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/112466","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/comments?post=112466"}],"version-history":[{"count":0,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/112466\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media?parent=112466"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/categories?post=112466"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/tags?post=112466"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/topic?post=112466"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}