Christophe Pettus (PostgreSQL Experts Inc.) delivers the talk, "Your Herd of Elephants: PostgreSQL Replication", on DAY 2 of the Percona Live Open Source Database Conference 2018, 4/25, at Santa Clara, CA.

PostgreSQL version 10 has added logical replication, and now the field of replication options in PostgreSQL has gotten wide: Streaming replication, warm standby, logical replication?

We'll discuss what the options are, their limitations and pitfalls, and what the best use-case for each one is. We'll show what it takes to set each one up, monitor it, and get it working again on failures. We'll cover:

* The history of replication in PostgreSQL.
* WAL shipping
* Streaming replication
* Trigger-based replication
* Logical decoding
* And some exotic animals


Related Videos: Percona Live Sessions, PostgreSQL, Replication

Introduction to pg_stat_monitor
PostgreSQL High-Performance Tuning and Optimization
Why PostgreSQL Is Becoming A Migration Target For Enterprise
SQL Row Store vs Data Warehouse: Which Is Right for Your Application? - Robert Hodges - PLO October 2020
Introducing Kunlun Distributed Database Cluster - David Zhao Wei - Percona Live ONLINE 2020
pg_stat_monitor: A cool extension for better monitoring using PMM - Percona Live Online 2020
PostgreSQL WAL and Commit Synchronization, Optimization Opportunities - Jobin Augustine - PLO October 2020