Re: Fault Tolerant Postgresql (two machines, two postmasters, one disk array)

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Fault Tolerant Postgresql (two machines, two postmasters, one disk array)
Дата
Msg-id 464CC14F.30000@cox.net
обсуждение исходный текст
Ответ на Re: Fault Tolerant Postgresql (two machines, two postmasters, one disk array)  (Andrew Sullivan <ajs@crankycanuck.ca>)
Ответы Re: Fault Tolerant Postgresql (two machines, two postmasters, one disk array)  (PFC <lists@peufeu.com>)
Re: Fault Tolerant Postgresql (two machines, two postmasters, one disk array)  (Andrew Sullivan <ajs@crankycanuck.ca>)
Список pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 05/17/07 09:35, Andrew Sullivan wrote:
[snip]
>
> The problems come when you get a false detection of machine failure.
> Consider a case, for instance, where the machine A gets overloaded,
> goes into swap madness, or has a billion runaway processes that cause
> it to stagger.  In this case, A might not respond in time on the
> heartbeat monitor, and then the standby machine B thinks A has
> failed.  But A doesn't know that, of course, because it is working as
> hard as it can just to stay up.  Now, if B mounts the disk and starts
> the postmaster, but doesn't have a way to make _sure_ tha A is
> completely disconnected from the disk, then it's entirely possible A
> will flush buffers out to the still-mounted data area.  Poof!
> Instant data corruption.

Aren't there PCI heartbeat cards that are independent of the load on
the host machine?

- --
Ron Johnson, Jr.
Jefferson LA  USA

Give a man a fish, and he eats for a day.
Hit him with a fish, and he goes away for good!

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFGTMFPS9HxQb37XmcRAgY7AJ9rJqy0XP01ubb4HqZwBUcBHplmwQCeM5wj
gXKTp80exZQhR9ZTbgq7Ejg=
=7Rkx
-----END PGP SIGNATURE-----

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

Предыдущее
От: Ron Johnson
Дата:
Сообщение: Re: Large Database Restore
Следующее
От: Paul Ramsey
Дата:
Сообщение: 8.0, UTF8, and CLIENT_ENCODING