Re: Automatic Client Failover - Mailing list pgsql-hackers

From Markus Wanner
Subject Re: Automatic Client Failover
Date
Msg-id 48982BB5.2070102@bluegap.ch
Whole thread Raw
In response to Re: Automatic Client Failover  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
Hi,

Simon Riggs wrote:
> On Tue, 2008-08-05 at 11:50 +0300, Hannu Krosing wrote:
>> I guess having the title "Automatic Client Failover" suggest to most
>> readers, that you are trying to solve the client side separately from
>> server. 
> 
> Yes, that's right: separately. Why would anybody presume I meant "and by
> the way you can turn off all other HA measures not mentioned here"? Not
> mentioning a topic means no change or no impact in that area, at least
> on all other hackers threads.

I think the pgbouncer-in-core idea caused some confusion here.

IMO the client failover method is very to what DNS round-robin setups do 
for webservers: even if clients might failover 'automatically', you 
still have to maintain the server states (which servers do you list in 
the DNS?) and care about 'replication' of your site to the webservers.

Regards

Markus Wanner



pgsql-hackers by date:

Previous
From: Markus Wanner
Date:
Subject: Re: Automatic Client Failover
Next
From: "Pavel Stehule"
Date:
Subject: Re: plan invalidation vs stored procedures