[Talk-us] US-based Server

Richard Welty rwelty at averillpark.net
Thu Oct 22 01:43:10 BST 2009


On 10/21/09 8:01 PM, Dale Puch wrote:
> Not a network or SQL engineer.  But a google search turned up this.
> http://pgcluster.projects.postgresql.org/feature.html  From the mailing list
> I see the code is up to 1.9 even if the page isn't updated.
>
> There also seemed like several basic configurations that can be used with
> different good and bad points.
>    
um, no.

synchronous multi-master requires that the database servers be in close 
physical proximity,
as latency is deadly. async allows for geographical distribution, but 
requires application
design to take it into account because of conflict resolution problems. 
there is no silver
bullet. anyone who claims otherwise is either poorly informed or a salesman.

database replication is a non-trivial engineering exercise, which is why 
people get paid
a lot of money to design and implement solutions, and database vendors 
can charge so
much money for solutions that aren't necessarily even all there.

richard
    (not a database administrator but as a developer, i annoy a bunch of 
them every day)





More information about the Talk-us mailing list