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 |
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 |
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. |