public inbox for [email protected]
help / color / mirror / Atom feedFrom: Ron Johnson <[email protected]>
To: [email protected] <[email protected]>
Subject: Re: PostgreSQL Active-Active Clustering
Date: Mon, 15 Jul 2024 15:55:19 -0400
Message-ID: <CANzqJaBA=iJ+vadW=d1b=12KCM5Aj_RDYHVZ13GDwo2jwdzR+g@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <PN0PR01MB9069922B90966633C8183C5AC5A12@PN0PR01MB9069.INDPRD01.PROD.OUTLOOK.COM>
<PN0PR01MB90693B1DF528D64769D81B91C5A12@PN0PR01MB9069.INDPRD01.PROD.OUTLOOK.COM>
<[email protected]>
On Mon, Jul 15, 2024 at 3:28 PM Christophe Pettus <[email protected]> wrote:
>
> > On Jul 15, 2024, at 12:06, Sarkar, Subhadeep <[email protected]>
> wrote:
> >
>
[snip]
> > • In the Community edition of PostgreSQL is it possible to setup a
> cluster where all the nodes are able to concurrently read-write the
> underlying database image using NATIVE features (i.e. without using any
> extensions or external components or usage of Kubernetes/Dockers).
>
[snip]
> No product, either commercial or open-source, provides the last one
> (read-write shared storage), although there are commercial products that
> provide for a shared-storage model single-writer, multiple-reader model
> (for example, Amazon Aurora).
>
This "lack of products" puzzles me, because DEC was doing this with VAX
(then Alpha and Itanium) clusters 40 years ago via a Distributed Lock
Manager integrated deep into VMS. Their Rdb and (CODASYL) DBMS products
used those functions extensively.
(In the late 1990s, they sold the DLM code to Oracle, which is where RAC
comes from.)
It was shared-disk, multiple-writer, because the DLM allowed for locking at
the row level. Thus, a half dozen cluster nodes could hold write locks on
different rows on the same data page.
view thread (5+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: PostgreSQL Active-Active Clustering
In-Reply-To: <CANzqJaBA=iJ+vadW=d1b=12KCM5Aj_RDYHVZ13GDwo2jwdzR+g@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox