mycat配置分库分表

<?xml version="1.0"?>
<!DOCTYPE mycat:schema SYSTEM "schema.dtd">
<mycat:schema xmlns:mycat="http://io.mycat/">
    <schema name="TESTDB" checkSQLschema="false" sqlMaxLimit="100" dataNode="orders">
        <!--配置表-->
        <table name="lmrs_orders" primaryKey="id"  subTables="lmrs_orders_$0-63"  dataNode="orders" rule="mod-long"/>
        <table name="lmrs_orders_items" primaryKey="id"  subTables="lmrs_order_items_$0-63"  dataNode="orders" rule="mod-long"/>
        <table name="lmrs_user_order_index" primaryKey="user_id"  subTables="lmrs_user_order_index_$0-63"  dataNode="orders" rule="mod-long-user_id"/>
    </schema>
    <!--配置节点-->
    <dataNode name="orders" dataHost="lmrs_orders" database="lmrs_2008_orders"/>
    <!--设置数据源-->
    <dataHost name="lmrs_orders" maxCon="1000" minCon="10" balance="3"
              writeType="0" dbType="mysql" dbDriver="native" switchType="1"  slaveThreshold="100">
        <heartbeat>select user()</heartbeat>
        <writeHost host="hostM1" url="172.18.12.1:3306" user="root" password="root">
            <readHost host="hostS1" url="172.18.12.1:3307" user="root" password="root"/>
            <readHost host="hostS2" url="172.18.12.1:3308" user="root" password="root"/>
        </writeHost>
    </dataHost>
</mycat:schema>

本作品采用《CC 协议》，转载必须注明作者和本文链接