Josh Berkus (Red Hat) delivers the talk, "HA PostgreSQL on Kubernetes by Demo", on DAY 1 of the Percona Live Open Source Database Conference 2019, 5/29, at Austin, TX.

You can have fully automated high availability PostgreSQL on your Kubernetes cluster ... today. The Patroni system for automating PostgreSQL deployment, failover, and migration is ready to use and in production in several places. In this live demo session, we will show you how you can make use of this technology.

We will run though setting up PostgreSQL clusters, both using basic Patroni and using a PostgreSQL Operator. We will then demonstrate failover and disaster recovery, go over some basic configuration options, show how security & authentication works, and explore some plugins and options. After that, you'll learn about the current state of the Patroni project as well as what the alternatives are.

If you need to administer more than one PostgreSQL replication cluster, you'll want to see how Patroni and Operators can make your daily DBA headaches and 2am wakeups go away.

Related Videos: Percona Live Sessions, PostgreSQL, High Availability, Migration

PostgreSQL High-Performance Tuning and Optimization
The Open Source Alternative to Paying for MongoDB
Why PostgreSQL Is Becoming A Migration Target For Enterprise
Google Cloud Platform: MySQL at Scale with Reliable HA
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