myCat schema.xml详解

    schema.xml 是mycat重要的配置文件之一，管理者mycat的逻辑库、表、分片规则、DataNode以及DataSource。想要了解使用mycat就要弄清楚schema里面的标签含义，下面将介绍一下schema里面的详细内容。

首先 mycat自带的schema.xml 如下所示：

 
 
 

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

  
<schema name="TESTDB" checkSQLschema="false" sqlMaxLimit="100">
  
		<!-- auto sharding by id (long) -->
  
		<table name="travelrecord" dataNode="dn1,dn2,dn3" rule="auto-sharding-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="company" primaryKey="ID" dataNode="dn3,dn2,dn1" rule="mod-long"/>
  
		<table name="goods" primaryKey="ID" type="global" dataNode="dn1,dn2" />
  
		<!-- random sharding using mod sharind rule -->
  
		<table name="hotnews" primaryKey="ID" dataNode="dn1,dn2,dn3"
  
			rule="mod-long" />
  
		<!-- <table name="dual" primaryKey="ID" dataNode="dnx,dnoracle2" type="global" 
  
			needAddLimit="false"/> <table name="worker" primaryKey="ID" dataNode="jdbc_dn1,jdbc_dn2,jdbc_dn3" 
  
			rule="mod-long" /> -->
  
		<table name="employee" primaryKey="ID" dataNode="dn1,dn2"
  
			rule="sharding-by-intfile" />
  
		<table name="customer" primaryKey="ID" dataNode="dn1,dn2"
  
			rule="sharding-by-intfile">
  
			<childTable name="orders" primaryKey="ID" joinKey="customer_id"
  
				parentKey="id">
  
				<childTable name="order_items" joinKey="order_id"
  
					parentKey="id" />
  
			</childTable>
  
			<childTable name="customer_addr" primaryKey="ID" joinKey="customer_id"
  
				parentKey="id" />