mycat读写分离

<?xml version="1.0"?>

<!DOCTYPE mycat:schema SYSTEM "schema.dtd">

<mycat:schema xmlns:mycat="http://org.opencloudb/">

<schema name="TESTDB" checkSQLschema="false" sqlMaxLimit="100" dataNode="dn1">

</schema>

<dataNode name="dn1" dataHost="localhost1" database="db1" />

<dataHost name="localhost1" maxCon="1000" minCon="10" balance="1"

writeType="0" dbType="oracle" dbDriver="jdbc">

<heartbeat>select 1 from  dual</heartbeat>

<!-- can have multi write hosts -->

<writeHost host="192.168.7.111" url="jdbc:oracle:thin:@192.168.7.111:1521/oracle" user="charge_baotoureli" password="charge_baotoureli">

        

             <readHost host="192.168.7.146" url="jdbc:oracle:thin:@192.168.7.146:1521/oracle" user="charge_baotoureli" password="charge_baotoureli" />

        </writeHost>

</dataHost>

</mycat:schema>