Windows安装配置Mycat

Myth丶恋晨 2022-02-21 16:42 607阅读 0赞

第一步，安装JDK并配置环境变量

第二步，安装MySQL

第三步，创建mycat数据库并创建user表

![20190411102950188.png][]

添加一条数据

![20190411103015112.png][]

第四步，下载Mycat

下载地址：[https://github.com/MyCATApache/Mycat-download][https_github.com_MyCATApache_Mycat-download]

我下载的版本是1.5

第四步，解压压缩包，最好放到没有中文路径的目录

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1dZQTE5OTM_size_16_color_FFFFFF_t_70][]

第五步，安装mycat，使用管理员身份打开cmd，进入D:/mycat/bin目录

执行mycat.bat install命令

第六步，配置用户信息，打开conf文件夹下的server.xml

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1dZQTE5OTM_size_16_color_FFFFFF_t_70 1][]

添加testuser用户，它只可以访问testmycat库

第七步，配置数据库信息，打开conf文件夹下的schema.xml

<?xml version="1.0"?>
    <!DOCTYPE mycat:schema SYSTEM "schema.dtd">
    <mycat:schema xmlns:mycat="http://org.opencloudb/" >
    
    	<schema name="TESTDB" checkSQLschema="false" sqlMaxLimit="100">
    		
    		<table name="travelrecord" dataNode="dn1,dn2,dn3" rule="auto-sharding-long" />
    
    		
    		<table name="company" primaryKey="ID" dataNode="dn3,dn2,dn1" rule="mod-long"/>
    		<table name="goods" primaryKey="ID" type="global" dataNode="dn1,dn2" />
    		
    		<table name="hotnews" primaryKey="ID" 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>
    	
    		
    	
    	<schema name="testmycat" checkSQLschema="true" sqlMaxLimit="100">
    		<table name="user" dataNode="testhost_dn1" type="global"/>
    	</schema>		
    	<dataNode name="dn1" dataHost="localhost1" database="db1" />
    	<dataNode name="dn2" dataHost="localhost1" database="db2" />
    	<dataNode name="dn3" dataHost="localhost1" database="db3" />
    	
    	
    	<dataNode name="testhost_dn1" dataHost="testhost" database="mycat" />
    	<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="10.202.4.39:3306" user="root"
    			password="sf123456">
    			
    			
    		</writeHost>
    		
    			
    		
    	</dataHost>
    	
    	<dataHost name="testhost" 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="root">
    			
    			
    		</writeHost>
    	</dataHost>
    	
    
    	
    	
    	
    </mycat:schema>

添加了三个测试的schema、dataNode、dataHost标签，连接的是本地创建的mycat库，并配置user表为全局表。

注意：schema、dataNode、dataHost标签必须按照顺序写，即

schema

。。。

dataNode

。。。

dataHost

。。。

否则启动会报错。

第八步，配置wrapper.conf

修改jdk地址

![20190411104441156.png][]

修改jvm参数

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1dZQTE5OTM_size_16_color_FFFFFF_t_70 2][]

如果是jdk8需要修改MaxPermSize为MaxMetaspaceSize，否则启动报错

第九步，启动mycat

使用管理员身份打开cmd，进入D:/mycat/bin目录

执行mycat.bat start命令

通过mycat.bat status命令查看状态

第十步，使用Navicat连接mycat

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1dZQTE5OTM_size_16_color_FFFFFF_t_70 3][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1dZQTE5OTM_size_16_color_FFFFFF_t_70 4][]

![20190411105229603.png][]

[20190411102950188.png]: /images/20220221/a6357233ac4a42628ad7bbc6b713c802.png
[20190411103015112.png]: /images/20220221/01e006ed184b4e84be41d0a6c6bcc2fa.png
[https_github.com_MyCATApache_Mycat-download]: https://github.com/MyCATApache/Mycat-download
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1dZQTE5OTM_size_16_color_FFFFFF_t_70]: /images/20220221/671fae63c74a4595923514d78bff4d95.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1dZQTE5OTM_size_16_color_FFFFFF_t_70 1]: /images/20220221/42bbd0917b46463387cc6afb881a761d.png
[20190411104441156.png]: /images/20220221/6e2e0b293c1e44ad8b4114d910300a0e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1dZQTE5OTM_size_16_color_FFFFFF_t_70 2]: /images/20220221/819a9b0aad2a4c63813c3a55811357ab.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1dZQTE5OTM_size_16_color_FFFFFF_t_70 3]: /images/20220221/7bf021a1184d40e9a7d457af5bb79946.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1dZQTE5OTM_size_16_color_FFFFFF_t_70 4]: /images/20220221/e7f2d40473a0488298ed48c17df1e854.png
[20190411105229603.png]: /images/20220221/d4353677b8cb4dc0a55775433133a64a.png