MyCat的在windows下的基础使用

迷南。 2023-05-30 06:29 5阅读 0赞

为了对数据进行水平切分(分库)，将项目集成mycat;

### 1.下载mycat [http://dl.mycat.io/][http_dl.mycat.io] ###

### 2.配置：主要是配置4个文件 ###

**1)配置环境变量：**

![20191108103847411.png][]![20191108103909698.png][]

配置完毕后，输入命令mycat，出现如下图，表示配置成功；

![20191108104003665.png][]

**2）配置系统参数，所有配置均在conf文件下**

a.配置运行环境：配置wrapper.conf文件

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L01pbl9DaGFuZGVy_size_16_color_FFFFFF_t_70][]

![20191108104251160.png][]

根据自己的实际java路径配置；

b.设置mycat账号和密码，在server.xml配置

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L01pbl9DaGFuZGVy_size_16_color_FFFFFF_t_70 1][]

调试方便，关键配置信息

<user name="sgkj" defaultAccount="true">
    		<property name="password">cdutcm@123</property>
    		<property name="schemas">mycats</property>
    	</user>

c.配置分表：在schema.xml配置

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L01pbl9DaGFuZGVy_size_16_color_FFFFFF_t_70 2][]

附关键配置：

<dataNode name="dn1" dataHost="localhost1" database="db1" />
    	<dataNode name="dn2" dataHost="localhost1" database="db2" />
    	<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="hostS1" url="localhost:3457" user="root"
    				   password="root" />
    </dataHost>

d.配置路由规则，这里用id为策略，平均分摊到每个数据库

<mycat:schema xmlns:mycat="http://io.mycat/">
    
    	<schema name="mycats" checkSQLschema="false" sqlMaxLimit="100">
    		
    		<table name="tb_user" dataNode="dn1,dn2" rule="mod-long" />
    
    	</schema>
    	
    	<dataNode name="dn1" dataHost="localhost1" database="db1" />
    	<dataNode name="dn2" dataHost="localhost1" database="db2" />
    	<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="hostS1" url="localhost:3457" user="sgkj"
    				   password="cdutcm@123" />
    		
    	</dataHost>
    </mycat:schema>

### 3.启动mycat; ###

mycat install 安装；

mycat start 启动服务；

启动服务的时候菜了几个坑，主要是java环境的问题，java8不能启动，后来换成了java7解决的；

### 4.测试是否安装成功,注意一下，mycat默认启动的端口是8066 ###

driver-class-name: com.mysql.jdbc.Driver.url: jdbc:mysql://localhost:8066/mycats?characterEncoding=utf8&useSSL=false&autoReconnect=true&allowMultiQueries=true
    username: root
    password: root

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L01pbl9DaGFuZGVy_size_16_color_FFFFFF_t_70 3][]

向mycat中插入数据后，查看结果，数据被分摊插入到不同的数据库

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L01pbl9DaGFuZGVy_size_16_color_FFFFFF_t_70 4][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L01pbl9DaGFuZGVy_size_16_color_FFFFFF_t_70 5][]

致谢：参看文献

[https://github.com/MyCATApache/Mycat-doc/blob/master/%E5%85%A5%E9%97%A8%E6%8C%87%E5%8D%97/mycat%E5%AE%89%E8%A3%85%E5%85%A5%E9%97%A8(%E4%B8%A4%E8%8A%82%E7%82%B9).md][https_github.com_MyCATApache_Mycat-doc_blob_master_E5_85_A5_E9_97_A8_E6_8C_87_E5_8D_97_mycat_E5_AE_89_E8_A3_85_E5_85_A5_E9_97_A8_E4_B8_A4_E8_8A_82_E7_82_B9_.md]

[http_dl.mycat.io]: http://dl.mycat.io/
[20191108103847411.png]: https://img-blog.csdnimg.cn/20191108103847411.png
[20191108103909698.png]: https://img-blog.csdnimg.cn/20191108103909698.png
[20191108104003665.png]: https://img-blog.csdnimg.cn/20191108104003665.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L01pbl9DaGFuZGVy_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20191108104226147.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L01pbl9DaGFuZGVy,size_16,color_FFFFFF,t_70
[20191108104251160.png]: https://img-blog.csdnimg.cn/20191108104251160.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L01pbl9DaGFuZGVy_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/2019110810443569.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L01pbl9DaGFuZGVy,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L01pbl9DaGFuZGVy_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20191108104718181.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L01pbl9DaGFuZGVy,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L01pbl9DaGFuZGVy_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/20191108110201482.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L01pbl9DaGFuZGVy,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L01pbl9DaGFuZGVy_size_16_color_FFFFFF_t_70 4]: https://img-blog.csdnimg.cn/20191108110537462.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L01pbl9DaGFuZGVy,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L01pbl9DaGFuZGVy_size_16_color_FFFFFF_t_70 5]: https://img-blog.csdnimg.cn/2019110811055313.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L01pbl9DaGFuZGVy,size_16,color_FFFFFF,t_70
[https_github.com_MyCATApache_Mycat-doc_blob_master_E5_85_A5_E9_97_A8_E6_8C_87_E5_8D_97_mycat_E5_AE_89_E8_A3_85_E5_85_A5_E9_97_A8_E4_B8_A4_E8_8A_82_E7_82_B9_.md]: https://github.com/MyCATApache/Mycat-doc/blob/master/%E5%85%A5%E9%97%A8%E6%8C%87%E5%8D%97/mycat%E5%AE%89%E8%A3%85%E5%85%A5%E9%97%A8%28%E4%B8%A4%E8%8A%82%E7%82%B9%29.md