Windows下简单安装Mycat

系统管理员 2021-11-10 08:52 458阅读 0赞

Mycat

首先在安装Mycat之前，需要安装JDK1.7以上，可以在cmd环境下输入 java -version 查看本地安装的java版本

![aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvODE4OTczLzIwMTcxMS84MTg5NzMtMjAxNzExMDYxMzQxMDc4NzItMTA5MzIzNTUyNS5wbmc][]

如果未安装或者版本在1.7以下，请重新安装。

安装JDK后，还需要安装Mysql(因为我本地环境安装的是Mysql，所以用Mysql做测试)

## 第一步：下载Mycat ##

首先下载Mycat,目前最新版本是1.6

下载地址：https://github.com/MyCATApache/Mycat-download/tree/master/1.6-RELEASE

选择如下版本:

![aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvODE4OTczLzIwMTcxMS84MTg5NzMtMjAxNzExMDYxMzM5Mzg4MjUtOTM2MjkwNTcwLnBuZw][]

## 第二步：解压 ##

下载成功后，解压到本地，目录结构如下：

![aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvODE4OTczLzIwMTcxMS84MTg5NzMtMjAxNzExMDYxMzQ1MDkwOTEtMTEzODQ1NzY4OS5wbmc][]

## 第三步：配置 ##

![20190208115307684.png][]

1、server.xml

<?xml version="1.0" encoding="UTF-8"?>
    
    <!DOCTYPE mycat:server SYSTEM "server.dtd">
    <mycat:server xmlns:mycat="http://io.mycat/">
    	<system>
    	<property name="useSqlStat">0</property>  
    	<property name="useGlobleTableCheck">0</property>  
    
    		<property name="sequnceHandlerType">2</property>
           
             
    	
    	
    		
    		<property name="processorBufferPoolType">0</property>
    		
    		
    		
    		
    		
    		
    		
    		
    		<property name="handleDistributedTransactions">0</property>
    		
    			
    		<property name="useOffHeapForMerge">1</property>
    
    		
    		<property name="memoryPageSize">1m</property>
    
    		
    		<property name="spillsFileBufferSize">1k</property>
    
    		<property name="useStreamOutput">0</property>
    
    		
    		<property name="systemReserveMemorySize">384m</property>
    
    
    		
    		<property name="useZKSwitch">true</property>
    
    
    	</system>
    	
    	
    	
    	
    	<user name="root">
    		<property name="password">123456</property>
    		<property name="schemas">TESTDB</property>
    		
    		
    		
    	</user>
    	<user name="user">
    		<property name="password">user</property>
    		<property name="schemas">TESTDB</property>
    		<property name="readOnly">true</property>
    	</user>
    
    </mycat:server>

下载下来后，应该默认如上图，有一个逻辑库，名字为TESTDB,有两个用户，root和user,默认即可

2、schemal.xml

<?xml version="1.0"?>
    <!DOCTYPE mycat:schema SYSTEM "schema.dtd">
    <mycat:schema xmlns:mycat="http://io.mycat/">
    
    	<schema name="TESTDB" checkSQLschema="false" sqlMaxLimit="100">
    		
    		<table name="travelrecord" dataNode="dn1,dn2,dn3" rule="auto-sharding-long" />
    
    		
    		<table name="company" primaryKey="ID" type="global" dataNode="dn1,dn2,dn3" />
    		<table name="goods" primaryKey="ID" type="global" dataNode="dn1,dn2" />
    		
    		<table name="hotnews" primaryKey="ID" autoIncrement="true" dataNode="dn1,dn2,dn3"
    			   rule="mod-long" />
    		
    		<table name="employee" primaryKey="ID" dataNode="dn1,dn2"
    			   rule="sharding-by-intfile" />
    		<table name="customer" primaryKey="ID" dataNode="dn1,dn2"
    			   rule="sharding-by-intfile">
    			<childTable name="orders" primaryKey="ID" joinKey="customer_id"
    						parentKey="id">
    				<childTable name="order_items" joinKey="order_id"
    							parentKey="id" />
    			</childTable>
    			<childTable name="customer_addr" primaryKey="ID" joinKey="customer_id"
    						parentKey="id" />
    		</table>
    		
    	</schema>
    	
    	<dataNode name="dn1" dataHost="localhost1" database="db1" />
    	<dataNode name="dn2" dataHost="localhost1" database="db2" />
    	<dataNode name="dn3" dataHost="localhost1" database="db3" />
    	
    	<dataHost name="localhost1" maxCon="1000" minCon="10" balance="0"
    			  writeType="0" dbType="mysql" dbDriver="native" switchType="1"  slaveThreshold="100">
    		<heartbeat>select user()</heartbeat>
    		
    		<writeHost host="hostM1" url="localhost:3306" user="root"
    				   password="123456">
    			
    		
    		</writeHost>
    		
    		
    	</dataHost>
    	
    
    	
    </mycat:schema>

如上图中，将writeHost标签中信息中修改为本地Mysql数据库信息，包括url、用户名、密码，因为只是在本地服务器上进行测试，所以将下面的<readHost>和<writeHost>进行了注释。

## 第四步：启动 ##

![aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvODE4OTczLzIwMTcxMS84MTg5NzMtMjAxNzExMDYxMzU4NDY3MzEtODQwMjQ3MzE1LnBuZw][]

找到mycat解压目录下的bin目录，bin目录下有一个叫startup\_nowrap.bat的文件，这就是mycat的启动文件。

按住shift键，点击鼠标右键，可以点击此处打开命令窗口，可快速打开cmd窗口

![aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvODE4OTczLzIwMTcxMS84MTg5NzMtMjAxNzExMDYxNDAzMTQ3MTYtNjA4NDE0MTgzLnBuZw][]

在打开的cmd窗口中输入：startup\_nowrap.bat 按回车键

![aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvODE4OTczLzIwMTcxMS84MTg5NzMtMjAxNzExMDYxNDA1MzExMzgtMTIyNzk1NjU0MC5wbmc][]

如果可以看到如下信息，说明启动成功。

![aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvODE4OTczLzIwMTcxMS84MTg5NzMtMjAxNzExMDYxNDA2MzA1NzUtNjgzNzU3MTYwLnBuZw][]

如果报错的话，可以在如下目录查看日志信息。

![aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvODE4OTczLzIwMTcxMS84MTg5NzMtMjAxNzExMDYxNDA3MTA3MTYtOTI5MjUzMzcwLnBuZw][]

##  第五步：测试 ##

启动好了后，接下来使用navicat连接mycat,新建一个mysql连接，如下图：连接成功，其中 8066端口是mycat的默认端口

![aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvODE4OTczLzIwMTcxMS84MTg5NzMtMjAxNzExMDYxNDA5NDU5MzQtMTY5ODE2MDI3OC5wbmc][]

打开刚刚新建的mysql连接，可以看到有一个TESTDB数据库：

![aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvODE4OTczLzIwMTcxMS84MTg5NzMtMjAxNzExMDYxNDE1MDg4NTYtMTU1NzQwNDI5NS5wbmc][]

这些表信息，其实都是在schema.xml文件中配置的。

schema.xml文件中具体配置的意义请参考Mycat权威指南一书。

到现在，mycat的安装基本完成了，但是现在点击其中的表是会报错的，比如我点击了customer表，报如下错误：

![aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvODE4OTczLzIwMTcxMS84MTg5NzMtMjAxNzExMDYxNDMyNTQ3NzgtNTE2MjU1OTgucG5n][]

可以看出是说在数据库db1中不存在customer表。

所以我们要在mysql数据库新建db1、db2、db3三个数据库

![aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvODE4OTczLzIwMTcxMS84MTg5NzMtMjAxNzExMDYxNDMxNTI5OTctMTM1OTA4MTg0Mi5wbmc][]

然后在db1、db2中新建customer表，并且 分别存入如下数据：

建表SQL：

CREATE TABLE `customer` (
      `id` int(11) NOT NULL,
      `name` varchar(255) DEFAULT NULL,
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

数据：

![aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvODE4OTczLzIwMTcxMS84MTg5NzMtMjAxNzExMDYxNDM3MTY4MDktNDM1NTcwMjAucG5n][]![aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvODE4OTczLzIwMTcxMS84MTg5NzMtMjAxNzExMDYxNDM4NTA0NjYtMTE5NTI5NzQucG5n][]

最后再在TESTDB中点开customer,可以看到如下信息：

![aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvODE4OTczLzIwMTcxMS84MTg5NzMtMjAxNzExMDYxNDQxMTYyNzgtMTAwNTk0MTk0Mi5wbmc][]

到现在就mycat就安装好了。

[aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvODE4OTczLzIwMTcxMS84MTg5NzMtMjAxNzExMDYxMzQxMDc4NzItMTA5MzIzNTUyNS5wbmc]: /images/20211109/5541b2f6b754445abb9c1d6dcc51c607.png
[aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvODE4OTczLzIwMTcxMS84MTg5NzMtMjAxNzExMDYxMzM5Mzg4MjUtOTM2MjkwNTcwLnBuZw]: /images/20211109/d44a1d28c64d4e55bc725e802ef33ec8.png
[aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvODE4OTczLzIwMTcxMS84MTg5NzMtMjAxNzExMDYxMzQ1MDkwOTEtMTEzODQ1NzY4OS5wbmc]: /images/20211109/79679630075e4bcf9b45052361fb4cd3.png
[20190208115307684.png]: /images/20211109/b55fda3c3d6244d393c3069a3c94667f.png
[aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvODE4OTczLzIwMTcxMS84MTg5NzMtMjAxNzExMDYxMzU4NDY3MzEtODQwMjQ3MzE1LnBuZw]: /images/20211109/d469c05d5e7548a88c50d123f148ac4a.png
[aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvODE4OTczLzIwMTcxMS84MTg5NzMtMjAxNzExMDYxNDAzMTQ3MTYtNjA4NDE0MTgzLnBuZw]: /images/20211109/4be1e6df80ab4bff88445871bebcb648.png
[aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvODE4OTczLzIwMTcxMS84MTg5NzMtMjAxNzExMDYxNDA1MzExMzgtMTIyNzk1NjU0MC5wbmc]: /images/20211109/b67a95a10dfd46a89e57a93c1193461f.png
[aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvODE4OTczLzIwMTcxMS84MTg5NzMtMjAxNzExMDYxNDA2MzA1NzUtNjgzNzU3MTYwLnBuZw]: /images/20211109/4c2015962f614a40a2a7fc802c322dcb.png
[aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvODE4OTczLzIwMTcxMS84MTg5NzMtMjAxNzExMDYxNDA3MTA3MTYtOTI5MjUzMzcwLnBuZw]: /images/20211109/e2f0c1770c5a43f983a494bf6aa6bf2c.png
[aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvODE4OTczLzIwMTcxMS84MTg5NzMtMjAxNzExMDYxNDA5NDU5MzQtMTY5ODE2MDI3OC5wbmc]: /images/20211109/d9dfea1fb7d248308b703370d5481836.png
[aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvODE4OTczLzIwMTcxMS84MTg5NzMtMjAxNzExMDYxNDE1MDg4NTYtMTU1NzQwNDI5NS5wbmc]: /images/20211109/8de3c042d9d84f76a10ef7412e7ad5da.png
[aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvODE4OTczLzIwMTcxMS84MTg5NzMtMjAxNzExMDYxNDMyNTQ3NzgtNTE2MjU1OTgucG5n]: /images/20211109/84ad3b04ca5f4d04acd5a6d1f14d3630.png
[aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvODE4OTczLzIwMTcxMS84MTg5NzMtMjAxNzExMDYxNDMxNTI5OTctMTM1OTA4MTg0Mi5wbmc]: /images/20211109/d6fd183a48004d208c3dc2df96aa693c.png
[aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvODE4OTczLzIwMTcxMS84MTg5NzMtMjAxNzExMDYxNDM3MTY4MDktNDM1NTcwMjAucG5n]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvODE4OTczLzIwMTcxMS84MTg5NzMtMjAxNzExMDYxNDM3MTY4MDktNDM1NTcwMjAucG5n
[aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvODE4OTczLzIwMTcxMS84MTg5NzMtMjAxNzExMDYxNDM4NTA0NjYtMTE5NTI5NzQucG5n]: /images/20211109/e1e336a435124d638139662551e250c1.png
[aHR0cHM6Ly9pbWFnZXMyMDE3LmNuYmxvZ3MuY29tL2Jsb2cvODE4OTczLzIwMTcxMS84MTg5NzMtMjAxNzExMDYxNDQxMTYyNzgtMTAwNTk0MTk0Mi5wbmc]: /images/20211109/5976bdbd4798477b948e958656eb4ad3.png