Re: performance problem of Failover Datasource?

Поиск
Список
Период
Сортировка
От Chen Huajun
Тема Re: performance problem of Failover Datasource?
Дата
Msg-id 50D82DD5.5020903@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

I have made a new patch(with my test). Please give a look.
It support the following features
1) performance improve for fail over by avoiding dead hosts.
2) simple load balance by picking up the first host from multiple valid hosts randomly.
3) ability of choosing master or slave to connect to.

And in the patch, three connection parameters were added.

targetServerType = String
Specifies what kind of server to connect.The value should be one of the following:
  any
  master
  slave
  slavefirst (Try connecting to the slaves first.If failed try the master)
The default is 'any'.

enableLoadBalance = boolean
Enable or disable load balance when multiple hosts were specified;If load balance is enabled,specified multiple hosts
willbe picked up randomly. 
The default is false.

failedHostCheckPeriod = int
Specifies period(seconds) to check whether the failed hosts had been repaired, when load balance is enabled; 0 means
nevercheck. 
The default is 600 seconds.


(2012/12/18 8:05), Chen Huajun wrote:
>
> Thanks for you advise.
> I will try to made a new patch and add load balance supporting.
>
>

--
Best Regards,
Chen Huajun


Вложения

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [BUGS] BUG #7766: Running a DML statement that affects more than 4 billion rows results in an exception
Следующее
От: Scott Harrington
Дата:
Сообщение: Re: performance problem of Failover Datasource?