Table of contents

PostgreSQL

%3 cluster_13247c75_c46c_4ea4_b8cf_695657e75902 PostgreSQL _58eac55b_4a8c_4e30_8e38_62ce9027970b Syncronization (HA) types _9f749a2d_475b_47b4_99c9_5df96496057d Databases _c7373cef_471f_4039_846e_65c482518354 PostgreSQL Internals _c7373cef_471f_4039_846e_65c482518354->__0:cluster_13247c75_c46c_4ea4_b8cf_695657e75902 __1:cluster_13247c75_c46c_4ea4_b8cf_695657e75902->_9f749a2d_475b_47b4_99c9_5df96496057d

Syncronization (HA) types

  • On PostgreSQL documentation

    https://www.postgresql.org/docs/10/high-availability.html Table 26.1. High Availability, Load Balancing, and Replication Feature Matrix https://www.postgresql.org/docs/10/different-replication-solutions.html

    • Feature Shared Disk File System Write-Ahead Log Shipping Logical Replication Trigger-Based Statement-Based Asynchronous Multimaster Synchronous Multimaster
    Failover Replication Master-Standby Replication Replication Middleware Replication Replication
    Most common implementations NAS DRBD built-in streaming replication built-in logical replication, pglogical Londiste, Slony pgpool-II Bucardo
    Communication method shared disk disk blocks WAL logical decoding table rows SQL table rows table rows and row locks
    No special hardware required ✔ ✔ ✔ ✔ ✔ ✔ ✔
    Allows multiple master servers ✔ ✔ ✔ ✔
    No master server overhead ✔ ✔ ✔ ✔
    No waiting for multiple servers ✔ with sync off with sync off ✔ ✔
    Master failure will never lose data ✔ ✔ with sync on with sync on ✔ ✔
    Replicas accept read-only queries with hot standby ✔ ✔ ✔ ✔ ✔
    Per-table granularity ✔ ✔ ✔ ✔
    No conflict resolution necessary ✔ ✔ ✔ ✔ ✔