mycat入门

曾经终败给现在 2022-09-06 01:14 205阅读 0赞

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Byb2dyYW1tZXJfdW5pb24_size_16_color_FFFFFF_t_70]  
打开mycat 官网

简介  
[https://github.com/MyCATApache/Mycat-Server/wiki/1.0-Mycat%E7%AE%80%E4%BB%8B][https_github.com_MyCATApache_Mycat-Server_wiki_1.0-Mycat_E7_AE_80_E4_BB_8B]

下载  
[https://github.com/MyCATApache/Mycat-download/tree/master/1.6-RELEASE][https_github.com_MyCATApache_Mycat-download_tree_master_1.6-RELEASE]

启动前，一般需要修改JVM配置参数，打开conf/wrapper.conf文件，如下行的内容为2G和2048，可根据本机配置情况修改为512M或其它值。 以下配置跟jvm参数完全一致，可以根据自己的jvm参数调整。

wrapper.java.additional.12=-XX:+UseParNewGC
    wrapper.java.additional.13=-XX:+UseConcMarkSweepGC
    wrapper.java.additional.14=-XX:+UseCMSCompactAtFullCollection
    wrapper.java.additional.15=-XX:CMSFullGCsBeforeCompaction=0
    wrapper.java.additional.16=-XX:CMSInitiatingOccupancyFraction=70

server.xml 中添加

schema.xml 中修改

<dataHost name="localhost1" maxCon="1000" minCon="1000" balance="0"
    			  writeType="0" dbType="mysql" dbDriver="native" switchType="1"  slaveThreshold="100">
    		<heartbeat>select user()</heartbeat>
    		
    		<writeHost host="hostM1" url="192.168.59.129:3339" user="root"
    				   password="123456">
    			
    			<readHost host="hostS2" url="192.168.59.129:3340" user="root" password="123456" />
    		</writeHost>
    		
    	</dataHost>

![在这里插入图片描述][baf60513733841cabaefed65df08d161.png]

**配置入门**

[https://github.com/MyCATApache/Mycat-Server/wiki/3.0-Mycat%E9%85%8D%E7%BD%AE%E5%85%A5%E9%97%A8][https_github.com_MyCATApache_Mycat-Server_wiki_3.0-Mycat_E9_85_8D_E7_BD_AE_E5_85_A5_E9_97_A8]  
分片的概念：分库 水平分库（库表结构都是一样的集群） 垂直分库（按照业务分库 分布式）  
分区的概念：分表

<schema name="db_jxc" checkSQLschema="false" sqlMaxLimit="100">
    		
    		
    		<table name="t_user_role"    primaryKey="ID"  dataNode="dn1,dn2,dn3" rule="auto-sharding-long"/>
    		<table name="t_user"    primaryKey="ID" dataNode="dn1,dn2,dn3"  rule="auto-sharding-long"/>
    		<table name="t_supplier"    primaryKey="ID"  dataNode="dn1,dn2,dn3" rule="auto-sharding-long"/>
    		<table name="t_sale_list_goods"    primaryKey="ID"  dataNode="dn1,dn2,dn3" rule="auto-sharding-long"/>
    		<table name="t_sale_list"    primaryKey="ID"  dataNode="dn1,dn2,dn3" rule="auto-sharding-long"/>
    		<table name="t_role_menu"    primaryKey="ID" dataNode="dn1,dn2,dn3" rule="auto-sharding-long"/>
    		<table name="t_role"    primaryKey="ID"  dataNode="dn1,dn2,dn3" rule="auto-sharding-long"/>
    		<table name="t_return_list_goods"    primaryKey="ID" dataNode="dn1,dn2,dn3" rule="auto-sharding-long"/>
    		<table name="t_return_list"    primaryKey="ID" dataNode="dn1,dn2,dn3" rule="auto-sharding-long"/>
    		<table name="t_purchase_list_goods"    primaryKey="ID"  dataNode="dn1,dn2,dn3" rule="auto-sharding-long"/>
    		<table name="t_purchase_list"    primaryKey="ID"  dataNode="dn1,dn2,dn3" rule="auto-sharding-long"/>
    		<table name="t_overflow_list_goods"    primaryKey="ID"  dataNode="dn1,dn2,dn3" rule="auto-sharding-long"/>
    		<table name="t_overflow_list"    primaryKey="ID" dataNode="dn1,dn2,dn3" rule="auto-sharding-long"/>
    		<table name="t_menu"    primaryKey="ID" dataNode="dn1,dn2,dn3" rule="auto-sharding-long"/>
    		<table name="t_log"    primaryKey="ID" dataNode="dn1,dn2,dn3" rule="auto-sharding-long"/>
    		<table name="t_goodsunit"    primaryKey="ID" dataNode="dn1,dn2,dn3" rule="auto-sharding-long"/>
    		<table name="t_goodstype"    primaryKey="ID" dataNode="dn1,dn2,dn3" rule="auto-sharding-long"/>
    		<table name="t_goods"    primaryKey="ID" dataNode="dn1,dn2,dn3" rule="auto-sharding-long"/>
    		<table name="t_damage_list_goods"    primaryKey="ID" dataNode="dn1,dn2,dn3" rule="auto-sharding-long"/>
    		<table name="t_damage_list"    primaryKey="ID"  dataNode="dn1,dn2,dn3" rule="auto-sharding-long"/>
    		<table name="t_customer_return_list_goods"    primaryKey="ID"  dataNode="dn1,dn2,dn3" rule="auto-sharding-long"/>
    		<table name="t_customer_return_list"    primaryKey="ID"  dataNode="dn1,dn2,dn3" rule="auto-sharding-long"/>
    		<table name="t_customer"    primaryKey="ID" dataNode="dn1,dn2,dn3" rule="auto-sharding-long"/>
    
    		
    	</schema>
    	
    	<dataNode name="dn1" dataHost="localhost1" database="db_jxc1" />
    	<dataNode name="dn2" dataHost="localhost1" database="db_jxc1" />
    	<dataNode name="dn3" dataHost="localhost1" database="db_jxc1" />
    	
    	<dataHost name="localhost1" maxCon="1000" minCon="1000" balance="0"
    			  writeType="0" dbType="mysql" dbDriver="native" switchType="1"  slaveThreshold="100">
    		<heartbeat>select user()</heartbeat>
    		
    		<writeHost host="hostM1" url="192.168.59.129:3339" user="root"
    				   password="123456">
    			
    			<readHost host="hostS2" url="192.168.59.129:3340" user="root" password="123456" />
    		</writeHost>
    		
    	</dataHost>

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Byb2dyYW1tZXJfdW5pb24_size_16_color_FFFFFF_t_70 1]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Byb2dyYW1tZXJfdW5pb24_size_16_color_FFFFFF_t_70 2]

## Mycat-Web ##

Mycat,mycat eye 依赖 jdk1.7＋环境，jdk 下载地址为：  
[http://www.oracle.com/technetwork/java/javase/downloads/][http_www.oracle.com_technetwork_java_javase_downloads]

Zookeeper 环境要求

Mycat eye 需要 Zookeeper 作为配置中心
    zookeeper-3.4.6.tar.gz

Zookeeper 配置

1. 解 压 zookeeper-3.4.6.tar.gz;
    2. zookeeper-3.4.6\conf 目录下把 zoo_sample.cfg 修改为 zoo.cfg;
    3. 启动 zookeeper
    Windowns 操作系统启动命令： zookeeper-3.4.6\bin\zkServer.bat
    Linux 操作系统启动命令：zookeeper-3.4.6\bin\zkServer.sh start
    mycat  资料 ;

Mycat eye 环境部署

软件清单
    Windowns 版本：
    Mycat-web-1.0-SNAPSHOT-20151208180035-win.zip
    Linux 版本：
    Mycat-web-1.0-SNAPSHOT-20151208180035-linux.tar.gz
    下载地址：https://github.com/MyCATApache/Mycat-download/tree/master/mycat-web-1.0

加压后生成 mycat-web 目录，目录结构如下：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Byb2dyYW1tZXJfdW5pb24_size_16_color_FFFFFF_t_70 3]

先启动 zookeeper；
    然后启动 mycat eye
    Windowns 版本：
    start.bat
    Linux 版本：
    start.sh
    访问 mycat eye
    http://localhost:8082/mycat/
    mycat.properties 配置
    如果 zookeeper 连接不上
    mycat-web\mycat-web\WEB-INF\classes\ mycat.properties 配置文件
    zookeeper=127.0.0.1:2181
    配置下 zookeeper 的服务器和端口
    方法 2：访问 http://localhost:8082/mycat/

**思路**：  
1、mycat 的server.xml 我们需要关心的是  
![在这里插入图片描述][dd12feba851d47ff91902c3316f562da.png]

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Byb2dyYW1tZXJfdW5pb24_size_16_color_FFFFFF_t_70 4]

2、schema.xml:

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Byb2dyYW1tZXJfdW5pb24_size_16_color_FFFFFF_t_70 5]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Byb2dyYW1tZXJfdW5pb24_size_16_color_FFFFFF_t_70 6]  
3、用 navicat 连接master 库，创建 路由对应的数据库（物理库），创建表结构和数据  
4、使用navicat 连接mycat ，再mycat 中添加数据进行测试  
5、再项目中配置mycat  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Byb2dyYW1tZXJfdW5pb24_size_16_color_FFFFFF_t_70 7]  
mycat具体相关资料放在博客资源tag下面,免费自取

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Byb2dyYW1tZXJfdW5pb24_size_16_color_FFFFFF_t_70]: /images/20220829/0ab2b6fecee94e8d99e9f60a4c6520b3.png
[https_github.com_MyCATApache_Mycat-Server_wiki_1.0-Mycat_E7_AE_80_E4_BB_8B]: https://github.com/MyCATApache/Mycat-Server/wiki/1.0-Mycat%E7%AE%80%E4%BB%8B
[https_github.com_MyCATApache_Mycat-download_tree_master_1.6-RELEASE]: https://github.com/MyCATApache/Mycat-download/tree/master/1.6-RELEASE
[baf60513733841cabaefed65df08d161.png]: /images/20220829/f5ab3a2f3edf49259c33699a755baef2.png
[https_github.com_MyCATApache_Mycat-Server_wiki_3.0-Mycat_E9_85_8D_E7_BD_AE_E5_85_A5_E9_97_A8]: https://github.com/MyCATApache/Mycat-Server/wiki/3.0-Mycat%E9%85%8D%E7%BD%AE%E5%85%A5%E9%97%A8
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Byb2dyYW1tZXJfdW5pb24_size_16_color_FFFFFF_t_70 1]: /images/20220829/41c01e70c42146b6b5d541a4086e6eb7.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Byb2dyYW1tZXJfdW5pb24_size_16_color_FFFFFF_t_70 2]: /images/20220829/4988ad67d03f42b7b2975594387d2d91.png
[http_www.oracle.com_technetwork_java_javase_downloads]: http://www.oracle.com/technetwork/java/javase/downloads/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Byb2dyYW1tZXJfdW5pb24_size_16_color_FFFFFF_t_70 3]: /images/20220829/0a719bfdd018410eae299767d547ee6d.png
[dd12feba851d47ff91902c3316f562da.png]: /images/20220829/bde454f31b18493297870ddf68555a55.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Byb2dyYW1tZXJfdW5pb24_size_16_color_FFFFFF_t_70 4]: /images/20220829/53c998a01dc54f239a9bd5965e9799a8.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Byb2dyYW1tZXJfdW5pb24_size_16_color_FFFFFF_t_70 5]: /images/20220829/8912d9e05b9048df8ef54a1ad548be4a.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Byb2dyYW1tZXJfdW5pb24_size_16_color_FFFFFF_t_70 6]: /images/20220829/73915007d0384ac6bfd7c028ecd8ee07.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Byb2dyYW1tZXJfdW5pb24_size_16_color_FFFFFF_t_70 7]: /images/20220829/ed96ed01b2a54d0fb69e01459261a18c.png