Re: performance problem of Failover Datasource?

Поиск
Список
Период
Сортировка
От Chen Huajun
Тема Re: performance problem of Failover Datasource?
Дата
Msg-id 50CC2279.3090301@cn.fujitsu.com
обсуждение исходный текст
Ответ на Re: performance problem of Failover Datasource?  (Chen Huajun <chenhj@cn.fujitsu.com>)
Ответы Re: performance problem of Failover Datasource?  (Scott Harrington <scotth01@sns-usa.com>)
Список pgsql-jdbc
Hi

In this patch,I use Collections.synchronizedSet to synchronize within multi-threads.
But i worry about locking operation is a litter frequent by Collections.synchronizedSet
  and may affect performance.
I think using keword "synchronized" explicitly instead of Collections.synchronizedSet
  may reduce times of locking.Is there any better suggestion?


In addition, I have a idea.
By adjusting the order of hosts we also can implement a simple load balance
while all of the hosts are master or read only slave.
For example:
Basically pick up the server randomly.If one server had dead remove it from the candidates,
and retry the next server.
And after a while(can be configured) re-add the dead host to the candidates because the dead
server may had been repaired.


What about that?



(2012/12/14 21:29), Chen Huajun wrote:
> Hi
>
> I had make the patch,Please check it.
>
> and I had run the testcases,the result is same as before modified.
>
>
>
>
>

--
Best Regards,
Chen Huajun




В списке pgsql-jdbc по дате отправления:

Предыдущее
От: dmp
Дата:
Сообщение: Re: Fwd: [ADMIN] Confuse about the behaveior of PreparedStatement.executeBatch (jdbc)
Следующее
От: Scott Harrington
Дата:
Сообщение: Re: performance problem of Failover Datasource?