读写分离
<?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>
<schema name="TMPDB" checkSQLschema="false" sqlMaxLimit="100" dataNode="dn2">
</schema>
<dataNode name="dn1" dataHost="node1" database="test" />
<dataNode name="dn2" dataHost="node1" database="tmp" />
<dataHost name="node1" maxCon="1000" minCon="10" balance="2" writeType="0" dbType="mysql" dbDriver="native" switchType="1">
<heartbeat>select user()</heartbeat>
<writeHost host="master1" url="172.16.40.58:3306" user="root" password="mysql*()">
<readHost host="slave1" url="172.16.20.11:3306" user="root" password="mysql*()" />
</writeHost>
</dataHost>
</mycat:schema>
