1 <queryRouter class="com.meidusa.amoeba.mysql.parser.MysqlQueryRouter"> 2 <property name="ruleLoader"> 3 <bean class="com.meidusa.amoeba.route.TableRuleFileLoader"> 4 <property name="ruleFile">${amoeba.home}/conf/rule.xml</property> 5 <property name="functionFile">${amoeba.home}/conf/ruleFunctionMap.xml</property> 6 </bean> 7 </property> 8 <property name="sqlFunctionFile">${amoeba.home}/conf/functionMap.xml</property> 9 <property name="LRUMapSize">1500</property> 10 <property name="defaultPool">multiPool</property> 11 12 13 <property name="writePool">server2</property> 14 <property name="readPool">server1</property> 15 16 <property name="needParse">true</property> 17 </queryRouter>
在writePool,readPool中配置读写对应的数据源。Amoeba 会自动识别是update,delete,insert 还是 select,然后自动路由到对应的数据源
1 <property name="writePool">server2</property> 2 <property name="readPool">server1</property>