X-Original-To: pgsql-www-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 03D2E5E46EC for ; Mon, 16 Aug 2004 11:27:07 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 07718-05 for ; Mon, 16 Aug 2004 14:26:49 +0000 (GMT) Received: from ngate.rdw.ru (mail.rdw.ru [195.42.172.4]) by svr1.postgresql.org (Postfix) with SMTP id 119D25E46F0 for ; Mon, 16 Aug 2004 11:26:45 -0300 (ADT) Received: (qmail 21140 invoked from network); 16 Aug 2004 14:26:47 -0000 Received: from unknown (HELO rdw.ru) (192.168.0.57) by ngate.rdw.ru with SMTP; 16 Aug 2004 14:26:47 -0000 Received: (qmail 16615 invoked from network); 16 Aug 2004 14:26:36 -0000 Received: from ppp01.rdw.ru (HELO [192.168.0.7]) ([192.168.0.7]) (envelope-sender ) by rdw.ru (qmail-ldap-1.03) with SMTP for ; 16 Aug 2004 14:26:35 -0000 Message-ID: <4120C427.8000700@cs.msu.su> Date: Mon, 16 Aug 2004 18:26:47 +0400 From: Alexey Borzov User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7) Gecko/20040616 X-Accept-Language: ru, en-us, en MIME-Version: 1.0 To: "Marc G. Fournier" Cc: pgsql-www@postgresql.org Subject: Re: Distributed Database Web Site References: <20040814174753.U24290@ganymede.hub.org> In-Reply-To: <20040814174753.U24290@ganymede.hub.org> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/147 X-Sequence-Number: 4922 Hi, Marc G. Fournier wrote: > For instance, if we had a read-only database on a mirror site, > replicated from the main database using something like Slony ... how > hard would it be t have 'write operations' sent to the main web site to > happen, with all read operations being local? What's the point? You can't realistically expect permanent high-speed connectivity between master and slaves, thus replication will be *extremely* asynchronous. The only obviuos benefit I see is reduced traffic. > ie. posting news events would happen at http://www.postgresql.org, but > reading news events would be @ http://www.xx.postgresql.org, but both > could/would be dynamic? It works this way even now.