public inbox for [email protected]
help / color / mirror / Atom feedFrom: Justin Clift <[email protected]>
To: Marc G. Fournier <[email protected]>
Cc: [email protected]
Subject: Re: Distributed Database Web Site
Date: Sun, 15 Aug 2004 20:23:49 +1000
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
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.
I haven't really played with Slony in the scenario of multiple mirrors
that may or may not all be available at any one time, but Jan should be
able to give input here.
> 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?
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.
:)
Regards and best wishes,
Justin Clift
> ----
> Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
> Email: [email protected] Yahoo!: yscrappy ICQ: 7615664
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to [email protected])
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