Mycat2 哈希分片 YYYYWEEK

YYYYWEEK

支持分庫分表

(YYYY*54+WEEK)%分片數

WEEK的范圍是1-53

java.time.temporal.WeekFields#weekOfWeekBasedYear

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