{"id":115163,"date":"2026-10-11T10:25:32","date_gmt":"2026-10-11T02:25:32","guid":{"rendered":"https:\/\/www.wsisp.com\/helps\/115163.html"},"modified":"2026-10-11T10:25:32","modified_gmt":"2026-10-11T02:25:32","slug":"mysql%e5%ad%a6%e4%b9%a0%e7%ac%94%e8%ae%b0%ef%bc%9ashardingsphere-proxy%e5%88%86%e5%ba%93%e5%88%86%e8%a1%a8%e8%af%bb%e5%86%99%e5%88%86%e7%a6%bb%e4%bb%8e%e9%9b%b6%e6%90%ad%e5%bb%ba%e6%8c%87%e5%8d%97","status":"publish","type":"post","link":"https:\/\/www.wsisp.com\/helps\/115163.html","title":{"rendered":"Mysql\u5b66\u4e60\u7b14\u8bb0\uff1aShardingSphere-Proxy\u5206\u5e93\u5206\u8868+\u8bfb\u5199\u5206\u79bb\u4ece\u96f6\u642d\u5efa\u6307\u5357"},"content":{"rendered":"<hr \/>\n<p>&#x1f4dd; \u672c\u6587\u9996\u53d1\u4e8e \u680f\u8f69\u00b7\u9601<\/p>\n<p>\u6b22\u8fce\u8bbf\u95ee\u9605\u8bfb\u539f\u6587&#xff0c;\u83b7\u53d6\u66f4\u597d\u7684\u9605\u8bfb\u4f53\u9a8c\u3002<\/p>\n<hr \/>\n<h3>\u4e00\u3001\u80cc\u666f&#xff1a;\u4e3a\u4ec0\u4e48\u9700\u8981\u5206\u5e03\u5f0f\u6570\u636e\u5e93<\/h3>\n<p>\u5355\u4e2a MySQL \u5b9e\u4f8b\u5728\u6570\u636e\u91cf\u8fbe\u5230\u5343\u4e07\u7ea7\u3001QPS \u8fbe\u5230\u6570\u5343\u65f6&#xff0c;\u4f1a\u9762\u4e34\u660e\u663e\u7684\u74f6\u9888&#xff1a;<\/p>\n<ul>\n<li>\u5199\u5165\u74f6\u9888&#xff1a;\u5355\u5e93\u7684\u5199\u5165\u80fd\u529b\u6709\u9650&#xff0c;\u65e0\u6cd5\u6c34\u5e73\u6269\u5c55<\/li>\n<li>\u8bfb\u53d6\u74f6\u9888&#xff1a;\u5355\u5e93\u625b\u4e0d\u4f4f\u5927\u91cf\u5e76\u53d1\u67e5\u8be2<\/li>\n<li>\u5b58\u50a8\u74f6\u9888&#xff1a;\u5355\u8868\u6570\u636e\u91cf\u8fc7\u5927\u65f6&#xff0c;\u7d22\u5f15\u7ef4\u62a4\u6210\u672c\u6025\u5267\u4e0a\u5347<\/li>\n<\/ul>\n<p>ShardingSphere \u5c31\u662f\u4e3a\u89e3\u51b3\u8fd9\u4e9b\u95ee\u9898\u800c\u751f\u2014\u2014\u5b83\u662f\u4e00\u5957\u5f00\u6e90\u7684\u5206\u5e03\u5f0f\u6570\u636e\u5e93\u4e2d\u95f4\u4ef6&#xff0c;\u63d0\u4f9b\u5206\u5e93\u5206\u8868\u3001\u8bfb\u5199\u5206\u79bb\u3001\u6570\u636e\u52a0\u5bc6\u3001\u5206\u5e03\u5f0f\u4e8b\u52a1\u7b49\u80fd\u529b\u3002<\/p>\n<h3>\u4e8c\u3001ShardingSphere \u6838\u5fc3\u6982\u5ff5<\/h3>\n<p>ShardingSphere \u63d0\u4f9b\u4e24\u79cd\u90e8\u7f72\u6a21\u5f0f&#xff1a;<\/p>\n<table>\n<tr>\u6a21\u5f0f\u7279\u70b9\u9002\u7528\u573a\u666f<\/tr>\n<tbody>\n<tr>\n<td>JDBC<\/td>\n<td>\u5d4c\u5165\u5e94\u7528\u5185&#xff0c;\u8f7b\u91cf\u7ea7<\/td>\n<td>\u5c0f\u578b\u9879\u76ee\u3001\u5355\u4f53\u5e94\u7528<\/td>\n<\/tr>\n<tr>\n<td>Proxy<\/td>\n<td>\u72ec\u7acb\u670d\u52a1&#xff0c;\u517c\u5bb9 MySQL \u534f\u8bae<\/td>\n<td>\u591a\u5e94\u7528\u5171\u4eab\u3001\u590d\u6742\u67b6\u6784<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\u672c\u6587\u91c7\u7528 Proxy \u6a21\u5f0f \u90e8\u7f72\u3002<\/p>\n<h4>\u5206\u7247\u7b56\u7565<\/h4>\n<p>ShardingSphere \u652f\u6301\u591a\u79cd\u5206\u7247\u7b97\u6cd5&#xff1a;<\/p>\n<ul>\n<li>MOD&#xff08;\u53d6\u6a21&#xff09;&#xff1a;user_id % 2 \u51b3\u5b9a\u6570\u636e\u53bb\u54ea\u4e2a\u5e93<\/li>\n<li>HASH_MOD&#xff1a;\u54c8\u5e0c\u53d6\u6a21&#xff0c;\u5206\u5e03\u66f4\u5747\u5300<\/li>\n<li>INLINE&#xff1a;\u901a\u8fc7 Groovy \u8868\u8fbe\u5f0f\u81ea\u5b9a\u4e49\u8def\u7531<\/li>\n<li>INTERVAL&#xff1a;\u6309\u65f6\u95f4\u8303\u56f4\u5206\u7247<\/li>\n<\/ul>\n<p>\u672c\u9879\u76ee\u4f7f\u7528 INLINE \u8868\u8fbe\u5f0f\u5b9e\u73b0\u53cc\u5c42\u5206\u7247&#xff1a;<\/p>\n<p>user_id % 2 \u2192 \u51b3\u5b9a\u53bb\u54ea\u4e2a\u96c6\u7fa4&#xff08;\u5206\u5e93&#xff09;<br \/>\norder_id % 2 \u2192 \u51b3\u5b9a\u53bb\u96c6\u7fa4\u5185\u7684\u54ea\u5f20\u8868&#xff08;\u5206\u8868&#xff09;<\/p>\n<h3>\u4e09\u3001\u67b6\u6784\u8bbe\u8ba1<\/h3>\n<p>\u5ba2\u6237\u7aef \u2192 ShardingSphere-Proxy (22226)<br \/>\n              \u2502<br \/>\n      \u250c\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2534\u2500\u2500\u2500\u2500\u2500\u2500\u2500\u2510<br \/>\n      \u2502               \u2502<br \/>\n   ds_0(\u5076\u6570)      ds_1(\u5947\u6570)<br \/>\n      \u2502               \u2502<br \/>\n  \u250c\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2510       \u250c\u2500\u2500\u2500\u253c\u2500\u2500\u2500\u2510<br \/>\n  \u2502   \u2502   \u2502       \u2502   \u2502   \u2502<br \/>\n Master Slave1 Slave2  Master Slave1 Slave2<br \/>\n(22220)(22221)(22222) (22223)(22224)(22225)<\/p>\n<p>\u5206\u7247\u89c4\u5219&#xff1a;<\/p>\n<ul>\n<li>user_id % 2 &#061;&#061; 0 \u2192 Cluster A&#xff08;ds_0&#xff09;<\/li>\n<li>user_id % 2 &#061;&#061; 1 \u2192 Cluster B&#xff08;ds_1&#xff09;<\/li>\n<li>order_id % 2 &#061;&#061; 0 \u2192 t_order_0<\/li>\n<li>order_id % 2 &#061;&#061; 1 \u2192 t_order_1<\/li>\n<\/ul>\n<h3>\u56db\u3001\u73af\u5883\u51c6\u5907<\/h3>\n<table>\n<tr>\u5de5\u5177\u7248\u672c<\/tr>\n<tbody>\n<tr>\n<td>Docker Desktop<\/td>\n<td>\u6700\u65b0\u7248<\/td>\n<\/tr>\n<tr>\n<td>Docker Compose<\/td>\n<td>V2<\/td>\n<\/tr>\n<tr>\n<td>MySQL<\/td>\n<td>8.0<\/td>\n<\/tr>\n<tr>\n<td>ShardingSphere-Proxy<\/td>\n<td>5.5.3<\/td>\n<\/tr>\n<tr>\n<td>OS<\/td>\n<td>Windows 11 &#043; WSL2<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>\u4e94\u3001\u96c6\u7fa4\u90e8\u7f72\u5b9e\u6218<\/h3>\n<h4>5.1 \u5bb9\u5668\u89c4\u5212<\/h4>\n<p>\u9700\u8981\u521b\u5efa 8 \u4e2a\u5bb9\u5668&#xff1a;<\/p>\n<table>\n<tr>\u5bb9\u5668\u540d\u89d2\u8272\u7aef\u53e3\u6620\u5c04<\/tr>\n<tbody>\n<tr>\n<td>mysql_a_master<\/td>\n<td>Cluster A \u4e3b\u5e93<\/td>\n<td>22220:3306<\/td>\n<\/tr>\n<tr>\n<td>mysql_a_slave1<\/td>\n<td>Cluster A \u4ece\u5e931<\/td>\n<td>22221:3306<\/td>\n<\/tr>\n<tr>\n<td>mysql_a_slave2<\/td>\n<td>Cluster A \u4ece\u5e932<\/td>\n<td>22222:3306<\/td>\n<\/tr>\n<tr>\n<td>mysql_b_master<\/td>\n<td>Cluster B \u4e3b\u5e93<\/td>\n<td>22223:3306<\/td>\n<\/tr>\n<tr>\n<td>mysql_b_slave1<\/td>\n<td>Cluster B \u4ece\u5e931<\/td>\n<td>22224:3306<\/td>\n<\/tr>\n<tr>\n<td>mysql_b_slave2<\/td>\n<td>Cluster B \u4ece\u5e932<\/td>\n<td>22225:3306<\/td>\n<\/tr>\n<tr>\n<td>sharding-proxy<\/td>\n<td>\u7edf\u4e00\u5165\u53e3<\/td>\n<td>22226:3307<\/td>\n<\/tr>\n<tr>\n<td>setup<\/td>\n<td>\u521d\u59cb\u5316&#xff08;\u4e00\u6b21\u6027&#xff09;<\/td>\n<td>&#8211;<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>5.2 \u9879\u76ee\u6587\u4ef6\u7ed3\u6784<\/h4>\n<p>\u5728\u5f00\u59cb\u4e4b\u524d&#xff0c;\u5148\u521b\u5efa\u597d\u76ee\u5f55\u7ed3\u6784&#xff1a;<\/p>\n<p>sharding-lab\/<br \/>\n\u251c\u2500\u2500 docker-compose.yml<br \/>\n\u251c\u2500\u2500 sharding-proxy\/<br \/>\n\u2502   \u251c\u2500\u2500 Dockerfile<br \/>\n\u2502   \u251c\u2500\u2500 global.yaml<br \/>\n\u2502   \u2514\u2500\u2500 database-sharding.yaml<br \/>\n\u2514\u2500\u2500 scripts\/<br \/>\n    \u2514\u2500\u2500 init.sh<\/p>\n<h4>5.3 \u7f16\u5199 Docker Compose<\/h4>\n<p>\u5b8c\u6574\u7684 docker-compose.yml&#xff1a;<\/p>\n<p><span class=\"token key atrule\">version<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token string\">&#034;3.8&#034;<\/span><\/p>\n<p><span class=\"token key atrule\">networks<\/span><span class=\"token punctuation\">:<\/span><br \/>\n  <span class=\"token key atrule\">sharding-net<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token key atrule\">driver<\/span><span class=\"token punctuation\">:<\/span> bridge<\/p>\n<p><span class=\"token key atrule\">x-mysql<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token important\">&amp;mysql<\/span><br \/>\n  <span class=\"token key atrule\">image<\/span><span class=\"token punctuation\">:<\/span> mysql<span class=\"token punctuation\">:<\/span><span class=\"token number\">8.0<\/span><br \/>\n  <span class=\"token key atrule\">environment<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token key atrule\">MYSQL_ROOT_PASSWORD<\/span><span class=\"token punctuation\">:<\/span> root123<br \/>\n  <span class=\"token key atrule\">networks<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token punctuation\">&#8211;<\/span> sharding<span class=\"token punctuation\">&#8211;<\/span>net<\/p>\n<p><span class=\"token key atrule\">services<\/span><span class=\"token punctuation\">:<\/span><br \/>\n  <span class=\"token comment\"># &#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061; Cluster A &#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;<\/span><br \/>\n  <span class=\"token comment\"># &#8212;- Master \u53c2\u6570\u8bf4\u660e &#8212;-<\/span><br \/>\n  <span class=\"token comment\"># &#8211;server-id: \u96c6\u7fa4\u5185\u552f\u4e00\u7f16\u53f7&#xff0c;\u4e3b\u4ece\u8282\u70b9\u5fc5\u987b\u4e0d\u540c<\/span><br \/>\n  <span class=\"token comment\"># &#8211;log-bin: \u5f00\u542f\u4e8c\u8fdb\u5236\u65e5\u5fd7&#xff0c;\u4ec5 Master \u9700\u8981<\/span><br \/>\n  <span class=\"token comment\"># &#8211;gtid_mode: \u542f\u7528 GTID \u590d\u5236&#xff0c;\u7b80\u5316\u4e3b\u4ece\u4f4d\u7f6e\u7ba1\u7406<\/span><br \/>\n  <span class=\"token comment\"># &#8211;binlog-do-db: \u53ea\u8bb0\u5f55\u6307\u5b9a\u5e93\u7684 binlog<\/span><br \/>\n  <span class=\"token key atrule\">mysql_a_master<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token key atrule\">&lt;&lt;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token important\">*mysql<\/span><br \/>\n    <span class=\"token key atrule\">container_name<\/span><span class=\"token punctuation\">:<\/span> mysql_a_master<br \/>\n    <span class=\"token key atrule\">ports<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;22220:3306&#034;<\/span><span class=\"token punctuation\">]<\/span><br \/>\n    <span class=\"token key atrule\">command<\/span><span class=\"token punctuation\">:<\/span><br \/>\n      <span class=\"token punctuation\">&#8211;<\/span><span class=\"token punctuation\">&#8211;<\/span>server<span class=\"token punctuation\">&#8211;<\/span>id&#061;1 <span class=\"token punctuation\">&#8211;<\/span><span class=\"token punctuation\">&#8211;<\/span>log<span class=\"token punctuation\">&#8211;<\/span>bin&#061;mysql<span class=\"token punctuation\">&#8211;<\/span>bin <span class=\"token punctuation\">&#8211;<\/span><span class=\"token punctuation\">&#8211;<\/span>binlog<span class=\"token punctuation\">&#8211;<\/span>format&#061;ROW<br \/>\n      <span class=\"token punctuation\">&#8211;<\/span><span class=\"token punctuation\">&#8211;<\/span>gtid_mode&#061;ON <span class=\"token punctuation\">&#8211;<\/span><span class=\"token punctuation\">&#8211;<\/span>enforce<span class=\"token punctuation\">&#8211;<\/span>gtid<span class=\"token punctuation\">&#8211;<\/span>consistency&#061;ON<br \/>\n      <span class=\"token punctuation\">&#8211;<\/span><span class=\"token punctuation\">&#8211;<\/span>binlog<span class=\"token punctuation\">&#8211;<\/span>do<span class=\"token punctuation\">&#8211;<\/span>db&#061;sharding_db<\/p>\n<p>  <span class=\"token comment\"># &#8212;- Slave \u53c2\u6570\u8bf4\u660e &#8212;-<\/span><br \/>\n  <span class=\"token comment\"># &#8211;server-id: \u4e0e Master \u4e0d\u540c\u5373\u53ef&#xff0c;\u65e0\u5927\u5c0f\u987a\u5e8f<\/span><br \/>\n  <span class=\"token comment\"># &#8211;relay-log: \u63a5\u6536 Master \u7684 binlog \u540e\u5199\u5165 relay log<\/span><br \/>\n  <span class=\"token comment\"># &#8211;skip-slave-start: \u542f\u52a8\u65f6\u4e0d\u81ea\u52a8\u590d\u5236&#xff0c;\u7531 init.sh \u63a7\u5236<\/span><br \/>\n  <span class=\"token comment\"># &#8211;gtid_mode: Slave \u4e5f\u8981\u5f00\u542f&#xff0c;\u624d\u80fd\u4f7f\u7528 MASTER_AUTO_POSITION<\/span><br \/>\n  <span class=\"token key atrule\">mysql_a_slave1<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token key atrule\">&lt;&lt;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token important\">*mysql<\/span><br \/>\n    <span class=\"token key atrule\">container_name<\/span><span class=\"token punctuation\">:<\/span> mysql_a_slave1<br \/>\n    <span class=\"token key atrule\">ports<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;22221:3306&#034;<\/span><span class=\"token punctuation\">]<\/span><br \/>\n    <span class=\"token key atrule\">command<\/span><span class=\"token punctuation\">:<\/span><br \/>\n      <span class=\"token punctuation\">&#8211;<\/span><span class=\"token punctuation\">&#8211;<\/span>server<span class=\"token punctuation\">&#8211;<\/span>id&#061;2 <span class=\"token punctuation\">&#8211;<\/span><span class=\"token punctuation\">&#8211;<\/span>relay<span class=\"token punctuation\">&#8211;<\/span>log&#061;relay<span class=\"token punctuation\">&#8211;<\/span>log <span class=\"token punctuation\">&#8211;<\/span><span class=\"token punctuation\">&#8211;<\/span>skip<span class=\"token punctuation\">&#8211;<\/span>slave<span class=\"token punctuation\">&#8211;<\/span>start&#061;ON<br \/>\n      <span class=\"token punctuation\">&#8211;<\/span><span class=\"token punctuation\">&#8211;<\/span>gtid_mode&#061;ON <span class=\"token punctuation\">&#8211;<\/span><span class=\"token punctuation\">&#8211;<\/span>enforce<span class=\"token punctuation\">&#8211;<\/span>gtid<span class=\"token punctuation\">&#8211;<\/span>consistency&#061;ON<\/p>\n<p>  <span class=\"token key atrule\">mysql_a_slave2<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token key atrule\">&lt;&lt;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token important\">*mysql<\/span><br \/>\n    <span class=\"token key atrule\">container_name<\/span><span class=\"token punctuation\">:<\/span> mysql_a_slave2<br \/>\n    <span class=\"token key atrule\">ports<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;22222:3306&#034;<\/span><span class=\"token punctuation\">]<\/span><br \/>\n    <span class=\"token key atrule\">command<\/span><span class=\"token punctuation\">:<\/span><br \/>\n      <span class=\"token punctuation\">&#8211;<\/span><span class=\"token punctuation\">&#8211;<\/span>server<span class=\"token punctuation\">&#8211;<\/span>id&#061;3 <span class=\"token punctuation\">&#8211;<\/span><span class=\"token punctuation\">&#8211;<\/span>relay<span class=\"token punctuation\">&#8211;<\/span>log&#061;relay<span class=\"token punctuation\">&#8211;<\/span>log <span class=\"token punctuation\">&#8211;<\/span><span class=\"token punctuation\">&#8211;<\/span>skip<span class=\"token punctuation\">&#8211;<\/span>slave<span class=\"token punctuation\">&#8211;<\/span>start&#061;ON<br \/>\n      <span class=\"token punctuation\">&#8211;<\/span><span class=\"token punctuation\">&#8211;<\/span>gtid_mode&#061;ON <span class=\"token punctuation\">&#8211;<\/span><span class=\"token punctuation\">&#8211;<\/span>enforce<span class=\"token punctuation\">&#8211;<\/span>gtid<span class=\"token punctuation\">&#8211;<\/span>consistency&#061;ON<\/p>\n<p>  <span class=\"token comment\"># &#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061; Cluster B &#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;<\/span><br \/>\n  <span class=\"token key atrule\">mysql_b_master<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token key atrule\">&lt;&lt;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token important\">*mysql<\/span><br \/>\n    <span class=\"token key atrule\">container_name<\/span><span class=\"token punctuation\">:<\/span> mysql_b_master<br \/>\n    <span class=\"token key atrule\">ports<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;22223:3306&#034;<\/span><span class=\"token punctuation\">]<\/span><br \/>\n    <span class=\"token key atrule\">command<\/span><span class=\"token punctuation\">:<\/span><br \/>\n      <span class=\"token punctuation\">&#8211;<\/span><span class=\"token punctuation\">&#8211;<\/span>server<span class=\"token punctuation\">&#8211;<\/span>id&#061;4 <span class=\"token punctuation\">&#8211;<\/span><span class=\"token punctuation\">&#8211;<\/span>log<span class=\"token punctuation\">&#8211;<\/span>bin&#061;mysql<span class=\"token punctuation\">&#8211;<\/span>bin <span class=\"token punctuation\">&#8211;<\/span><span class=\"token punctuation\">&#8211;<\/span>binlog<span class=\"token punctuation\">&#8211;<\/span>format&#061;ROW<br \/>\n      <span class=\"token punctuation\">&#8211;<\/span><span class=\"token punctuation\">&#8211;<\/span>gtid_mode&#061;ON <span class=\"token punctuation\">&#8211;<\/span><span class=\"token punctuation\">&#8211;<\/span>enforce<span class=\"token punctuation\">&#8211;<\/span>gtid<span class=\"token punctuation\">&#8211;<\/span>consistency&#061;ON<br \/>\n      <span class=\"token punctuation\">&#8211;<\/span><span class=\"token punctuation\">&#8211;<\/span>binlog<span class=\"token punctuation\">&#8211;<\/span>do<span class=\"token punctuation\">&#8211;<\/span>db&#061;sharding_db<\/p>\n<p>  <span class=\"token key atrule\">mysql_b_slave1<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token key atrule\">&lt;&lt;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token important\">*mysql<\/span><br \/>\n    <span class=\"token key atrule\">container_name<\/span><span class=\"token punctuation\">:<\/span> mysql_b_slave1<br \/>\n    <span class=\"token key atrule\">ports<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;22224:3306&#034;<\/span><span class=\"token punctuation\">]<\/span><br \/>\n    <span class=\"token key atrule\">command<\/span><span class=\"token punctuation\">:<\/span><br \/>\n      <span class=\"token punctuation\">&#8211;<\/span><span class=\"token punctuation\">&#8211;<\/span>server<span class=\"token punctuation\">&#8211;<\/span>id&#061;5 <span class=\"token punctuation\">&#8211;<\/span><span class=\"token punctuation\">&#8211;<\/span>relay<span class=\"token punctuation\">&#8211;<\/span>log&#061;relay<span class=\"token punctuation\">&#8211;<\/span>log <span class=\"token punctuation\">&#8211;<\/span><span class=\"token punctuation\">&#8211;<\/span>skip<span class=\"token punctuation\">&#8211;<\/span>slave<span class=\"token punctuation\">&#8211;<\/span>start&#061;ON<br \/>\n      <span class=\"token punctuation\">&#8211;<\/span><span class=\"token punctuation\">&#8211;<\/span>gtid_mode&#061;ON <span class=\"token punctuation\">&#8211;<\/span><span class=\"token punctuation\">&#8211;<\/span>enforce<span class=\"token punctuation\">&#8211;<\/span>gtid<span class=\"token punctuation\">&#8211;<\/span>consistency&#061;ON<\/p>\n<p>  <span class=\"token key atrule\">mysql_b_slave2<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token key atrule\">&lt;&lt;<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token important\">*mysql<\/span><br \/>\n    <span class=\"token key atrule\">container_name<\/span><span class=\"token punctuation\">:<\/span> mysql_b_slave2<br \/>\n    <span class=\"token key atrule\">ports<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;22225:3306&#034;<\/span><span class=\"token punctuation\">]<\/span><br \/>\n    <span class=\"token key atrule\">command<\/span><span class=\"token punctuation\">:<\/span><br \/>\n      <span class=\"token punctuation\">&#8211;<\/span><span class=\"token punctuation\">&#8211;<\/span>server<span class=\"token punctuation\">&#8211;<\/span>id&#061;6 <span class=\"token punctuation\">&#8211;<\/span><span class=\"token punctuation\">&#8211;<\/span>relay<span class=\"token punctuation\">&#8211;<\/span>log&#061;relay<span class=\"token punctuation\">&#8211;<\/span>log <span class=\"token punctuation\">&#8211;<\/span><span class=\"token punctuation\">&#8211;<\/span>skip<span class=\"token punctuation\">&#8211;<\/span>slave<span class=\"token punctuation\">&#8211;<\/span>start&#061;ON<br \/>\n      <span class=\"token punctuation\">&#8211;<\/span><span class=\"token punctuation\">&#8211;<\/span>gtid_mode&#061;ON <span class=\"token punctuation\">&#8211;<\/span><span class=\"token punctuation\">&#8211;<\/span>enforce<span class=\"token punctuation\">&#8211;<\/span>gtid<span class=\"token punctuation\">&#8211;<\/span>consistency&#061;ON<\/p>\n<p>  <span class=\"token comment\"># &#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061; ShardingSphere-Proxy &#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;<\/span><br \/>\n  <span class=\"token key atrule\">sharding-proxy<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token key atrule\">build<\/span><span class=\"token punctuation\">:<\/span> .\/sharding<span class=\"token punctuation\">&#8211;<\/span>proxy<br \/>\n    <span class=\"token key atrule\">container_name<\/span><span class=\"token punctuation\">:<\/span> sharding<span class=\"token punctuation\">&#8211;<\/span>proxy<br \/>\n    <span class=\"token key atrule\">ports<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;22226:3307&#034;<\/span><span class=\"token punctuation\">]<\/span><br \/>\n    <span class=\"token key atrule\">volumes<\/span><span class=\"token punctuation\">:<\/span><br \/>\n      <span class=\"token punctuation\">&#8211;<\/span> .\/sharding<span class=\"token punctuation\">&#8211;<\/span>proxy\/global.yaml<span class=\"token punctuation\">:<\/span>\/opt\/shardingsphere<span class=\"token punctuation\">&#8211;<\/span>proxy\/conf\/global.yaml<br \/>\n      <span class=\"token punctuation\">&#8211;<\/span> .\/sharding<span class=\"token punctuation\">&#8211;<\/span>proxy\/database<span class=\"token punctuation\">&#8211;<\/span>sharding.yaml<span class=\"token punctuation\">:<\/span>\/opt\/shardingsphere<span class=\"token punctuation\">&#8211;<\/span>proxy\/conf\/database<span class=\"token punctuation\">&#8211;<\/span>sharding.yaml<br \/>\n    <span class=\"token key atrule\">depends_on<\/span><span class=\"token punctuation\">:<\/span><br \/>\n      <span class=\"token punctuation\">&#8211;<\/span> mysql_a_master<br \/>\n      <span class=\"token punctuation\">&#8211;<\/span> mysql_a_slave1<br \/>\n      <span class=\"token punctuation\">&#8211;<\/span> mysql_a_slave2<br \/>\n      <span class=\"token punctuation\">&#8211;<\/span> mysql_b_master<br \/>\n      <span class=\"token punctuation\">&#8211;<\/span> mysql_b_slave1<br \/>\n      <span class=\"token punctuation\">&#8211;<\/span> mysql_b_slave2<br \/>\n    <span class=\"token key atrule\">networks<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token punctuation\">[<\/span>sharding<span class=\"token punctuation\">&#8211;<\/span>net<span class=\"token punctuation\">]<\/span><\/p>\n<p>  <span class=\"token comment\"># &#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061; \u521d\u59cb\u5316 &#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;&#061;<\/span><br \/>\n  <span class=\"token key atrule\">setup<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token key atrule\">image<\/span><span class=\"token punctuation\">:<\/span> mysql<span class=\"token punctuation\">:<\/span><span class=\"token number\">8.0<\/span><br \/>\n    <span class=\"token key atrule\">container_name<\/span><span class=\"token punctuation\">:<\/span> sharding<span class=\"token punctuation\">&#8211;<\/span>setup<br \/>\n    <span class=\"token key atrule\">entrypoint<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;&#034;<\/span><span class=\"token punctuation\">]<\/span><br \/>\n    <span class=\"token key atrule\">command<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token punctuation\">[<\/span><span class=\"token string\">&#034;bash&#034;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#034;\/scripts\/init.sh&#034;<\/span><span class=\"token punctuation\">]<\/span><br \/>\n    <span class=\"token key atrule\">depends_on<\/span><span class=\"token punctuation\">:<\/span><br \/>\n      <span class=\"token punctuation\">&#8211;<\/span> mysql_a_master<br \/>\n      <span class=\"token punctuation\">&#8211;<\/span> mysql_a_slave1<br \/>\n      <span class=\"token punctuation\">&#8211;<\/span> mysql_a_slave2<br \/>\n      <span class=\"token punctuation\">&#8211;<\/span> mysql_b_master<br \/>\n      <span class=\"token punctuation\">&#8211;<\/span> mysql_b_slave1<br \/>\n      <span class=\"token punctuation\">&#8211;<\/span> mysql_b_slave2<br \/>\n    <span class=\"token key atrule\">volumes<\/span><span class=\"token punctuation\">:<\/span><br \/>\n      <span class=\"token punctuation\">&#8211;<\/span> .\/scripts\/init.sh<span class=\"token punctuation\">:<\/span>\/scripts\/init.sh<br \/>\n    <span class=\"token key atrule\">networks<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token punctuation\">[<\/span>sharding<span class=\"token punctuation\">&#8211;<\/span>net<span class=\"token punctuation\">]<\/span><\/p>\n<p>Proxy \u5b98\u65b9\u955c\u50cf\u4e0d\u5305\u542b MySQL JDBC \u9a71\u52a8&#xff0c;\u9700\u901a\u8fc7 Dockerfile \u989d\u5916\u6dfb\u52a0&#xff1a;<\/p>\n<p>FROM apache\/shardingsphere-proxy:latest<\/p>\n<p>ADD https:\/\/repo1.maven.org\/maven2\/com\/mysql\/mysql-connector-j\/8.0.33\/mysql-connector-j-8.0.33.jar \\\\<br \/>\n    \/opt\/shardingsphere-proxy\/ext-lib\/mysql-connector-j-8.0.33.jar<\/p>\n<p>EXPOSE 3307<\/p>\n<p>\u539f\u56e0&#xff1a;ShardingSphere \u5b98\u65b9\u955c\u50cf\u9ed8\u8ba4\u53ea\u5305\u542b PostgreSQL \u548c openGauss \u9a71\u52a8&#xff0c;MySQL \u9a71\u52a8\u9700\u7528\u6237\u81ea\u884c\u63d0\u4f9b\u3002\u8be6\u89c1\u5b98\u65b9\u6587\u6863\u3002<\/p>\n<h4>5.4 \u914d\u7f6e ShardingSphere-Proxy<\/h4>\n<p>Proxy \u4f7f\u7528\u4e24\u4e2a\u914d\u7f6e\u6587\u4ef6&#xff1a;<\/p>\n<p>global.yaml \u2014 \u8ba4\u8bc1\u4e0e\u5168\u5c40\u914d\u7f6e&#xff1a;<\/p>\n<p><span class=\"token key atrule\">mode<\/span><span class=\"token punctuation\">:<\/span><br \/>\n  <span class=\"token key atrule\">type<\/span><span class=\"token punctuation\">:<\/span> Standalone                            <span class=\"token comment\"># \u5355\u673a\u6a21\u5f0f&#xff0c;\u65e0\u9700\u6ce8\u518c\u4e2d\u5fc3<\/span><\/p>\n<p><span class=\"token key atrule\">authority<\/span><span class=\"token punctuation\">:<\/span><br \/>\n  <span class=\"token key atrule\">users<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token punctuation\">&#8211;<\/span> <span class=\"token key atrule\">user<\/span><span class=\"token punctuation\">:<\/span> root&#064;%                            <span class=\"token comment\"># \u7528\u6237&#064;\u4e3b\u673a&#xff0c;% \u8868\u793a\u4efb\u610f\u4e3b\u673a<\/span><br \/>\n      <span class=\"token key atrule\">password<\/span><span class=\"token punctuation\">:<\/span> root123<br \/>\n  <span class=\"token key atrule\">privilege<\/span><span class=\"token punctuation\">:<\/span><br \/>\n    <span class=\"token key atrule\">type<\/span><span class=\"token punctuation\">:<\/span> ALL_PERMITTED                       <span class=\"token comment\"># \u6240\u6709\u7528\u6237\u62e5\u6709\u5168\u90e8\u6743\u9650<\/span><\/p>\n<p><span class=\"token key atrule\">props<\/span><span class=\"token punctuation\">:<\/span><br \/>\n  <span class=\"token key atrule\">proxy-frontend-port<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token number\">3307<\/span>                   <span class=\"token comment\"># Proxy \u76d1\u542c\u7aef\u53e3<\/span><br \/>\n  <span class=\"token key atrule\">sql-show<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token boolean important\">true<\/span>                              <span class=\"token comment\"># \u6253\u5370\u5b9e\u9645\u8def\u7531 SQL&#xff0c;\u8c03\u8bd5\u7528<\/span><\/p>\n<p>database-sharding.yaml \u2014 \u5206\u7247\u4e0e\u8bfb\u5199\u5206\u79bb\u89c4\u5219&#xff1a;<\/p>\n<p><span class=\"token key atrule\">databaseName<\/span><span class=\"token punctuation\">:<\/span> sharding_db                       <span class=\"token comment\"># \u903b\u8f91\u6570\u636e\u5e93\u540d&#xff0c;\u5ba2\u6237\u7aef\u8fde\u63a5\u7528<\/span><\/p>\n<p><span class=\"token key atrule\">dataSources<\/span><span class=\"token punctuation\">:<\/span><br \/>\n  <span class=\"token comment\"># &#061;&#061;&#061;&#061;&#061; Cluster A (ds_0) &#061;&#061;&#061;&#061;&#061;<\/span><br \/>\n  <span class=\"token key atrule\">ds_0_master<\/span><span class=\"token punctuation\">:<\/span>                                  <span class=\"token comment\"># A \u96c6\u7fa4\u5199\u5165\u8282\u70b9<\/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>\/\/mysql_a_master<span class=\"token punctuation\">:<\/span>3306\/sharding_db<span class=\"token punctuation\">?<\/span>useSSL&#061;false<span class=\"token important\">&amp;allowPublicKeyRetrieval&#061;true<\/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> root123<br \/>\n  <span class=\"token key atrule\">ds_0_slave1<\/span><span class=\"token punctuation\">:<\/span>                                  <span class=\"token comment\"># A \u96c6\u7fa4\u8bfb\u8282\u70b9 1<\/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>\/\/mysql_a_slave1<span class=\"token punctuation\">:<\/span>3306\/sharding_db<span class=\"token punctuation\">?<\/span>useSSL&#061;false<span class=\"token important\">&amp;allowPublicKeyRetrieval&#061;true<\/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> root123<br \/>\n  <span class=\"token key atrule\">ds_0_slave2<\/span><span class=\"token punctuation\">:<\/span>                                  <span class=\"token comment\"># A \u96c6\u7fa4\u8bfb\u8282\u70b9 2<\/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>\/\/mysql_a_slave2<span class=\"token punctuation\">:<\/span>3306\/sharding_db<span class=\"token punctuation\">?<\/span>useSSL&#061;false<span class=\"token important\">&amp;allowPublicKeyRetrieval&#061;true<\/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> root123<\/p>\n<p>  <span class=\"token comment\"># &#061;&#061;&#061;&#061;&#061; Cluster B (ds_1) &#061;&#061;&#061;&#061;&#061;<\/span><br \/>\n  <span class=\"token key atrule\">ds_1_master<\/span><span class=\"token punctuation\">:<\/span>                                  <span class=\"token comment\"># B \u96c6\u7fa4\u5199\u5165\u8282\u70b9<\/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>\/\/mysql_b_master<span class=\"token punctuation\">:<\/span>3306\/sharding_db<span class=\"token punctuation\">?<\/span>useSSL&#061;false<span class=\"token important\">&amp;allowPublicKeyRetrieval&#061;true<\/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> root123<br \/>\n  <span class=\"token key atrule\">ds_1_slave1<\/span><span class=\"token punctuation\">:<\/span>                                  <span class=\"token comment\"># B \u96c6\u7fa4\u8bfb\u8282\u70b9 1<\/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>\/\/mysql_b_slave1<span class=\"token punctuation\">:<\/span>3306\/sharding_db<span class=\"token punctuation\">?<\/span>useSSL&#061;false<span class=\"token important\">&amp;allowPublicKeyRetrieval&#061;true<\/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> root123<br \/>\n  <span class=\"token key atrule\">ds_1_slave2<\/span><span class=\"token punctuation\">:<\/span>                                  <span class=\"token comment\"># B \u96c6\u7fa4\u8bfb\u8282\u70b9 2<\/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>\/\/mysql_b_slave2<span class=\"token punctuation\">:<\/span>3306\/sharding_db<span class=\"token punctuation\">?<\/span>useSSL&#061;false<span class=\"token important\">&amp;allowPublicKeyRetrieval&#061;true<\/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> root123<\/p>\n<p><span class=\"token key atrule\">rules<\/span><span class=\"token punctuation\">:<\/span><br \/>\n  <span class=\"token comment\"># &#061;&#061;&#061;&#061;&#061; \u5206\u7247\u89c4\u5219 &#061;&#061;&#061;&#061;&#061;<\/span><br \/>\n  <span class=\"token punctuation\">&#8211;<\/span> <span class=\"token tag\">!SHARDING<\/span><br \/>\n    <span class=\"token key atrule\">tables<\/span><span class=\"token punctuation\">:<\/span><br \/>\n      <span class=\"token key atrule\">t_order<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token key atrule\">actualDataNodes<\/span><span class=\"token punctuation\">:<\/span> ds_$<span class=\"token punctuation\">{<\/span>0..1<span class=\"token punctuation\">}<\/span>.t_order_$<span class=\"token punctuation\">{<\/span>0..1<span class=\"token punctuation\">}<\/span>   <span class=\"token comment\"># 2\u5e93 \u00d7 2\u8868<\/span><br \/>\n        <span class=\"token key atrule\">databaseStrategy<\/span><span class=\"token punctuation\">:<\/span>                               <span class=\"token comment\"># \u5206\u5e93\u7b56\u7565<\/span><br \/>\n          <span class=\"token key atrule\">standard<\/span><span class=\"token punctuation\">:<\/span><br \/>\n            <span class=\"token key atrule\">shardingColumn<\/span><span class=\"token punctuation\">:<\/span> user_id                     <span class=\"token comment\"># \u6309 user_id \u5206\u5e93<\/span><br \/>\n            <span class=\"token key atrule\">shardingAlgorithmName<\/span><span class=\"token punctuation\">:<\/span> db_inline                <span class=\"token comment\"># \u5f15\u7528\u4e0b\u65b9 db_inline \u7b97\u6cd5<\/span><br \/>\n        <span class=\"token key atrule\">tableStrategy<\/span><span class=\"token punctuation\">:<\/span>                                  <span class=\"token comment\"># \u5206\u8868\u7b56\u7565<\/span><br \/>\n          <span class=\"token key atrule\">standard<\/span><span class=\"token punctuation\">:<\/span><br \/>\n            <span class=\"token key atrule\">shardingColumn<\/span><span class=\"token punctuation\">:<\/span> order_id                    <span class=\"token comment\"># \u6309 order_id \u5206\u8868<\/span><br \/>\n            <span class=\"token key atrule\">shardingAlgorithmName<\/span><span class=\"token punctuation\">:<\/span> table_inline              <span class=\"token comment\"># \u5f15\u7528\u4e0b\u65b9 table_inline \u7b97\u6cd5<\/span><br \/>\n        <span class=\"token key atrule\">keyGenerateStrategy<\/span><span class=\"token punctuation\">:<\/span>                            <span class=\"token comment\"># \u5206\u5e03\u5f0f\u4e3b\u952e\u751f\u6210\u7b56\u7565<\/span><br \/>\n          <span class=\"token key atrule\">column<\/span><span class=\"token punctuation\">:<\/span> order_id                              <span class=\"token comment\"># \u5bf9\u54ea\u5217\u751f\u6210\u4e3b\u952e<\/span><br \/>\n          <span class=\"token key atrule\">keyGeneratorName<\/span><span class=\"token punctuation\">:<\/span> snowflake                   <span class=\"token comment\"># \u4f7f\u7528\u96ea\u82b1\u7b97\u6cd5<\/span><br \/>\n    <span class=\"token key atrule\">shardingAlgorithms<\/span><span class=\"token punctuation\">:<\/span><br \/>\n      <span class=\"token key atrule\">db_inline<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token key atrule\">type<\/span><span class=\"token punctuation\">:<\/span> INLINE                                    <span class=\"token comment\"># INLINE &#061; Groovy \u8868\u8fbe\u5f0f\u8def\u7531<\/span><br \/>\n        <span class=\"token key atrule\">props<\/span><span class=\"token punctuation\">:<\/span><br \/>\n          <span class=\"token key atrule\">algorithm-expression<\/span><span class=\"token punctuation\">:<\/span> ds_$<span class=\"token punctuation\">{<\/span>user_id % 2<span class=\"token punctuation\">}<\/span>       <span class=\"token comment\"># \u5076\u6570\u2192ds_0&#xff0c;\u5947\u6570\u2192ds_1<\/span><br \/>\n      <span class=\"token key atrule\">table_inline<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token key atrule\">type<\/span><span class=\"token punctuation\">:<\/span> INLINE<br \/>\n        <span class=\"token key atrule\">props<\/span><span class=\"token punctuation\">:<\/span><br \/>\n          <span class=\"token key atrule\">algorithm-expression<\/span><span class=\"token punctuation\">:<\/span> t_order_$<span class=\"token punctuation\">{<\/span>order_id % 2<span class=\"token punctuation\">}<\/span> <span class=\"token comment\"># \u5076\u6570\u2192t_order_0,\u5947\u6570\u2192t_order_1<\/span><br \/>\n    <span class=\"token key atrule\">keyGenerators<\/span><span class=\"token punctuation\">:<\/span><br \/>\n      <span class=\"token key atrule\">snowflake<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token key atrule\">type<\/span><span class=\"token punctuation\">:<\/span> SNOWFLAKE                                 <span class=\"token comment\"># \u96ea\u82b1\u7b97\u6cd5&#xff0c;\u751f\u6210\u5206\u5e03\u5f0f\u552f\u4e00 ID<\/span><\/p>\n<p>  <span class=\"token comment\"># &#061;&#061;&#061;&#061;&#061; \u8bfb\u5199\u5206\u79bb &#061;&#061;&#061;&#061;&#061;<\/span><br \/>\n  <span class=\"token punctuation\">&#8211;<\/span> <span class=\"token tag\">!READWRITE_SPLITTING<\/span><br \/>\n    <span class=\"token key atrule\">dataSourceGroups<\/span><span class=\"token punctuation\">:<\/span><br \/>\n      <span class=\"token key atrule\">ds_0<\/span><span class=\"token punctuation\">:<\/span>                                            <span class=\"token comment\"># Cluster A<\/span><br \/>\n        <span class=\"token key atrule\">writeDataSourceName<\/span><span class=\"token punctuation\">:<\/span> ds_0_master                <span class=\"token comment\"># \u5199\u64cd\u4f5c\u2192Master<\/span><br \/>\n        <span class=\"token key atrule\">readDataSourceNames<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token punctuation\">[<\/span>ds_0_slave1<span class=\"token punctuation\">,<\/span> ds_0_slave2<span class=\"token punctuation\">]<\/span> <span class=\"token comment\"># \u8bfb\u64cd\u4f5c\u2192\u8f6e\u8be2 Slave<\/span><br \/>\n        <span class=\"token key atrule\">loadBalancerName<\/span><span class=\"token punctuation\">:<\/span> round_robin                   <span class=\"token comment\"># Slave \u95f4\u8f6e\u8be2\u8d1f\u8f7d\u5747\u8861<\/span><br \/>\n      <span class=\"token key atrule\">ds_1<\/span><span class=\"token punctuation\">:<\/span>                                            <span class=\"token comment\"># Cluster B<\/span><br \/>\n        <span class=\"token key atrule\">writeDataSourceName<\/span><span class=\"token punctuation\">:<\/span> ds_1_master                <span class=\"token comment\"># \u5199\u64cd\u4f5c\u2192Master<\/span><br \/>\n        <span class=\"token key atrule\">readDataSourceNames<\/span><span class=\"token punctuation\">:<\/span> <span class=\"token punctuation\">[<\/span>ds_1_slave1<span class=\"token punctuation\">,<\/span> ds_1_slave2<span class=\"token punctuation\">]<\/span> <span class=\"token comment\"># \u8bfb\u64cd\u4f5c\u2192\u8f6e\u8be2 Slave<\/span><br \/>\n        <span class=\"token key atrule\">loadBalancerName<\/span><span class=\"token punctuation\">:<\/span> round_robin<br \/>\n    <span class=\"token key atrule\">loadBalancers<\/span><span class=\"token punctuation\">:<\/span><br \/>\n      <span class=\"token key atrule\">round_robin<\/span><span class=\"token punctuation\">:<\/span><br \/>\n        <span class=\"token key atrule\">type<\/span><span class=\"token punctuation\">:<\/span> ROUND_ROBIN                               <span class=\"token comment\"># \u8f6e\u8be2\u7b97\u6cd5<\/span><\/p>\n<h4>5.5 \u521d\u59cb\u5316\u811a\u672c<\/h4>\n<p>setup \u5bb9\u5668\u4f1a\u81ea\u52a8\u6267\u884c scripts\/init.sh&#xff0c;\u5185\u5bb9\u5982\u4e0b&#xff1a;<\/p>\n<p><span class=\"token shebang important\">#!\/bin\/bash<\/span><br \/>\n<span class=\"token builtin class-name\">set<\/span> <span class=\"token parameter variable\">-e<\/span><\/p>\n<p><span class=\"token assign-left variable\">PASS<\/span><span class=\"token operator\">&#061;<\/span>root123<\/p>\n<p><span class=\"token comment\"># 1. \u7b49\u5f85\u5168\u90e8 MySQL \u5c31\u7eea<\/span><br \/>\n<span class=\"token keyword\">for<\/span> <span class=\"token for-or-select variable\">host<\/span> <span class=\"token keyword\">in<\/span> mysql_a_master mysql_a_slave1 mysql_a_slave2 <span class=\"token punctuation\">\\\\<\/span><br \/>\n            mysql_b_master mysql_b_slave1 mysql_b_slave2<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">do<\/span><br \/>\n  <span class=\"token keyword\">until<\/span> mysql <span class=\"token parameter variable\">-h<\/span> <span class=\"token string\">&#034;<span class=\"token variable\">$host<\/span>&#034;<\/span> <span class=\"token parameter variable\">-uroot<\/span> -p<span class=\"token string\">&#034;<span class=\"token variable\">$PASS<\/span>&#034;<\/span> <span class=\"token parameter variable\">-e<\/span> <span class=\"token string\">&#034;SELECT 1&#034;<\/span> <span class=\"token operator\">&amp;&gt;<\/span>\/dev\/null<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">do<\/span><br \/>\n    <span class=\"token function\">sleep<\/span> <span class=\"token number\">2<\/span><br \/>\n  <span class=\"token keyword\">done<\/span><br \/>\n  <span class=\"token builtin class-name\">echo<\/span> <span class=\"token string\">&#034;  \u2713 <span class=\"token variable\">$host<\/span>&#034;<\/span><br \/>\n<span class=\"token keyword\">done<\/span><\/p>\n<p><span class=\"token comment\"># 2. \u521b\u5efa\u6570\u636e\u5e93&#xff08;\u5168\u90e8\u8282\u70b9&#xff09;<\/span><br \/>\n<span class=\"token keyword\">for<\/span> <span class=\"token for-or-select variable\">host<\/span> <span class=\"token keyword\">in<\/span> mysql_a_master mysql_a_slave1 mysql_a_slave2 <span class=\"token punctuation\">\\\\<\/span><br \/>\n            mysql_b_master mysql_b_slave1 mysql_b_slave2<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">do<\/span><br \/>\n  mysql <span class=\"token parameter variable\">-h<\/span> <span class=\"token string\">&#034;<span class=\"token variable\">$host<\/span>&#034;<\/span> <span class=\"token parameter variable\">-uroot<\/span> -p<span class=\"token string\">&#034;<span class=\"token variable\">$PASS<\/span>&#034;<\/span> <span class=\"token parameter variable\">-e<\/span> <span class=\"token string\">&#034;CREATE DATABASE IF NOT EXISTS sharding_db;&#034;<\/span><br \/>\n<span class=\"token keyword\">done<\/span><\/p>\n<p><span class=\"token comment\"># 3. \u521b\u5efa\u590d\u5236\u7528\u6237&#xff08;\u5fc5\u987b\u7528 mysql_native_password&#xff09;<\/span><br \/>\n<span class=\"token keyword\">for<\/span> <span class=\"token for-or-select variable\">host<\/span> <span class=\"token keyword\">in<\/span> mysql_a_master mysql_b_master<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">do<\/span><br \/>\n  mysql <span class=\"token parameter variable\">-h<\/span> <span class=\"token string\">&#034;<span class=\"token variable\">$host<\/span>&#034;<\/span> <span class=\"token parameter variable\">-uroot<\/span> -p<span class=\"token string\">&#034;<span class=\"token variable\">$PASS<\/span>&#034;<\/span> <span class=\"token parameter variable\">-e<\/span> <span class=\"token string\">&#034;<br \/>\n    CREATE USER IF NOT EXISTS &#039;repl&#039;&#064;&#039;%&#039;<br \/>\n      IDENTIFIED WITH mysql_native_password BY &#039;repl123&#039;;<br \/>\n    GRANT REPLICATION SLAVE ON *.* TO &#039;repl&#039;&#064;&#039;%&#039;;<br \/>\n    FLUSH PRIVILEGES;&#034;<\/span><br \/>\n<span class=\"token keyword\">done<\/span><\/p>\n<p><span class=\"token comment\"># 4. \u8bbe\u7f6e GTID \u4e3b\u4ece\u590d\u5236<\/span><br \/>\n<span class=\"token function-name function\">SETUP_SLAVE<\/span><span class=\"token punctuation\">(<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token punctuation\">{<\/span><br \/>\n  <span class=\"token builtin class-name\">local<\/span> <span class=\"token assign-left variable\">slave<\/span><span class=\"token operator\">&#061;<\/span><span class=\"token variable\">$1<\/span> <span class=\"token assign-left variable\">master<\/span><span class=\"token operator\">&#061;<\/span><span class=\"token variable\">$2<\/span><br \/>\n  mysql <span class=\"token parameter variable\">-h<\/span> <span class=\"token string\">&#034;<span class=\"token variable\">$slave<\/span>&#034;<\/span> <span class=\"token parameter variable\">-uroot<\/span> -p<span class=\"token string\">&#034;<span class=\"token variable\">$PASS<\/span>&#034;<\/span> <span class=\"token parameter variable\">-e<\/span> <span class=\"token string\">&#034;<br \/>\n    STOP SLAVE; RESET SLAVE ALL;<br \/>\n    CHANGE MASTER TO MASTER_HOST&#061;&#039;<span class=\"token variable\">$master<\/span>&#039;, MASTER_PORT&#061;3306,<br \/>\n      MASTER_USER&#061;&#039;repl&#039;, MASTER_PASSWORD&#061;&#039;repl123&#039;,<br \/>\n      MASTER_AUTO_POSITION&#061;1;<br \/>\n    START SLAVE;&#034;<\/span><br \/>\n  <span class=\"token assign-left variable\">IO<\/span><span class=\"token operator\">&#061;<\/span><span class=\"token variable\"><span class=\"token variable\">$(<\/span>mysql <span class=\"token parameter variable\">-h<\/span> <span class=\"token string\">&#034;<span class=\"token variable\">$slave<\/span>&#034;<\/span> <span class=\"token parameter variable\">-uroot<\/span> -p<span class=\"token string\">&#034;<span class=\"token variable\">$PASS<\/span>&#034;<\/span> <span class=\"token parameter variable\">-e<\/span> <span class=\"token string\">&#034;SHOW SLAVE STATUS\\\\G&#034;<\/span> <span class=\"token punctuation\">\\\\<\/span><br \/>\n    <span class=\"token operator\">|<\/span> <span class=\"token function\">grep<\/span> <span class=\"token string\">&#034;Slave_IO_Running:&#034;<\/span> <span class=\"token operator\">|<\/span> <span class=\"token function\">awk<\/span> <span class=\"token string\">&#039;{print $2}&#039;<\/span><span class=\"token variable\">)<\/span><\/span><br \/>\n  <span class=\"token assign-left variable\">SQL<\/span><span class=\"token operator\">&#061;<\/span><span class=\"token variable\"><span class=\"token variable\">$(<\/span>mysql <span class=\"token parameter variable\">-h<\/span> <span class=\"token string\">&#034;<span class=\"token variable\">$slave<\/span>&#034;<\/span> <span class=\"token parameter variable\">-uroot<\/span> -p<span class=\"token string\">&#034;<span class=\"token variable\">$PASS<\/span>&#034;<\/span> <span class=\"token parameter variable\">-e<\/span> <span class=\"token string\">&#034;SHOW SLAVE STATUS\\\\G&#034;<\/span> <span class=\"token punctuation\">\\\\<\/span><br \/>\n    <span class=\"token operator\">|<\/span> <span class=\"token function\">grep<\/span> <span class=\"token string\">&#034;Slave_SQL_Running:&#034;<\/span> <span class=\"token operator\">|<\/span> <span class=\"token function\">awk<\/span> <span class=\"token string\">&#039;{print $2}&#039;<\/span><span class=\"token variable\">)<\/span><\/span><br \/>\n  <span class=\"token builtin class-name\">echo<\/span> <span class=\"token string\">&#034;  \u2713 <span class=\"token variable\">$slave<\/span> \u2192 <span class=\"token variable\">$master<\/span>  (IO:<span class=\"token variable\">$IO<\/span>  SQL:<span class=\"token variable\">$SQL<\/span>)&#034;<\/span><br \/>\n<span class=\"token punctuation\">}<\/span><\/p>\n<p>SETUP_SLAVE mysql_a_slave1 mysql_a_master<br \/>\nSETUP_SLAVE mysql_a_slave2 mysql_a_master<br \/>\nSETUP_SLAVE mysql_b_slave1 mysql_b_master<br \/>\nSETUP_SLAVE mysql_b_slave2 mysql_b_master<\/p>\n<p><span class=\"token comment\"># 5. \u521b\u5efa\u5206\u7247\u7269\u7406\u8868<\/span><br \/>\n<span class=\"token keyword\">for<\/span> <span class=\"token for-or-select variable\">host<\/span> <span class=\"token keyword\">in<\/span> mysql_a_master mysql_b_master<span class=\"token punctuation\">;<\/span> <span class=\"token keyword\">do<\/span><br \/>\n  mysql <span class=\"token parameter variable\">-h<\/span> <span class=\"token string\">&#034;<span class=\"token variable\">$host<\/span>&#034;<\/span> <span class=\"token parameter variable\">-uroot<\/span> -p<span class=\"token string\">&#034;<span class=\"token variable\">$PASS<\/span>&#034;<\/span> sharding_db <span class=\"token parameter variable\">-e<\/span> <span class=\"token string\">&#034;<br \/>\n    CREATE TABLE IF NOT EXISTS t_order_0 (<br \/>\n      order_id BIGINT NOT NULL, user_id INT NOT NULL,<br \/>\n      product_name VARCHAR(100), status TINYINT DEFAULT 0,<br \/>\n      PRIMARY KEY (order_id)) ENGINE&#061;InnoDB;<br \/>\n    CREATE TABLE IF NOT EXISTS t_order_1 (<br \/>\n      order_id BIGINT NOT NULL, user_id INT NOT NULL,<br \/>\n      product_name VARCHAR(100), status TINYINT DEFAULT 0,<br \/>\n      PRIMARY KEY (order_id)) ENGINE&#061;InnoDB;&#034;<\/span><br \/>\n<span class=\"token keyword\">done<\/span><\/p>\n<p><span class=\"token builtin class-name\">echo<\/span> <span class=\"token string\">&#034;\u521d\u59cb\u5316\u5b8c\u6210&#xff01;&#034;<\/span><\/p>\n<h4>5.6 \u542f\u52a8\u96c6\u7fa4<\/h4>\n<p>\u5728 sharding-lab\/ \u76ee\u5f55\u4e0b\u6267\u884c\u542f\u52a8\u547d\u4ee4&#xff1a;<\/p>\n<p><span class=\"token builtin class-name\">cd<\/span> sharding-lab<br \/>\n<span class=\"token function\">docker<\/span> compose up <span class=\"token parameter variable\">-d<\/span> <span class=\"token parameter variable\">&#8211;build<\/span><\/p>\n<p><span class=\"token comment\"># \u67e5\u770b\u521d\u59cb\u5316\u8fdb\u5ea6<\/span><br \/>\n<span class=\"token function\">docker<\/span> logs sharding-setup <span class=\"token parameter variable\">-f<\/span><\/p>\n<p><span class=\"token comment\"># \u9884\u671f\u8f93\u51fa&#xff08;\u7ea6 1-2 \u5206\u949f\u540e&#xff09;<\/span><br \/>\n  \u2713 mysql_a_master<br \/>\n  \u2713 mysql_a_slave1<br \/>\n  <span class=\"token punctuation\">..<\/span>.<br \/>\n  \u2713 mysql_b_slave2<br \/>\n  \u2713 mysql_a_slave1 \u2192 mysql_a_master  <span class=\"token punctuation\">(<\/span>IO:Yes  SQL:Yes<span class=\"token punctuation\">)<\/span><br \/>\n  <span class=\"token punctuation\">..<\/span>.<br \/>\n  \u521d\u59cb\u5316\u5b8c\u6210&#xff01;<\/p>\n<p><span class=\"token comment\"># \u786e\u8ba4 Proxy \u542f\u52a8\u6210\u529f<\/span><br \/>\n<span class=\"token function\">docker<\/span> logs sharding-proxy <span class=\"token operator\">|<\/span> <span class=\"token function\">grep<\/span> <span class=\"token string\">&#034;started successfully&#034;<\/span><br \/>\n<span class=\"token comment\"># \u8f93\u51fa: ShardingSphere-Proxy Standalone mode started successfully<\/span><\/p>\n<h3>\u516d\u3001\u529f\u80fd\u9a8c\u8bc1<\/h3>\n<h4>6.1 \u5206\u7247\u9a8c\u8bc1<\/h4>\n<p><span class=\"token comment\">&#8212; \u901a\u8fc7 Proxy \u63d2\u5165\u6570\u636e<\/span><br \/>\n<span class=\"token keyword\">INSERT<\/span> <span class=\"token keyword\">INTO<\/span> t_order <span class=\"token punctuation\">(<\/span>order_id<span class=\"token punctuation\">,<\/span> user_id<span class=\"token punctuation\">,<\/span> product_name<span class=\"token punctuation\">,<\/span> <span class=\"token keyword\">status<\/span><span class=\"token punctuation\">)<\/span> <span class=\"token keyword\">VALUES<\/span><br \/>\n  <span class=\"token punctuation\">(<\/span><span class=\"token number\">1<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;\u5546\u54c1A&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span><br \/>\n  <span class=\"token punctuation\">(<\/span><span class=\"token number\">2<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">2<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;\u5546\u54c1B&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span><br \/>\n  <span class=\"token punctuation\">(<\/span><span class=\"token number\">3<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">3<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;\u5546\u54c1C&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">,<\/span><br \/>\n  <span class=\"token punctuation\">(<\/span><span class=\"token number\">4<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">4<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token string\">&#039;\u5546\u54c1D&#039;<\/span><span class=\"token punctuation\">,<\/span> <span class=\"token number\">1<\/span><span class=\"token punctuation\">)<\/span><span class=\"token punctuation\">;<\/span><\/p>\n<p><span class=\"token comment\">&#8212; \u67e5\u8be2<\/span><br \/>\n<span class=\"token keyword\">SELECT<\/span> <span class=\"token operator\">*<\/span> <span class=\"token keyword\">FROM<\/span> t_order <span class=\"token keyword\">ORDER<\/span> <span class=\"token keyword\">BY<\/span> order_id<span class=\"token punctuation\">;<\/span><\/p>\n<p>\u5206\u7247\u7ed3\u679c&#xff1a;<\/p>\n<p>\u76f4\u8fde MySQL \u67e5\u770b\u7269\u7406\u8868&#xff0c;\u6570\u636e\u5206\u5e03\u7b26\u5408\u9884\u671f&#xff1a;<\/p>\n<p><span class=\"token comment\">&#8212; Cluster A (ds_0): user_id \u5076\u6570\u7684\u6570\u636e<\/span><br \/>\nmysql<span class=\"token operator\">&gt;<\/span> <span class=\"token keyword\">SELECT<\/span> order_id<span class=\"token punctuation\">,<\/span> user_id<span class=\"token punctuation\">,<\/span> product_name <span class=\"token keyword\">FROM<\/span> t_order_0<span class=\"token punctuation\">;<\/span><br \/>\n<span class=\"token operator\">&#043;<\/span><span class=\"token comment\">&#8212;&#8212;&#8212;-&#043;&#8212;&#8212;&#8212;&#043;&#8212;&#8212;&#8212;&#8212;&#8211;&#043;<\/span><br \/>\n<span class=\"token operator\">|<\/span> order_id <span class=\"token operator\">|<\/span> user_id <span class=\"token operator\">|<\/span> product_name <span class=\"token operator\">|<\/span><br \/>\n<span class=\"token operator\">&#043;<\/span><span class=\"token comment\">&#8212;&#8212;&#8212;-&#043;&#8212;&#8212;&#8212;&#043;&#8212;&#8212;&#8212;&#8212;&#8211;&#043;<\/span><br \/>\n<span class=\"token operator\">|<\/span>        <span class=\"token number\">2<\/span> <span class=\"token operator\">|<\/span>       <span class=\"token number\">2<\/span> <span class=\"token operator\">|<\/span> \u5546\u54c1B        <span class=\"token operator\">|<\/span><br \/>\n<span class=\"token operator\">|<\/span>        <span class=\"token number\">4<\/span> <span class=\"token operator\">|<\/span>       <span class=\"token number\">4<\/span> <span class=\"token operator\">|<\/span> \u5546\u54c1D        <span class=\"token operator\">|<\/span><br \/>\n<span class=\"token operator\">&#043;<\/span><span class=\"token comment\">&#8212;&#8212;&#8212;-&#043;&#8212;&#8212;&#8212;&#043;&#8212;&#8212;&#8212;&#8212;&#8211;&#043;<\/span><\/p>\n<p><span class=\"token comment\">&#8212; Cluster B (ds_1): user_id \u5947\u6570\u7684\u6570\u636e<\/span><br \/>\nmysql<span class=\"token operator\">&gt;<\/span> <span class=\"token keyword\">SELECT<\/span> order_id<span class=\"token punctuation\">,<\/span> user_id<span class=\"token punctuation\">,<\/span> product_name <span class=\"token keyword\">FROM<\/span> t_order_1<span class=\"token punctuation\">;<\/span><br \/>\n<span class=\"token operator\">&#043;<\/span><span class=\"token comment\">&#8212;&#8212;&#8212;-&#043;&#8212;&#8212;&#8212;&#043;&#8212;&#8212;&#8212;&#8212;&#8211;&#043;<\/span><br \/>\n<span class=\"token operator\">|<\/span> order_id <span class=\"token operator\">|<\/span> user_id <span class=\"token operator\">|<\/span> product_name <span class=\"token operator\">|<\/span><br \/>\n<span class=\"token operator\">&#043;<\/span><span class=\"token comment\">&#8212;&#8212;&#8212;-&#043;&#8212;&#8212;&#8212;&#043;&#8212;&#8212;&#8212;&#8212;&#8211;&#043;<\/span><br \/>\n<span class=\"token operator\">|<\/span>        <span class=\"token number\">1<\/span> <span class=\"token operator\">|<\/span>       <span class=\"token number\">1<\/span> <span class=\"token operator\">|<\/span> \u5546\u54c1A        <span class=\"token operator\">|<\/span><br \/>\n<span class=\"token operator\">|<\/span>        <span class=\"token number\">3<\/span> <span class=\"token operator\">|<\/span>       <span class=\"token number\">3<\/span> <span class=\"token operator\">|<\/span> \u5546\u54c1C        <span class=\"token operator\">|<\/span><br \/>\n<span class=\"token operator\">&#043;<\/span><span class=\"token comment\">&#8212;&#8212;&#8212;-&#043;&#8212;&#8212;&#8212;&#043;&#8212;&#8212;&#8212;&#8212;&#8211;&#043;<\/span><\/p>\n<table>\n<tr>Clusteruser_id\u7269\u7406\u8868\u6570\u636e<\/tr>\n<tbody>\n<tr>\n<td>ds_0<\/td>\n<td>\u5076\u6570&#xff08;2, 4&#xff09;<\/td>\n<td>t_order_0<\/td>\n<td>\u5546\u54c1B, \u5546\u54c1D<\/td>\n<\/tr>\n<tr>\n<td>ds_1<\/td>\n<td>\u5947\u6570&#xff08;1, 3&#xff09;<\/td>\n<td>t_order_1<\/td>\n<td>\u5546\u54c1A, \u5546\u54c1C<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4>6.2 \u8bfb\u5199\u5206\u79bb\u9a8c\u8bc1<\/h4>\n<p>\u4ece Proxy \u65e5\u5fd7\u53ef\u4ee5\u770b\u5230 SQL \u8def\u7531\u60c5\u51b5&#xff1a;<\/p>\n<p>INSERT \u2192 ds_0_master, ds_1_master      # \u5199\u64cd\u4f5c\u8d70\u5230 Master<br \/>\nSELECT \u2192 ds_0_slave1, ds_1_slave2&#8230;   # \u8bfb\u64cd\u4f5c\u8d70\u5230 Slave<\/p>\n<p>\u8bfb\u5199\u5206\u79bb\u89c4\u5219&#xff1a;<\/p>\n<ul>\n<li>INSERT\u3001UPDATE\u3001DELETE \u2192 \u81ea\u52a8\u8def\u7531\u5230 Master<\/li>\n<li>SELECT \u2192 \u8f6e\u8be2\u5206\u53d1\u5230 Slave&#xff08;round_robin \u7b56\u7565&#xff09;<\/li>\n<li>\u67d0\u4e2a Slave \u5b95\u673a \u2192 \u81ea\u52a8\u8df3\u8fc7&#xff0c;\u4e0d\u5f71\u54cd\u670d\u52a1<\/li>\n<\/ul>\n<h4>6.3 \u7eb5\u5411\u6269\u5c55\u793a\u4f8b<\/h4>\n<p>\u5f53\u9700\u8981\u589e\u52a0\u5206\u7247\u6570\u65f6&#xff0c;\u53ea\u9700\u4fee\u6539\u914d\u7f6e&#xff1a;<\/p>\n<p><span class=\"token key atrule\">actualDataNodes<\/span><span class=\"token punctuation\">:<\/span> ds_$<span class=\"token punctuation\">{<\/span>0..2<span class=\"token punctuation\">}<\/span>.t_order_$<span class=\"token punctuation\">{<\/span>0..3<span class=\"token punctuation\">}<\/span>    <span class=\"token comment\"># 3\u5e93 \u00d7 4\u8868<\/span><\/p>\n<p><span class=\"token key atrule\">db_inline<\/span><span class=\"token punctuation\">:<\/span><br \/>\n  <span class=\"token key atrule\">algorithm-expression<\/span><span class=\"token punctuation\">:<\/span> ds_$<span class=\"token punctuation\">{<\/span>user_id % 3<span class=\"token punctuation\">}<\/span>       <span class=\"token comment\"># \u52063\u5e93<\/span><\/p>\n<p><span class=\"token key atrule\">table_inline<\/span><span class=\"token punctuation\">:<\/span><br \/>\n  <span class=\"token key atrule\">algorithm-expression<\/span><span class=\"token punctuation\">:<\/span> t_order_$<span class=\"token punctuation\">{<\/span>order_id % 4<span class=\"token punctuation\">}<\/span> <span class=\"token comment\"># \u6bcf\u5e934\u8868<\/span><\/p>\n<h3>\u4e03\u3001\u8e29\u5751\u8bb0\u5f55<\/h3>\n<h4>\u57511&#xff1a;MySQL \u9a71\u52a8\u7f3a\u5931<\/h4>\n<p>\u73b0\u8c61&#xff1a; No suitable driver \u539f\u56e0&#xff1a; ShardingSphere \u5b98\u65b9\u955c\u50cf\u53ea\u5185\u7f6e\u4e86 PostgreSQL\/openGauss \u9a71\u52a8&#xff0c;MySQL \u9a71\u52a8\u9700\u8981\u7528\u6237\u81ea\u884c\u6dfb\u52a0 \u89e3\u51b3&#xff1a; \u901a\u8fc7 Dockerfile \u5c06 mysql-connector-j-8.0.33.jar \u4e0b\u8f7d\u5230 \/opt\/shardingsphere-proxy\/ext-lib\/<\/p>\n<h4>\u57512&#xff1a;\u914d\u7f6e\u6587\u4ef6\u547d\u540d\u53d8\u66f4<\/h4>\n<p>\u73b0\u8c61&#xff1a; \u914d\u7f6e\u6587\u4ef6\u52a0\u8f7d\u5931\u8d25&#xff0c;\u8ba4\u8bc1\u914d\u7f6e\u5931\u6548 \u539f\u56e0&#xff1a; 5.5.x \u8d77\u6539\u7528 global.yaml &#043; database-*.yaml&#xff0c;\u4e0d\u518d\u652f\u6301 server.yaml &#043; config-*.yaml \u89e3\u51b3&#xff1a; \u4f7f\u7528\u6b63\u786e\u6587\u4ef6\u540d<\/p>\n<h4>\u57513&#xff1a;\u590d\u5236\u7528\u6237\u8ba4\u8bc1\u65b9\u5f0f<\/h4>\n<p>\u73b0\u8c61&#xff1a; Slave_IO_Running: Connecting&#xff0c;\u9519\u8bef Authentication requires secure connection \u539f\u56e0&#xff1a; MySQL 8.0 \u9ed8\u8ba4 caching_sha2_password&#xff0c;\u590d\u5236\u9700\u8981 SSL \u6216\u6539\u7528 mysql_native_password \u89e3\u51b3&#xff1a; CREATE USER &#8230; IDENTIFIED WITH mysql_native_password BY &#039;&#8230;&#039;<\/p>\n<h4>\u57514&#xff1a;Public Key Retrieval \u9519\u8bef<\/h4>\n<p>\u73b0\u8c61&#xff1a; Proxy \u542f\u52a8\u65f6 Public Key Retrieval is not allowed \u539f\u56e0&#xff1a; JDBC \u8fde\u63a5 MySQL 8.0 \u4e0d\u5e26 SSL \u65f6\u9700\u8981\u663e\u5f0f\u5141\u8bb8\u516c\u94a5\u68c0\u7d22 \u89e3\u51b3&#xff1a; JDBC URL \u52a0\u53c2\u6570 allowPublicKeyRetrieval&#061;true<\/p>\n<h3>\u516b\u3001\u603b\u7ed3<\/h3>\n<p>\u901a\u8fc7\u672c\u6587\u7684\u5b9e\u6218&#xff0c;\u4f60\u5b8c\u6210\u4e86\u4ee5\u4e0b\u76ee\u6807&#xff1a;<\/p>\n<table>\n<tr>\u76ee\u6807\u72b6\u6001<\/tr>\n<tbody>\n<tr>\n<td>\u7406\u89e3\u5206\u5e93\u5206\u8868\u539f\u7406<\/td>\n<td>\u2705<\/td>\n<\/tr>\n<tr>\n<td>\u642d\u5efa 2 \u96c6\u7fa4 \u00d7 3 \u8282\u70b9 MySQL \u96c6\u7fa4<\/td>\n<td>\u2705<\/td>\n<\/tr>\n<tr>\n<td>\u914d\u7f6e GTID \u4e3b\u4ece\u590d\u5236<\/td>\n<td>\u2705<\/td>\n<\/tr>\n<tr>\n<td>\u90e8\u7f72 ShardingSphere-Proxy<\/td>\n<td>\u2705<\/td>\n<\/tr>\n<tr>\n<td>\u5b9e\u73b0\u5206\u7247&#xff08;\u5206\u5e93 &#043; \u5206\u8868&#xff09;<\/td>\n<td>\u2705<\/td>\n<\/tr>\n<tr>\n<td>\u5b9e\u73b0\u8bfb\u5199\u5206\u79bb<\/td>\n<td>\u2705<\/td>\n<\/tr>\n<tr>\n<td>\u4e86\u89e3\u5e38\u89c1\u5751\u53ca\u89e3\u51b3\u65b9\u6848<\/td>\n<td>\u2705<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"<p>&#x1f4dd; \u672c\u6587\u9996\u53d1\u4e8e \u680f\u8f69\u00b7\u9601 \u6b22\u8fce\u8bbf\u95ee\u9605\u8bfb\u539f\u6587&#xff0c;\u83b7\u53d6\u66f4\u597d\u7684\u9605\u8bfb\u4f53\u9a8c\u3002 \u4e00\u3001\u80cc\u666f&#xff1a;\u4e3a\u4ec0\u4e48\u9700\u8981\u5206\u5e03\u5f0f\u6570\u636e\u5e93<br \/>\n\u5355\u4e2a MySQL \u5b9e\u4f8b\u5728\u6570\u636e\u91cf\u8fbe\u5230\u5343\u4e07\u7ea7\u3001QPS \u8fbe\u5230\u6570\u5343\u65f6&#xff0c;\u4f1a\u9762\u4e34\u660e\u663e\u7684\u74f6\u9888&#xff1a;<br \/>\n\u5199\u5165\u74f6\u9888&#xff1a;\u5355\u5e93\u7684\u5199\u5165\u80fd\u529b\u6709\u9650&#xff0c;\u65e0\u6cd5\u6c34\u5e73\u6269\u5c55\u8bfb\u53d6\u74f6\u9888&#xff1a;\u5355\u5e93\u625b\u4e0d\u4f4f\u5927\u91cf\u5e76\u53d1\u67e5\u8be2\u5b58\u50a8\u74f6\u9888&#xff1a;\u5355\u8868\u6570\u636e\u91cf\u8fc7\u5927\u65f6&#xff0c;\u7d22\u5f15\u7ef4\u62a4\u6210\u672c\u6025\u5267\u4e0a\u5347<br \/>\nShardingSpher<\/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":[9098,114,371,305],"topic":[],"class_list":["post-115163","post","type-post","status-publish","format-standard","hentry","category-server","tag-it","tag-mysql","tag-371","tag-305"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Mysql\u5b66\u4e60\u7b14\u8bb0\uff1aShardingSphere-Proxy\u5206\u5e93\u5206\u8868+\u8bfb\u5199\u5206\u79bb\u4ece\u96f6\u642d\u5efa\u6307\u5357 - \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\/115163.html\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Mysql\u5b66\u4e60\u7b14\u8bb0\uff1aShardingSphere-Proxy\u5206\u5e93\u5206\u8868+\u8bfb\u5199\u5206\u79bb\u4ece\u96f6\u642d\u5efa\u6307\u5357 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"og:description\" content=\"&#x1f4dd; \u672c\u6587\u9996\u53d1\u4e8e \u680f\u8f69\u00b7\u9601 \u6b22\u8fce\u8bbf\u95ee\u9605\u8bfb\u539f\u6587&#xff0c;\u83b7\u53d6\u66f4\u597d\u7684\u9605\u8bfb\u4f53\u9a8c\u3002 \u4e00\u3001\u80cc\u666f&#xff1a;\u4e3a\u4ec0\u4e48\u9700\u8981\u5206\u5e03\u5f0f\u6570\u636e\u5e93 \u5355\u4e2a MySQL \u5b9e\u4f8b\u5728\u6570\u636e\u91cf\u8fbe\u5230\u5343\u4e07\u7ea7\u3001QPS \u8fbe\u5230\u6570\u5343\u65f6&#xff0c;\u4f1a\u9762\u4e34\u660e\u663e\u7684\u74f6\u9888&#xff1a; \u5199\u5165\u74f6\u9888&#xff1a;\u5355\u5e93\u7684\u5199\u5165\u80fd\u529b\u6709\u9650&#xff0c;\u65e0\u6cd5\u6c34\u5e73\u6269\u5c55\u8bfb\u53d6\u74f6\u9888&#xff1a;\u5355\u5e93\u625b\u4e0d\u4f4f\u5927\u91cf\u5e76\u53d1\u67e5\u8be2\u5b58\u50a8\u74f6\u9888&#xff1a;\u5355\u8868\u6570\u636e\u91cf\u8fc7\u5927\u65f6&#xff0c;\u7d22\u5f15\u7ef4\u62a4\u6210\u672c\u6025\u5267\u4e0a\u5347 ShardingSpher\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wsisp.com\/helps\/115163.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-11T02:25:32+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=\"7 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/115163.html\",\"url\":\"https:\/\/www.wsisp.com\/helps\/115163.html\",\"name\":\"Mysql\u5b66\u4e60\u7b14\u8bb0\uff1aShardingSphere-Proxy\u5206\u5e93\u5206\u8868+\u8bfb\u5199\u5206\u79bb\u4ece\u96f6\u642d\u5efa\u6307\u5357 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"isPartOf\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\"},\"datePublished\":\"2026-10-11T02:25:32+00:00\",\"dateModified\":\"2026-10-11T02:25:32+00:00\",\"author\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/115163.html#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wsisp.com\/helps\/115163.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/115163.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.wsisp.com\/helps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Mysql\u5b66\u4e60\u7b14\u8bb0\uff1aShardingSphere-Proxy\u5206\u5e93\u5206\u8868+\u8bfb\u5199\u5206\u79bb\u4ece\u96f6\u642d\u5efa\u6307\u5357\"}]},{\"@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":"Mysql\u5b66\u4e60\u7b14\u8bb0\uff1aShardingSphere-Proxy\u5206\u5e93\u5206\u8868+\u8bfb\u5199\u5206\u79bb\u4ece\u96f6\u642d\u5efa\u6307\u5357 - \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\/115163.html","og_locale":"zh_CN","og_type":"article","og_title":"Mysql\u5b66\u4e60\u7b14\u8bb0\uff1aShardingSphere-Proxy\u5206\u5e93\u5206\u8868+\u8bfb\u5199\u5206\u79bb\u4ece\u96f6\u642d\u5efa\u6307\u5357 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","og_description":"&#x1f4dd; \u672c\u6587\u9996\u53d1\u4e8e \u680f\u8f69\u00b7\u9601 \u6b22\u8fce\u8bbf\u95ee\u9605\u8bfb\u539f\u6587&#xff0c;\u83b7\u53d6\u66f4\u597d\u7684\u9605\u8bfb\u4f53\u9a8c\u3002 \u4e00\u3001\u80cc\u666f&#xff1a;\u4e3a\u4ec0\u4e48\u9700\u8981\u5206\u5e03\u5f0f\u6570\u636e\u5e93 \u5355\u4e2a MySQL \u5b9e\u4f8b\u5728\u6570\u636e\u91cf\u8fbe\u5230\u5343\u4e07\u7ea7\u3001QPS \u8fbe\u5230\u6570\u5343\u65f6&#xff0c;\u4f1a\u9762\u4e34\u660e\u663e\u7684\u74f6\u9888&#xff1a; \u5199\u5165\u74f6\u9888&#xff1a;\u5355\u5e93\u7684\u5199\u5165\u80fd\u529b\u6709\u9650&#xff0c;\u65e0\u6cd5\u6c34\u5e73\u6269\u5c55\u8bfb\u53d6\u74f6\u9888&#xff1a;\u5355\u5e93\u625b\u4e0d\u4f4f\u5927\u91cf\u5e76\u53d1\u67e5\u8be2\u5b58\u50a8\u74f6\u9888&#xff1a;\u5355\u8868\u6570\u636e\u91cf\u8fc7\u5927\u65f6&#xff0c;\u7d22\u5f15\u7ef4\u62a4\u6210\u672c\u6025\u5267\u4e0a\u5347 ShardingSpher","og_url":"https:\/\/www.wsisp.com\/helps\/115163.html","og_site_name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","article_published_time":"2026-10-11T02:25:32+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"admin","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"7 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wsisp.com\/helps\/115163.html","url":"https:\/\/www.wsisp.com\/helps\/115163.html","name":"Mysql\u5b66\u4e60\u7b14\u8bb0\uff1aShardingSphere-Proxy\u5206\u5e93\u5206\u8868+\u8bfb\u5199\u5206\u79bb\u4ece\u96f6\u642d\u5efa\u6307\u5357 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","isPartOf":{"@id":"https:\/\/www.wsisp.com\/helps\/#website"},"datePublished":"2026-10-11T02:25:32+00:00","dateModified":"2026-10-11T02:25:32+00:00","author":{"@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41"},"breadcrumb":{"@id":"https:\/\/www.wsisp.com\/helps\/115163.html#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wsisp.com\/helps\/115163.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.wsisp.com\/helps\/115163.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.wsisp.com\/helps"},{"@type":"ListItem","position":2,"name":"Mysql\u5b66\u4e60\u7b14\u8bb0\uff1aShardingSphere-Proxy\u5206\u5e93\u5206\u8868+\u8bfb\u5199\u5206\u79bb\u4ece\u96f6\u642d\u5efa\u6307\u5357"}]},{"@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\/115163","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=115163"}],"version-history":[{"count":0,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/115163\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media?parent=115163"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/categories?post=115163"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/tags?post=115163"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/topic?post=115163"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}