mycat-rule
<?xml version="1.0" encoding="UTF-8"?> <!-- - - Licensed under the Apache License, Version 2.0 (the "License"); - you may not use this file except in compliance with the License. - You may obtain a copy of the License at - - http://www.apache.org/licenses/LICENSE-2.0 - - Unless required by applicable law or agreed to in writing, software - distributed under the License is distributed on an "AS IS" BASIS, - WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. - See the License for the specific language governing permissions and - limitations under the License. --> <!DOCTYPE rule SYSTEM "rule.dtd"> -<mycat:rule xmlns:mycat="http://org.opencloudb/"> -<tableRule name="rule1"> -<rule> <columns>id</columns> <algorithm>func1</algorithm> </rule> </tableRule> -<tableRule name="rule2"> -<rule> <columns>user_id</columns> <algorithm>func1</algorithm> </rule> </tableRule> -<tableRule name="sharding-by-intfile"> -<rule> <columns>sharding_id</columns> <algorithm>hash-int</algorithm> </rule> </tableRule> -<tableRule name="auto-sharding-long"> -<rule> <columns>id</columns> <algorithm>rang-long</algorithm> </rule> </tableRule> -<tableRule name="mod-long"> -<rule> <columns>id</columns> <algorithm>mod-long</algorithm> </rule> </tableRule> -<tableRule name="sharding-by-murmur"> -<rule> <columns>id</columns> <algorithm>murmur</algorithm> </rule> </tableRule> -<tableRule name="sharding-by-month"> -<rule> <columns>create_date</columns> <algorithm>partbymonth</algorithm> </rule> </tableRule> -<tableRule name="latest-month-calldate"> -<rule> <columns>calldate</columns> <algorithm>latestMonth</algorithm> </rule> </tableRule> -<tableRule name="auto-sharding-rang-mod"> -<rule> <columns>id</columns> <algorithm>rang-mod</algorithm> </rule> </tableRule> -<tableRule name="jch"> -<rule> <columns>id</columns> <algorithm>jump-consistent-hash</algorithm> </rule> </tableRule> <!--add in 2010.10.13 by zhangkai--> -<tableRule name="dguid"> -<rule> <columns>device_guid</columns> <algorithm>murmur</algorithm> </rule> </tableRule> <!--add in 2010.10.19 by zhangkai--> -<tableRule name="userid"> -<rule> <columns>userid</columns> <algorithm>murmur</algorithm> </rule> </tableRule> <!--add in 2010.10.20 by zhangkai--> -<tableRule name="id"> -<rule> <columns>id</columns> <algorithm>murmur</algorithm> </rule> </tableRule> <!--add in 2010.10.26 by zhangkai--> -<tableRule name="keyname"> -<rule> <columns>keyname</columns> <algorithm>murmur</algorithm> </rule> </tableRule> -<function name="murmur" class="org.opencloudb.route.function.PartitionByMurmurHash"> <property name="seed">0</property> <!-- 默认是0 --> <property name="count">1</property> <!-- 要分片的数据库节点数量,必须指定,否则没法分片 --> <property name="virtualBucketTimes">160</property> <!-- 一个实际的数据库节点被映射为这么多虚拟节点,默认是160倍,也就是虚拟节点数是物理节点数的160倍 --> <!-- <property name="weightMapFile">weightMapFile</property> 节点的权重,没有指定权重的节点默认是1。以properties文件的格式填写,以从0开始到count-1的整数值也就是节点索引为key,以节点权重值为值。所有权重值必须是正整数,否则以1代替 --> <!-- <property name="bucketMapPath">/etc/mycat/bucketMapPath</property> 用于测试时观察各物理节点与虚拟节点的分布情况,如果指定了这个属性,会把虚拟节点的murmur hash值与物理节点的映射按行输出到这个文件,没有默认值,如果不指定,就不会输出任何东西 --> </function> -<function name="hash-int" class="org.opencloudb.route.function.PartitionByFileMap"> <property name="mapFile">partition-hash-int.txt</property> </function> -<function name="rang-long" class="org.opencloudb.route.function.AutoPartitionByLong"> <property name="mapFile">autopartition-long.txt</property> </function> -<function name="mod-long" class="org.opencloudb.route.function.PartitionByMod"> <!-- how many data nodes --> <property name="count">3</property> </function> -<function name="func1" class="org.opencloudb.route.function.PartitionByLong"> <property name="partitionCount">8</property> <property name="partitionLength">128</property> </function> -<function name="latestMonth" class="org.opencloudb.route.function.LatestMonthPartion"> <property name="splitOneDay">24</property> </function> -<function name="partbymonth" class="org.opencloudb.route.function.PartitionByMonth"> <property name="dateFormat">yyyy-MM-dd</property> <property name="sBeginDate">2015-01-01</property> </function> -<function name="rang-mod" class="org.opencloudb.route.function.PartitionByRangeMod"> <property name="mapFile">partition-range-mod.txt</property> </function> -<function name="jump-consistent-hash" class="org.opencloudb.route.function.PartitionByJumpConsistentHash"> <property name="totalBuckets">3</property> </function> </mycat:rule>
只要还没死,就不要把自己当废物