Re: Sync Rep Design
Robert Haas <robertmhaas@gmail.com>
From: Robert Haas <robertmhaas@gmail.com>
To: Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>
Cc: Simon Riggs <simon@2ndquadrant.com>, Josh Berkus <josh@agliodbs.com>, Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>, Hannu Krosing <hannu@2ndquadrant.com>, greg@2ndquadrant.com, pgsql-hackers@postgresql.org
Date: 2011-01-04T19:54:04Z
Lists: pgsql-hackers
On Tue, Jan 4, 2011 at 2:50 PM, Stefan Kaltenbrunner <stefan@kaltenbrunner.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