Mycat 实现数据库读写分离，负载均衡

た入场券 2022-12-07 12:23 189阅读 0赞

*  下载
    
        wget https://github.com/MyCATApache/Mycat2

基于心跳的自动故障切换，支持读写分离，支持MySQL主从  
默认连接端口是`8066`  
配置文件

*  schema.xml
    
        <?xml version="1.0"?>
        <!DOCTYPE mycat:schema SYSTEM "schema.dtd">
        <mycat:schema xmlns:mycat="http://io.mycat/">
        	
        	
        	<schema name="jtdb" checkSQLschema="false" sqlMaxLimit="100" dataNode="jtdb"/>
        
        	
        	<dataNode name="jtdb" dataHost="localhost1" database="jtdb" />
        		
        		  
        		
        			
        		
        		
        		
        		
        		
        		
        	<dataHost name="localhost1" maxCon="1000" minCon="10" balance="1"
        			  writeType="0" dbType="mysql" dbDriver="native" switchType="1"  slaveThreshold="100">
        		<heartbeat>select 1</heartbeat>
        
        		
        		<writeHost host="hostM1" url="192.168.126.129:3306" user="root" password="123456">
        			
        			<readHost host="hostS1" url="192.168.126.130:3306" user="root" password="123456" />
        			
        			<readHost host="hostS2" url="192.168.126.129:3306" user="root" password="123456" />
        			
        		</writeHost>
        
        			
        			
        			
        			
        			
        		
        		
        			
        			
        			
        			
        		
        		
        	</dataHost>
        </mycat:schema>
 *  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="sequnceHandlerType">2</property>
               
                 
        	
        	
                
        		<property name="processorBufferPoolType">0</property>
        		
        		
        		
        		
        		
        		
        		
        		
        		<property name="handleDistributedTransactions">0</property>
        		
        			
        		<property name="useOffHeapForMerge">1</property>
        
        		
                <property name="memoryPageSize">64k</property>
        
        		
        		<property name="spillsFileBufferSize">1k</property>
        
        		<property name="useStreamOutput">0</property>
        
        		
        		<property name="systemReserveMemorySize">384m</property>
        
        
        		
        		<property name="useZKSwitch">true</property>
        
        		
        		
        
        		
        		
        
        	</system>
        	
        	
        	
        	
        	
        	
        	
        	
        	
        	
        	<user name="root">
        		<property name="password">123456</property>
        		
        		<property name="schemas">jtdb</property>
        	</user>
        
        	<user name="user">
        		<property name="password">user</property>
        		<property name="schemas">jtdb</property>
        		<property name="readOnly">true</property>
        	</user>
        </mycat:server>

启动  
进入mycat安装目录中的bin目录

[root@localhost bin]# ./mycat start
    Starting Mycat-server...
    [root@localhost bin]# ./mycat status
    Mycat-server is running (16483).
    [root@localhost bin]# t

检查运行状态

[root@localhost bin]# ./mycat status
    Mycat-server is running (16483).
    [root@localhost bin]#

停止

[root@localhost bin]# ./mycat stop
    Stopping Mycat-server...
    Stopped Mycat-server.
    [root@localhost bin]# ./mycat status
    Mycat-server is not running.
    [root@localhost bin]#

将主数据库关闭后仍然能正常访问，且主数据库启动后能够自动同步数据  
就配置好了