说明:根据字段按照范围分片。
注释:字段为数字类型。
一、conf/schema.xml文件
<!DOCTYPE mycat:schema SYSTEM "schema.dtd">
<mycat:schema xmlns:mycat="http://io.mycat/">
<schema name="TESTDB" checkSQLschema="false" sqlMaxLimit="100">
<table name="auto_sharding_long" primaryKey="id" dataNode="dn0,dn1,dn2"
rule="auto-sharding-long" />
</schema>
<dataNode name="dn0" dataHost="dh-1" database="db0"/>
<dataNode name="dn1" dataHost="dh-1" database="db1"/>
<dataNode name="dn2" dataHost="dh-1" database="db2"/>
<dataHost name="dh-1" maxCon="1000" minCon="10" balance="0"
writeType="0" dbType="mysql" dbDriver="native" switchType="1" slaveThreshold="100">
<heartbeat>select user()</heartbeat>
<writeHost host="hostM1" url="localhost:3306" user="root"
password="123456">
</writeHost>
</dataHost>
</mycat:schema>
二、conf/rule.xml文件
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mycat:rule SYSTEM "rule.dtd">
<mycat:rule xmlns:mycat="http://io.mycat/">
<tableRule name="auto-sharding-long">
<rule>
<columns>age</columns>
<algorithm>rang-long</algorithm>
</rule>
</tableRule>
<function name="rang-long"
class="io.mycat.route.function.AutoPartitionByLong">
<property name="mapFile">fun/autopartition-long.txt</property>
<property name="defaultNode">0</property>
</function>
</mycat:rule>
三、规则文件信息autopartition-long.txt
# range start-end ,data node index
# K=1000,M=10000.
0-20=0
20-30=1
31-60=2
四、测试用到的sql
=============按照age字段范围================
CREATE TABLE auto_sharding_long (`age` int NOT NULL ,`db_nm` varchar(20) NULL);
INSERT INTO auto_sharding_long (age,db_nm) VALUES (10, database());
INSERT INTO auto_sharding_long (age,db_nm) VALUES (20, database());
INSERT INTO auto_sharding_long (age,db_nm) VALUES (40, database());
select * from auto_sharding_long;
五、注意事项:
1、schema里的table的dataNode节点个数必须:大于等于 partition-hash-int.txt里的配置个数
2、序号节点从0开始