MyCat的使用

水深无声 2021-10-19 02:14 325阅读 0赞

*  Mycat官网地址:http://www.mycat.io/
 *  Mycat下载地址: http://dl.mycat.io/
 *  Mycat帮助文档:https://github.com/MyCATApache/Mycat-Server/wiki/1.0-Mycat%E7%AE%80%E4%BB%8B

1.  下载对应版本的Mycat, 本文以windows为例  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW5nbmluZ2tpZA_size_16_color_FFFFFF_t_70]
2.  进入conf文件夹内， 主要修改三个xml文件

> a. schema.xml - 设置读写分离、分库分表  
> b. server.xml - 设置账号密码  
> c. rule.xml - 设置分片规则

1.  schema.xml参考:

<?xml version="1.0"?>
    <!DOCTYPE mycat:schema SYSTEM "schema.dtd">
    <mycat:schema xmlns:mycat="http://io.mycat/">
    
    	<schema name="TESTDB" checkSQLschema="true" sqlMaxLimit="100" dataNode="dn">
    	</schema>
    	
    	<dataNode name="dn" dataHost="wfx_wh1903" database="db1" />
    	
    	<dataHost name="wfx_wh1903" maxCon="1000" minCon="10" balance="3" writeType="0" dbType="mysql" dbDriver="native" switchType="1" slaveThreshold="100">
    		<heartbeat>select user()</heartbeat>
    		<writeHost host="hostM1" url="192.168.227.131:3306" user="root" password="zhangningpegasus">
    			<readHost host="hostS1" url="192.168.227.132:3306" user="root" password="zhangningpegasus" />
    		</writeHost>		
    	</dataHost>
    
    </mycat:schema>

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="nonePasswordLogin">0</property> 
    	<property name="useHandshakeV10">1</property>
    	<property name="useSqlStat">0</property>  
    	<property name="useGlobleTableCheck">0</property>  
    		<property name="sqlExecuteTimeout">300</property>  
    		<property name="sequnceHandlerType">2</property>
    		
    		
    		<property name="sequnceHandlerPattern">(?:(\s*next\s+value\s+for\s*MYCATSEQ_(\w+))(,|\)|\s)*)+</property>
    	<property name="subqueryRelationshipCheck">false</property> 
           
             
    	
    	
            
    		<property name="processorBufferPoolType">0</property>
    		
    		
    		
    		
    		
    		
    		
    		
    		<property name="handleDistributedTransactions">0</property>
    		
    			
    		<property name="useOffHeapForMerge">0</property>
    
    		
            <property name="memoryPageSize">64k</property>
    
    		
    		<property name="spillsFileBufferSize">1k</property>
    
    		<property name="useStreamOutput">0</property>
    
    		
    		<property name="systemReserveMemorySize">384m</property>
    
    
    		
    		<property name="useZKSwitch">false</property>
    
    		
    		
    
    		
    		
    		
    		<property name="strictTxIsolation">false</property>
    	
    		<property name="useZKSwitch">true</property>
    
    	</system>
    	
    	<user name="root" defaultAccount="true">
    		<property name="password">123456</property>
    		<property name="schemas">TESTDB</property>
    	</user>
    
    </mycat:server>

1.  启动bin文件夹下的startup\_nowrap.bat即可  
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW5nbmluZ2tpZA_size_16_color_FFFFFF_t_70 1]
2.  连接mycat, 和连接mysql一模一样，没有任何的区别， 端口8066

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW5nbmluZ2tpZA_size_16_color_FFFFFF_t_70]: /images/20211018/8f53fe5c990d4d3b92b8944ea2173169.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3poYW5nbmluZ2tpZA_size_16_color_FFFFFF_t_70 1]: /images/20211018/f9e14bfe7832480997c30e965329e91c.png