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.
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