{"id":3623,"date":"2014-06-04T14:14:18","date_gmt":"2014-06-04T06:14:18","guid":{"rendered":"http:\/\/blog.hmouse.tk\/?p=3623"},"modified":"2015-06-07T11:06:42","modified_gmt":"2015-06-07T03:06:42","slug":"cobar%e7%9b%b8%e5%85%b3%e6%b1%87%e6%80%bb","status":"publish","type":"post","link":"https:\/\/www.hmouse.cn\/?p=3623","title":{"rendered":"cobar\u76f8\u5173\u6c47\u603b"},"content":{"rendered":"

\u76f8\u5173url\uff1ahttps:\/\/github.com\/alibaba\/cobar<\/a><\/p>\n

\u7ba1\u7406\u754c\u9762<\/p>\n

mysql -h 192.168.1.80 -utest -ptest -P9066<\/p>\n

\u91cd\u65b0\u8f7d\u5165<\/p>\n

reload @@config;<\/p>\n

 <\/p>\n

cobar rule<\/p>\n

<!– \u8def\u7531\u51fd\u6570\u5b9a\u4e49 –>
\n<function name=”func1″ class=”com.alibaba.cobar.route.function.PartitionByLong”>
\n<property name=”partitionCount”>4<\/property>
\n<property name=”partitionLength”>256<\/property>
\n<\/function><\/p>\n

int\u89c4\u5219\uff0c\u52064\u4e2a\u5e93\uff0c256\u4e2a\u4e00\u5207\u5272<\/p>\n

<function name=”func2″ class=”com.alibaba.cobar.route.function.PartitionByString”>
\n<property name=”partitionCount”>4<\/property>
\n<property name=”partitionLength”>256<\/property>
\n<\/function><\/p>\n

\u5b57\u7b26\u89c4\u5219\uff0chash\u503c\uff0c\u52064\u4e2a\u5e93\uff0c256\u4e00\u5207\u5272\uff0c\u53ef\u80fd\u4e0d\u662f\u5f88\u5747\u8861\u3002<\/p>\n

<tableRule name=”ruleByRoomActivityId”>
\n<rule>
\n<columns>room_activity_id<\/columns>
\n<algorithm><![CDATA[ func1(${room_activity_id}) ]]><\/algorithm>
\n<\/rule>
\n<\/tableRule><\/p>\n

 <\/p>\n

ruleByRoomActivityId \u89c4\u5219\u4ee5room_activity_id \u5207\u5206\u3002\u6309\u7167func1 \u7684\u89c4\u5219\u3002<\/p>\n

 <\/p>\n

<table name=”private_message_status” dataNode=”dn_shanliao$0-3″ rule=”ruleByUserId”\/><\/p>\n

private_message_status \u5207\u5206\u7684\u89c4\u5219\u662f\u6309 ruleByUserId\u3002<\/p>\n

 <\/p>\n

\u5176\u4ed6\u7684\u53ef\u4ee5\u53c2\u7167\u5b98\u65b9\u6587\u6863\u3002\uff08\u6216\u8005\u770b\u9875\u9996\u7684\u76f8\u5173url\uff09<\/p>\n

[gview file=”https:\/\/www.hmouse.cn\/wp-content\/uploads\/2014\/06\/Cobar-Alibaba-Open-Sesame1.pdf”]<\/p>\n","protected":false},"excerpt":{"rendered":"

\u76f8\u5173url\uff1ahttps:\/\/github.com\/alibaba\/cobar<\/a><\/p>\n

\u7ba1\u7406\u754c\u9762<\/p>\n

mysql -h 192.168.1.80 -utest -ptest -P9066<\/p>\n

\u91cd\u65b0\u8f7d\u5165<\/p>\n

reload @@config;<\/p>\n

 <\/p>\n

cobar rule<\/p>\n

<!– \u8def\u7531\u51fd\u6570\u5b9a\u4e49 –>
\n<function name=”func1″ class=”com.alibaba.cobar.route.function.PartitionByLong”>
\n<property name=”partitionCount”>4<\/property>
\n<property name=”partitionLength”>256<\/property>
\n<\/function><\/p>\n

int\u89c4\u5219\uff0c\u52064\u4e2a\u5e93\uff0c256\u4e2a\u4e00\u5207\u5272<\/p>\n

<function name=”func2″ class=”com.alibaba.cobar.route.function.PartitionByString”>
\n<property name=”partitionCount”>4<\/property>
\n<property name=”partitionLength”>256<\/property>
\n<\/function><\/p>\n

\u5b57\u7b26\u89c4\u5219\uff0chash\u503c\uff0c\u52064\u4e2a\u5e93\uff0c256\u4e00\u5207\u5272\uff0c\u53ef\u80fd\u4e0d\u662f\u5f88\u5747\u8861\u3002<\/p>\n

<tableRule name=”ruleByRoomActivityId”>
\n<rule>
\n<columns>room_activity_id<\/columns>
\n<algorithm><![CDATA[ func1(${room_activity_id}) ]]><\/algorithm>
\n<\/rule>
\n<\/tableRule><\/p>\n

 <\/p>\n

ruleByRoomActivityId \u89c4\u5219\u4ee5room_activity_id \u5207\u5206\u3002\u6309\u7167func1 \u7684\u89c4\u5219\u3002<\/p>\n

 <\/p>\n

<table name=”private_message_status” dataNode=”dn_shanliao$0-3″ rule=”ruleByUserId”\/><\/p>\n

private_message_status \u5207\u5206\u7684\u89c4\u5219\u662f\u6309 ruleByUserId\u3002<\/p>\n

 <\/p>\n

\u5176\u4ed6\u7684\u53ef\u4ee5\u53c2\u7167\u5b98\u65b9\u6587\u6863\u3002\uff08\u6216\u8005\u770b\u9875\u9996\u7684\u76f8\u5173url\uff09<\/p>\n

[gview file=”https:\/\/www.hmouse.cn\/wp-content\/uploads\/2014\/06\/Cobar-Alibaba-Open-Sesame1.pdf”]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[111,112],"class_list":["post-3623","post","type-post","status-publish","format-standard","hentry","category-5","tag-cobar","tag-mysql","category-5-id","post-seq-1","post-parity-odd","meta-position-corners","fix"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.hmouse.cn\/index.php?rest_route=\/wp\/v2\/posts\/3623","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hmouse.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hmouse.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hmouse.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hmouse.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3623"}],"version-history":[{"count":5,"href":"https:\/\/www.hmouse.cn\/index.php?rest_route=\/wp\/v2\/posts\/3623\/revisions"}],"predecessor-version":[{"id":3631,"href":"https:\/\/www.hmouse.cn\/index.php?rest_route=\/wp\/v2\/posts\/3623\/revisions\/3631"}],"wp:attachment":[{"href":"https:\/\/www.hmouse.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3623"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hmouse.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3623"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hmouse.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3623"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}