mysql数据库读写分离方案

# MyCAT配置文件 server.xml
<server>
    <system>
        <property name="useSqlStat">1</property>
        <property name="useGlobleTableCheck">0</property>
        <property name="sequnceHandlerType">2</property>
        <property name="useSchemaSync">0</property>
    </system>

    <user name="root" defaultAccount="true">
        <property name="password">root_password</property>
        <property name="schemas">testdb</property>
    </user>

    <schema name="testdb" checkSQLschema="false" sqlMaxLimit="100">
        <table name="t_user" dataNode="dn1,dn2" rule="mod-long"/>
    </schema>

    <dataNode name="dn1" dataHost="host1" database="db1" />
    <dataNode name="dn2" dataHost="host2" database="db2" />

    <dataHost name="host1" maxCon="1000" minCon="10" balance="0" writeType="0" dbType="mysql" dbDriver="native" switchType="1" slaveThreshold="100">
        <heartbeat>select user()</heartbeat>
        <writeHost host="master1" url="master1_ip:3306" user="root" password="root_password" />
        <writeHost host="slave1" url="slave1_ip:3306" user="root" password="root_password" />
    </dataHost>

    <dataHost name="host2" maxCon="1000" minCon="10" balance="0" writeType="0" dbType="mysql" dbDriver="native" switchType="1" slaveThreshold="100">
        <heartbeat>select user()</heartbeat>
        <writeHost host="master2" url="master2_ip:3306" user="root" password="root_password" />
        <writeHost host="slave2" url="slave2_ip:3306" user="root" password="root_password" />
    </dataHost>
</server>