Re: Would you ever recommend Shared Disk Failover for HA?

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: Would you ever recommend Shared Disk Failover for HA?
Дата
Msg-id fa2bd3bec91dcf0c206931a3cfc0f31a46a6ea44.camel@cybertec.at
обсуждение исходный текст
Ответ на Re: Would you ever recommend Shared Disk Failover for HA?  (Ron Johnson <ronljohnsonjr@gmail.com>)
Список pgsql-admin
On Fri, 2024-02-23 at 02:21 -0500, Ron Johnson wrote:
> On Fri, Feb 23, 2024 at 2:02 AM Laurenz Albe <laurenz.albe@cybertec.at> wrote:
> [snip] 
> >
> > Anyway, my personal experience with a shared disk setup is a bad one.
> >
> > Imagine two nodes, redundantly attached to disks mirrored across data
> > centers with fibrechannel.  No single point of failure, right?
> > Well, one day one of the fibrechannel cables had intermittent failures,
> > which led to a corrupted file system.
> > So we ended up with a currupted file system, nicely mirrored across
> > data centers.  We had to restore the 3TB database from backup.
>
> 1. Sounds like both nodes were turned on.

Possible, but I think that's not relevant.

> 2. Couldn't this happen in /any/ SAN with redundant cabling?

I'd say yes, and the redundant cabling is irrelevant too - I just
wanted to emphasize that hardware redundancy is not enough.

The single point of failure was the file system.

Yours,
Laurenz Albe



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

Предыдущее
От: Gabriel Guillem Barceló Soteras
Дата:
Сообщение: Re: Use AD-account as login into Postgres.
Следующее
От: Julien Rouhaud
Дата:
Сообщение: Re: print cached SQL plans of a backend