Re: Sync Rep Design

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