Re: 2-phase commit

Поиск
Список
Период
Сортировка
От Marc G. Fournier
Тема Re: 2-phase commit
Дата
Msg-id 20030927091156.F711@ganymede.hub.org
обсуждение исходный текст
Ответ на Re: 2-phase commit  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: 2-phase commit  (Andrew Sullivan <andrew@libertyrms.info>)
Список pgsql-hackers

On Sat, 27 Sep 2003, Tom Lane wrote:

> Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
> >> ... You can make this work, but the resource costs
> >> are steep.
>
> > So, after 'n' seconds of waiting, we abandon the slave and the slave
> > abandons the master.
>
> [itch...]  But you surely cannot guarantee that the slave and the master
> time out at exactly the same femtosecond.  What happens when the comm
> link comes back online just when one has timed out and the other not?
> (Hint: in either order, it ain't good.

I think it was Andrew that suggested it ... when the slave timesout, it
should "trigger" a READ ONLY mode on the slave, so that when/if the master
tries to start to talk to it, it can't ...

As for the master itself, it should be smart enough that if it times out,
it knows to actually abandom the slave and not continue to try ...


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: initdb failure (was Re: [GENERAL] sequence's plpgsql)
Следующее
От: "mlg7"
Дата:
Сообщение: Re: PL contribution guidelines?