Re: [HACKERS] Replication documentation addition

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Jeff Frost <jeff(at)frostconsultingllc(dot)com>
Cc: Chris Browne <cbbrowne(at)acm(dot)org>, pgsql-docs(at)postgresql(dot)org
Subject: Re: [HACKERS] Replication documentation addition
Date: 2006-11-15 01:10:28
Message-ID: 200611150110.kAF1ASa11108@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-hackers

Jeff Frost wrote:
> On Tue, 14 Nov 2006, Bruce Momjian wrote:
>
> >> "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."
> >>
> >> Unfortunately, I can't seem to come up with anything more clever.
> >
> > 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.
>
> Ahh..I like this explanation, because the inter-server communication in
> clustering is not necessarily SQL queries.

OK, I have updated the documentation with the attached patch, which
clarifies SQL broadcast vs. modified row propogation. Current version
is at:

http://momjian.us/main/writings/pgsql/sgml/failover.html

--
Bruce Momjian bruce(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com

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

Attachment Content-Type Size
/bjm/diff text/x-diff 3.9 KB

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Markus Schiltknecht 2006-11-15 09:57:38 Re: [HACKERS] Replication documentation addition
Previous Message Jeff Frost 2006-11-15 00:13:59 Re: [HACKERS] Replication documentation addition

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2006-11-15 01:12:15 Re: TODO Item: IN(long list ...)
Previous Message Rune Bromer 2006-11-15 00:57:16 Re: Segmentation fault with HEAD.