1.安装好mycat2.0之后,执行sql进行分库分表
DROP TABLE `sys_user`;
CREATE TABLE `sys_user` (
`id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT 'id',
`username` varchar(32) NULL COMMENT '用户名',
`password` varchar(32) NULL COMMENT '密码',
PRIMARY KEY (`id`),
KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 dbpartition by mod_hash(id) tbpartition by mod_hash(id) tbpartitions 2 dbpartitions 2;
报错 3002 - ERROR-CODE: [MYCAT-3002][ERR_FETCH_METADATA] MetadataManager init fail
2.经过一天的消磨,百度,gpt,csdn之后,终于找到原因,没有数据源
-- 创建数据源
/*+ mycat:createDataSource{
"name":"dr",
"url":"jdbc:mysql://xxxxx:3308/mysql",
"user":"root",
"password":"111111"
} */;