Received: from localhost (uranus.hub.org [200.46.204.60]) by postgresql.org (Postfix) with ESMTP id 8A5C89FB26E for ; Tue, 14 Nov 2006 18:43:45 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.60]) (amavisd-new, port 10024) with ESMTP id 35639-04 for ; Tue, 14 Nov 2006 18:43:44 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from momjian.us (momjian.us [70.90.9.53]) by postgresql.org (Postfix) with ESMTP id 46FA69FA5C8 for ; Tue, 14 Nov 2006 18:43:44 -0400 (AST) Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id kAEMhZf02180; Tue, 14 Nov 2006 17:43:35 -0500 (EST) From: Bruce Momjian Message-Id: <200611142243.kAEMhZf02180@momjian.us> Subject: Re: [HACKERS] Replication documentation addition In-Reply-To: To: Jeff Frost Date: Tue, 14 Nov 2006 17:43:35 -0500 (EST) CC: Chris Browne , pgsql-docs@postgresql.org X-Mailer: ELM [version 2.4ME+ PL123] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="US-ASCII" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/17 X-Sequence-Number: 3851 Jeff Frost wrote: > > FYI, as far as I know, Continuent's solution is "Query Broadcast Load > > Balancing", not clustering. > > I would speculate that your terminology is slightly more accurate than mine. > The do query broadcast, but they also do a bit more with it than that as they > evaluate many of the non deterministic write queries on a particular server > and update the broadcast query so each db gets the same value. > > I guess middleware of this sort automatically ends up in the query broadcast > category. It just sounds awfully similar to the description of cluster for > load balancing: > > In clustering, each server can accept write requests, and these write requests > are broadcast from the original server to all other servers before each > transaction commits. > > I guess it's kind of a fine line how it gets defined? Hmmm. Interesting. Does anyone else have details or an opinion on this? The fact that there is something sitting above the servers seems to be the defining issue of calling it query broadcast. -- Bruce Momjian bruce@momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +