Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Replication documentation addition

From: Jim Nasby <decibel(at)decibel(dot)org>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Jeff Frost <jeff(at)frostconsultingllc(dot)com>, Chris Browne <cbbrowne(at)acm(dot)org>, pgsql-docs(at)postgresql(dot)org
Subject: Re: [HACKERS] Replication documentation addition
Date: 2006-11-17 01:48:58
Message-ID: EE16DB51-3C5E-4A18-BA5E-E7EB60853194@decibel.org (view raw or flat)
Thread:
Lists: pgsql-docspgsql-hackers
On Nov 14, 2006, at 5:11 PM, Bruce Momjian wrote:
> Basically, when you are broadcasting outside the server, you are
> broadcasting SQL queries, and those queries do not have information
> about non-deterministic functions and have issues with universal  
> commits
> on all node.

That's true of simple query broadcasting (ie: pgpool), but not true  
of Continuent/Sequoia. Continuent's software adds a lot of additional  
features on top of simple query broadcasting, making it far more  
robust than simply spewing queries out to every node in the cluster.  
You still have to be very careful with how you use it, but not nearly  
as much as with simpler solutions.
--
Jim Nasby                                            jim(at)nasby(dot)net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)



In response to

Responses

pgsql-docs by date

Next:From: Josh BerkusDate: 2006-11-18 23:29:07
Subject: Re: [HACKERS] Replication documentation addition
Previous:From: Richard Broersma JrDate: 2006-11-16 06:36:01
Subject: Re: Valued Predicates

pgsql-hackers by date

Next:From: Jim NasbyDate: 2006-11-17 03:48:49
Subject: Re: Cast null to int4 upgrading from Version 7.2
Previous:From: Jim NasbyDate: 2006-11-17 01:29:35
Subject: ALTER TABLE RENAME column

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group