Re:An Overview of Distributed PostgreSQL Architectures
by pi-e-sigma on Tuesday January 09, 2024 @10:02AM
(#38926947)
To this day only Oracle RAC provides true active-active cluster. All the other things are not real clusters, just replications.
[ Parent
| on HN ]
Re:An Overview of Distributed PostgreSQL Architectures
by sargun on Tuesday January 09, 2024 @12:01PM
(#38928517)
err, CockroachDB would like a word... Although, I'm not sure if its just data serving that's active-active, or query execution is distributed.
Also, Cassandra is active-active as well.
I'm sure there are others, but I'm less familiar with them (Yugabyte, Couchbase, etc..)
Re:An Overview of Distributed PostgreSQL Architectures
by pi-e-sigma on Tuesday January 09, 2024 @12:46PM
(#38929207)
Active-active is when you don't have any replicas, you have just one data store and multiple 'engines' accessing it. So there is no replication, because there is nothing to replicate. So CockroachDB is definitively not active-active, despite their claims to the otherwise; what they call active-active is two-way synchronous replication, which is worse than asynchronous replication because of the latency and worse than Oracle RAC active-active because it's less fail-tolerant. In Oracle RAC your cluster is up and running even if just one engine is still alive, in CockroachDB approach when you lose majority of nodes the cluster goes down.
Obviously Oracle RAC active-active has it's own downsides, too, but it's another topic.
EDIT to expand: Think about a SQL transaction. In Oracle RAC it gets picked up by any of the nodes and is executed by this node. All the other nodes see updated data immediately. In CockroachDB the same transaction would need to be executed by each of the nodes separately plus the overhead of communication between the nodes.
Re:An Overview of Distributed PostgreSQL Architectures
by NavinF on Tuesday January 09, 2024 @03:43PM
(#38931836)
> In Oracle RAC your cluster is up and running even if just one engine is still alive
So it's not consistent in the CAP Theorem sense. Comparing it with other databases that don't lose writes and don't have split brain issues makes no sense
Re:An Overview of Distributed PostgreSQL Architectures
by pi-e-sigma on Tuesday January 09, 2024 @04:08PM
(#38932123)
It is always consistent because it is a single storage database with multiple access points. It's not distributed data so CAP theorem doesn't even apply to it.
Re:An Overview of Distributed PostgreSQL Architectures
by dikei on Tuesday January 09, 2024 @09:53PM
(#38935558)
Oracle RAC is a shared storage system, every database instances write to same datastore, so as long as a transaction is committed by one node, it'll be seen by other nodes.
Of course, the issue with all shared-storage systems is how much it costs to have a reliable and fast shared storage.
Re:An Overview of Distributed PostgreSQL Architectures
by franckpachot on Wednesday January 10, 2024 @02:15AM
(#38937183)
You have a misconception about CockroachDB and YugabyteDB architecture. It is not 2-way replication. It writes to a Raft group. The transaction can be picked up by any node because the transaction intents are also replicated. The main difference with RAC is that the current version of a row is read/write on the Raft Leader, replicated to followers (that can be elected new leader). In RAC, the block with current version of a row is moved back and forth between the instance. That's possible only with reliable, short distance, dedicated network. Distributed SQL can scale out to multiple availability zones. Not RAC