阅读(84)
赞(14)
Mycat2 哈希分片 YYYYMM
2021-09-08 14:01:51 更新
YYYYMM
仅用于分库
(YYYY*12+MM)%分库数
create table travelrecord (
....
) ENGINE=InnoDB DEFAULT CHARSET=utf8
dbpartition by YYYYMM(xxx) dbpartitions 8
tbpartition by xxx(xx) tbpartitions 12;