1.rule.xml
-
<tableRule name="sharding-by-date-test">
-
<rule>
-
<columns>createtime</columns>
-
<algorithm>sharding-by-date</algorithm>
-
</rule>
-
</tableRule>
-
<function name="sharding-by-date" class="io.mycat.route.function.PartitionByDate">
-
<property name="dateFormat">yyyy-MM-dd</property>
-
<property name="sBeginDate">2016-01-01</property>
-
<property name="sPartionDay">10</property>
-
</function>
分片日期从2016-01-01开始,每10天一个分片。
2.schema.xml
-
<!DOCTYPE mycat:schema SYSTEM "schema.dtd">
-
<mycat:schema xmlns:mycat="">
-
-
<schema name="logdb" checkSQLschema="false" sqlMaxLimit="100">
-
<table name="tb_log_t" primaryKey="ID" autoIncrement="true" dataNode="dn1,dn2,dn3,dn4,dn5,dn6" rule="mod-long" />
-
<table name="tb_user_t" dataNode="dn1,dn2,dn3,dn4,dn5,dn6" rule="sharding-by-intfile-provcode" />
-
<table name="tb_user_detail_t" dataNode="dn1,dn2,dn3,dn4,dn5,dn6" rule="auto-sharding-long-userid" />
-
<table name="tb_user_murmur_t" dataNode="dn1,dn2,dn3,dn4,dn5,dn6" rule="sharding-by-murmur" />
-
<table name="tb_user_murmur_string_t" dataNode="dn1,dn2,dn3,dn4,dn5,dn6" rule="sharding-by-murmur-userid" />
-
<table name="tb_user_crc32slot_t" dataNode="dn1,dn2,dn3,dn4,dn5,dn6" rule="crc32slot" />
-
<table name="tb_user_partbymonth_t" dataNode="dn$1-13" rule="sharding-by-month" />
-
<table name="tb_user_latestmonth_t" dataNode="dn1,dn2,dn3,dn4,dn5,dn6" rule="latest-month-calldate" />
-
<!-- <table name="t_subtable" primaryKey="id" autoIncrement="true" subTables="t_subtable_$(20170730,20170806)" dataNode="d
-
n1"/> -->
-
<table name="tb_user_shardingbydate_t" dataNode="dn1,dn2,dn3,dn4,dn5,dn6" rule="sharding-by-date-test" />
-
</schema>
-
<schema name="coss03" checkSQLschema="false" sqlMaxLimit="100" dataNode="dnoss03"/>
-
<dataNode name="dn1" dataHost="localhost1" database="log01" />
-
<dataNode name="dn2" dataHost="localhost1" database="log02" />
-
<dataNode name="dn3" dataHost="localhost1" database="log03" />
-
<dataNode name="dn4" dataHost="localhost1" database="log04" />
-
<dataNode name="dn5" dataHost="localhost1" database="log05" />
-
<dataNode name="dn6" dataHost="localhost1" database="log06" />
-
<dataNode name="dn7" dataHost="localhost1" database="log01" />
-
<dataNode name="dn8" dataHost="localhost1" database="log02" />
-
<dataNode name="dn9" dataHost="localhost1" database="log03" />
-
<dataNode name="dn10" dataHost="localhost1" database="log04" />
-
<dataNode name="dn11" dataHost="localhost1" database="log05" />
-
<dataNode name="dn12" dataHost="localhost1" database="log06" />
-
<dataNode name="dn13" dataHost="localhost1" database="log01" />
-
<dataNode name="dnoss03" dataHost="localhost1" database="oss03" />
-
<dataHost name="localhost1" maxCon="1000" minCon="10" balance="0"
-
writeType="0" dbType="mysql" dbDriver="native" switchType="1" slaveThreshold="100">
-
<heartbeat>select user()</heartbeat>
-
<!-- can have multi write hosts -->
-
<writeHost host="hostM1" url="192.168.56.141:3306" user="root"
-
password="mysql">
-
<!-- can have multi read hosts -->
-
<readHost host="hostS2" url="192.168.56.142:3306" user="root" password="mysql" />
-
</writeHost>
-
</dataHost>
-
</mycat:schema>
3.创建表
CREATE TABLE `tb_user_shardingbydate_t` (
`id` varchar(32) NOT NULL,
`name` varchar(64) DEFAULT NULL,
`createtime` varchar(10)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
写入数据:
insert into tb_user_shardingbydate_t(id,name,createtime) values('a0001','name1','2016-01-01');
insert into tb_user_shardingbydate_t(id,name,createtime) values('a0002','name1','2016-01-02');
insert into tb_user_shardingbydate_t(id,name,createtime) values('a0003','name1','2016-01-03');
insert into tb_user_shardingbydate_t(id,name,createtime) values('a0004','name1','2016-01-04');
insert into tb_user_shardingbydate_t(id,name,createtime) values('a0005','name1','2016-01-05');
insert into tb_user_shardingbydate_t(id,name,createtime) values('a0006','name1','2016-01-06');
insert into tb_user_shardingbydate_t(id,name,createtime) values('a0007','name1','2016-01-07');
insert into tb_user_shardingbydate_t(id,name,createtime) values('a0005','name1','2016-01-08');
insert into tb_user_shardingbydate_t(id,name,createtime) values('a0006','name1','2016-01-09');
insert into tb_user_shardingbydate_t(id,name,createtime) values('a0007','name1','2016-01-10');
insert into tb_user_shardingbydate_t(id,name,createtime) values('a0001','name1','2016-01-11');
insert into tb_user_shardingbydate_t(id,name,createtime) values('a0002','name1','2016-01-12');
insert into tb_user_shardingbydate_t(id,name,createtime) values('a0003','name1','2016-01-13');
insert into tb_user_shardingbydate_t(id,name,createtime) values('a0004','name1','2016-01-14');
insert into tb_user_shardingbydate_t(id,name,createtime) values('a0005','name1','2016-01-15');
insert into tb_user_shardingbydate_t(id,name,createtime) values('a0006','name1','2016-01-16');
insert into tb_user_shardingbydate_t(id,name,createtime) values('a0007','name1','2016-01-17');
insert into tb_user_shardingbydate_t(id,name,createtime) values('a0005','name1','2016-01-18');
insert into tb_user_shardingbydate_t(id,name,createtime) values('a0006','name1','2016-01-19');
insert into tb_user_shardingbydate_t(id,name,createtime) values('a0007','name1','2016-01-20');
-- The End --
