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

	<schema name="test_schrma" checkSQLschema="true" sqlMaxLimit="100">
		<!--<table name="test1" primaryKey="id" dataNode="test_dn"/>-->
		<table name="test" primaryKey="id" autoIncrement="true" subTables="test$1-3" dataNode="test_dn" rule="mod-long"/>
	</schema>
	<!-- database:具体数据库名称  -->
	<dataNode name="test_dn" dataHost="test_dh" database="mycat_test" />
	<dataHost name="test_dh" maxCon="1000" minCon="10" balance="0" writeType="0" dbType="mysql" dbDriver="native" switchType="1"  slaveThreshold="100">
		<heartbeat>select user()</heartbeat>
		<!-- can have multi write hosts -->
		<writeHost host="hostM1" url="127.0.0.1:3306" user="root" password="root">
			<!-- can have multi read hosts -->
			<!--<readHost host="hostS2" url="120.25.81.49:3306" user="cbh" password="cbh123" />-->
			<readHost host="hostS2" url="127.0.0.1:3306" user="root" password="root" />
		</writeHost>
	</dataHost>
</mycat:schema>

<function name="mod-long" class="io.mycat.route.function.PartitionByMod">
	<!-- how many data nodes -->
	<property name="count">3</property>
</function>