PostgreSQL HA High Availability Tutorial

Показать описание

0:00 - Why High Availability?
0:39 - Steps to achieve High Availability
2:36 - Essential Questions to set-up High Availability
7:56 - Log-Shipping Replication
9:19 - Streaming Replication and Logical Replication
11:50 - Cascading Replication
13:07 - Synchronous vs. Asynchronous Replication
15:11 - Automatic Failover and Always-on Strategy
16:32 - Simple HA Solution Example
17:23 - Better HA Solution Example

🐘 Want to find out MORE about Scaling PostgreSQL?
Use the link below to get 60% OFF on the Entire Course.

High-Performance Programming

Рекомендации по теме

Комментарии

One of the greatest introduction videos on failover topic I ever saw. You have a talent! Thank you, keep it up!

awaitingforsunrise

Great video! Super nice explanations and flow of information!

mroobert

Please provide a complete tutorial of Postgres high available cluster.

jamshaedfared

Please continue doing that. Very helpful. I have a question: u mentioned that we have 3 WAL levels: minimal, replica and logical. And also we have streaming and logical replication. Can you clarify: streaming replication is executed using WAL or not? Do I have to choose a particular WAL level to execute streaming replication?

aleksandrshipilo

Great Video.. nice explication regarding High Availability... I've one query so when the primary node goes down the standby is become a primary right so here when early primary node back to in running state how the data will replica form between these two nodes??.

sunilkumarreddykalli

Amazing content, bro. Keep it coming.

magician

Your explanations are "what" but not always "why". You should focus more on the explanation of the chosen solution and why it is used.

SKglitches

Very nice, a tutorial on encryption at rest (Transparent Data Encryption) would be very much appreciated

rickardhermansson

Great video! I have a question about the last example named "Better HA Solution Example". Where the patroni's etcd nodes lives to avoid a disruption if one datacenter goes down?

martinlonigro

It's pronounced 'synchronous' (sing·kruh·nuhs) - not synchronious
That is my contribution :)

sdolo

Hey Great Video! But how do you address writing data back to primary before a failback?

steele_ntwrk

Your last example is similar to how Stolon works

smyrnian_

PostgreSQL HA High Availability Tutorial

PostgreSQL HA High Availability Tutorial

PostgreSQL High Availability Options

Part01-PostgreSQL Patroni Cluster HA

PostgreSQL Streaming Replication Tutorial

Patroni PostgreSQL - Cluster Setup

Pgpool-II Tutorial

104 - High availability (HA) in Google PostgreSQL

Master PostgreSQL 12 Replication and Failover: Tutorial for Data Security and High Availability!

Multi-tenant Apps With Distributed PostgreSQL

How to Design for Database High Availability

Webinar: Beginners Guide to High Availability for Postgres

Patroni for PostgreSQL- High availability with automatic failover management: Topics

PostgresOpen 2019 Easy And Correct High Availability PostgreSQL With Kubernetes

How to build a highly available PostgreSQL cluster using EDB Failover Manager?

PostgreSQL HA Proxy Setup - Ubuntu, CentOS/RHEL & Debian OS - Simple step to configure Load Bala...

PostgreSQL- Streaming Replication - Five Steps to Configure HA in CentOS, RHEL, Debian & Ubuntu

PostgreSQL HA With Patroni: Looking at Failure Scenarios and How the Cluster Recovers From Them

How to configure a High Availability System in PostgreSQL with repmgr

Patroni HA PostgreSQL Made Easy

Implementing High Availability with PostgreSQL

Replication and High Availability Methods on PostgreSQL - Aakash Muthuramalingam, Mydbops Team

PostgreSQL in 100 Seconds

PostgreSQL Tutorial - 20 - Highly Available PostgreSQL Cluster using Patroni and HAProxy on Ubuntu

Part02-PostgreSQL Patroni Cluster HA