Mycat配置文件

Bertha 。 2022-01-12 02:15 275阅读 0赞

### Mycat配置文件 ###

*   *  主要配置文件
     *  配置文件详解
     *   *  server.xml
         *  schema.xml
         *  rule.xml

## 主要配置文件 ##

[Mycat的github地址][Mycat_github]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ppYW5nMTgyMzgwMzI4OTE_size_16_color_FFFFFF_t_70]  
从这张图中就能知道，mycat的主要配置文件就三个：

*  server.xml: 配置Mycat服务器参数和用户授权。
 *  schema.xml：配置逻辑库、表和分片。
 *  rule.xml: 是分片规则的配置文件，配置文件修改需要重启Mycat。

## 配置文件详解 ##

### server.xml ###

这个配置文件中：system中是配置的Mycat的服务器参数，user中配置的是用户、用户权限以及库信息。

<?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="sequnceHandlerType">2</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>
    	<user name="user">
    		<property name="password">user</property>
    		<property name="schemas">TESTDB</property>
    		
    		<property name="readOnly">true</property>
    	</user>
    </mycat:server>

### schema.xml ###

配置中主要包括：schema:虚拟数据库，dataNode：数据节点，dataHost:实际物理地址

<?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="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>
    		
    		<table name="oc_call" primaryKey="ID" dataNode="dn1$0-743" rule="latest-month-calldate" />
    	</schema>
    	
    	
    	<dataNode name="dn1" dataHost="node1" database="db1" />
    	<dataNode name="dn2" dataHost="node2" database="db2" />
    	<dataNode name="dn3" dataHost="node2" database="db3" />
    	
    	<dataHost name="node1" 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">
    			
    			<readHost host="hostS2" url="192.168.1.200:3306" user="root" password="xxx" />
    		</writeHost>
    		
    		<writeHost host="hostS1" url="localhost:3316" user="root" password="123456" />
    	</dataHost>
    	
    
    	
    </mycat:schema>

### rule.xml ###

<?xml version="1.0" encoding="UTF-8"?>
    <!DOCTYPE mycat:rule SYSTEM "rule.dtd">
    <mycat:rule xmlns:mycat="http://io.mycat/">
    	<tableRule name="rule1">
    		<rule>
    			<columns>id</columns>
    			<algorithm>func1</algorithm>
    		</rule>
    	</tableRule>
    
    	<tableRule name="rule2">
    		<rule>
    			<columns>user_id</columns>
    			<algorithm>func1</algorithm>
    		</rule>
    	</tableRule>
    
    	<tableRule name="sharding-by-intfile">
    		<rule>
    			<columns>sharding_id</columns>
    			<algorithm>hash-int</algorithm>
    		</rule>
    	</tableRule>
    	<tableRule name="auto-sharding-long">
    		<rule>
    			<columns>id</columns>
    			<algorithm>rang-long</algorithm>
    		</rule>
    	</tableRule>
    	<tableRule name="mod-long">
    		<rule>
    			<columns>id</columns>
    			<algorithm>mod-long</algorithm>
    		</rule>
    	</tableRule>
    	<tableRule name="sharding-by-murmur">
    		<rule>
    			<columns>id</columns>
    			<algorithm>murmur</algorithm>
    		</rule>
    	</tableRule>
    	<tableRule name="crc32slot">
    		<rule>
    			<columns>id</columns>
    			<algorithm>crc32slot</algorithm>
    		</rule>
    	</tableRule>
    	<tableRule name="sharding-by-month">
    		<rule>
    			<columns>create_time</columns>
    			<algorithm>partbymonth</algorithm>
    		</rule>
    	</tableRule>
    	<tableRule name="latest-month-calldate">
    		<rule>
    			<columns>calldate</columns>
    			<algorithm>latestMonth</algorithm>
    		</rule>
    	</tableRule>
    	
    	<tableRule name="auto-sharding-rang-mod">
    		<rule>
    			<columns>id</columns>
    			<algorithm>rang-mod</algorithm>
    		</rule>
    	</tableRule>
    	
    	<tableRule name="jch">
    		<rule>
    			<columns>id</columns>
    			<algorithm>jump-consistent-hash</algorithm>
    		</rule>
    	</tableRule>
    
    	<function name="murmur" class="io.mycat.route.function.PartitionByMurmurHash">
    		<property name="seed">0</property>
    		<property name="count">2</property>
    		<property name="virtualBucketTimes">160</property>
    		
    		
    	</function>
    
    	<function name="crc32slot" class="io.mycat.route.function.PartitionByCRC32PreSlot">
    	</function>
    	<function name="hash-int" class="io.mycat.route.function.PartitionByFileMap">
    		<property name="mapFile">partition-hash-int.txt</property>
    	</function>
    	<function name="rang-long" class="io.mycat.route.function.AutoPartitionByLong">
    		<property name="mapFile">autopartition-long.txt</property>
    	</function>
    	<function name="mod-long" class="io.mycat.route.function.PartitionByMod">
    		
    		<property name="count">3</property>
    	</function>
    
    	<function name="func1" class="io.mycat.route.function.PartitionByLong">
    		<property name="partitionCount">8</property>
    		<property name="partitionLength">128</property>
    	</function>
    	<function name="latestMonth" class="io.mycat.route.function.LatestMonthPartion">
    		<property name="splitOneDay">24</property>
    	</function>
    	<function name="partbymonth" class="io.mycat.route.function.PartitionByMonth">
    		<property name="dateFormat">yyyy-MM-dd</property>
    		<property name="sBeginDate">2015-01-01</property>
    	</function>
    	
    	<function name="rang-mod" class="io.mycat.route.function.PartitionByRangeMod">
            	<property name="mapFile">partition-range-mod.txt</property>
    	</function>
    	
    	<function name="jump-consistent-hash" class="io.mycat.route.function.PartitionByJumpConsistentHash">
    		<property name="totalBuckets">3</property>
    	</function>
    </mycat:rule>

自学Mycat，有表达不当之处还请指正！！

[Mycat_github]: https://github.com/MyCATApache/Mycat-Server
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2ppYW5nMTgyMzgwMzI4OTE_size_16_color_FFFFFF_t_70]: /images/20220109/b0d86c499b4a409697b8f29d8d562c4c.png