Windows下安装Mycat

https://www.oracle.com/java/technologies/downloads/#java8

http://dl.mycat.org.cn/1.6.7.4/Mycat-server-1.6.7.4-release/Mycat-server-1.6.7.4-release-20200105164103-win.tar.gz

bin -- 启动文件
conf -- 配置文件
logs -- 日志文件

D:\mycat\bin>mycat install

wrapper  | CreateService failed - 指定的服务已存在。 (0x431)

D:\mycat\bin>mycat start
wrapper  | Starting the Mycat-server service...
wrapper  | Mycat-server started.

CREATE TABLE `travelrecord` (
`id`  int(11) NOT NULL AUTO_INCREMENT ,
`uid`  int(11) NULL ,
PRIMARY KEY (`id`)
);

INSERT INTO `travelrecord` (`id`, `uid`) VALUES(1, 1);
INSERT INTO `travelrecord` (`id`, `uid`) VALUES(5000001, 5000001);
INSERT INTO `travelrecord` (`id`, `uid`) VALUES(10000001, 10000001);

EXPLAIN SELECT * FROM travelrecord