mycat读写分离

server.xml文件(只需更改,登录mycat的管理员和普通用户)

<user name="root">

<property name="password">123456</property>

<property name="schemas">v_mysql</property>

<!-- 表级 DML 权限设置 -->

<!--

<privileges check="false"> <schema name="TESTDB" dml="0110" > <table name="tb01" dml="0000"></table> <table name="tb02" dml="1111"></table> </schema> </privileges>

-->

</user>

<user name="user">

<property name="password">user</property>

<property name="schemas">v_mysql</property>

<property name="readOnly">true</property>

</user>



schema.xm文件

<mycat:schema xmlns:mycat="http://io.mycat/">
<schema name="v_mysql" checkSQLschema="false" sqlMaxLimit="100" dataNode="dn1"></schema>
<dataNode name="dn1" dataHost="mysql1" database="mysql"/>
<dataHost name="mysql1" maxCon="1000" minCon="10" balance="3" writeType="0" dbType="mysql" dbDriver="native" switchType="1" slaveThreshold="100">
<heartbeat>select user()</heartbeat>
<!--  can have multi write hosts  -->
<writeHost host="hostM1" url="192.168.1.50:3306" user="root" password="toor">
<!--  can have multi read hosts  -->
<readHost host="hostS1" url="192.168.1.53:3306" user="read" password="123456"/>
<readHost host="hostS2" url="192.168.1.54:3306" user="read" password="123456"/>
<readHost host="hostS3" url="192.168.1.55:3306" user="read" password="123456"/>
<readHost host="hostS4" url="192.168.1.56:3306" user="read" password="123456"/>
</writeHost>
</dataHost>
</mycat:schema>