mycat

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

    <schema name="m-gallery" checkSQLschema="false" sqlMaxLimit="100">
        <table name="t_about_service" primaryKey="id" dataNode="dn1"  />
        <table name="t_account_commission" primaryKey="id" dataNode="dn1"  />
    </schema>
    
    <dataNode name="dn1" dataHost="localhost1" database="m-gallery" />
    
    <dataHost name="localhost1" maxCon="2000" minCon="10" balance="1"
              writeType="0" dbType="mysql" dbDriver="native" switchType="1"  slaveThreshold="100">
        <heartbeat>select user()</heartbeat>
        <writeHost host="hostM1" url="123.45.67.8:3306" user="root"
                   password="m-password">
            <readHost host="hostS1" url="123.45.67.9:3306" user="root" password="m-password" />
        </writeHost>
        <writeHost host="hostM2" url="123.45.67.9:3306" user="root" password="m-password" >
            <readHost host="hostS2" url="123.45.67.8:3306" user="root" password="m-password" />
         </writeHost>
    </dataHost>
</mycat:schema>