| From: | Alexey Borzov <borz_off(at)cs(dot)msu(dot)su> |
|---|---|
| To: | "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org> |
| Cc: | pgsql-www(at)postgresql(dot)org |
| Subject: | Re: Distributed Database Web Site |
| Date: | 2004-08-16 14:26:47 |
| Message-ID: | 4120C427.8000700@cs.msu.su |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-www |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexey Borzov | 2004-08-16 14:39:13 | Re: time to move to the new code |
| Previous Message | Marc G. Fournier | 2004-08-16 13:33:32 | Re: FW: [ pginstaller-Bugs-1000056 ] DLL not found |