Concepts

• Terminology
  • Asynchronous replication
  • Availability
  • CAMO or commit-at-most-once
  • Clustering
  • Data sharding
  • Eager Replication for PGD
  • Eventual consistency
  • Failover
  • Horizontal scaling or scale out
  • Logical replication
  • Nines
  • Node
  • Physical replication
  • Read scalability
  • Recovery point objective (RPO)
  • Recovery time objective (RTO)
  • Single point of failure (SPOF)
  • Switchover
  • Synchronous replication
  • Two-phase commit (2PC)
  • Vertical scaling or scale up
  • Write scalability
  • Write leader
• PGD overview
  • Basic architecture
    • Multiple groups
    • Multiple masters
    • Asynchronous, by default
    • Mesh topology
    • Logical replication
    • Connection management
    • High availability
  • Architectural options and performance
    • Always On architectures
    • Supported Postgres database servers
    • Characteristics affecting performance