Mycat2 哈希分片 RIGHT_SHIFT

RIGHT_SHIFT

RIGHT_SHIFT(字段名,位移數(shù))

僅支持數(shù)值類型

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

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;