schema.xml配置
<schema name="TESTDB" checkSQLschema="false" sqlMaxLimit="100" dataNode="dn1"></schema> <dataNode name="dn1" dataHost="localhost1" database="rw_test"/> <dataHost name="localhost1" maxCon="1000" minCon="10" balance="3" writeType="0" dbType="mysql" dbDriver="native" switchType="1" slaveThreshold="100"> <heartbeat>select user()</heartbeat> <writeHost host="hostM1" url="192.168.181.101:3306" user="root" password="root"> <readHost host="hostS2" url="192.168.181.102:3306" user="root" password="root"/> <readHost host="hostS3" url="192.168.181.106:3306" user="root" password="root"/> </writeHost> </dataHost>
schema:因为没有分片,所以直接配置 dataNode="dn1" dataNode:指定真实的数据库 dataHost: balance:1 0:读操作也都发到w上, 1:读操作都发到r上 2:读操作随机发到w和r上 writeType:0 0:写操作发到w上 1:写操作随机发到r上 2:写操作随机发到r和w上
server.xml配置 <user name="user_w"> <property name="password">123456</property> <property name="schemas">TESTDB</property> </user> <user name="user_r"> <property name="password">123456</property> <property name="schemas">TESTDB</property> <property name="readOnly">true</property> </user>
user_w/user_w:并不是mysql真实的用户,这里是指连接mycat用的 TESTDB:mycat虚拟的数据库,和schemal对应即可
|