X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 23B93D1B276 for ; Sun, 30 May 2004 23:51:49 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 08317-02 for ; Sun, 30 May 2004 23:51:51 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id D11F1D1B275 for ; Sun, 30 May 2004 23:51:46 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i4V2pkSx099064 for ; Mon, 31 May 2004 02:51:46 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i4V2oLV2098962 for pgsql-admin@postgresql.org; Mon, 31 May 2004 02:50:21 GMT From: Christopher Browne X-Newsgroups: comp.databases.postgresql.admin Subject: Re: Postgresql on a shared storage Date: Sun, 30 May 2004 22:22:00 -0400 Organization: cbbrowne Computing Inc Lines: 32 Message-ID: References: <1085566093.17556.94.camel@doom.home.ludost.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org X-message-flag: Outlook is rather hackable, isn't it? X-Home-Page: http://www.cbbrowne.com/info/ X-Affero: http://svcs.affero.net/rm.php?r=cbbrowne User-Agent: Gnus/5.1006 (Gnus v5.10.6) XEmacs/21.4 (Security Through Obscurity, linux) Cancel-Lock: sha1:c5Aw47wHT/jPL0SyhwWqojqAK5U= To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200405/328 X-Sequence-Number: 13644 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 ; 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. 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