pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Postgresql on a shared storage
2+ messages / 2 participants
[nested] [flat]

* Postgresql on a shared storage
@ 2004-05-26 10:08 Vasil Kolev <vasil@ludost.net>
  2004-05-31 02:22 ` Re: Postgresql on a shared storage Christopher Browne <cbbrowne@acm.org>
  0 siblings, 1 reply; 2+ messages in thread

From: Vasil Kolev @ 2004-05-26 10:08 UTC (permalink / raw)
  To: pgsql-admin; +Cc: chervarium@sigbus.nove.bg

  Hello,

I'm working on a system that has 2 servers with postgresql, and a FC
shared storage between them, where the database is stored. After some
weeks of using google and reading lists, I've come to the conclusion,
that there is no way (using F(L)OSS tools) to use both databases R/W, or
even one of them R/O, and one of the machines has to do all the work,
and the other one to be a hot spare. Am I right, or have I missed
something?

And is there something tested and usable for my case, even if it's
commercial, that will run under linux?

Attachments:

  signature.asc (application/pgp-signature, 188B) download

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Postgresql on a shared storage
  2004-05-26 10:08 Postgresql on a shared storage Vasil Kolev <vasil@ludost.net>
@ 2004-05-31 02:22 ` Christopher Browne <cbbrowne@acm.org>
  0 siblings, 0 replies; 2+ messages in thread

From: Christopher Browne @ 2004-05-31 02:22 UTC (permalink / raw)
  To: pgsql-admin

vasil@ludost.net (Vasil Kolev) wrote:
> I'm working on a system that has 2 servers with postgresql, and a FC
> shared storage between them, where the database is stored. After
> some weeks of using google and reading lists, I've come to the
> conclusion, that there is no way (using F(L)OSS tools) to use both
> databases R/W, or even one of them R/O, and one of the machines has
> to do all the work, and the other one to be a hot spare. Am I right,
> or have I missed something?
>
> And is there something tested and usable for my case, even if it's
> commercial, that will run under linux?

The only quasi-FLOSS system that bills itself as being good for this
sort of thing is Backplane <http://www.backplane.com/;; it is _way_ too
early for it to be considered mature for the purpose, and it's
licensed under much the same sort of "if you're doing anything
commercial, you have to pay for commercial licenses" arrangement as
MySQL.

The most relevant Oracle thing is RAC.  It looks like it's _very_
expensive, and it's not evident that it allows multiple instances to
share the FC storage.  <http://www.dba-oracle.com/art_rac.htm;

I'm not sure you'll find it easy to find commercial databases that
allow you to spread write load across multiple servers.

What you're looking for is some form of multimaster replication;
that's problematic on any platform.  
-- 
let name="cbbrowne" and tld="acm.org" in name ^ "@" ^ tld;;
http://cbbrowne.com/info/linuxdistributions.html
"Optimization hinders evolution."  -- Alan Perlis



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2004-05-31 02:22 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-05-26 10:08 Postgresql on a shared storage Vasil Kolev <vasil@ludost.net>
2004-05-31 02:22 ` Christopher Browne <cbbrowne@acm.org>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox