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

From Jan Bilek
Subject Re: PostgreSql replication and load balancing ( is Slony-I a solution?)
Date
Msg-id 003201c78c3f$14f29920$0100a8c0@ook
Whole thread Raw
In response to PostgreSql replication and load balancing ( is Slony-I a solution?)  ("Jan Bilek" <bilekj@gmail.com>)
List 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 by date:

Previous
From: Reece Hart
Date:
Subject: Re: IF function?
Next
From: novnov
Date:
Subject: Re: IF function?