mycat 简单的配置数据库分片(二)

接下来我们编辑schema.xml 

数据库分片在此文件下配置  

<?xml version="1.0"?>
<!DOCTYPE mycat:schema SYSTEM "schema.dtd">
<mycat:schema xmlns:mycat="http://io.mycat/">

	<schema name="TESTDB" checkSQLschema="false" sqlMaxLimit="100" dataNode="dn1">
		<!--配置需要分片的表-->
		<table name="student" primaryKey="id"  dataNode="dn1,dn2,dn3" rule="mod-long" ></table>
	</schema>
	<!--配置三个数据库分片 对应3个dataHost-->
	<dataNode name="dn1" dataHost="localhost1" database="test" />
	<dataNode name="dn2" dataHost="localhost2" database="test" />
	<dataNode name="dn3" dataHost="localhost3" database="test" />
	<!--分别配置3个对应的dataHost 对应3个物理数据库-->
	<dataHost name="localhost1" maxCon="1000" minCon="10" balance="0"
			  writeType="0" dbType="mysql" dbDriver="native" switchType="1"  slaveThreshold="100">
		<heartbeat>select user()</heartbeat>
		<writeHost host="hostM1" url="192.168.80.131:3306" user="root"
				   password="123456">
		</writeHost>
		
	
	</dataHost>
	<dataHost name="localhost2" maxCon="1000" minCon="10" balance="0"
			  writeType="0" dbType="mysql" dbDriver="native" switchType="1"  slaveThreshold="100">
		<heartbeat>select user()</heartbeat>
		<writeHost host="hostM1" url="192.168.80.132:3306" user="root"
				   password="123456">
		</writeHost>

	</dataHost>
	<dataHost name="localhost3" maxCon="1000" minCon="10" balance="0"
			  writeType="0" dbType="mysql" dbDriver="native" switchType="1"  slaveThreshold="100">
		<heartbeat>select user()</heartbeat>
		<writeHost host="hostM1" url="192.168.80.133:3306" user="root"
				   password="123456">
		</writeHost>

	</dataHost>
	
</mycat:schema>

配置好之后  我们切换到bin目录下   启动mycat  ./mycat start  

日志在logs目录下   如果出现异常  到该目录下看日志