Re: Real application clustering in postgres.

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: Real application clustering in postgres.
Дата
Msg-id 29d192b7b0b198b5e1253fac35e7654331614053.camel@cybertec.at
обсуждение исходный текст
Ответ на Re: Real application clustering in postgres.  (Ron <ronljohnsonjr@gmail.com>)
Ответы Re: Real application clustering in postgres.
Re: Real application clustering in postgres.
Re: Real application clustering in postgres.
Список pgsql-general
On Fri, 2020-03-06 at 03:25 -0600, Ron wrote:
> > RAC is not really a high availability solution: because of the shared
> > storage, it has a sibgle point of failure.   
> 
> This is utter nonsense.  Dual redundant storage controllers
> connected to disks in RAID-10 configurations have been around for at
> least 25 years.
> 
> Oracle got it's clustering technology from DEC, and I know
> that works.  Cluster members, storage controllers and disks have all
> gone down, while the database and application keep on humming along.

I am not saying that it is buggy, it is limited by design.

If you have mirrored disks, and you write junk (e.g, because of
a flaw in a fibre channel cable, something I have witnessed),
then you have two perfectly fine copies of the junk.

I am not saying the (physical) disk is the single point of failure, the
(logical) file system is (Oracle calls it ASM / tablespace, but it is
still a file system).

Yours,
Laurenz Albe




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

Предыдущее
От: Andrei Zhidenkov
Дата:
Сообщение: Limit transaction lifetime
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: How to allow users to create and modify tables only in theirown schemas, but with generic table owner