一、准备工作：
下载地址：
http://dl.mycat.org.cn/2.0/install-template/mycat2-install-template-1.21.zip
http://dl.mycat.org.cn/2.0/1.21-release/
下载后文件：

将文件mycat2-install-template-1.21解压，将mycat2-1.21-release-jar-with-dependencies2022-5-5.jar复制放到mycat\lib一份：
二、mycat配置修改

1、mycat配置文件位置：

打开配置prototypeDs.datasource.json文件：

{"dbType":"mysql","idleTimeout":60000,"initSqls":[],"initSqlsGetConnection":true,"instanceType":"READ_WRITE","maxCon":1000,"maxConnectTimeout":3000,"maxRetryCount":5,"minCon":1,// 数据源名称，不用修改"name":"prototypeDs",//数据库密码"password":"lll123","type":"JDBC",//连接master数据库"url":"jdbc:mysql://localhost:3306/mysql?useUnicode=true&serverTimezone=Asia/Shanghai&characterEncoding=UTF-8",//数据库用户名"user":"root","weight":0
}

mycat启动后，会自行建立mycat库，用来预存mycat需要用到的一些信息。mycat会自行建立，如果建立失败，可以手动先在数据库建立后再启动。

1、启动mycat：

mycat install
mycat start
mycat status

2、登录：登录mycat,默认用户名:root 密码:123456

3、创建逻辑库

在Mycat里创建数据库test_mycat

create database test_mycat;

逻辑库创建成功后，自动生成配置文件。

主库创建了相应的数据库。

打开test_mycat.schema.json文件

{"customTables":{},"globalTables":{},"normalProcedures":{},"normalTables":{},//逻辑库名，也是mysql中对应的物理数据库名"schemaName":"test_mycat",//集群"targetName":"mycatCluster","shardingTables":{},"views":{}
}

解释：
customTables 放置的是mycat默认的表的配置
globalTables 放置的是全局表的配置
shardingTables 放置分片表的配置
normalTables 放置普通表的配置

4、配置数据源

在cmd登录mycat或在navicate连接mycat后使用命令行界面输入：
注释命令添加主数据源：

/*+ mycat:createDataSource{ "name" :"mycatWrite" , "url":"jdbc:mysql://localhost:3306/test_mycat?useSSL=false&characterEncoding=UTF-8&useJDBCCompliantTimezoneShift=true","user":"root","password" :"ldst123"} */;

添加从数据源：

/*+ mycat:createDataSource{ "name" :"mycatRead" , "url":"jdbc:mysql://localhost:3307/test_mycat?useSSL=false&characterEncoding=UTF-8&useJDBCCompliantTimezoneShift=true","user":"root","password" :"ldst123"} */;

查看主从数据源创建是否成功！

/*+ mycat:showDataSources{} */

成功后生成的主从数据源文件：

mycatWrite:

{"dbType":"mysql","idleTimeout":60000,"initSqls":[],"initSqlsGetConnection":true,"instanceType":"READ_WRITE","maxCon":1000,"maxConnectTimeout":30000,"maxRetryCount":5,"minCon":1,"name":"mycatWrite","password":"xxx123","queryTimeout":0,"type":"JDBC","url":"jdbc:mysql://localhost:3306/test_mycat?useJDBCCompliantTimezoneShift=true&useUnicode=true&serverTimezone=Asia/Shanghai&characterEncoding=UTF-8&autoReconnect=true&useSSL=false","user":"root","weight":0
}

mycatRead:

{"dbType":"mysql","idleTimeout":60000,"initSqls":[],"initSqlsGetConnection":true,//跟/*+ mycat:showDataSources{} */命令查到的库中属性值不一致？"instanceType":"READ_WRITE","maxCon":1000,"maxConnectTimeout":30000,"maxRetryCount":5,"minCon":1,"name":"mycatRead","password":"xxx123","queryTimeout":0,"type":"JDBC","url":"jdbc:mysql://localhost:3307/test_mycat?serverTimezone=Asia/Shanghai&useJDBCCompliantTimezoneShift=true&characterEncoding=UTF-8&useUnicode=true&autoReconnect=true&useSSL=false","user":"root","weight":0
}

5、创建集群配置信息

/*! mycat:createCluster{"name":"mycatCluster","masters":["mycatWrite"],"replicas":["mycatRead"]} */

查询集群信息：

/*+ mycat:showClusters{} */;

集群创建成功后生成文件：

查看mycatCluster.cluster文件

{"clusterType":"MASTER_SLAVE","heartbeat":{"heartbeatTimeout":1000,"maxRetryCount":3,"minSwitchTimeInterval":300,"showLog":false,"slaveThreshold":0.0},"masters":["mycatWrite"],"maxCon":2000,"name":"mycatCluster","readBalanceType":"BALANCE_ALL","replicas":["mycatRead"],"switchType":"SWITCH"
}

6、完成后在mycat中进行操作测试即可。

注意事项：

在cmd登录mycat2在表中插入数据有乱码，登录时可以指明字符集：

在cmd中登录mycat时由使用 mysql -uroot -p这种方式了
改为mysql --default-character-set=utf8 -uroot -p123456 -P8066进行登录***