public inbox for [email protected]  

help / color / mirror / Atom feed

From: Marc G. Fournier <[email protected]>
To: Justin Clift <[email protected]>
Cc: Marc G. Fournier <[email protected]>
Cc: [email protected]
Subject: Re: Distributed Database Web Site
Date: Sun, 15 Aug 2004 12:50:55 -0300 (ADT)
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>

On Sun, 15 Aug 2004, Justin Clift wrote:

> Marc G. Fournier wrote:
>>
>> Just curious, how hard would it be to distinguish on the main web site 
>> between read and write operations?
>> 
>> 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?
>
> Thinking about what it would take...
>
> We'd need the pg_hba.conf of the main database set to allow connections from 
> the mirror website(s), so the write operations can occur.
>
> Or, perhaps as an alternative, we could look at making the pages that 
> generate writes only be on the main PG website.  So, the majority of content 
> is mirrored except for a few pages which do stuff like (i.e.) submit new 
> stories and stuff.

This second was what I was thinking ...

> Yep, should be possible.  We just have to think about the technology 
> we'd like web mirrors to run, and then ensure it's acceptable and 
> do-able.

Now, knowing that all mirrors couldn't do this (or wouldn't), I was 
thinking of having a pseudo-regional master mirror that others could rsync 
static content from ...

----
Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
Email: [email protected]           Yahoo!: yscrappy              ICQ: 7615664

view thread (5+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Distributed Database Web Site
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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