Thread: redundancy and disk i/o

redundancy and disk i/o

From
Sandeep Joshi
Date:
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: redundancy and disk i/o

From
Don Baccus
Date:
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
Serviceand other goodies at http://donb.photo.net.
 


Re: redundancy and disk i/o

From
"Dominic J. Eidson"
Date:
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: redundancy and disk i/o

From
Thomas Lockhart
Date:
> 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