{"id":425,"date":"2017-08-17T20:49:18","date_gmt":"2017-08-17T12:49:18","guid":{"rendered":"http:\/\/www.chenweikang.top\/?p=425"},"modified":"2017-09-19T11:36:19","modified_gmt":"2017-09-19T03:36:19","slug":"mycat%e5%ae%9e%e9%aa%8c%ef%bc%884%ef%bc%89-mycat%e6%95%b0%e6%8d%ae%e5%88%86%e7%89%87%e6%b5%8b%e8%af%95","status":"publish","type":"post","link":"https:\/\/www.chenweikang.top\/?p=425","title":{"rendered":"Mycat\u4e3b\u4ece\u540c\u6b65\u3001\u8bfb\u5199\u5206\u79bb\u3001\u5206\u5e93\u5206\u8868\uff084\uff09-Mycat\u6570\u636e\u5206\u7247\u6d4b\u8bd5"},"content":{"rendered":"<blockquote><p>\u672c\u7bc7\u5b9e\u9a8c\u4ecd\u7136\u662f\u57fa\u4e8e\u4e0a\u7bc7\u7684\u4e3b\u4ece\u540c\u6b65\u73af\u5883\uff0c\u57283306\u521b\u5efa5\u4e2a\u6570\u636e\u5e93 db1,db2,db3,db4,db5\u3001\u5e76\u52a0\u5165\u5230\u4e3b\u4ece\u540c\u6b65\uff0c\u5728mycat\u4e2d\u5c06\u8fd95\u4e2a\u6570\u636e\u5e93\u914d\u7f6e\u4e3a\u5206\u7247\u6570\u636e\u5e93\uff0c\u4f7f\u7528\u8303\u56f4\u7ea6\u5b9a\u7b97\u6cd5\u6765\u6d4b\u8bd5\u6570\u636e\u5206\u7247\u3002<\/p>\n<p>mycat\u768410\u4e2d\u6570\u636e\u5206\u7247\u89c4\u5219\uff1a<a href=\"http:\/\/www.chenweikang.top\/mycat%E4%B8%AD%E7%9A%8410%E7%A7%8D%E5%88%86%E7%89%87%E8%A7%84%E5%88%99\/\" target=\"_blank\" rel=\"noopener\">Mycat\u4e2d\u768410\u4e2d\u5206\u7247\u89c4\u5219<\/a><\/p><\/blockquote>\n<h3><strong>\u57fa\u4e8e\u4e0a\u7bc7\u7684\u5b9e\u9a8c\uff0c\u6211\u4eec\u5f53\u524d\u7684\u73af\u5883\u4e3a\uff1a<\/strong><\/h3>\n<p>\u89d2\u8272 \u00a0 \u00a0 \u00a0\u670d\u52a1\u7aef\u53e3 \u00a0 \u00a0 \u00a0\u7528\u6237 \u00a0 \u00a0 \u00a0 \u00a0\u5bc6\u7801<\/p>\n<p>master \u00a03306 \u00a0 \u00a0 \u00a0 root \u00a0 \u00a0root@3306<\/p>\n<p>slave \u00a0 \u00a0 3307 \u00a0 \u00a0 \u00a0 root \u00a0 \u00a0root@3307<\/p>\n<p>slave \u00a0 \u00a0 3308 \u00a0 \u00a0 \u00a0 root \u00a0 \u00a0root@3308<\/p>\n<h2>\u521b\u5efa\u5206\u7247\u6570\u636e\u5e93\uff0c\u914d\u7f6e\u4e3b\u4ece\u540c\u6b65<\/h2>\n<p>\u5206\u522b\u767b\u5f55\u52303306\u30013307\u30013308\uff0c\u521b\u5efa\u6570\u636e\u5e93db1-5 \u6570\u636e\u5e93<\/p>\n<pre class=\"prettyprint linenums\">create database db1\uff1b\r\ncreate database db2\uff1b\r\ncreate database db3\uff1b\r\ncreate database db4\uff1b\r\ncreate database db5\uff1b<\/pre>\n<p>\u5206\u522b\u7f16\u8f91\/etc\/my3306.cnf\u3001\/etc\/my3307.cnf\u3001\/etc\/my3308.cnf\uff0c<\/p>\n<p>\u5c06\u521b\u5efa\u7684\u6570\u636e\u5e93\u914d\u7f6e\u4e3a\u9700\u8981\u540c\u6b65<br \/>\n\/etc\/my3306.cnf:<\/p>\n<pre class=\"prettyprint linenums\">#\u9700\u8981\u540c\u6b65\u7684\u6570\u636e\u5e93\r\nbinlog-do-db = test_db\r\nbinlog-do-db = db1\r\nbinlog-do-db = db2\r\nbinlog-do-db = db3\r\nbinlog-do-db = db4\r\nbinlog-do-db = db5\r\n<\/pre>\n<p>\/etc\/my3307.cnf:<\/p>\n<pre class=\"prettyprint linenums\">#\u9700\u8981\u5907\u4efd\u7684\u6570\u636e\u5e93\r\nreplicate-do-db=test_db\r\nreplicate-do-db = db1\r\nreplicate-do-db = db2\r\nreplicate-do-db = db3\r\nreplicate-do-db = db4\r\nreplicate-do-db = db5\r\n<\/pre>\n<p>\/etc\/my3308.cnf:<\/p>\n<pre class=\"prettyprint linenums\">#\u9700\u8981\u5907\u4efd\u7684\u6570\u636e\u5e93\r\nreplicate-do-db=test_db\r\nreplicate-do-db = db1\r\nreplicate-do-db = db2\r\nreplicate-do-db = db3\r\nreplicate-do-db = db4\r\nreplicate-do-db = db5\r\n<\/pre>\n<p>\u91cd\u542f3306\u30013307\u30013308\u7684mysql\u670d\u52a1<\/p>\n<h2>\u914d\u7f6eMycat\u6570\u636e\u5206\u7247<\/h2>\n<h3>\u5f00\u542fMycat\u81ea\u589eID<\/h3>\n<p>mycat\u6709\u4e24\u79cd\u5b9e\u73b0\u65b9\u5f0f\uff0c\u4e00\u79cd\u662f\u914d\u7f6e\u6587\u4ef6\u3001\u4e00\u79cd\u662f\u6570\u636e\u5e93\u65b9\u5f0f\u6765\u5b9e\u73b0\u5168\u5c40\u81ea\u589eID\uff0c\u672c\u4f8b\u4f7f\u7528\u914d\u7f6e\u6587\u4ef6\u65b9\u5f0f\u5b9e\u73b0<\/p>\n<p><strong>\u7f16\u8f91\u914d\u7f6e\u6587\u4ef6\u00a0conf\/sequence_conf.properties :<\/strong><\/p>\n<pre class=\"prettyprint linenums\">#\u81ea\u5e26\u7684\u5168\u5c40\u81ea\u589e\u914d\u7f6e\r\nGLOBAL.CURID=10052\r\nGLOBAL.MINID=10001\r\nGLOBAL.MAXID=20000\r\nGLOBAL.HISIDS=\r\n\r\n#\u6211\u4eec\u81ea\u5b9a\u4e49\u7684\uff1a\r\n\r\nCUSTOMER.HISIDS=\r\nCUSTOMER.CURID=100\r\nCUSTOMER.MINID=100\r\nCUSTOMER.MAXID=10000\r\n<\/pre>\n<p>MINID\uff1a\u8868\u793a\u6700\u5c0f\u7684ID\uff0c\u4e5f\u5c31\u662f\u521d\u59cb\u7684<\/p>\n<p>MAXID\uff1a\u6700\u5927\u7684ID\uff0c\u5982\u679c\u7528\u5b8c\u4e86\uff0c\u63d2\u5165\u6570\u636e\u65f6\u4f1a\u62a5\u9519<\/p>\n<p>CURID\uff1a\u5f53\u524dID\uff0c\u6bcf\u6b21\u63d2\u5165\u6570\u636e\u4f1a\u5c06\u5f53\u524dID\u8bb0\u5f55\u5230\u8fd9\u4e2a\u5c5e\u6027\uff0c\u6240\u4ee5\u8fd9\u4e2a\u6587\u4ef6\u662f\u4e0d\u505c\u5728\u53d8\u5316<\/p>\n<p>\u4f7f\u7528\u81ea\u589e\u65f6\u7528\u7279\u5b9a\u7684SQL\u8bed\u53e5\u6765\u8c03\u7528\u8fd9\u4e2a\u65b9\u6848<\/p>\n<p>\u4f8b\u5982 \uff1a\u00a0next value for MYCATSEQ_CUSTOMER \u00a0\u5373\u8fd4\u56deCURID+1<\/p>\n<p>&nbsp;<\/p>\n<h3>\u9009\u62e9\u5206\u7247\u65b9\u6848<\/h3>\n<p>mycat\u7684\u5206\u7247\u89c4\u5219\u914d\u7f6e\u6587\u4ef6\u4e3aconf\/rule.xml\uff0c\u5206\u7247\u89c4\u5219\u53ef\u67e5\u770b \uff1a<a href=\"http:\/\/www.chenweikang.top\/mycat%E4%B8%AD%E7%9A%8410%E7%A7%8D%E5%88%86%E7%89%87%E8%A7%84%E5%88%99\/\" target=\"_blank\" rel=\"noopener\">Mycat\u4e2d\u768410\u4e2d\u5206\u7247\u89c4\u5219<\/a><\/p>\n<p><strong>\u6211\u4eec\u4f7f\u7528\u6bd4\u8f83\u7b80\u5355\u7684\u4e00\u79cd\u89c4\u5219\uff0c\u6839\u636e\u4e3b\u952e\u7684\u8303\u56f4\u8fdb\u884c\u5206\u7247\uff0c\u67e5\u770brule.xml\uff1a<\/strong><\/p>\n<blockquote><p>&lt;tableRule name=\"auto-sharding-long\"&gt;<\/p>\n<p>&lt;rule&gt;<\/p>\n<p>&lt;columns&gt;id&lt;\/columns&gt;<\/p>\n<p>&lt;algorithm&gt;rang-long&lt;\/algorithm&gt;<\/p>\n<p>&lt;\/rule&gt;<br \/>\n&lt;\/tableRule&gt;<\/p>\n<p>#<span style=\"color: #800000;\">\u5bf9\u5e94\u7684\u65b9\u6cd5\u4e3arang-long\uff0c\u4f7f\u7528\u65f6\u4f1a\u8c03\u7528autopartition-long.txt\u4e2d\u7f16\u8f91\u597d\u7684\u89c4\u5219\uff0c\u6240\u4ee5\u6211\u4eec\u7f16\u8f91autopartition-long.txt\u6587\u4ef6<\/span><\/p>\n<p>&lt;function name=\"rang-long\"<\/p>\n<p>class=\"io.mycat.route.function.AutoPartitionByLong\"&gt;<\/p>\n<p>&lt;property name=\"mapFile\"&gt;autopartition-long.txt&lt;\/property&gt;<br \/>\n&lt;\/function&gt;<\/p><\/blockquote>\n<p><strong>\u7f16\u8f91conf\/schema.xml\uff1a<\/strong><\/p>\n<blockquote><p>&lt;!--<\/p>\n<p>\u5b9a\u4e49\u5206\u7247\u8868t_customer \u5206\u5e03\u5728db6-db10 ,<\/p>\n<p>\u89c4\u5219\u7528\u9ed8\u8ba4\u7684auto-sharding-long<\/p>\n<p>autoIncrement=\"true\" \u5f00\u542f\u4e3b\u952e\u81ea\u589e<\/p>\n<p>--&gt;<\/p>\n<p>&lt;table primaryKey=\"id\" autoIncrement=\"true\" \u00a0name=\"<span style=\"color: #ff0000;\">t_customer<\/span>\" dataNode=\"db$6-10\" rule=\"auto-sharding-long\" \/&gt;<\/p>\n<p>&lt;!--\u5b9a\u4e49\u6570\u636e\u8282\u70b9\uff0c\u865a\u62df\u5e93\u540d\u79f0db6-10 \u5bf9\u5e94\u6211\u4eec\u5f00\u59cb\u521b\u5efa\u7684\u6570\u636e\u5e93 db1\u3001db2\u3001db3\u3001db4\u3001db5 --&gt;<\/p>\n<p>&lt;dataNode name=\"db$6-10\" dataHost=\"localhost1\" database=\"db$1-5\" \/&gt;<\/p><\/blockquote>\n<h3>\u7f16\u8f91\u5206\u7247\u89c4\u5219\uff1a<\/h3>\n<p>\u7f16\u8f91conf\/autopartition-long.txt \u914d\u7f6e\u5206\u7247\u89c4\u5219\uff1a<\/p>\n<pre class=\"prettyprint linenums\"># range start-end ,data node index\r\n#\u5de6\u8fb9\u4e3aID\u8303\u56f4a-b \u53f3\u8fb9\u4e3a\u914d\u7f6e\u7684\u6570\u636e\u8282\u70b9\r\n100-120=0\r\n121-140=1\r\n141-160=2\r\n161-180=3\r\n181-200=4\r\n<\/pre>\n<p>\u8fd9\u6bb5\u8868\u793a \u4e3b\u952eid\u4e3a100-120\u7684\u6570\u636e\u5b58\u5230\u7b2c\u4e00\u4e2a\u5206\u7247\uff0c121-140\u5b58\u5230\u7b2c\u4e8c\u4e2a\u5206\u7247\uff0c\u4ee5\u6b64\u7c7b\u63a8\u3002\u6ce8\u610f\uff1a<span style=\"color: #ff0000;\">\u53f3\u8fb9\u5fc5\u987b\u4ece0\u5f00\u59cb\uff0c\u5e76\u4e0d\u5bf9\u5e94dataNode\u4e2d$6-10\uff0c\u5e94\u8be5\u662f\u6570\u7ec4index<\/span><\/p>\n<h2>\u6d4b\u8bd5\u5206\u7247\u65b9\u6848<\/h2>\n<p>\u4f7f\u7528\u6211\u4eec\u914d\u7f6e\u7684t_customer\u8868\u8fdb\u884c\u6d4b\u8bd5\uff0c\u521b\u5efat_customer\u8868\uff0c\u5e76\u63d2\u5165100\u6761\u6570\u636e\uff0c\u4e3b\u952eid\u4e3a100-200\uff0c\u6700\u540e\u67e5\u770b\u662f\u5426\u6570\u636e\u6b63\u5e38\u8fdb\u5165\u5230\u5404\u5206\u7247<\/p>\n<h3>\u521b\u5efa\u6d4b\u8bd5\u8868t_customer:<\/h3>\n<pre class=\"prettyprint linenums\">#\u91cd\u542fmycat :\r\nmycat restart\r\n#\u767b\u5f55\u5230mycat:\r\n<span style=\"color: #ff0000;\">#\u6ce8\u610f\uff1a\u867d\u7136\u6211\u4eec\u589e\u52a0\u4e86db1-db5 5\u4e2a\u6570\u636e\u5e93\uff0c\u4f46\u662fmycat\u4e2d\u914d\u7f6e\u7684\u903b\u8f91\u6570\u636e\u5e93\u4ecd\u7136\u662ftest_db<\/span>\r\nmysql -uroot -p123456 -h127.0.0.1 -P8066 test_db \r\n#\u521b\u5efa\u8868t_customer:\r\nmysql&gt;use test_db;\r\nmysql&gt; create table t_customer(\r\n id int primary key auto_increment,\r\n username varchar(20) not null,\r\n password varchar(50) not null,\r\n createtime datetime , \r\n port varchar(5)\r\n );\r\n#\u67e5\u770b\u8def\u7531\u60c5\u51b5\uff1a\r\nmysql&gt; explain select * from t_customer;\r\n+-----------+------------------------------------+\r\n| DATA_NODE | SQL |\r\n+-----------+------------------------------------+\r\n| db10 | SELECT * FROM t_customer LIMIT 100 |\r\n| db6 | SELECT * FROM t_customer LIMIT 100 |\r\n| db7 | SELECT * FROM t_customer LIMIT 100 |\r\n| db8 | SELECT * FROM t_customer LIMIT 100 |\r\n| db9 | SELECT * FROM t_customer LIMIT 100 |\r\n+-----------+------------------------------------+\r\n5 rows in set (0.01 sec)\r\n\u53ef\u4ee5\u770b\u5230select\u7684\u6570\u636e\u6765\u6e90\u4e8e5\u4e2a\u5206\u7247<\/pre>\n<h3>\u5411t_customer\u8868\u63d2\u5165100\u6761\u6d4b\u8bd5\u6570\u636e<\/h3>\n<pre class=\"prettyprint linenums\">#<span style=\"color: #ff0000;\">next value for MYCATSEQ_CUSTOMER<\/span> \u5c31\u8c03\u7528\u4e86\u6211\u4eec\u81ea\u5b9a\u4e49\u7684\u81ea\u589eID\u65b9\u6848\r\nmysql&gt;insert into t_customer(id,username,password,createtime,port) values \r\n(<span style=\"color: #ff0000;\">next value for MYCATSEQ_CUSTOMER<\/span>,CONCAT('user_',FLOOR((RAND()*1000))),'111111',NOW(),@@PORT);\r\n.....\u6267\u884c100\u6b21\r\n\r\n#\u67e5\u8be2\u6570\u636e\uff1a\r\nmysql&gt; select * from t_customer;\r\n+-----+----------+----------+---------------------+------+\r\n| id | username | password | createtime | port |\r\n+-----+----------+----------+---------------------+------+\r\n| 101 | user_10 | 111111 | 2017-08-16 14:05:48 | 3308 |\r\n| 102 | user_389 | 111111 | 2017-08-16 14:05:57 | 3308 |\r\n| 103 | user_56 | 111111 | 2017-08-16 14:05:58 | 3308 |\r\n| 104 | user_918 | 111111 | 2017-08-16 14:05:59 | 3308 |\r\n| 105 | user_252 | 111111 | 2017-08-16 14:06:01 | 3308 |\r\n| 106 | user_422 | 111111 | 2017-08-16 14:06:02 | 3308 |\r\n| 107 | user_93 | 111111 | 2017-08-16 14:06:03 | 3308 |\r\n| 108 | user_356 | 111111 | 2017-08-16 14:06:04 | 3308 |\r\n| 109 | user_708 | 111111 | 2017-08-16 14:06:07 | 3308 |\r\n| 110 | user_514 | 111111 | 2017-08-16 14:06:08 | 3308 |\r\n| 111 | user_264 | 111111 | 2017-08-16 14:06:09 | 3308 |\r\n| 112 | user_503 | 111111 | 2017-08-16 14:06:10 | 3308 |\r\n| 113 | user_193 | 111111 | 2017-08-16 14:06:11 | 3308 |\r\n| 114 | user_972 | 111111 | 2017-08-16 14:06:17 | 3308 |\r\n| 115 | user_177 | 111111 | 2017-08-16 14:06:18 | 3308 |\r\n| 116 | user_353 | 111111 | 2017-08-16 14:06:19 | 3308 |\r\n| 117 | user_305 | 111111 | 2017-08-16 14:06:20 | 3308 |\r\n| 118 | user_850 | 111111 | 2017-08-16 14:06:20 | 3308 |\r\n| 119 | user_995 | 111111 | 2017-08-16 14:06:21 | 3308 |\r\n| 120 | user_190 | 111111 | 2017-08-16 14:06:22 | 3308 |\r\n| 121 | user_582 | 111111 | 2017-08-16 14:06:23 | 3307 |\r\n| 122 | user_276 | 111111 | 2017-08-16 14:06:24 | 3307 |\r\n| 123 | user_606 | 111111 | 2017-08-16 14:06:29 | 3307 |\r\n| 124 | user_715 | 111111 | 2017-08-16 14:06:30 | 3307 |\r\n| 125 | user_830 | 111111 | 2017-08-16 14:06:36 | 3307 |\r\n| 126 | user_202 | 111111 | 2017-08-16 14:06:37 | 3307 |\r\n| 127 | user_6 | 111111 | 2017-08-16 14:06:38 | 3307 |\r\n| 128 | user_194 | 111111 | 2017-08-16 14:06:38 | 3307 |\r\n| 129 | user_539 | 111111 | 2017-08-16 14:06:39 | 3307 |\r\n| 130 | user_362 | 111111 | 2017-08-16 14:06:40 | 3307 |\r\n| 131 | user_681 | 111111 | 2017-08-16 14:06:41 | 3307 |\r\n| 132 | user_230 | 111111 | 2017-08-16 14:06:42 | 3307 |\r\n| 133 | user_785 | 111111 | 2017-08-16 14:06:43 | 3307 |\r\n| 134 | user_64 | 111111 | 2017-08-16 14:06:43 | 3307 |\r\n| 135 | user_885 | 111111 | 2017-08-16 14:06:44 | 3307 |\r\n| 136 | user_70 | 111111 | 2017-08-16 14:06:46 | 3307 |\r\n| 137 | user_630 | 111111 | 2017-08-16 14:06:46 | 3307 |\r\n....\r\n\r\n<span style=\"color: #ff0000;\">\u7531\u4e8e\u6211\u4eec\u5df2\u7ecf\u505a\u4e86\u4e3b\u4ece\u540c\u6b65\uff0c\u8bfb\u5199\u5206\u79bb\u3002\u521a\u521a\u63d2\u5165\u7684\u6570\u636e\u6765\u6e90\u4e8e3307\u548c3308\u4e24\u4e2a\u5e93<\/span><\/pre>\n<h3>\u9a8c\u8bc1\u5206\u7247\u662f\u5426\u6b63\u5e38\uff1a<\/h3>\n<p><strong>\u767b\u5f55\u52303306\u4e3b\u5e93\u67e5\u770b\u6570\u636e\uff1a<\/strong><\/p>\n<pre class=\"prettyprint linenums\"><span style=\"color: #ff0000;\">#\u67e5\u770b\u5206\u7247\u6570\u636e\u5e93\uff0c\u53ef\u4ee5\u770b\u5230\u6700\u5f00\u59cb\u6211\u4eec\u521b\u5efa\u76845\u4e2a\u5206\u7247<\/span>\r\nmysql&gt; show databases;\r\n+--------------------+\r\n| Database           |\r\n+--------------------+\r\n| information_schema |\r\n| db1                |\r\n| db2                |\r\n| db3                |\r\n| db4                |\r\n| db5                |\r\n| mysql              |\r\n| performance_schema |\r\n| test               |\r\n+--------------------+\r\n11 rows in set (0.00 sec)\r\n\r\n<span style=\"color: #ff0000;\">#\u67e5\u770b\u7b2c\u4e00\u4e2a\u5206\u7247db1:<\/span>\r\nmysql&gt; use db1;\r\nDatabase changed\r\nmysql&gt; show tables;\r\n+---------------+\r\n| Tables_in_db1 |\r\n+---------------+\r\n| t_customer    |\r\n+---------------+\r\n1 row in set (0.00 sec)\r\n\r\nmysql&gt; select * from t_customer;\r\n+-----+----------+----------+---------------------+------+\r\n| id  | username | password | createtime          | port |\r\n+-----+----------+----------+---------------------+------+\r\n| 101 | user_10  | 111111   | 2017-08-16 14:05:48 | 3306 |\r\n| 102 | user_389 | 111111   | 2017-08-16 14:05:57 | 3306 |\r\n| 103 | user_56  | 111111   | 2017-08-16 14:05:58 | 3306 |\r\n| 104 | user_918 | 111111   | 2017-08-16 14:05:59 | 3306 |\r\n| 105 | user_252 | 111111   | 2017-08-16 14:06:01 | 3306 |\r\n| 106 | user_422 | 111111   | 2017-08-16 14:06:02 | 3306 |\r\n| 107 | user_93  | 111111   | 2017-08-16 14:06:03 | 3306 |\r\n| 108 | user_356 | 111111   | 2017-08-16 14:06:04 | 3306 |\r\n| 109 | user_708 | 111111   | 2017-08-16 14:06:07 | 3306 |\r\n| 110 | user_514 | 111111   | 2017-08-16 14:06:08 | 3306 |\r\n| 111 | user_264 | 111111   | 2017-08-16 14:06:09 | 3306 |\r\n| 112 | user_503 | 111111   | 2017-08-16 14:06:10 | 3306 |\r\n| 113 | user_193 | 111111   | 2017-08-16 14:06:11 | 3306 |\r\n| 114 | user_972 | 111111   | 2017-08-16 14:06:17 | 3306 |\r\n| 115 | user_177 | 111111   | 2017-08-16 14:06:18 | 3306 |\r\n| 116 | user_353 | 111111   | 2017-08-16 14:06:19 | 3306 |\r\n| 117 | user_305 | 111111   | 2017-08-16 14:06:20 | 3306 |\r\n| 118 | user_850 | 111111   | 2017-08-16 14:06:20 | 3306 |\r\n| 119 | user_995 | 111111   | 2017-08-16 14:06:21 | 3306 |\r\n| 120 | user_190 | 111111   | 2017-08-16 14:06:22 | 3306 |\r\n+-----+----------+----------+---------------------+------+\r\n20 rows in set (0.00 sec)\r\n\r\n\u53ef\u4ee5\u770b\u5230ID \u4e3a 101-120\u7684\u6570\u636e\u6b63\u786e\u8fdb\u5165\u5230\u7b2c\u4e00\u4e2a\u5206\u7247db1\r\n<span style=\"color: #ff0000;\">\u67e5\u770b\u7b2c\u4e8c\u4e2a\u5206\u7247db2\uff1a<\/span>\r\nmysql&gt; use db2\r\nReading table information for completion of table and column names\r\nYou can turn off this feature to get a quicker startup with -A\r\n\r\nDatabase changed\r\nmysql&gt; select * from t_customer;\r\n+-----+----------+----------+---------------------+------+\r\n| id  | username | password | createtime          | port |\r\n+-----+----------+----------+---------------------+------+\r\n| 121 | user_582 | 111111   | 2017-08-16 14:06:23 | 3306 |\r\n| 122 | user_276 | 111111   | 2017-08-16 14:06:24 | 3306 |\r\n| 123 | user_606 | 111111   | 2017-08-16 14:06:29 | 3306 |\r\n| 124 | user_715 | 111111   | 2017-08-16 14:06:30 | 3306 |\r\n| 125 | user_830 | 111111   | 2017-08-16 14:06:36 | 3306 |\r\n| 126 | user_202 | 111111   | 2017-08-16 14:06:37 | 3306 |\r\n| 127 | user_6   | 111111   | 2017-08-16 14:06:38 | 3306 |\r\n| 128 | user_194 | 111111   | 2017-08-16 14:06:38 | 3306 |\r\n| 129 | user_539 | 111111   | 2017-08-16 14:06:39 | 3306 |\r\n| 130 | user_362 | 111111   | 2017-08-16 14:06:40 | 3306 |\r\n| 131 | user_681 | 111111   | 2017-08-16 14:06:41 | 3306 |\r\n| 132 | user_230 | 111111   | 2017-08-16 14:06:42 | 3306 |\r\n| 133 | user_785 | 111111   | 2017-08-16 14:06:43 | 3306 |\r\n| 134 | user_64  | 111111   | 2017-08-16 14:06:43 | 3306 |\r\n| 135 | user_885 | 111111   | 2017-08-16 14:06:44 | 3306 |\r\n| 136 | user_70  | 111111   | 2017-08-16 14:06:46 | 3306 |\r\n| 137 | user_630 | 111111   | 2017-08-16 14:06:46 | 3306 |\r\n| 138 | user_695 | 111111   | 2017-08-16 14:06:47 | 3306 |\r\n| 139 | user_959 | 111111   | 2017-08-16 14:06:48 | 3306 |\r\n| 140 | user_264 | 111111   | 2017-08-16 14:06:49 | 3306 |\r\n+-----+----------+----------+---------------------+------+\r\n20 rows in set (0.00 sec)\r\n\r\n<\/pre>\n<p>\u6211\u4eec\u8fd8\u53ef\u4ee5\u767b\u5f55\u5230\u4ece\u5e933307\u548c3308\u67e5\u770b\uff1a<\/p>\n<p><a href=\"http:\/\/www.chenweikang.top\/wp-content\/uploads\/2017\/08\/mycat-fenpian.png\" class=\"gallery_colorbox\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-433\" src=\"http:\/\/www.chenweikang.top\/wp-content\/uploads\/2017\/08\/mycat-fenpian.png\"  alt=\"\" width=\"1280\" height=\"625\" srcset=\"https:\/\/www.chenweikang.top\/wp-content\/uploads\/2017\/08\/mycat-fenpian.png 1280w, https:\/\/www.chenweikang.top\/wp-content\/uploads\/2017\/08\/mycat-fenpian-300x146.png 300w, https:\/\/www.chenweikang.top\/wp-content\/uploads\/2017\/08\/mycat-fenpian-768x375.png 768w, https:\/\/www.chenweikang.top\/wp-content\/uploads\/2017\/08\/mycat-fenpian-1024x500.png 1024w\" sizes=\"auto, (max-width: 1280px) 100vw, 1280px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h2>\u9644\u5f55<\/h2>\n<ul>\n<li>Mycat \u6350\u8d60\u5730\u5740 \uff1a<a href=\"http:\/\/www.mycat.io\/donate.html\" target=\"_blank\" rel=\"noopener\">http:\/\/www.mycat.io\/donate.html<\/a><\/li>\n<li>Mycat \u5b98\u65b9\u7f51\u7ad9\uff1a<a href=\"http:\/\/www.mycat.io\/\" target=\"_blank\" rel=\"noopener\">http:\/\/www.mycat.io\/<\/a><\/li>\n<li>Mycat \u6e90\u7801\uff1a<a href=\"https:\/\/github.com\/MyCATApache\/Mycat-Server\" target=\"_blank\" rel=\"noopener\">https:\/\/github.com\/MyCATApache\/Mycat-Server<\/a><\/li>\n<li>Mycat \u4e0b\u8f7d\u5730\u5740\uff1a<a href=\"https:\/\/github.com\/MyCATApache\/Mycat-download\" target=\"_blank\" rel=\"noopener\">https:\/\/github.com\/MyCATApache\/Mycat-download<\/a><\/li>\n<\/ul>\n<h2>\u5176\u4ed6\u5b9e\u9a8c<\/h2>\n<ul>\n<li><a href=\"http:\/\/www.chenweikang.top\/mycat%E5%AE%9E%E9%AA%8C%EF%BC%881%EF%BC%89-%E5%8D%95%E4%B8%AA%E6%9C%8D%E5%8A%A1%E5%99%A8%E9%83%A8%E7%BD%B2%E5%A4%9A%E4%B8%AAmysql\/\">mycat\u5b9e\u9a8c\uff081\uff09-\u5355\u4e2a\u670d\u52a1\u5668\u90e8\u7f72\u591a\u4e2amysql<\/a><\/li>\n<li><a href=\"http:\/\/www.chenweikang.top\/mycat%E5%AE%9E%E9%AA%8C%EF%BC%882%EF%BC%89-%E9%85%8D%E7%BD%AEmysql%E4%B8%BB%E4%BB%8E%E5%90%8C%E6%AD%A5\/\">mycat\u5b9e\u9a8c\uff082\uff09-\u914d\u7f6emysql\u4e3b\u4ece\u540c\u6b65<\/a><\/li>\n<li><a href=\"http:\/\/www.chenweikang.top\/mycat%E5%AE%9E%E9%AA%8C%EF%BC%883%EF%BC%89-%E7%AE%80%E5%8D%95%E9%85%8D%E7%BD%AEmycat%EF%BC%8C%E5%AE%9E%E7%8E%B0%E8%AF%BB%E5%86%99%E5%88%86%E7%A6%BB\/\">mycat\u5b9e\u9a8c\uff083\uff09-\u7b80\u5355\u914d\u7f6emycat\uff0c\u5b9e\u73b0\u8bfb\u5199\u5206\u79bb<\/a><\/li>\n<li><a href=\"http:\/\/www.chenweikang.top\/mycat%E5%AE%9E%E9%AA%8C%EF%BC%884%EF%BC%89-mycat%E6%95%B0%E6%8D%AE%E5%88%86%E7%89%87%E6%B5%8B%E8%AF%95\/\">mycat\u5b9e\u9a8c\uff084\uff09-mycat\u6570\u636e\u5206\u7247\u6d4b\u8bd5<\/a><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>\u8f6c\u8f7d\u8bf7\u6ce8\u660e\uff1a<a href=\"https:\/\/www.chenweikang.top\">\u5de6\u624b\u4ee3\u7801\u53f3\u624b\u8bd7<\/a> &raquo; <a href=\"https:\/\/www.chenweikang.top\/?p=425\">Mycat\u4e3b\u4ece\u540c\u6b65\u3001\u8bfb\u5199\u5206\u79bb\u3001\u5206\u5e93\u5206\u8868\uff084\uff09-Mycat\u6570\u636e\u5206\u7247\u6d4b\u8bd5<\/a><\/p><div class=\"__youshang\">\r\n            <div id=\"__youshang_popup\" class=\"wechat popup\" style=\"display: none;\">\r\n                <div class=\"head\">~\u8c22\u8c22\u6253\u8d4f~<\/div>\r\n                <div class=\"qrcode\"><div class=\"qrcode-li wechat\" ><img src=\"https:\/\/www.chenweikang.top\/wp-content\/uploads\/2019\/07\/wexin.png\" \/><\/div><div class=\"qrcode-li alipay\" style=\"display:none;\"><img src=\"https:\/\/www.chenweikang.top\/wp-content\/uploads\/2019\/07\/ali-pay.png\" \/><\/div><div class=\"qrcode-li hongbao\" style=\"display:none;\"><img src=\"https:\/\/www.chenweikang.top\/wp-content\/uploads\/2019\/07\/ali-hongbao.png\" \/><\/div><\/div>\r\n                <ul class=\"platform\"><li class=\"icon-wechat active\" data-bg-color=\"#05af4e\" data-thanks=\"~\u8c22\u8c22\u6253\u8d4f~\"><\/li><li class=\"icon-alipay \" data-bg-color=\"#00a2ea\" data-thanks=\"~\u8c22\u8c22\u6253\u8d4f~\"><\/li><li class=\"icon-hongbao \" data-bg-color=\"#dd5746\" data-thanks=\"<p>\u626b\u7801\u9886\u7ea2\u5305<\/p><p style='margin-top: 24px;'>\uff08\u4f59\u989d\u5b9d\u652f\u4ed8\u65f6\u53ef\u62b5\u73b0\uff09<\/p>\"><\/li><\/ul>\r\n            <\/div>\r\n            <a href=\"javascript:void(0);\" id=\"__youshang_btn\">\u8d4f<\/a>\r\n        <\/div>","protected":false},"excerpt":{"rendered":"<p>\u672c\u7bc7\u5b9e\u9a8c\u4ecd\u7136\u662f\u57fa\u4e8e\u4e0a\u7bc7\u7684\u4e3b\u4ece\u540c\u6b65\u73af\u5883\uff0c\u57283306\u521b\u5efa5\u4e2a\u6570\u636e\u5e93 db1,db2,db3,db4,db5\u3001\u5e76\u52a0\u5165 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":433,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[4],"tags":[46,45,47],"class_list":["post-425","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database","tag-mycat","tag-45","tag-47"],"_links":{"self":[{"href":"https:\/\/www.chenweikang.top\/index.php?rest_route=\/wp\/v2\/posts\/425","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.chenweikang.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.chenweikang.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.chenweikang.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.chenweikang.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=425"}],"version-history":[{"count":0,"href":"https:\/\/www.chenweikang.top\/index.php?rest_route=\/wp\/v2\/posts\/425\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.chenweikang.top\/index.php?rest_route=\/wp\/v2\/media\/433"}],"wp:attachment":[{"href":"https:\/\/www.chenweikang.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=425"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.chenweikang.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=425"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.chenweikang.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=425"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}