Message-ID: <4D1D912D.7070106@kaltenbrunner.cc>
Date: Fri, 31 Dec 2010 09:15:41 +0100
From: Stefan Kaltenbrunner <stefan@kaltenbrunner.cc>
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US;
	rv:1.9.1.15) Gecko/20101030 Iceowl/1.0b1 Icedove/3.0.10
MIME-Version: 1.0
To: Simon Riggs <simon@2ndQuadrant.com>
CC: Robert Treat <rob@xzilla.net>, pgsql-hackers@postgresql.org
Subject: Re: Sync Rep Design
References: <1293729972.1892.23804.camel@ebony>	
	<4D1CC47E.7050207@kaltenbrunner.cc>
	<1293735853.1892.24886.camel@ebony>	
	<AANLkTi=dr9TuYRLMWjPkJdL1Jjg+TAJXPJQbLGiN1Pag@mail.gmail.com>	
	<1293741390.1892.25918.camel@ebony>	
	<AANLkTim3mEVaP9eJsqticw600sSomHhJgsQVgjoDxASA@mail.gmail.com>	
	<1293742878.1892.26205.camel@ebony>
	<4D1CF4E2.5000208@kaltenbrunner.cc>
	<1293744431.1892.26514.camel@ebony>
In-Reply-To: <1293744431.1892.26514.camel@ebony>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

On 12/30/2010 10:27 PM, Simon Riggs wrote:
> On Thu, 2010-12-30 at 22:08 +0100, Stefan Kaltenbrunner wrote:
>> On 12/30/2010 10:01 PM, Simon Riggs wrote:
>>> On Thu, 2010-12-30 at 15:51 -0500, Robert Treat wrote:
>>>
>>>> Still, one thing that has me concerned is that in the case of two
>>>> slaves, you don't know which one is the more up-to-date one if you
>>>> need to failover. It'd be nice if you could just guarantee they both
>>>> are...
>>>
>>> Regrettably, nobody can know that, without checking.
>>
>> how exactly would you check? - this seems like something that needs to
>> be done from the SQL and the CLI level and also very well documented
>> (which I cannot see in your proposal).
>
> This is a proposal for sync rep, not multi-node failover. I'm definitely
> not going to widen the scope of this project.
>
> Functions already exist to check the thing you're asking.

well your proposal includes a lot of stuff on how to avoid dataloss and 
getting High Availability - so I think it is a requirement for us to 
tell the DBA what the procedures are for both setting it up (which is 
what is in the docs - but only 50% of the thing) and what to do in the 
case of a desaster (which is the other part of the problem).
Or said otherwise - sync rep is not very useful if there is no easy and 
reliable way to get that information, if that stuff is already available 
even better but I'm not aware of what is there and what not, so I expect 
others to have the same problem.


Stefan