How to configure a High Availability System in PostgreSQL

Install, configure and monitor a replica system for 24x7 availability, step by step with out of the box scripts

4.10 (49 reviews)

Udemy

platform

English

language

Other

What you will learn

High availability

Replication System

Streaming Replication Asynchronous

Hot standby to allow read-only connections

Failover so that when the primary database goes down, a replica is activated immediately and the service is not interrupted

Switchover to reverse the roles between the Primary and Standby

Promote a standby, that is, make it a master

Clone a standby to connect it to the master

Virtual IP to connect to the main database

Virtual IP to connect to the standby database

Why take this course?

A database system must be available when it is needed, and even more so in specific business cases such as large companies, emergency services, banks, etc.

To guarantee an availability close to 100% it is necessary to implement a replica system that allows us to ensure that clients can work with another server when the main database server has to be disconnected to carry out maintenance tasks or expansion tasks. Anothre feature this replica system enables is that in the event of an uncontrolled drop in service, clients have another server to work with while the problem is resolved.

The availability of 99.99% is possible and in this course I install, configure and monitor a replica system to teach you how to do it, step by step, so that you do not have any difficulties when backing up your PostgreSQL databases with this system. .

Not only will you have a secondary server (also called standby or slave) with which to work, with all the data, in the event of a main server crash, but also you will be able to use that secondary server for reading operations. In so doing, customers who access the system to perform reports, statistics, pattern analysis, etc., will be able to do it through the standby server, reducing the workload on the main server, for the benefit of the entire system.

The replication system that we will configure in this course will have a failover system implemented. This means that, in the event of an unexpected crash of the database service, the standby server will become the new master without intervention from the DBA, automatically, whatever time it is, whatever day it is, and the service can continue without problems.

Finally, and to further assure the clients of this availability, we will use two virtual IPs, one to connect to the main database, and another to connect to the replica, so that clients do not have the need to know how many servers form part of the replica system, if they are active or down, nor the role that each one of them has.

Screenshots

How to configure a High Availability System in PostgreSQL - Screenshot_01

How to configure a High Availability System in PostgreSQL - Screenshot_02

How to configure a High Availability System in PostgreSQL - Screenshot_03

How to configure a High Availability System in PostgreSQL - Screenshot_04

Reviews

Michel

August 14, 2023

Translation is good and examples are easy to understand. I would like to see more content. I think, there is room for more in depth examples. In some Q&A answers are teasers for more content in the future. Some Graphics could be useful.

Marcell

June 13, 2023

The course is good but I would really appreciate an update on how we can configure virtual Ips on ubuntu 22.04 LTS for this as it uses netplan and does not support the method used in the course anymore. Also I would love if we can get an additional video for synchronous setup. I spent a lot of time researching this and I am not sure if I got my Ubuntu virtual IPs and synchronous replication correct.

Denis

May 18, 2023

The course is ok. It covers all aspects of docu with a good explanation. However, it would have been good if the author had pointed to the aspect in lesson 3. Replica is not needed to be configured in new created servers. Repmgr will do all job. I didn't check, but it looks like even the already existing huge DB repmgr is able to replicate correctly. At least I was able to add a new node to the working cluster.

Kay

April 18, 2023

Overall this is great course. Got a little lost in the beginning of staging the 2 nodes postgresql databases such as sizing, the tables, should I clone my first VM or setup a new one and how's the NICs configuration. Being new to the class, I didn't know what to expect. I had to take sometime for a little trial and errors. Overall, not too much of a difficulty, just sometime taken to for some guessworks instead of working straight on the labs. Some basic write ups (text documentation) prior to the start of the class would be great.

Wally

January 29, 2023

Quick and to the point knowledge, I sure will use this information to implement my HA solution on my work place.

Shahajada

September 11, 2022

The course is really nice and very descriptive and precise. I really like the quality of the content.

Vicky

March 14, 2022

Genial curso. Lo que aprendí me será muy útil. Sencillo de entender gracias a que está muy bien explicado.

Charts

Price

Rating

Enrollment distribution

How to configure a High Availability System in PostgreSQL - Distribution chart