fr
en
PostgreSQL Replication and High Availability
You need to be able to recover your data after an incident. With PostgreSQL, structure protection and recovery mechanisms to prepare operations more effectively. Strengthen your ability to check safeguards and organise database interventions.
- Duration
- 3 days 21 hours
- Code
- POS03FR Code
Presentation
This course develops participants' skills and knowledge of PostgreSQL replication and high-availability mechanisms.
Objectives
This course enables participants to implement a replicated system to ensure data security and availability through the following topics:
- Review of archiving, hot backups and point-in-time recovery (PITR).
- Replication techniques: warm standby (log shipping), hot standby (log shipping) and streaming replication.
- Designing a high-availability architecture.
- Pgpool II principles: installation and configuration.
- Incident management.
Program
Review of archiving and hot backups
Understand the key concepts for implementing a hot backup system.
- Configure a cluster in archive mode.
- Perform hot backups of your databases.
Review of PITR
Understand the principles of restoring a hot backup using point-in-time recovery.
- The different postgresql.conf parameters.
- Select the recovery date and time.
- The recovery.conf file.
- Start and monitor recovery.
Replication techniques
Understand the fundamental differences between the available replication options.
- Asynchronous/asymmetric replication.
- Asynchronous/symmetric replication.
- Synchronous/asymmetric replication.
- Synchronous/symmetric replication.
Warm standby (log shipping)
PostgreSQL warm standby replication using log shipping.
- Warm standby principles.
- Implementation.
Hot standby (log shipping)
PostgreSQL hot standby replication using log shipping.
- Hot standby principles.
- Implementation.
Streaming replication
The PostgreSQL streaming replication mechanism.
- Streaming replication principles.
- Implementation.
Incident resolution: failover
Respond to a production incident and learn how to recover your clusters quickly without losing data.
- Failover: switching to the slave cluster.
- Failback: rebuilding replication.
Conclusion
Review of replication techniques
Understand the fundamental differences between the available replication options.
- Asynchronous/asymmetric replication.
- Asynchronous/symmetric replication.
- Synchronous/asymmetric replication.
- Synchronous/symmetric replication.
Review of streaming replication
The PostgreSQL streaming replication mechanism.
- Streaming replication principles.
- Implementation.
Designing a high-availability architecture
Design a multi-server architecture that meets the requirements of a 24/7 service.
- How many servers does my HA architecture need?
- The role of each server.
Pgpool II principles
Explore the main features and options of Pgpool II.
- Replication mode.
- Master/Slave mode.
- Load balancing.
- Failover.
- Online recovery.
- Health checks.
Installing and configuring Pgpool II
Install high-availability PostgreSQL clusters with Pgpool II in our training infrastructure.
- Install Pgpool II on CentOS.
- Explore Pgpool II options and parameters.
- Configure and start Pgpool II.
- Understand Pgpool II load balancing.
Incident management
How Pgpool II responds to an incident such as the loss of the master cluster.
- Understand health checks.
- Loss of the master and promotion of a slave (failover).
- Rebuild slaves (failback).
Conclusion
Audience
This course is suitable for database administrators.
Experience with Linux is desirable.
Prerequisites
The PostgreSQL Advanced Administration course is required.
Teaching and assessment methods
- Initial skills assessment
- Training materials provided to participants
- Continuous assessment throughout the course
- End-of-course feedback questionnaire
- Combination of theory and practical application
- Attendance records
- Post-course follow-up evaluation
Dates and sessions
Choose the date and delivery format that suit you.
No upcoming sessions are currently available.