Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id EC6129FA219 for ; Mon, 20 Nov 2006 11:03:28 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 84080-04 for ; Mon, 20 Nov 2006 11:03:07 -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 606709FA221 for ; Mon, 20 Nov 2006 11:03:06 -0400 (AST) Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id kAKF32U19682; Mon, 20 Nov 2006 10:03:02 -0500 (EST) From: Bruce Momjian Message-Id: <200611201503.kAKF32U19682@momjian.us> Subject: Re: [HACKERS] Replication documentation addition In-Reply-To: <200611181529.07429.josh@agliodbs.com> To: Josh Berkus Date: Mon, 20 Nov 2006 10:03:02 -0500 (EST) CC: pgsql-docs@postgresql.org, Jim Nasby , Jeff Frost , Chris Browne 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/38 X-Sequence-Number: 3872 Josh Berkus wrote: > Jim, > > > 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. > > I think the general term is "statement-based replication", not "broadcasting". Well, the problem is that you can use a statement-based method to replication from a master to a slave. I think MySQL used to use this method, or still does, so I don't think the term "statement-based" is clear enough, though I am open to other terms than "broadcast". -- Bruce Momjian bruce@momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +