From 346d5bf1ca33bcf27eda5d23fba3999e6356b905 Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Wed, 16 Aug 2017 13:59:40 -0400 Subject: [PATCH] doc: Add logical replication to comparison matrix Author: Steve Singer --- doc/src/sgml/high-availability.sgml | 43 ++++++++++++++++++++++++----- 1 file changed, 36 insertions(+), 7 deletions(-) diff --git a/doc/src/sgml/high-availability.sgml b/doc/src/sgml/high-availability.sgml index a4494a3494..1a152cf118 100644 --- a/doc/src/sgml/high-availability.sgml +++ b/doc/src/sgml/high-availability.sgml @@ -111,7 +111,7 @@ - File System (Block-Device) Replication + File System (Block Device) Replication @@ -158,6 +158,24 @@ protocol to make nodes agree on a serializable transactional order. + + Logical Replication + + + Logical replication allows a database server to send a stream of data + modifications to another server. PostgreSQL + logical replication constructs a stream of logical data modifications + from the WAL. Logical replication allows the data changes from + individual tables to be replicated. Logical replication doesn't require + a particular server to be designated as a master or a replica but allows + data to flow in multiple directions. For more information on logical + replication, see . Through the + logical decoding interface (), + third-party extensions can also provide similar functionality. + + + + Trigger-Based Master-Standby Replication @@ -290,6 +308,7 @@ protocol to make nodes agree on a serializable transactional order. Shared Disk Failover File System Replication Write-Ahead Log Shipping + Logical Replication Trigger-Based Master-Standby Replication Statement-Based Replication Middleware Asynchronous Multimaster Replication @@ -300,21 +319,23 @@ protocol to make nodes agree on a serializable transactional order. - Most Common Implementation + Most common implementations NAS DRBD - Streaming Repl. - Slony + built-in streaming replication + built-in logical replication, pglogical + Londiste, Slony pgpool-II Bucardo - Communication Method + Communication method shared disk disk blocks WAL + logical decoding table rows SQL table rows @@ -330,6 +351,7 @@ protocol to make nodes agree on a serializable transactional order. • • • + • @@ -337,6 +359,7 @@ protocol to make nodes agree on a serializable transactional order. + • • • @@ -348,6 +371,7 @@ protocol to make nodes agree on a serializable transactional order. • • + • • @@ -359,6 +383,7 @@ protocol to make nodes agree on a serializable transactional order. • with sync off + with sync off • • @@ -370,6 +395,7 @@ protocol to make nodes agree on a serializable transactional order. • • with sync on + with sync on • @@ -377,10 +403,11 @@ protocol to make nodes agree on a serializable transactional order. - Standby accept read-only queries + Replicas accept read-only queries - with hot + with hot standby + • • • • @@ -393,6 +420,7 @@ protocol to make nodes agree on a serializable transactional order. • + • • • @@ -403,6 +431,7 @@ protocol to make nodes agree on a serializable transactional order. • • • + • -- 2.40.0