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)