Re: Sync Rep Design

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>, Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, Hannu Krosing <hannu(at)2ndquadrant(dot)com>, greg(at)2ndquadrant(dot)com, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Sync Rep Design
Date: 2011-01-04 19:54:04
Message-ID: AANLkTi=zqkCSHLL8XfBgUpVcXcjZXtHREJ9UPJ3LapLu@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Jan 4, 2011 at 2:50 PM, Stefan Kaltenbrunner
<stefan(at)kaltenbrunner(dot)cc> wrote:
> On 01/04/2011 07:51 PM, Simon Riggs wrote:
>>
>> On Tue, 2011-01-04 at 10:28 -0800, Josh Berkus wrote:
>>
>>> The relevant question is: which configuration(s) can we have ready for
>>> the next CommitFest and alpha release?
>>
>> Based upon that series of conversations, I've reworked the design so
>> that there is (currently) only a single standby offering sync rep at any
>> one time. Other standbys can request to be sync standbys but they only
>> become the sync standby if the first one fails. Which was simple to do
>> and bridges the challenges of an exactly identified sync standby and the
>> fragility of too closely specifying the config.
>
> ah cool - like that approach for 9.1!

Yeah, I like that idea too, on first blush. I think we should think
it over and see whether we're committing ourselves to any design
decisions we may later regret - what parameters will we need to add
from that point to get all the configs we ultimately want to support?
But it seems a reasonable starting point, and we can argue about the
rest once we have working code.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2011-01-04 19:56:55 Re: system views for walsender activity
Previous Message David E. Wheeler 2011-01-04 19:53:42 Re: Upgrading Extension, version numbers