public inbox for [email protected]  

help / color / mirror / Atom feed

From: Achilleas Mantzios <[email protected]>
To: [email protected]
Subject: Re: PostgreSQL Active-Active Clustering
Date: Tue, 16 Jul 2024 08:26:55 +0300
Message-ID: <[email protected]> (raw)
In-Reply-To: <CANzqJaBA=iJ+vadW=d1b=12KCM5Aj_RDYHVZ13GDwo2jwdzR+g@mail.gmail.com>
References: <PN0PR01MB9069922B90966633C8183C5AC5A12@PN0PR01MB9069.INDPRD01.PROD.OUTLOOK.COM>
	<PN0PR01MB90693B1DF528D64769D81B91C5A12@PN0PR01MB9069.INDPRD01.PROD.OUTLOOK.COM>
	<[email protected]>
	<CANzqJaBA=iJ+vadW=d1b=12KCM5Aj_RDYHVZ13GDwo2jwdzR+g@mail.gmail.com>

Στις 15/7/24 22:55, ο/η Ron Johnson έγραψε:
> 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.
IMHO IBM did something similar with their shared DASDi back in 70s+. 
There was serialization mechanism enabling concurrent writes to data 
sets (meaning files). Not to mention IBM had great VM technology back in 
the day.
>
> (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.
>
-- 
Achilleas Mantzios
  IT DEV - HEAD
  IT DEPT
  Dynacom Tankers Mgmt (as agents only)

view thread (5+ messages)

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: <[email protected]>

* 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