Mycat2 哈希分片 RIGHT_SHIFT

RIGHT_SHIFT

RIGHT_SHIFT(字段名,位移數)

僅支持數值類型

分片值右移二進制位數,然后按分片數量取余

create table travelrecord( 
 ...
)ENGINE=InnoDB DEFAULT CHARSET=utf8 
dbpartition by RIGHT_SHIFT(id,4) dbpartitions 3
tbpartition by RIGHT_SHIFT(user_id,4) tbpartitions 3;