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>