mycat配置主从复制，读写分离，分库分表

妖狐艹你老母 2021-10-19 07:42 400阅读 0赞

# 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">0</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="mycat" defaultAccount="true">
    		<property name="password">123456</property>
    		<property name="schemas">mycatdb</property>
    		
    		
    		
    	</user>
    
    	<user name="user">
    		<property name="password">user</property>
    		<property name="schemas">mycatdb</property>
    		<property name="readOnly">true</property>
    	</user>
    
    </mycat:server>

# 2.schema.xml文件完整内容 #

<?xml version="1.0"?>
    <!DOCTYPE mycat:schema SYSTEM "schema.dtd">
    <mycat:schema xmlns:mycat="http://io.mycat/">
    
    	<schema name="mycatdb" checkSQLschema="false" sqlMaxLimit="100" dataNode="dn1">
    		
    		
    		
    		
    		<table name="t_order" primaryKey="id" dataNode="dn1,dn2,dn3" rule="mod-long"/>
    	</schema>
    	
    	
    	<dataNode name="dn1" dataHost="localhost1" database="springdb" />
    	<dataNode name="dn2" dataHost="localhost1" database="springdc" />
    	<dataNode name="dn3" dataHost="localhost1" database="springdd" />
    
    
    	
    	<dataHost name="localhost1" maxCon="1000" minCon="10" balance="1"
    			  writeType="0" dbType="mysql" dbDriver="native" switchType="1"  slaveThreshold="100">
    
    		<heartbeat>select user()</heartbeat>
    		
    		
    		<writeHost host="hostM132" url="192.168.72.132:3306" user="root" password="123456">
    			
    			<readHost host="hostM134" url="192.168.72.134:3306" user="root" password="123456" />
    			<readHost host="hostS133" url="192.168.72.133:3306" user="root" password="123456" />
    		</writeHost>
    
    		<writeHost host="hostM134" url="localhost:3316" user="root" password="123456" >
    			<readHost host="hostM132" url="192.168.72.132:3306" user="root" password="123456" />
    			<readHost host="hostS135" url="192.168.72.135:3306" user="root" password="123456" />
    		</writeHost>
    
    	</dataHost>
    </mycat:schema>