\u5728\u6570\u636e\u5207\u5206\u5904\u7406\u4e2d\uff0c\u7279\u522b\u662f\u6c34\u5e73\u5207\u5206\u4e2d\uff0c\u4e2d\u95f4\u4ef6\u6700\u91cd\u8981\u7684\u4e24\u4e2a\u5904\u7406\u8fc7\u7a0b\u5c31\u662f\u6570\u636e\u7684\u5207\u5206\u3001\u6570\u6364\u7684\u805a\u548c\u3002\u9009\u62e9\u5408\u9002\u7684\u5207\u5206\u89c4\u5219\uff0c\u81f3\u5173\u91cd\u8981\uff0c\u56e0\u4e3a\u5b83\u51b3\u5b9a\u4e86\u540e\u7eed\u6570\u636e\u805a\u548c\u7684\u96be\u6613\u7a0b\u5ea6\uff0c\u751a\u81f3\u53ef\u4ee5\u907f\u514d\u8de8\u5e93\u7684\u6570\u636e\u805a\u5408\u5904\u7406\u3002<\/p><\/blockquote>\n

\u5206\u7247\u89c4\u5219\u914d\u7f6e\u6587\u4ef6rule.xml<\/h2>\n
rule.xml \u91cc\u9762\u5c31\u5b9a\u4e49\u4e86\u6211\u4eec\u5bf9\u8868\u8fdb\u884c\u62c6\u5206\u6240\u6d89\u53ca\u5230\u7684\u89c4\u5219\u5b9a\u4e49\u3002\u6211\u4eec\u53ef\u4ee5\u7075\u6d3b\u7684\u5bf9\u8868\u4f7f\u7528\u4e0d\u540c\u7684\u5206\u7247\u7b97\u6cd5\uff0c\u6216\u8005\u5bf9\u8868\u4f7f\u7528\u76f8\u540c\u7684\u7b97\u6cd5\u4f46\u5177\u4f53\u7684\u53c2\u6570\u4e0d\u540c\u3002\u8fd9\u4e2a\u6587\u4ef6\u91cc\u9762\u4e3b\u8981\u6709 tableRule \u548c function \u8fd9\u4e1f\u4e2a\u6807\u7b7e\u3002\u5728\u5177\u4f53\u4f7f\u7528\u8fc7\u7a0b\u4e2d\u53ef\u4ee5\u6309\u7167\u9700\u6c42\u6dfb\u52a0 tableRule \u548c function\u3002<\/p>\n

tableRule\u6807\u7b7e<\/h3>\n

\u8fd9\u4e2a\u6807\u7b7e\u5b9a\u4e49\u4e86\u8868\u89c4\u5219\u3002
\n\u5b9a\u4e49\u7684\u8868\u89c4\u5219\uff0c\u5728 schema.xml\u7684table\u6807\u7b7e\u4e2d\u53ef\u4ee5\u7528rule\u5c5e\u6027\u6307\u5b9a\u89c4\u5219\uff1a<\/p>\n

<tableRule name=\"rule1\"><\/p>\n

<rule><\/p>\n

<columns>id<\/columns><\/p>\n

<algorithm>func1<\/algorithm><\/p>\n

<\/rule><\/p>\n

<\/tableRule><\/p><\/blockquote>\n

name \u5c5e\u6027\u6307\u5b9a\u552f\u4e00\u7684\u540d\u5b57\uff0c\u7528\u4e8e\u6807\u793a\u4e0d\u540c\u7684\u8868\u89c4\u5219\u3002
\n\u5185\u5d4c\u7684 rule \u6807\u7b7e\u5219\u6307\u5b9a\u5bf9\u7269\u7406\u8868\u4e2d\u7684\u54ea\u4e00\u5217\u8fdb\u884c\u62c6\u5206\u548c\u4f7f\u7528\u4ec0\u4e48\u8def\u7531\u7b97\u6cd5\u3002
\ncolumns \u6307\u5b9a\u8981\u62c6\u5206\u7684\u5217\u540d\u5b57\u3002
\nalgorithm \u4f7f\u7528 function \u6807\u7b7e\u4e2d\u7684name \u5c5e\u6027\u3002\u8fde\u63a5\u8868\u89c4\u5219\u548c\u5177\u4f53\u8def\u7531\u7b97\u6cd5\u3002\u5f53\u7136\uff0c\u591a\u4e2a\u8868\u89c4\u5219\u53ef\u4ee5\u8fde\u63a5\u5230\u540c\u4e00\u4e2a\u8def\u7531\u7b97\u6cd5\u4e0a\u3002table \u6807\u7b7e\u5185\u4f7f\u7528\u3002\u8ba9\u903b\u8f91\u8868\u4f7f\u7528\u8fd9\u4e2a\u89c4\u5219\u8fdb\u884c\u5206\u7247\u3002<\/p>\n

function\u6807\u7b7e<\/h3>\n

<function name=\"hash-int\" class=\"org.opencloudb.route.function.PartitionByFileMap\"><\/p>\n

<property name=\"mapFile\">partition-hash-int.txt<\/property><\/p>\n

<\/function><\/p><\/blockquote>\n

name \u6307\u5b9a\u7b97\u6cd5\u7684\u540d\u5b57\u3002<\/p>\n

class \u6307\u5b9a\u8def\u7531\u7b97\u6cd5\u5177\u4f53\u7684\u7c7b\u540d\u5b57\u3002<\/p>\n

property \u4e3a\u5177\u4f53\u7b97\u6cd5\u9700\u8981\u7528\u5230\u7684\u4e00\u4e9b\u5c5e\u6027\u3002<\/p>\n

\u4e00\u3001\u679a\u4e3e\u6cd5<\/strong><\/h2>\n
\n
\n
<tableRule name=\"sharding-by-intfile\"><\/div>\n
\u00a0\u00a0\u00a0 <rule><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0 <columns>user_id<\/columns><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0 <algorithm>hash-int<\/algorithm><\/div>\n
\u00a0\u00a0\u00a0 <\/rule><\/div>\n
\u00a0 <\/tableRule><\/div>\n
<function name=\"hash-int\" class=\"io.mycat.route.function.PartitionByFileMap\"><\/div>\n
\u00a0\u00a0\u00a0 <property name=\"mapFile\">partition-hash-int.txt<\/property><\/div>\n
\u00a0\u00a0\u00a0 <property name=\"type\">0<\/property><\/div>\n
\u00a0\u00a0\u00a0 <property name=\"defaultNode\">0<\/property><\/div>\n
\u00a0 <\/function><\/div>\n
<\/div>\n
partition-hash-int.txt \u914d\u7f6e\uff1a<\/span><\/div>\n
10000=0<\/div>\n
10010=1<\/div>\n<\/div>\n<\/div>\n
\n
\n
\u4e0a\u9762columns \u6807\u8bc6\u5c06\u8981\u5206\u7247\u7684\u8868\u5b57\u6bb5\uff0calgorithm \u5206\u7247\u51fd\u6570\uff0c\u5176\u4e2d\u5206\u7247\u51fd\u6570\u914d\u7f6e\u4e2d\uff0cmapFile\u6807\u8bc6\u914d\u7f6e\u6587\u4ef6\u540d\u79f0\uff0ctype\u9ed8\u8ba4\u503c\u4e3a0\uff0c0\u8868\u793aInteger\uff0c\u975e\u96f6\u8868\u793aString\uff0c<\/div>\n
\u6240\u6709\u7684\u8282\u70b9\u914d\u7f6e\u90fd\u662f\u4ece0\u5f00\u59cb\uff0c\u53ca0\u4ee3\u8868\u8282\u70b91<\/div>\n
\/**
\n*\u00a0\u00a0defaultNode \u9ed8\u8ba4\u8282\u70b9:\u5c0f\u4e8e0\u8868\u793a\u4e0d\u8bbe\u7f6e\u9ed8\u8ba4\u8282\u70b9\uff0c\u5927\u4e8e\u7b49\u4e8e0\u8868\u793a\u8bbe\u7f6e\u9ed8\u8ba4\u8282\u70b9,\u7ed3\u70b9\u4e3a\u6307\u5b9a\u7684\u503c
\n*
\n\u9ed8\u8ba4\u8282\u70b9\u7684\u4f5c\u7528\uff1a\u679a\u4e3e\u5206\u7247\u65f6\uff0c\u5982\u679c\u78b0\u5230\u4e0d\u8bc6\u522b\u7684\u679a\u4e3e\u503c\uff0c\u5c31\u8ba9\u5b83\u8def\u7531\u5230\u9ed8\u8ba4\u8282\u70b9
\n*\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u5982\u679c\u4e0d\u914d\u7f6e\u9ed8\u8ba4\u8282\u70b9\uff08defaultNode\u503c\u5c0f\u4e8e0\u8868\u793a\u4e0d\u914d\u7f6e\u9ed8\u8ba4\u8282\u70b9\uff09\uff0c\u78b0\u5230
\n*\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u4e0d\u8bc6\u522b\u7684\u679a\u4e3e\u503c\u5c31\u4f1a\u62a5\u9519\uff0c
\n*\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0like this\uff1acan't find datanode for sharding column:column_name val:ffffffff
\n*\/<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\u4e8c\u3001\u56fa\u5b9a\u5206\u7247hash\u7b97\u6cd5<\/strong><\/h2>\n
\n
\n
<tableRule name=\"rule1\"><\/div>\n
\u00a0\u00a0\u00a0 <rule><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0 <columns>user_id<\/columns><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0 <algorithm>func1<\/algorithm><\/div>\n
\u00a0\u00a0\u00a0 <\/rule><\/div>\n
<\/tableRule><\/div>\n
<\/div>\n
\u00a0 <function name=\"func1\" class=\"io.mycat.route.function.PartitionByLong\"><\/div>\n
\u00a0\u00a0\u00a0 <property name=\"partitionCount\">2,1<\/property><\/div>\n
\u00a0\u00a0\u00a0 <property name=\"partitionLength\">256,512<\/property><\/div>\n
\u00a0 <\/function><\/div>\n<\/div>\n<\/div>\n
\n
\u914d\u7f6e\u8bf4\u660e\uff1a<\/div>\n
\n
\u4e0a\u9762columns \u6807\u8bc6\u5c06\u8981\u5206\u7247\u7684\u8868\u5b57\u6bb5\uff0calgorithm \u5206\u7247\u51fd\u6570\uff0cpartitionCount \u5206\u7247\u4e2a\u6570\u5217\u8868\uff0cpartitionLength \u5206\u7247\u8303\u56f4\u5217\u8868\u5206\u533a\u957f\u5ea6:\u9ed8\u8ba4\u4e3a\u6700\u59272^n=1024 ,\u5373\u6700\u5927\u652f\u63011024\u5206\u533a<\/div>\n
\u7ea6\u675f :<\/div>\n
count,length\u4e24\u4e2a\u6570\u7ec4\u7684\u957f\u5ea6\u5fc5\u987b\u662f\u4e00\u81f4\u7684\u3002
\n1024 = sum((count[i]*length[i])). count<\/strong>\u548clength\u4e24\u4e2a\u5411\u91cf\u7684\u70b9\u79ef\u6052\u7b49\u4e8e1024<\/strong><\/div>\n
\u7528\u6cd5\u4f8b\u5b50\uff1a<\/div>\n
\n
@Test\r\npublic void testPartition() {\r\n \/\/ \u672c\u4f8b\u7684\u5206\u533a\u7b56\u7565\uff1a\u5e0c\u671b\u5c06\u6570\u636e\u6c34\u5e73\u5206\u62103\u4efd\uff0c\u524d\u4e24\u4efd\u5404\u536025%\uff0c\u7b2c\u4e09\u4efd\u536050%\u3002\uff08\u6545\u672c\u4f8b\u975e\u5747\u5300\u5206\u533a\uff09\r\n \/\/ |<---------------------1024------------------------>|\r\n \/\/ |<----256--->|<----256--->|<----------512---------->|\r\n \/\/ | partition0 | partition1 | partition2 |\r\n \/\/ | \u51712\u4efd,\u6545count[0]=2 | \u51711\u4efd\uff0c\u6545count[1]=1 |\r\n int[] count = new int[] { 2, 1 };\r\n int[] length = new int[] { 256, 512 };\r\n PartitionUtil pu = new PartitionUtil(count, length);\r\n\r\n \/\/ \u4e0b\u9762\u4ee3\u7801\u6f14\u793a\u5206\u522b\u4ee5offerId\u5b57\u6bb5\u6216memberId\u5b57\u6bb5\u6839\u636e\u4e0a\u8ff0\u5206\u533a\u7b56\u7565\u62c6\u5206\u7684\u5206\u914d\u7ed3\u679c\r\n int DEFAULT_STR_HEAD_LEN = 8; \/\/ cobar\u9ed8\u8ba4\u4f1a\u914d\u7f6e\u4e3a\u6b64\u503c\r\n long offerId = 12345;\r\n String memberId = \"qiushuo\";\r\n\r\n \/\/ \u82e5\u6839\u636eofferId\u5206\u914d\uff0cpartNo1\u5c06\u7b49\u4e8e0\uff0c\u5373\u6309\u7167\u4e0a\u8ff0\u5206\u533a\u7b56\u7565\uff0cofferId\u4e3a12345\u65f6\u5c06\u4f1a\u88ab\u5206\u914d\u5230partition0\u4e2d\r\n int partNo1 = pu.partition(offerId);\r\n\r\n \/\/ \u82e5\u6839\u636ememberId\u5206\u914d\uff0cpartNo2\u5c06\u7b49\u4e8e2\uff0c\u5373\u6309\u7167\u4e0a\u8ff0\u5206\u533a\u7b56\u7565\uff0cmemberId\u4e3aqiushuo\u65f6\u5c06\u4f1a\u88ab\u5206\u5230partition2\u4e2d\r\n int partNo2 = pu.partition(memberId, 0, DEFAULT_STR_HEAD_LEN);\r\n\r\n Assert.assertEquals(0, partNo1);\r\n Assert.assertEquals(2, partNo2);\r\n}<\/pre>\n<\/div>\n
<\/div>\n
\u5982\u679c\u9700\u8981\u5e73\u5747\u5206\u914d\u8bbe\u7f6e\uff1a\u5e73\u5747\u5206\u4e3a4\u5206\u7247\uff0cpartitionCount*partitionLength=1024<\/strong><\/div>\n<\/div>\n
\n
<function name=\"func1\" class=\"org.opencloudb.route.function.PartitionByLong\"><\/strong><\/div>\n
\u00a0\u00a0\u00a0 <property name=\"partitionCount\">4<\/property><\/strong><\/div>\n
\u00a0\u00a0\u00a0 <property name=\"partitionLength\">256<\/property><\/strong><\/div>\n
\u00a0 <\/function><\/strong><\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\u4e09\u3001\u8303\u56f4\u7ea6\u5b9a<\/strong><\/h2>\n
\n
\n
<tableRule name=\"auto-sharding-long\"><\/strong><\/div>\n
\u00a0\u00a0\u00a0 <rule><\/strong><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0 <columns>user_id<\/columns><\/strong><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0 <algorithm>rang-long<\/algorithm><\/strong><\/div>\n
\u00a0\u00a0\u00a0 <\/rule><\/strong><\/div>\n
\u00a0 <\/tableRule><\/strong><\/div>\n
<function name=\"rang-long\" class=\"io.mycat.route.function.AutoPartitionByLong\"><\/strong><\/div>\n
\u00a0\u00a0\u00a0 <property name=\"mapFile\">autopartition-long.txt<\/property><\/strong><\/div>\n
\u00a0 <\/function><\/strong><\/div>\n
# range start-end ,data node index<\/strong><\/div>\n
# K=1000,M=10000.<\/strong><\/div>\n
0-500M=0<\/strong><\/div>\n
500M-1000M=1<\/strong><\/div>\n
1000M-1500M=2<\/strong><\/div>\n
\u6216<\/strong><\/div>\n
0-10000000=0<\/strong><\/div>\n
10000001-20000000=1<\/strong><\/div>\n<\/div>\n
\n
\u00a0<\/strong><\/div>\n<\/div>\n
\n
\u914d\u7f6e\u8bf4\u660e\uff1a<\/div>\n
\u4e0a\u9762columns \u6807\u8bc6\u5c06\u8981\u5206\u7247\u7684\u8868\u5b57\u6bb5\uff0calgorithm \u5206\u7247\u51fd\u6570\uff0c<\/div>\n
rang-long \u51fd\u6570\u4e2dmapFile\u4ee3\u8868\u914d\u7f6e\u6587\u4ef6\u8def\u5f84<\/div>\n
\u6240\u6709\u7684\u8282\u70b9\u914d\u7f6e\u90fd\u662f\u4ece0\u5f00\u59cb\uff0c\u53ca0\u4ee3\u8868\u8282\u70b91\uff0c\u6b64\u914d\u7f6e\u975e\u5e38\u7b80\u5355\uff0c\u5373\u9884\u5148\u5236\u5b9a\u53ef\u80fd\u7684id\u8303\u56f4\u5230\u67d0\u4e2a\u5206\u7247<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\u56db\u3001\u6c42\u6a21\u6cd5<\/strong><\/h2>\n
\n
\n
<tableRule name=\"mod-long\"><\/strong><\/div>\n
\u00a0\u00a0\u00a0 <rule><\/strong><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0 <columns>user_id<\/columns><\/strong><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0 <algorithm>mod-long<\/algorithm><\/strong><\/div>\n
\u00a0\u00a0\u00a0 <\/rule><\/strong><\/div>\n
\u00a0 <\/tableRule><\/strong><\/div>\n
\u00a0 <function name=\"mod-long\" class=\"io.mycat.route.function.PartitionByMod\"><\/strong><\/div>\n
\u00a0\u00a0 <\/strong><\/div>\n
\u00a0\u00a0\u00a0 <property name=\"count\">3<\/property><\/strong><\/div>\n
\u00a0 <\/function><\/strong><\/div>\n
<\/div>\n
\u914d\u7f6e\u8bf4\u660e\uff1a<\/div>\n
\u4e0a\u9762columns \u6807\u8bc6\u5c06\u8981\u5206\u7247\u7684\u8868\u5b57\u6bb5\uff0calgorithm \u5206\u7247\u51fd\u6570\uff0c<\/div>\n
\u6b64\u79cd\u914d\u7f6e\u975e\u5e38\u660e\u786e\u5373\u6839\u636eid\u4e0ecount\uff08\u4f60\u7684\u7ed3\u70b9\u6570\uff09\u8fdb\u884c\u6c42\u6a21\u9884\u7b97\uff0c\u76f8\u6bd4\u65b9\u5f0f1\uff0c\u6b64\u79cd\u5728\u6279\u91cf\u63d2\u5165\u65f6\u9700\u8981\u5207\u6362\u6570\u636e\u6e90\uff0cid\u4e0d\u8fde\u7eed<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\u4e94\u3001\u65e5\u671f\u5217\u5206\u533a\u6cd5<\/strong><\/h2>\n
\n
\n
<tableRule name=\"sharding-by-date\"><\/strong><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0 <rule><\/strong><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <columns>create_time<\/columns><\/strong><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <algorithm>sharding-by-date<\/algorithm><\/strong><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0 <\/rule><\/strong><\/div>\n
\u00a0\u00a0 <\/tableRule>\u00a0<\/strong><\/div>\n
<function name=\"sharding-by-date\" class=\"io.mycat.route.function..PartitionByDate\"><\/strong><\/div>\n<\/div>\n<\/div>\n
\n
\n
\u00a0\u00a0 <property name=\"dateFormat\">yyyy-MM-dd<\/property><\/strong><\/div>\n
\u00a0\u00a0\u00a0 <property name=\"sBeginDate\">2014-01-01<\/property><\/strong><\/div>\n
\u00a0\u00a0\u00a0 <property name=\"sPartionDay\">10<\/property><\/strong><\/div>\n
\u00a0 <\/function><\/strong><\/div>\n
\u914d\u7f6e\u8bf4\u660e\uff1a\u4e0a\u9762columns \u6807\u8bc6\u5c06\u8981\u5206\u7247\u7684\u8868\u5b57\u6bb5\uff0calgorithm \u5206\u7247\u51fd\u6570\uff0c\u914d\u7f6e\u4e2d\u914d\u7f6e\u4e86\u5f00\u59cb\u65e5\u671f\uff0c\u5206\u533a\u5929\u6570\uff0c\u5373\u9ed8\u8ba4\u4ece\u5f00\u59cb\u65e5\u671f\u7b97\u8d77\uff0c\u5206\u969410\u5929\u4e00\u4e2a\u5206\u533a\u8fd8\u6709\u4e00\u5207\u7279\u6027\u8bf7\u770b\u6e90\u7801<\/div>\n<\/div>\n
Assert.assertEquals(true, 0 == partition.calculate(\"2014-01-01\"));
\nAssert.assertEquals(true, 0 == partition.calculate(\"2014-01-10\"));
\nAssert.assertEquals(true, 1 == partition.calculate(\"2014-01-11\"));
\nAssert.assertEquals(true, 12 == partition.calculate(\"2014-05-01\"));<\/p>\n<\/div>\n
<\/div>\n<\/div>\n
\n
\u516d\u3001\u901a\u914d\u53d6\u6a21<\/strong><\/h2>\n
\n
<tableRule name=\"sharding-by-pattern\"><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0 <rule><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <columns>user_id<\/columns><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <algorithm>sharding-by-pattern<\/algorithm><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0 <\/rule><\/div>\n
\u00a0\u00a0 <\/tableRule><\/div>\n
<function name=\"sharding-by-pattern\" class=\"io.mycat.route.function.PartitionByPattern\"><\/div>\n
\u00a0\u00a0\u00a0 <property name=\"patternValue\">256<\/property><\/div>\n
\u00a0\u00a0\u00a0 <property name=\"defaultNode\">2<\/property><\/div>\n
\u00a0\u00a0\u00a0 <property name=\"mapFile\">partition-pattern.txt<\/property><\/div>\n
\u00a0 <\/function><\/div>\n
<\/div>\n
partition-pattern.txt :<\/span><\/div>\n
# id partition range start-end ,data node index<\/div>\n
###### first host configuration<\/div>\n
1-32=0<\/div>\n
33-64=1<\/div>\n
65-96=2<\/div>\n
97-128=3<\/div>\n
######## second host configuration<\/div>\n
129-160=4<\/div>\n
161-192=5<\/div>\n
193-224=6<\/div>\n
225-256=7<\/div>\n
0-0=7<\/div>\n<\/div>\n
\n
\n
\u914d\u7f6e\u8bf4\u660e\uff1a\u4e0a\u9762columns \u6807\u8bc6\u5c06\u8981\u5206\u7247\u7684\u8868\u5b57\u6bb5\uff0calgorithm \u5206\u7247\u51fd\u6570\uff0cpatternValue \u5373\u6c42\u6a21\u57fa\u6570\uff0cdefaoultNode \u9ed8\u8ba4\u8282\u70b9\uff0c\u5982\u679c\u4e0d\u914d\u7f6e\u4e86\u9ed8\u8ba4\uff0c\u5219\u9ed8\u8ba4\u662f0\u5373\u7b2c\u4e00\u4e2a\u7ed3\u70b9mapFile \u914d\u7f6e\u6587\u4ef6\u8def\u5f84\u914d\u7f6e\u6587\u4ef6\u4e2d\uff0c1-32 \u5373\u4ee3\u8868id%256\u540e\u5206\u5e03\u7684\u8303\u56f4\uff0c\u5982\u679c\u57281-32\u5219\u5728\u5206\u533a1\uff0c\u5176\u4ed6\u7c7b\u63a8\uff0c\u5982\u679cid\u975e\u6570\u5b57\u6570\u636e\uff0c\u5219\u4f1a\u5206\u914d\u5728defaoultNode \u9ed8\u8ba4\u8282\u70b9<\/div>\n<\/div>\n
\n
String idVal = \"0\";<\/p>\n<\/div>\n
Assert.assertEquals(true, 7 == autoPartition.calculate(idVal));
\nidVal = \"45a\";
\nAssert.assertEquals(true, 2 == autoPartition.calculate(idVal));<\/p>\n<\/div>\n<\/div>\n
\n
\u4e03\u3001ASCII\u7801\u6c42\u6a21\u901a\u914d<\/strong><\/h2>\n
\n
<tableRule name=\"sharding-by-prefixpattern\"><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0 <rule><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <columns>user_id<\/columns><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <algorithm>sharding-by-prefixpattern<\/algorithm><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0 <\/rule><\/div>\n
\u00a0\u00a0 <\/tableRule><\/div>\n
<function name=\"sharding-by-pattern\" class=\"io.mycat.route.function.PartitionByPrefixPattern\"><\/div>\n
\u00a0\u00a0\u00a0 <property name=\"patternValue\">256<\/property><\/div>\n
\u00a0\u00a0\u00a0 <property name=\"prefixLength\">5<\/property><\/div>\n
\u00a0\u00a0\u00a0 <property name=\"mapFile\">partition-pattern.txt<\/property><\/div>\n
\u00a0 <\/function><\/div>\n
<\/div>\n
partition-pattern.txt:<\/span><\/div>\n
# range start-end ,data node index<\/div>\n
# ASCII<\/div>\n
# 48-57=0-9<\/div>\n
# 64\u300165-90=@\u3001A-Z<\/div>\n
# 97-122=a-z<\/div>\n
###### first host configuration<\/div>\n
1-4=0<\/div>\n
5-8=1<\/div>\n
9-12=2<\/div>\n
13-16=3<\/div>\n
###### second host configuration<\/div>\n
17-20=4<\/div>\n
21-24=5<\/div>\n
25-28=6<\/div>\n
29-32=7<\/div>\n
0-0=7<\/div>\n
\u914d\u7f6e\u8bf4\u660e\uff1a<\/div>\n
\u4e0a\u9762columns \u6807\u8bc6\u5c06\u8981\u5206\u7247\u7684\u8868\u5b57\u6bb5\uff0calgorithm \u5206\u7247\u51fd\u6570\uff0cpatternValue \u5373\u6c42\u6a21\u57fa\u6570\uff0cprefixLength\u00a0ASCII \u622a\u53d6\u7684\u4f4d\u6570mapFile \u914d\u7f6e\u6587\u4ef6\u8def\u5f84\u914d\u7f6e\u6587\u4ef6\u4e2d\uff0c1-32 \u5373\u4ee3\u8868id%256\u540e\u5206\u5e03\u7684\u8303\u56f4\uff0c\u5982\u679c\u57281-32\u5219\u5728\u5206\u533a1\uff0c\u5176\u4ed6\u7c7b\u63a8<\/div>\n
\u6b64\u79cd\u65b9\u5f0f\u7c7b\u4f3c\u65b9\u5f0f6\u53ea\u4e0d\u8fc7\u91c7\u53d6\u7684\u662f\u5c06\u5217\u79cd\u83b7\u53d6\u524dprefixLength\u4f4d\u5217\u6240\u6709ASCII\u7801\u7684\u548c\u8fdb\u884c\u6c42\u6a21sum%patternValue ,\u83b7\u53d6\u7684\u503c\uff0c\u5728\u901a\u914d\u8303\u56f4\u5185\u7684<\/div>\n
\n
\n
\u5373 \u5206\u7247\u6570\uff0c<\/div>\n
\/**
\n* ASCII\u7f16\u7801\uff1a
\n* 48-57=0-9\u963f\u62c9\u4f2f\u6570\u5b57
\n* 64\u300165-90=@\u3001A-Z
\n* 97-122=a-z
\n*
\n*\/<\/div>\n
\u5982<\/div>\n<\/div>\n
String idVal=\"gf89f9a\";
\nAssert.assertEquals(true, 0==autoPartition.calculate(idVal));<\/p>\n
idVal=\"8df99a\";
\nAssert.assertEquals(true, 4==autoPartition.calculate(idVal));<\/p>\n
idVal=\"8dhdf99a\";
\nAssert.assertEquals(true, 3==autoPartition.calculate(idVal));<\/p>\n<\/div>\n<\/div>\n<\/div>\n
\n
\u516b\u3001\u7f16\u7a0b\u6307\u5b9a<\/strong><\/h2>\n
\n
\n
<tableRule name=\"sharding-by-substring\"><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0 <rule><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <columns>user_id<\/columns><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <algorithm>sharding-by-substring<\/algorithm><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0 <\/rule><\/div>\n
\u00a0\u00a0 <\/tableRule><\/div>\n
<function name=\"sharding-by-substring\" class=\"io.mycat.route.function.PartitionDirectBySubString\"><\/div>\n
\u00a0\u00a0\u00a0 <property name=\"startIndex\">0<\/property> <\/div>\n
\u00a0\u00a0\u00a0 <property name=\"size\">2<\/property><\/div>\n
\u00a0\u00a0\u00a0 <property name=\"partitionCount\">8<\/property><\/div>\n
\u00a0\u00a0\u00a0 <property name=\"defaultPartition\">0<\/property><\/div>\n
\u00a0 <\/function><\/div>\n
\u914d\u7f6e\u8bf4\u660e\uff1a<\/div>\n
\u4e0a\u9762columns \u6807\u8bc6\u5c06\u8981\u5206\u7247\u7684\u8868\u5b57\u6bb5\uff0calgorithm \u5206\u7247\u51fd\u6570<\/div>\n
\u6b64\u65b9\u6cd5\u4e3a\u76f4\u63a5\u6839\u636e\u5b57\u7b26\u5b50\u4e32\uff08\u5fc5\u987b\u662f\u6570\u5b57\uff09\u8ba1\u7b97\u5206\u533a\u53f7\uff08\u7531\u5e94\u7528\u4f20\u9012\u53c2\u6570\uff0c\u663e\u5f0f\u6307\u5b9a\u5206\u533a\u53f7\uff09\u3002<\/div>\n
\u4f8b\u5982id=05-100000002<\/div>\n
\u5728\u6b64\u914d\u7f6e\u4e2d\u4ee3\u8868\u6839\u636eid\u4e2d\u4ecestartIndex=0\uff0c\u5f00\u59cb\uff0c\u622a\u53d6siz=2\u4f4d\u6570\u5b57\u537305\uff0c05\u5c31\u662f\u83b7\u53d6\u7684\u5206\u533a\uff0c\u5982\u679c\u6ca1\u4f20\u9ed8\u8ba4\u5206\u914d\u5230defaultPartition<\/div>\n<\/div>\n<\/div>\n<\/div>\n
\n
\u4e5d\u3001\u5b57\u7b26\u4e32\u62c6\u5206hash\u89e3\u6790<\/strong><\/h2>\n
\n
\n
<tableRule name=\"sharding-by-stringhash\"><\/strong><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0 <rule><\/strong><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <columns>user_id<\/columns><\/strong><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <algorithm>sharding-by-stringhash<\/algorithm><\/strong><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0 <\/rule><\/strong><\/div>\n
\u00a0\u00a0 <\/tableRule><\/strong><\/div>\n
<function name=\"sharding-by-substring\" class=\"io.mycat.route.function.PartitionByString\"><\/strong><\/div>\n
\u00a0\u00a0\u00a0 <property name=length>512<\/property> <\/strong><\/div>\n
\u00a0\u00a0\u00a0 <property name=\"count\">2<\/property><\/strong><\/div>\n
\u00a0\u00a0\u00a0 <property name=\"hashSlice\">0:2<\/property><\/strong><\/div>\n
\u00a0 <\/function><\/strong><\/div>\n
\u914d\u7f6e\u8bf4\u660e\uff1a<\/div>\n
\u4e0a\u9762columns \u6807\u8bc6\u5c06\u8981\u5206\u7247\u7684\u8868\u5b57\u6bb5\uff0calgorithm \u5206\u7247\u51fd\u6570\u51fd\u6570\u4e2dlength\u4ee3\u8868\u5b57\u7b26\u4e32hash\u6c42\u6a21\u57fa\u6570\uff0ccount\u5206\u533a\u6570\uff0chashSlice hash\u9884\u7b97\u4f4d\u5373\u6839\u636e\u5b50\u5b57\u7b26\u4e32 hash\u8fd0\u7b97<\/div>\n
\u00a0hashSlice \uff1a 0 means str.length(), -1 means str.length()-1<\/div>\n<\/div>\n
\/**
\n* \"2\" -> (0,2)<br\/>
\n* \"1:2\" -> (1,2)<br\/>
\n* \"1:\" -> (1,0)<br\/>
\n* \"-1:\" -> (-1,0)<br\/>
\n* \":-1\" -> (0,-1)<br\/>
\n* \":\" -> (0,0)<br\/>
\n*\/<\/p>\n
public class PartitionByStringTest {\r\n\r\n @Test\r\n public void test() {\r\n PartitionByString rule = new PartitionByString();\r\n String idVal=null;\r\n rule.setPartitionLength(\"512\");\r\n rule.setPartitionCount(\"2\");\r\n rule.init();\r\n rule.setHashSlice(\"0:2\");\r\n\/\/ idVal = \"0\";\r\n\/\/ Assert.assertEquals(true, 0 == rule.calculate(idVal));\r\n\/\/ idVal = \"45a\";\r\n\/\/ Assert.assertEquals(true, 1 == rule.calculate(idVal));\r\n\r\n \r\n \r\n \/\/last 4\r\n rule = new PartitionByString();\r\n rule.setPartitionLength(\"512\");\r\n rule.setPartitionCount(\"2\");\r\n rule.init();\r\n \/\/last 4 characters\r\n rule.setHashSlice(\"-4:0\");\r\n idVal = \"aaaabbb0000\";\r\n Assert.assertEquals(true, 0 == rule.calculate(idVal));\r\n idVal = \"aaaabbb2359\";\r\n Assert.assertEquals(true, 0 == rule.calculate(idVal));\r\n }<\/pre>\n<\/div>\n<\/div>\n
\n
\u5341\u3001\u4e00\u81f4\u6027hash<\/strong><\/h2>\n
\n
\n
<tableRule name=\"sharding-by-murmur\"><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0 <rule><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <columns>user_id<\/columns><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <algorithm>murmur<\/algorithm><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0 <\/rule><\/div>\n
\u00a0\u00a0 <\/tableRule><\/div>\n
<function name=\"murmur\" class=\"io.mycat.route.function.PartitionByMurmurHash\"><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0 <property name=\"seed\">0<\/property><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0 <property name=\"count\">2<\/property><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0 <\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0 <\/div>\n
\u00a0 <\/function><\/div>\n<\/div>\n
\u00a0<\/strong><\/div>\n
\u4e00\u81f4\u6027hash\u9884\u7b97\u6709\u6548\u89e3\u51b3\u4e86\u5206\u5e03\u5f0f\u6570\u636e\u7684\u6269\u5bb9\u95ee\u9898\uff0c\u524d1-9\u4e2did\u89c4\u5219\u90fd\u591a\u5c11\u5b58\u5728\u6570\u636e\u6269\u5bb9\u96be\u9898\uff0c\u800c10\u89c4\u5219\u89e3\u51b3\u4e86\u6570\u636e\u6269\u5bb9\u96be\u70b9<\/strong><\/div>\n
<\/div>\n
<\/div>\n<\/div>\n<\/div>\n
\u8f6c\u8f7d\u8bf7\u6ce8\u660e\uff1a\u5de6\u624b\u4ee3\u7801\u53f3\u624b\u8bd7<\/a> » Mycat\u4e2d\u768410\u79cd\u5206\u7247\u89c4\u5219<\/a><\/p>
\r\n
\r\n
~\u8c22\u8c22\u6253\u8d4f~<\/div>\r\n
<\/div>
<\/div>
<\/div><\/div>\r\n
<\/li>
<\/li>
\u626b\u7801\u9886\u7ea2\u5305<\/p>
\uff08\u4f59\u989d\u5b9d\u652f\u4ed8\u65f6\u53ef\u62b5\u73b0\uff09<\/p>\"><\/li><\/ul>\r\n <\/div>\r\n \u8d4f<\/a>\r\n <\/div>","protected":false},"excerpt":{"rendered":"
\u5728\u6570\u636e\u5207\u5206\u5904\u7406\u4e2d\uff0c\u7279\u522b\u662f\u6c34\u5e73\u5207\u5206\u4e2d\uff0c\u4e2d\u95f4\u4ef6\u6700\u91cd\u8981\u7684\u4e24\u4e2a\u5904\u7406\u8fc7\u7a0b\u5c31\u662f\u6570\u636e\u7684\u5207\u5206\u3001\u6570\u6364\u7684\u805a\u548c\u3002\u9009\u62e9\u5408\u9002\u7684\u5207\u5206\u89c4\u5219\uff0c […]<\/p>\n","protected":false},"author":1,"featured_media":363,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[4],"tags":[46,45,47],"class_list":["post-428","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\/428","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=428"}],"version-history":[{"count":0,"href":"https:\/\/www.chenweikang.top\/index.php?rest_route=\/wp\/v2\/posts\/428\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.chenweikang.top\/index.php?rest_route=\/wp\/v2\/media\/363"}],"wp:attachment":[{"href":"https:\/\/www.chenweikang.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=428"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.chenweikang.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=428"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.chenweikang.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=428"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}