Replication and HA in PostgreSQLPgSQL-REPL-HA

The course is available on demand.

Remote training: online live with a trainer and a group. Available on demand, at time and place convenient to you, for groups of at least 5 participants.

exempt from VAT

Price: 740 EUR

refreshments included

computer station included

first minute (30+ days before) - 3%

Category: PostgreSQL

The training focuses on the management of PostgreSQL large size databases, working in conditions requiring high availability. We discuss the issues of correct implementation of HA (High Availability) system for PostgreSQL and techniques which are intended to distribute application load over several servers. We will give some reliable recipes for systems that could survive the failure of the infrastructure’s part without disrupting their work.

The training programme includes analysis of the available PostgreSQL replication methods and practical examples of embedded replication usage. We will accurately explain the difference between synchronous and asynchronous replication and we will analyse the advantages and disadvantages of each solution. We will not forget about comprehensive approaching the issue of monitoring, without which HA systems cannot do.

Our instructors have many years of experience with PostgreSQL, both as administrators and as programmers. One of our trainers is a PostgreSQL contributor and a regular speaker at the world’s largest conference on the topic.

Duration

2 days

Agenda

  1. PostgreSQL operation log
    • Principle of WAL operation
    • Logs archiving (log shipping)
    • _pg_basebackup_program
    • _pg_receivexlog_program
    • Point In Time Recovery
  2. Replication
    • Hot standby
    • Streaming replication
      • Monitoring replication stage
      • Replication parameters tuning
      • Cascading Replication
    • Synchronous replication
      • Inner workings
      • The balance of benefits and costs
    • External replication systems
  3. High Availability
    • Replication setting for HA
    • Master-slave automated promotion
      • STONITH problem (Shoot The Other Node In The Head)
    • Security guarantees for HA systems
    • Estimating the risk of loosing data in case of failure
    • External HA systems for PostgreSQL

Download as PDF

Audience and prerequisites

We recommend that the participants have good knowledge of PostgreSQL and ability to administrate Linux system.

Certificates

Course participants receive completion certificates signed by ALX.

There are currently no entries

Enter your e-mail address and we will notify you about future dates

Question?

Ask us anything about this training

* I hereby give my consent to the processing of my personal data by ALX Training Ltd. for the purpose of this request.