Re: [HACKERS] Replication documentation addition

Jim Nasby wrote:
> 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.

Yes, I have heard that Continuent/Sequoia has a process running on each
server that deals with many of the problems with broadcasting.  Not sure
how I should work that into the documentation.  In fact, based on our
description, the improvements Continuent/Sequoia made are probably
clearer.

--
  Bruce Momjian   bruce@momjian.us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +