Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit346d5bf

Browse files
committed
doc: Add logical replication to comparison matrix
Author: Steve Singer <steve@ssinger.info>
1 parent9b5140f commit346d5bf

File tree

1 file changed

+36
-7
lines changed

1 file changed

+36
-7
lines changed

‎doc/src/sgml/high-availability.sgml

Lines changed: 36 additions & 7 deletions
Original file line numberDiff line numberDiff line change
@@ -111,7 +111,7 @@
111111
</varlistentry>
112112

113113
<varlistentry>
114-
<term>File System (Block-Device) Replication</term>
114+
<term>File System (BlockDevice) Replication</term>
115115
<listitem>
116116

117117
<para>
@@ -158,6 +158,24 @@ protocol to make nodes agree on a serializable transactional order.
158158
</listitem>
159159
</varlistentry>
160160

161+
<varlistentry>
162+
<term>Logical Replication</term>
163+
<listitem>
164+
<para>
165+
Logical replication allows a database server to send a stream of data
166+
modifications to another server. <productname>PostgreSQL</productname>
167+
logical replication constructs a stream of logical data modifications
168+
from the WAL. Logical replication allows the data changes from
169+
individual tables to be replicated. Logical replication doesn't require
170+
a particular server to be designated as a master or a replica but allows
171+
data to flow in multiple directions. For more information on logical
172+
replication, see <xref linkend="logical-replication">. Through the
173+
logical decoding interface (<xref linkend="logicaldecoding">),
174+
third-party extensions can also provide similar functionality.
175+
</para>
176+
</listitem>
177+
</varlistentry>
178+
161179
<varlistentry>
162180
<term>Trigger-Based Master-Standby Replication</term>
163181
<listitem>
@@ -290,6 +308,7 @@ protocol to make nodes agree on a serializable transactional order.
290308
<entry>Shared Disk Failover</entry>
291309
<entry>File System Replication</entry>
292310
<entry>Write-Ahead Log Shipping</entry>
311+
<entry>Logical Replication</entry>
293312
<entry>Trigger-Based Master-Standby Replication</entry>
294313
<entry>Statement-Based Replication Middleware</entry>
295314
<entry>Asynchronous Multimaster Replication</entry>
@@ -300,21 +319,23 @@ protocol to make nodes agree on a serializable transactional order.
300319
<tbody>
301320

302321
<row>
303-
<entry>MostCommon Implementation</entry>
322+
<entry>Mostcommon implementations</entry>
304323
<entry align="center">NAS</entry>
305324
<entry align="center">DRBD</entry>
306-
<entry align="center">Streaming Repl.</entry>
307-
<entry align="center">Slony</entry>
325+
<entry align="center">built-in streaming replication</entry>
326+
<entry align="center">built-in logical replication, pglogical</entry>
327+
<entry align="center">Londiste, Slony</entry>
308328
<entry align="center">pgpool-II</entry>
309329
<entry align="center">Bucardo</entry>
310330
<entry align="center"></entry>
311331
</row>
312332

313333
<row>
314-
<entry>CommunicationMethod</entry>
334+
<entry>Communicationmethod</entry>
315335
<entry align="center">shared disk</entry>
316336
<entry align="center">disk blocks</entry>
317337
<entry align="center">WAL</entry>
338+
<entry align="center">logical decoding</entry>
318339
<entry align="center">table rows</entry>
319340
<entry align="center">SQL</entry>
320341
<entry align="center">table rows</entry>
@@ -330,13 +351,15 @@ protocol to make nodes agree on a serializable transactional order.
330351
<entry align="center">&bull;</entry>
331352
<entry align="center">&bull;</entry>
332353
<entry align="center">&bull;</entry>
354+
<entry align="center">&bull;</entry>
333355
</row>
334356

335357
<row>
336358
<entry>Allows multiple master servers</entry>
337359
<entry align="center"></entry>
338360
<entry align="center"></entry>
339361
<entry align="center"></entry>
362+
<entry align="center">&bull;</entry>
340363
<entry align="center"></entry>
341364
<entry align="center">&bull;</entry>
342365
<entry align="center">&bull;</entry>
@@ -348,6 +371,7 @@ protocol to make nodes agree on a serializable transactional order.
348371
<entry align="center">&bull;</entry>
349372
<entry align="center"></entry>
350373
<entry align="center">&bull;</entry>
374+
<entry align="center">&bull;</entry>
351375
<entry align="center"></entry>
352376
<entry align="center">&bull;</entry>
353377
<entry align="center"></entry>
@@ -359,6 +383,7 @@ protocol to make nodes agree on a serializable transactional order.
359383
<entry align="center">&bull;</entry>
360384
<entry align="center"></entry>
361385
<entry align="center">with sync off</entry>
386+
<entry align="center">with sync off</entry>
362387
<entry align="center">&bull;</entry>
363388
<entry align="center"></entry>
364389
<entry align="center">&bull;</entry>
@@ -370,17 +395,19 @@ protocol to make nodes agree on a serializable transactional order.
370395
<entry align="center">&bull;</entry>
371396
<entry align="center">&bull;</entry>
372397
<entry align="center">with sync on</entry>
398+
<entry align="center">with sync on</entry>
373399
<entry align="center"></entry>
374400
<entry align="center">&bull;</entry>
375401
<entry align="center"></entry>
376402
<entry align="center">&bull;</entry>
377403
</row>
378404

379405
<row>
380-
<entry>Standby accept read-only queries</entry>
406+
<entry>Replicas accept read-only queries</entry>
381407
<entry align="center"></entry>
382408
<entry align="center"></entry>
383-
<entry align="center">with hot</entry>
409+
<entry align="center">with hot standby</entry>
410+
<entry align="center">&bull;</entry>
384411
<entry align="center">&bull;</entry>
385412
<entry align="center">&bull;</entry>
386413
<entry align="center">&bull;</entry>
@@ -393,6 +420,7 @@ protocol to make nodes agree on a serializable transactional order.
393420
<entry align="center"></entry>
394421
<entry align="center"></entry>
395422
<entry align="center">&bull;</entry>
423+
<entry align="center">&bull;</entry>
396424
<entry align="center"></entry>
397425
<entry align="center">&bull;</entry>
398426
<entry align="center">&bull;</entry>
@@ -403,6 +431,7 @@ protocol to make nodes agree on a serializable transactional order.
403431
<entry align="center">&bull;</entry>
404432
<entry align="center">&bull;</entry>
405433
<entry align="center">&bull;</entry>
434+
<entry align="center"></entry>
406435
<entry align="center">&bull;</entry>
407436
<entry align="center"></entry>
408437
<entry align="center"></entry>

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp