Re: Distributed Database Web Site

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.