<?xml version="1.0"?>

<!DOCTYPE mycat:schema SYSTEM "schema.dtd">

<mycat:schema xmlns:mycat="http://io.mycat/">

	<schema name="springmybaitis" checkSQLschema="false" sqlMaxLimit="100">

		<!-- auto sharding by id (long) -->

		<table name="user" dataNode="dn1,dn2" primaryKey="id" rule="mod-long"/>

		<!-- global table is auto cloned to all defined data nodes ,so can join

			with any table whose sharding node is in the same data node -->

		<!-- <table name="oc_call" primaryKey="ID" dataNode="dn1$0-743" rule="latest-month-calldate"

			/> -->

	</schema>

	<!-- <dataNode name="dn1$0-743" dataHost="localhost1" database="db$0-743"

		/> -->

	<dataNode name="dn1" dataHost="localhost1" database="springmybaitis" />

	<dataNode name="dn2" dataHost="localhost2" database="springmybaitis1" />

	<!--<dataNode name="dn4" dataHost="sequoiadb1" database="SAMPLE" />

	 <dataNode name="jdbc_dn1" dataHost="jdbchost" database="db1" />

	<dataNode	name="jdbc_dn2" dataHost="jdbchost" database="db2" />

	<dataNode name="jdbc_dn3" 	dataHost="jdbchost" database="db3" /> -->

	<dataHost name="localhost1" maxCon="1000" minCon="10" balance="3"

			  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="123456">

			<!-- can have multi read hosts -->

			<readHost host="hostS2" url="127.0.0.1:3307" user="root" password="123456" />

		</writeHost>

	</dataHost>

	<dataHost name="localhost2" maxCon="1000" minCon="10" balance="3"

			  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="123456">

			<!-- can have multi read hosts -->

			<readHost host="hostS2" url="127.0.0.1:3307" user="root" password="123456" />

		</writeHost>

	</dataHost>

	<!--

		<dataHost name="sequoiadb1" maxCon="1000" minCon="1" balance="0" dbType="sequoiadb" dbDriver="jdbc">

		<heartbeat> 		</heartbeat>

		 <writeHost host="hostM1" url="sequoiadb://1426587161.dbaas.sequoialab.net:11920/SAMPLE" user="jifeng" 	password="jifeng"></writeHost>

		 </dataHost>

	  <dataHost name="oracle1" maxCon="1000" minCon="1" balance="0" writeType="0" 	dbType="oracle" dbDriver="jdbc"> <heartbeat>select 1 from dual</heartbeat>

		<connectionInitSql>alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss'</connectionInitSql>

		<writeHost host="hostM1" url="jdbc:oracle:thin:@127.0.0.1:1521:nange" user="base" 	password="123456" > </writeHost> </dataHost>

		<dataHost name="jdbchost" maxCon="1000" 	minCon="1" balance="0" writeType="0" dbType="mongodb" dbDriver="jdbc">

		<heartbeat>select 	user()</heartbeat>

		<writeHost host="hostM" url="mongodb://192.168.0.99/test" user="admin" password="123456" ></writeHost> </dataHost>

		<dataHost name="sparksql" maxCon="1000" minCon="1" balance="0" dbType="spark" dbDriver="jdbc">

		<heartbeat> </heartbeat>

		 <writeHost host="hostM1" url="jdbc:hive2://feng01:10000" user="jifeng" 	password="jifeng"></writeHost> </dataHost> -->

	<!-- <dataHost name="jdbchost" maxCon="1000" minCon="10" balance="0" dbType="mysql"

		dbDriver="jdbc"> <heartbeat>select user()</heartbeat> <writeHost host="hostM1"

		url="jdbc:mysql://localhost:3306" user="root" password="123456"> </writeHost>

		</dataHost> -->

</mycat:schema>