.net core mycat(2) 水平分表

水平分表

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

    <schema name="TESTDB" checkSQLschema="true" sqlMaxLimit="100" randomDataNode="dn1">

   <table name="User" dataNode="dn1" primaryKey="id" subTables="User$1-3" rule="mod-long" ></table>
   
    </schema>

    <dataNode name="dn1" dataHost="localhost1" database="TestDB" />
    <dataHost name="localhost1" maxCon="1000" minCon="10" balance="0"
              writeType="0" dbType="mysql" dbDriver="jdbc" switchType="1"  slaveThreshold="100">
        <heartbeat>select user()</heartbeat>
    <writeHost host="hostM1" url="jdbc:mysql://192.168.0.192:3306?useSSL=false&amp;serverTimezone=PRC" user="root" password="123456">
        </writeHost>
    </dataHost>
</mycat:schema>

 

 

 

 水平分库

 

 

 

 

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

    <schema name="TESTDB" checkSQLschema="true" sqlMaxLimit="100" randomDataNode="dn1">
 
 
   <!--水平分表-->
   <table name="User" dataNode="dn0" primaryKey="id" subTables="User$1-3" rule="mod-long" ></table>
   
   <!--水平分库-->
   <table name="User1" dataNode="dn$1-3" primaryKey="id"  rule="mod-long" ></table>
    </schema>

    <dataNode name="dn0" dataHost="localhost1" database="TestDB" />
     <dataNode name="dn1" dataHost="localhost1" database="TestDB1" />
    <dataNode name="dn2" dataHost="localhost1" database="TestDB2" />
     <dataNode name="dn3" dataHost="localhost1" database="TestDB3" />
 
    <dataHost name="localhost1" maxCon="1000" minCon="10" balance="0"
              writeType="0" dbType="mysql" dbDriver="jdbc" switchType="1"  slaveThreshold="100">
        <heartbeat>select user()</heartbeat>
    <writeHost host="hostM1" url="jdbc:mysql://192.168.0.192:3306?useSSL=false&amp;serverTimezone=PRC" user="root" password="123456">
        </writeHost>
    </dataHost>
</mycat:schema>

 

上面有个规则  rule.xml