Mycat2 哈希分片 MMDD

MMDD

僅用于分表

僅DATE/DATETIME

一年之中第幾天%分表數(shù)

tbpartitions不超過366

create table travelrecord (
 ....
) ENGINE=InnoDB DEFAULT CHARSET=utf8 
dbpartition by xxx(xx) dbpartitions 8
tbpartition by MMDD(xx) tbpartitions 366;