mycat读写分离

<?xml version="1.0"?>
<!DOCTYPE mycat:schema SYSTEM "schema.dtd">
<mycat:schema xmlns:mycat="http://io.mycat/">

<!-- 数据库配置，与server.xml中的数据库对应 -->
    <schema name="wordpress" checkSQLschema="false" sqlMaxLimit="100" dataNode="dn1">
    </schema>

<!-- 分片配置 -->
    <dataNode name="dn1" dataHost="test1" database="wordpress" />


<!-- 物理数据库配置 -->
    <dataHost name="test1" maxCon="1000" minCon="10" balance="3"  writeType="0" dbType="mysql" dbDriver="native">
        <heartbeat>select user();</heartbeat>
        <writeHost host="hostM1" url="192.168.1.190:3306" user="qiu" password="123qqq...A">
        <readHost host="hostS1" url="192.168.1.193:3306" user="qiu" password="123qqq...A">
        </readHost>
       </writeHost>
        <writeHost host="hostM2" url="192.168.1.191:3306" user="qiu" password="123qqq...A">
        <readHost host="hostS2" url="192.168.1.194:3306" user="qiu" password="123qqq...A">
        </readHost>
       </writeHost>
        <writeHost host="hostM3" url="192.168.1.192:3306" user="qiu" password="123qqq...A">
        <readHost host="hostS3" url="192.168.1.195:3306" user="qiu" password="123qqq...A">
        </readHost>
       </writeHost>
    </dataHost>
</mycat:schema>