redundancy and disk i/o

Started by Sandeep Joshiabout 25 years ago4 messages
#1Sandeep Joshi
sjoshi@Zambeel.com

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

#2Dominic J. Eidson
sauron@the-infinite.org
In reply to: Sandeep Joshi (#1)
Re: redundancy and disk i/o

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/

#3Don Baccus
dhogaza@pacifier.com
In reply to: Sandeep Joshi (#1)
Re: redundancy and disk i/o

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 <dhogaza@pacifier.com>
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.

#4Thomas Lockhart
lockhart@alumni.caltech.edu
In reply to: Don Baccus (#3)
Re: redundancy and disk i/o

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