Re: PostgreSql replication and load balancing ( is Slony-I a solution?)

Поиск
Список
Период
Сортировка
От Jan Bilek
Тема Re: PostgreSql replication and load balancing ( is Slony-I a solution?)
Дата
Msg-id 003201c78c3f$14f29920$0100a8c0@ook
обсуждение исходный текст
Ответ на PostgreSql replication and load balancing ( is Slony-I a solution?)  ("Jan Bilek" <bilekj@gmail.com>)
Список pgsql-general
> On 5/1/07, Jan Bilek <bilekj@gmail.com> wrote:
>> Is Slony-I capable of load balancing and how to set it up? We searched
>> the
>> web and some people mentioned that Slony-I could do load balancing, but
>> haven't found how to make Slony-I to do it.
>
> Slony does not do load balancing. Personally, I recommend doing the
> load balancing in the application if possible; you will need to funnel
> updates to the master and distribute queries to the slaves, and the
> app is in the best position to determine whether something is an
> update or a query. Any intermediate middleware is going to add
> additional latency and overhead and will add just another single point
> of failure to an already complex system.
>
> Alexander.

Thanks for info.



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

Предыдущее
От: Reece Hart
Дата:
Сообщение: Re: IF function?
Следующее
От: novnov
Дата:
Сообщение: Re: IF function?