Re: Parallel databases? - Mailing list pgsql-general

From Colin Smith
Subject Re: Parallel databases?
Date
Msg-id Pine.LNX.4.10.10004151350400.1791-100000@Orlanth.homenetwork
Whole thread Raw
In response to Re: Parallel databases?  (Colin Smith <colin@yelm.freeserve.co.uk>)
List pgsql-general
On Sat, 15 Apr 2000, Colin Smith wrote:

> On Fri, 14 Apr 2000, A James Lewis wrote:
>
> >
> > Does anyone have any suggestions for a way to keep 2 databases in sync?
> >
> > Ideally updates need to be made to both... this can't be too uncommon a
> > requirement..... any kind of HA would need it....

I've had a closer look at drbd. The home site is:
http://www.complang.tuwien.ac.at/reisner/drbd/

It will replicate the blocks on a device out to backup servers. If the
primary system fails the backup can take over. It doesn't do any
distributed locking so it's strictly a failover service at the moment.

It also looks like a real performance killer which is pretty much what
you'd expect with each block being sent over the LAN as well as to disk.
Definitely a case for a very high bandwidth low latency network (SCI, SP
switch) 100Mbit/1Gbit dedicated might be acceptable though.

--
|Colin Smith:  Colin.Smith@yelm.freeserve.co.uk  |   Windows 2000    |
|Linux: Delivers on the promises Microsoft make. |        AKA        |
|             http://www.linux.org/              |    The W2K Bug    |


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Does error within transaction imply restarting it?
Next
From: Jeffrey
Date:
Subject: catching errors from BDI.pm