PostgreSQL Replication – High Availability and Load Balancing

NYOUG Webinar on October 22, 2024 presented by James Vanderpoel

Join this Viscosity webinar to uncover differences between High Availability and Load Balancing along with the two main types of replication used. Additionally, we will discuss Log Shipping and any hybridization of Log-Shipping with Replication (Cascading and Synchronous).

What you can take away from this webinar:

Physical Replication
the architecture involved
flavors of physical replication (asynchronous and synchronous)
considerations and implications for either types’ use-case (database size, etc.), as well limitations.
Demo: setting such up along with monitoring.

Logical Replication
the architecture involved
publisher and subscriber models and roles, advantages and limitations of each
Demo: setting up both modes, along with monitoring.

Log Shipping
the architecture
roles involved
Primary and StandBy, and any implications with using such.
prepping both the Standby and Primary Servers
authentication implications
Multiple-Synchronous Standby setups
cross pollination with Cascading and cross pollination with Synchronous Replication along with the Cascading Replication features allowed in Log Shipping.
Demo: setting up Log Shipping and monitoring such.

Presented by James Vanderpoel, Viscosity North America

This event is co-hosted by the New York Oracle Users Group (www.nyoug.org) and Oracle Professional Services firm, Viscosity North America (www.viscosityna.com)