Re: Replicating databases - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: Replicating databases
Date
Msg-id 20051103215643.GE16854@phlogiston.dyndns.org
Whole thread Raw
In response to Re: Replicating databases  ("codeWarrior" <gpatnude@hotmail.com>)
List pgsql-general
On Thu, Nov 03, 2005 at 08:16:01AM -0800, codeWarrior wrote:
> It doesnt sound to me like replication is the right answer to this
> problem... You are setting yourself up to try and defeat one of the major
> purposes of a database in a client-server system -- namely -- centralized
> storage.

While I have a certain amount of sympathy for this view, it's often
the case that centralised storage isn't quite what you want.  After
all, if always-fast is more important than always-right, we prefer
caches and such like.  DNS is the obvious example there.  And if
always-works is more important than always-fast or always-right, then
you have a very powerful incentive to keep things local.

That said, this case does sort of sound like money might be better
spent on improved communications that a humungous amount of work to
Rube up a Goldberg for getting all the data in every store.  But
maybe we don't have the whole picture: maybe communications links
aren't stable in some of these stores, and can't be made so
economically.

A

--
Andrew Sullivan  | ajs@crankycanuck.ca
The plural of anecdote is not data.
        --Roger Brinner

pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Replicating databases
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Replicating databases