Skip to content

Commit 47eec34

Browse files
committed
docs: Improve A?synchronous Multimaster Replication descr.
The docs for sync and async multimaster replication were unclear about when to use it, and when it has benefits; this change clarifies that. Reported-by: juha-pekka.eloranta@reaktor.fi Discussion: https://postgr.es/m/156856543824.1274.12180817186798859836@wrigleys.postgresql.org Backpatch-through: 9.4
1 parent cae078f commit 47eec34

File tree

1 file changed

+4
-4
lines changed

1 file changed

+4
-4
lines changed

doc/src/sgml/high-availability.sgml

+4-4
Original file line numberDiff line numberDiff line change
@@ -237,7 +237,8 @@ protocol to make nodes agree on a serializable transactional order.
237237
<listitem>
238238

239239
<para>
240-
For servers that are not regularly connected, like laptops or
240+
For servers that are not regularly connected or have slow
241+
communication links, like laptops or
241242
remote servers, keeping data consistent among servers is a
242243
challenge. Using asynchronous multimaster replication, each
243244
server works independently, and periodically communicates with
@@ -256,9 +257,8 @@ protocol to make nodes agree on a serializable transactional order.
256257
In synchronous multimaster replication, each server can accept
257258
write requests, and modified data is transmitted from the
258259
original server to every other server before each transaction
259-
commits. Heavy write activity can cause excessive locking,
260-
leading to poor performance. In fact, write performance is
261-
often worse than that of a single server. Read requests can
260+
commits. Heavy write activity can cause excessive locking and
261+
commit delays, leading to poor performance. Read requests can
262262
be sent to any server. Some implementations use shared disk
263263
to reduce the communication overhead. Synchronous multimaster
264264
replication is best for mostly read workloads, though its big

0 commit comments

Comments
 (0)