drds分库分表

DRDS是一款基于MySQL存储、采用分库分表技术进行水平扩展的分布式OLTP数据库服务产品,支持 RDS for MySQL以及POLARDB for MySQL,
产品目标旨在提升数据存储容量、并发吞吐、复杂计算效率三个方面的扩展性需求.

分库：

CREATE TABLE `Untitled`  (
  `ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `REQUEST` varchar(6000) NULL COMMENT '请求内容',
  `RESPONSE` varchar(3000) NULL COMMENT '返回结果',
  `REQUEST_TIME` datetime(0) NULL COMMENT '调用时间',
  `RESPONSE_TIME` varchar(255) NULL COMMENT '响应时长',
  `KEY_ID` int(10) NULL COMMENT '分库键',
  PRIMARY KEY (`ID`)
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci dbpartition BY HASH (`KEY_ID`);

dbpartition BY HASH (字段名);

分库分表：

CREATE TABLE `Untitled`  (
  `ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `DATE_ID` DATE NOT NULL COMMENT COMMENT '数据日期',
  `REQUEST` varchar(6000) NULL COMMENT '请求内容',
  `RESPONSE` varchar(3000) NULL COMMENT '返回结果',
  `REQUEST_TIME` datetime(0) NULL COMMENT '调用时间',
  `RESPONSE_TIME` varchar(255) NULL COMMENT '响应时长',
  `KEY_ID` int(10) NULL COMMENT '分库键',
  PRIMARY KEY (`ID`,`DATE_ID`)
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci dbpartition BY HASH (`KEY_ID`) tbpartition BY MMDD(`DATE_ID`) tbpartitions 365;

dbpartition BY HASH (字段名) tbpartition BY MMDD(字段名) tbpartitions 365