972
社区成员




<?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="dn1">
</schema>
<dataNode name="dn1" dataHost="localhost1" database="sunftdb" />
<dataHost name="localhost1" maxCon="1000" minCon="10" balance="1" writeType="1"
dbType="postgresql" dbDriver="jdbc" switchType="1" slaveThreshold="100">
<heartbeat>select 1</heartbeat>
<!-- can have multi write hosts -->
<writeHost host="hostM1" url="jdbc:postgresql://100.10.1.1:5432/sunftdb" user="root" password="123456">
<!-- can have multi read hosts -->
<readHost host="hostS1" url="jdbc:postgresql://100.10.1.2:5432/sunftdb" user="root" password="123456" />
</writeHost>
<writeHost host="hostM2" url="jdbc:postgresql://100.10.1.2:5432/sunftdb" user="root" password="123456"/>
</dataHost>
</mycat:schema>