HASH型分片算法-YYYYDD

YYYYDD

仅用于分库

DD是一年之中的天数
(YYYY*366+DD)%分库数

  1. create table travelrecord (
  2.  ....
  3. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 
  4. dbpartition by YYYYDD(xxx) dbpartitions 8
  5. tbpartition by xxx(xxx) tbpartitions 12;