mycat搭建多主多从

• 编写schema.xml

<?xml version="1.0"?>
<!DOCTYPE mycat:schema SYSTEM "schema.dtd">
<mycat:schema xmlns:mycat="http://io.mycat/">
	
	<schema name="QUAN" checkSQLschema="true" sqlMaxLimit="100">
		<table name="user" dataNode="dn1" primaryKey="id"/>
	</schema>
	
	<dataNode name="dn1" dataHost="localhost1" database="db03" />

	<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="hostM1" url="192.168.88.3:3306" user="root" password="123456">
			<readHost host="hostS1" url="192.168.88.4:3306" user="root" password="123456" />
		</writeHost>
		
		<writeHost host="hostM2" url="192.168.88.5:3306" user="root" password="123456">
			<readHost host="hostS2" url="192.168.88.6:3306" user="root" password="123456" />
		</writeHost>
	</dataHost>
    
</mycat:schema>

• 启动mycat

mysql -h 192.168.88.3 -P 8066 -u root -p

• 测试

select * from user;