From de597154a8acae01be28ba32b5b6e0ec4915ef3f Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Tue, 21 Nov 2006 18:31:57 +0000 Subject: [PATCH] Update Statement-Based Replication Middleware docs to be more general. --- doc/src/sgml/high-availability.sgml | 20 ++++++++++---------- 1 file changed, 10 insertions(+), 10 deletions(-) diff --git a/doc/src/sgml/high-availability.sgml b/doc/src/sgml/high-availability.sgml index d3ef45944f..ccdfd8d1cb 100644 --- a/doc/src/sgml/high-availability.sgml +++ b/doc/src/sgml/high-availability.sgml @@ -1,4 +1,4 @@ - + High Availability and Load Balancing @@ -166,16 +166,16 @@ protocol to make nodes agree on a serializable transactional order. - One limitation of this solution is that functions like + If queries are simply broadcast unmodified, functions like random(), CURRENT_TIMESTAMP, and - sequences can have different values on different servers. This - is because each server operates independently, and because SQL - queries are broadcast (and not actual modified rows). If this - is unacceptable, applications must query such values from a - single server and then use those values in write queries. - Also, care must be taken that all transactions either commit - or abort on all servers, perhaps using two-phase commit ( and . Pgpool is an example of this type of replication. -- 2.40.0