On 02/27/11 4:07 PM, Andrew Sullivan wrote:
> Multi-master transactional ACID-type databases with multiple masters is very hard.
>
indeed.
Oracle RAC works by having a distributed cache and locking manager
replicating over a fast bus like infininet. oracle fundamentally uses
a transaction redo log rather than a write-ahead log like postgres, this
is somewhat more amendable to distributed processing when combined with
the distributed cache and lock.
The trade-off is, its a really complicated and fragile system, with a
high opportunity for catastrophic failure. It seems to me like Oracle
wants to sell turnkey database servers with their Exadata stuff.