Re: Distributed Database Web Site

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: scrappy@hub.org           Yahoo!: yscrappy              ICQ: 7615664