Обсуждение: redundancy and disk i/o
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
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.
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/
> 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