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.
www.udemy.com/course/postgres...

[@awaitingforsunrise]

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

[@mroobert]

Great video! Super nice explanations and flow of information!

[@codegeek-il5fm]

Great tutorial. Well explained.

[@islamicstories8687]

Please provide a complete tutorial of Postgres high available cluster.

[@derzskyi1]

You are good at explanation, thanks!

[@magician6123]

Amazing content, bro. Keep it coming.

[@riansyahtohamba8215]

thanks mate for the videos

[@martinlonigro]

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?

[@leydifall]

Perfect tutorial 🎊 🎁

[@steele_ntwrk]

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

[@norliegh]

Such a great video!!

[@aleksandrshipilo4467]

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?

[@rickardhermansson6163]

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

[@sunilkumarreddykalli7056]

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??.

[@sdolo222]

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

[@sohom004]

Great

[@smyrnian_]

Your last example is similar to how Stolon works

[@S3Kglitches]

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

[@ViktorZavadskyi]

Best play at 1.75 speed =)

[@junialter]

Audio is way too silent

[@Delicatamente]

huuuuge thanks!