Re: Automatic Client Failover

From: Markus Wanner <markus(at)bluegap(dot)ch>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: Hannu Krosing <hannu(at)krosing(dot)net>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, josh(at)agliodbs(dot)com, Dimitri Fontaine <dfontaine(at)hi-media(dot)com>, "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Automatic Client Failover
Date: 2008-08-05 10:30:13
Message-ID: 48982BB5.2070102@bluegap.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2008-08-05 10:40:30 Re: plan invalidation vs stored procedures
Previous Message Markus Wanner 2008-08-05 10:21:39 Re: Automatic Client Failover