Sample sharded file for disabling colonies in Production_V1

You can review the sample XML of a sharded file for disabling colonies in Production_V1.


?xml version="1.0" encoding="UTF-8"?>
<colonyconfig>
    <pools>
        <pool id="DEFAULT_METADATA">
          <jdbc>
            <param name="url" value="<url to connect to database>"/>
            <param name="user" value="<Production_V1_METADATA>"/>
            <param name="password" value="<Production_V1_METADATA>"/>
            <param name="driver" value="<class name of your database driver>"/>
            <param name="schema" value="<Production_V1_METADATA>"/>
          </jdbc>
        </pool>
        <pool id="DEFAULT_STATISTICS">
          <jdbc>
            <param name="url" value="<url to connect to database>"/>
            <param name="user" value="<Production_V1_STATISTICS>"/>
            <param name="password" value="<Production_V1_STATISTICS>"/>
            <param name="driver" value="<class name of your database driver>"/>
            <param name="schema" value="<Production_V1_STATISTICS>"/>
          </jdbc>
        </pool>
        <pool id="DEFAULT_CONFIGURATION">
          <jdbc>
            <param name="url" value="<url to connect to database>"/>
            <param name="user" value="<Production_V1_CONFIGURATION>"/>
            <param name="password" value="<Production_V1_CONFIGURATION>"/>
            <param name="driver" value="<class name of your database driver>"/>
            <param name="schema" value="<Production_V1_CONFIGURATION>"/>
          </jdbc>
        </pool>
        <pool id="DEFAULT_TRANSACTION">
          <jdbc>
            <paramname="url"value="<url to connect to database>"/>
            <param name="user" value="<Production_V1_DEFAULT_TRANSACTION>"/>
            <param name="password" value="<Production_V1_DEFAULT_TRANSACTION>"/>
            <param name="driver" value="<class name of your database driver>"/>
            <param name="schema" value="<Production_V1_DEFAULT_TRANSACTION>"/>
          </jdbc>
        </pool>
        <pool id="TRANSACTION-01">
          <jdbc>
            <param name="url" value="<url to connect to database>"/> 
            <param name="user" value="<Colony_01_TRANSACTION>"/>
            <param name="password" value="<Colony_01_TRANSACTION>"/>
            <param name="driver" value="<class name of your database driver>"/>
            <param name="schema" value="<Colony_01_TRANSACTION>"/>
          </jdbc>
        </pool>        
        <pool id="TRANSACTION-02"> remove reference
          <jdbc>
            <param name="url" value="<url to connect to database>"/>
            <param name="user" value="<Colony_02_TRANSACTION>"/>
            <param name="password" value="<Colony_02_TRANSACTION>"/>
            <param name="driver" value="<class name of your database driver>"/>
            <param name="schema" value="<Colony_02_TRANSACTION>"/>
          </jdbc>
        </pool>
    </pools>
    <colonies>
        <colony name="Colony-01" version="9.4" status="UPGRADE" pkprefix="11">
            <schema poolid="DEFAULT_METADATA" tabletype="METADATA"/>
            <schema poolid="DEFAULT_CONFIGURATION" tabletype="CONFIGURATION"/>
            <schema poolid="DEFAULT_STATISTICS" tabletype="STATISTICS"/>
            <schema poolid="TRANSACTION-01" tabletype="TRANSACTION"/>
            <schema poolid="TRANSACTION-01" tabletype="MASTER"/>
       </colony>
        <colony name="Colony-02" version="9.4" pkprefix="21"> remove reference 
            <schema poolid="DEFAULT_METADATA" tabletype="METADATA"/>
            <schema poolid="DEFAULT_CONFIGURATION" tabletype="CONFIGURATION"/>
            <schema poolid="DEFAULT_STATISTICS" tabletype="STATISTICS"/>
            <schema poolid="TRANSACTION-02" tabletype="TRANSACTION"/>
            <schema poolid="TRANSACTION-02" tabletype="MASTER"/>
        </colony>
        <colony name="DEFAULT" version= "9.4 " pkprefix="20">
            <schema poolid="DEFAULT_METADATA" tabletype="METADATA"/>
            <schema poolid="DEFAULT_STATISTICS" tabletype="STATISTICS"/>
            <schema poolid="DEFAULT_CONFIGURATION" tabletype="CONFIGURATION"/>
            <schema poolid="DEFAULT_TRANSACTION" tabletype="TRANSACTION"/>
            <schema poolid="DEFAULT_TRANSACTION" tabletype="MASTER"/>
        </colony>
    </colonies>
</colonyconfig>