- 论坛徽章:
- 0
|
回复 36# luwenju
今天又研究了下关于切换的问题,如果你设置的主从,这样切换会出现问题,应为如果主停掉,由于default pool中只有一个master,所以会报如下错误:
mysql> java.lang.Exception: poolName=master, no valid pools
at com.meidusa.amoeba.net.poolable.MultipleLoadBalanceObjectPool.borrowObject(MultipleLoadBalanceObjectPool.java:174)
at com.meidusa.amoeba.mysql.handler.CommandMessageHandler.startSession(CommandMessageHandler.java:571)
at com.meidusa.amoeba.mysql.handler.MySqlCommandDispatcher.handleMessage(MySqlCommandDispatcher.java:104)
at com.meidusa.amoeba.mysql.net.MysqlClientConnection$2.run(MysqlClientConnection.java:231)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:90
at java.lang.Thread.run(Thread.java:619)
因为你的那个pool没有可用的机器,又是你的default pool设置所以出现问题,解决办法是设置成主主同步,在master上设置两台mysql主服务器,这样如果一台出现问题就会把写入操作都转换到另外一台,当故障的主机回复以后又会两个都会写入!测试的结果是几秒就能完成切换,很快,不影响服务!配置如下:
<dbServer name="master" virtual="true">
<poolConfig class="com.meidusa.amoeba.server.MultipleServerPool">
<property name="loadbalance">1</property>
<property name="poolNames">server1,server2</property>
</poolConfig>
</dbServer>
<dbServer name="slave" virtual="true">
<poolConfig class="com.meidusa.amoeba.server.MultipleServerPool">
<property name="loadbalance">1</property>
<property name="poolNames">server1,server2</property>
</poolConfig>
</dbServer> |
|