Re: PG on two nodes with shared disk ocfs2 & drbd

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: PG on two nodes with shared disk ocfs2 & drbd
Date: 2011-02-28 00:34:42
Message-ID: 4D6AEDA2.6050202@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2011-02-28 01:39:24 Re: Binary params in libpq
Previous Message Michael Harris 2011-02-28 00:25:02 ERROR: missing chunk number 0 for toast value 382548694 in pg_toast_847386