PostgreSQL High Availability & Patroni Cluster Manager
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.
This training can also be held at your place or as online training especially for your company. In this case the course agenda can also be adapted to suit your needs best.
Learn more about our customized training >>
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
Other courses that might interest you
We offer these services
9/5 Basic Support
El soporte básico 9/5 de CYBERTEC incluye todos los servicios de Product Support y además Tuning y resolución extendida de problemas. 9/5 significa que estaremos disponibles para usted de lunes a viernes de 9 AM a 5 PM (CET / MEZ). Otras zonas horarias a petición. CYBERTEC proporciona las correcciones de todos los errores para las […]
9/5 Dedicated DBA
El servicio de soporte DBA Dedicado 9/5 incluye un experto de CYBERTEC que se ocupa de forma remota de sus bases de datos. Nos ocuparemos de cualquier problema antes de que siquiera lo note y le informaremos de manera proactiva sobre posibles contingencias futuras y acciones necesarias. Soporte de DBA Dedicado 9/5 significa que su […]
CYBERTEC Partner Network (CPN)
Consultoría experta en PostgreSQL para su portfolio de productos La solución perfecta para resellers y revendedores de software: ¿Es de una empresa de software o sistemas que ofrece PostgreSQL a sus clientes? ¿Necesita un partner experto en el área, con más de 20 años de experiencia, servicios sofisticados y desarrollos propios? Sumese a CYBERTEC Partner […]