mycat做读写分离，schema.xml

//schema.xml
<?xml version="1.0"?>
<!DOCTYPE mycat:schema SYSTEM "schema.dtd">
<mycat:schema xmlns:mycat="http://io.mycat/">
        <schema name="bds-oneaccept-new" checkSQLschema="false" sqlMaxLimit="100" dataNode="dn1"/>
        <dataNode name="dn1" dataHost="ywtb" database="bds-oneaccept-new" />
        <dataHost name="ywtb" maxCon="1000" minCon="10" balance="4"
                          writeType="0" dbType="mysql" dbDriver="jdbc" switchType="1"  slaveThreshold="100">
                <heartbeat>select user()</heartbeat>
                <writeHost host="hostM1" url="jdbc:mysql://10.*****:3306" user="root" password="root@123" >
                        <readHost host="hostS1" url="jdbc:mysql://10.*****:3306" user="root" password="root@123"/>
                </writeHost>
        </dataHost>
</mycat:schema>

　　

　　

//server.xml
<user name="root" defaultAccount="true">
                <property name="password">root@123</property>
                <property name="schemas">bds-oneaccept-new</property>
                <property name="defaultSchema">bds-oneaccept-new</property>
                <!--No MyCAT Database selected 错误前会尝试使用该schema作为schema，不设置则为null,报错 -->

                <!-- 表级 DML 权限设置 -->
                <!--            
                <privileges check="false">
                        <schema name="TESTDB" dml="0110" >
                                <table name="tb01" dml="0000"></table>
                                <table name="tb02" dml="1111"></table>
                        </schema>
                </privileges>           
                 -->
</user>