Mycat2 哈希分片 YYYYDD

YYYDD

僅用于分庫

DD是一年之中的天數(shù)

(YYYY*366+DD)%分庫數(shù)

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