[HACKERS] redundancy and disk i/o

2000-12-03 Thread Sandeep Joshi

Hi,
I have two questions

1. Is it possible to set up a set of redundant disks for a database? one

of them being remote from
the database?


2. If I want to use my i/o routines for disk i/o, is it possible?
does postgres support such APIs?




thanks,
Sandeep






Re: [HACKERS] redundancy and disk i/o

2000-12-04 Thread Don Baccus

At 07:30 PM 11/28/00 -0800, Sandeep Joshi wrote:
>Hi,
>I have two questions
>
>1. Is it possible to set up a set of redundant disks for a database? one
>of them being remote from the database?

If you're talking about replication, PostgreSQL, Inc. will be offering a
solution to its $19,000/yr Platinum Partners shortly.  It will be released
in open source form no more than two years after its release in proprietary
form.

Check out http://www.erserver.com for more details, and http://www.pgsql.com
for more details on the PostgreSQL, Inc. partnership program.

Locally, you can use RAID.  Are there open-source journaling filesystems that
offer filesystem-level replication out there?



- Don Baccus, Portland OR <[EMAIL PROTECTED]>
  Nature photos, on-line guides, Pacific Northwest
  Rare Bird Alert Service and other goodies at
  http://donb.photo.net.



Re: [HACKERS] redundancy and disk i/o

2000-12-04 Thread Dominic J. Eidson

On Tue, 28 Nov 2000, Sandeep Joshi wrote:

> 1. Is it possible to set up a set of redundant disks for a database? one 
> of them being remote from the database?

Call IBM Global Services, and tell them you are interested in purchasing
an RS/6000 with a 7133 SSA drives, one tray off-site using the fiber
extenders.

With those, you can have your drives up to 2.4 km from the server they're
connected to, while they still are local to the machine. (And you still
get 4 simultaneous reads/writes in each direction of the loop, for a total
of 160 Mbyte/sec transfer.)


-- 
Dominic J. Eidson
"Baruk Khazad! Khazad ai-menu!" - Gimli
---
http://www.the-infinite.org/  http://www.the-infinite.org/~dominic/




Re: [HACKERS] redundancy and disk i/o

2000-12-04 Thread Thomas Lockhart

> If you're talking about replication, PostgreSQL, Inc. will be offering a
> solution to its $19,000/yr Platinum Partners shortly.  It will be released
> in open source form no more than two years after its release in proprietary
> form.
> Check out http://www.erserver.com for more details, and http://www.pgsql.com
> for more details on the PostgreSQL, Inc. partnership program.

Thanks Don for the reference. As you know, there will also be a "roll
your own" replication toolset contributed by PostgreSQL Inc. under the
BSD license in the PostgreSQL contrib/ directory for the 7.1 release,
assuming that this inclusion is acceptable to the community. Given the
general interest, I hope that this won't be an issue, and that the
recent flames will have died down enough to not be a continued
distraction.

  - Thomas