PostgreSQL High-Availability & Patroni Cluster Manager

Level:

Advanced

Duration:

3 days

Dates & Times

See available dates for this High-Availability & Patroni course!
If there is no date and time available for a certain training you are interested in, please contact us.

See dates  >>

 

This course takes 3 days with 8 hours each (on site) or 4 hours each (online).
The only difference is that there will be less practical exercises in an online course. However, we will hand them over to you and you can still do them on your own and ask our consultants for feedback or help if needed.

Summary

This course is intended for PostgreSQL users who are interested in fully automating high availability operations.
The course first gives an overview of the general high availability landscape in PostgreSQL clusters and then focuses on the very popular (open source) cluster manager «Patroni».

Audience Requirements

Target group for this course are experienced PostgreSQL users with at least basic Linux knowledge (command line, editing of configuration files)

Available Languages

This course can be held in English, German and Estonian.

AGENDA

Overview of PostgreSQL High Availability (HA):

  • binary replication
  • typical replication problems and solutions
  • built-in HA mechanisms
  • switchover and failover
  • logical replication

 

HA automation:

  • basic concepts
  • standard HA problems
  • decisions with consent
  • different approaches

 

DCS for consensus:

  • installation of etcd

 

Patroni:

  • basic idea & introduction
  • installation
  • configuration & operation

 

Patronictl:

  • extended functionalities
  • postgresql.conf + pg_hba.conf replacement
  • common problems

 

Routing of client requests:

  • libpq/JDBC
  • vip manager
  • HAProxy

 

Updates and upgrades