【详解】Mycat多Schema配置

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

    <!-- 配置schema1 -->
    <schema name="schema1" checkSQLschema="false" sqlMaxLimit="100">
        <table name="user" dataNode="dn1" rule="auto-sharding-long"/>
    </schema>

    <!-- 配置schema2 -->
    <schema name="schema2" checkSQLschema="false" sqlMaxLimit="100">
        <table name="order" dataNode="dn2" rule="auto-sharding-long"/>
    </schema>

    <!-- 配置dataNode -->
    <dataNode name="dn1" dataHost="host1" database="db1"/>
    <dataNode name="dn2" dataHost="host2" database="db2"/>

    <!-- 配置dataHost -->
    <dataHost name="host1" maxCon="1000" minCon="10" balance="1"
              writeType="0" dbType="mysql" dbDriver="native" switchType="1" slaveThreshold="100">
        <heartbeat>select user()</heartbeat>
        <writeHost host="host1-1" url="192.168.1.1:3306" user="root" password="password"/>
    </dataHost>

    <dataHost name="host2" maxCon="1000" minCon="10" balance="1"
              writeType="0" dbType="mysql" dbDriver="native" switchType="1" slaveThreshold="100">
        <heartbeat>select user()</heartbeat>
        <writeHost host="host2-1" url="192.168.1.2:3306" user="root" password="password"/>
    </dataHost>

</mycat:schema>