<dataNode name="dn1" dataHost="localhost1" database="test" />
<!-- 定义数据节点,包括了各种逻辑项的配置 -->
<dataHost name="localhost1" maxCon="1000" minCon="10" balance="0" writeType="0" dbType="mysql" dbDriver="native" switchType="1" slaveThreshold="100">
<!-- 配置真实MySQL与MyCat的心跳 -->
<heartbeat>select user()</heartbeat>
<!-- 配置真实的MySQL的连接路径 -->
<writeHost host="hostMaster" url="192.168.1.196:3306" user="root" password="123456">
<readHost host="hostSlave" url="192.168.1.168:3306" user="root" password="123456"/>
</writeHost>
</dataHost>
对于读写分离的配置中:
设置readHost读取:balance=3,
设置writeHost与ReadHost共同分担读取:balance=2
签名:这个人很懒,什么也没有留下!