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>