mycat管理mysql需要把所有表名都配置好吗？

Question

我现在MySQL库中有很多表，如果用mycat进行管理，是不是需要将所有的表都配置在mycat的schema的配置文件中？如果需要通过mycat建表也需要把表名配置上？可不可以配置表名就新建？希望有人能解答一下我的疑惑，谢谢！

Answer 1

不用的表名全部配置进去的，你只需要配置你需要分库的那些就可以了，我这边有schema的，给你看下：

1. <?xml version="1.0"?>
   <!DOCTYPE mycat:schema SYSTEM "schema.dtd">
   <mycat:schema xmlns:mycat="http://io.mycat/">
   
   	<schema name="foodie-shop-dev" checkSQLschema="false" sqlMaxLimit="100" dataNode="dn131">
   		<!-- auto sharding by id (long) 
   		<table name="user" dataNode="dn131,dn132" rule="mod-long" />
   		<table name="province" dataNode="dn131,dn132" type="global"/>
   		<table name="o_order" autoIncrement="true" primaryKey="id"  dataNode="dn131,dn132" rule="mod-long">
   			<childTable name="order_item" joinKey="order_id" parentKey="id"/>
   		</table>
   		-->
   
   		<!-- <table name="oc_call" primaryKey="ID" dataNode="dn1$0-743" rule="latest-month-calldate"
   			/> -->
   		<table name="orders" dataNode="dn131,dn132" rule="sharding-by-murmur">
   			<childTable name="order_items" joinKey="order_id" parentKey="id"/>
   			<childTable name="order_status" joinKey="order_id" parentKey="id" />
   		</table>
   	</schema>
   	<dataNode name="dn131" dataHost="db131" database="foodie-shop-dev" />
   	<dataNode name="dn132" dataHost="db132" database="foodie-shop-dev" />
   	<dataHost name="db131" maxCon="1000" minCon="10" balance="0"
   			  writeType="0" dbType="mysql" dbDriver="native" switchType="1"  slaveThreshold="100">
   		<heartbeat>select user()</heartbeat>
   		<writeHost host="M1" url="192.168.73.131:3306" user="imooc"
   				   password="Imooc@123456">
   		</writeHost>
   	</dataHost>
   	<dataHost name="db132" maxCon="1000" minCon="10" balance="0"
                             writeType="0" dbType="mysql" dbDriver="native" switchType="1"  slaveThreshold="100">
                   <heartbeat>select user()</heartbeat>
                   <writeHost host="M1" url="192.168.73.132:3306" user="imooc"
                                      password="Imooc@123456">
                   </writeHost>
           </dataHost>
   </mycat:schema>