Description

With this course, PostgreSQL administrators will gain an in-depth understanding of high availability mechanisms and discover a range of available solutions. They will master the implementation of an operational solution with PostgreSQL, including the different forms of replication and load balancing.

Who is this training for ?

For whom ?

Database Administrator (DBA) and SysAdmin.

Prerequisites

Training objectives

Implement physical replication between instances

Improve replication in relation to physical backups

Change replication configuration Implement logical replication between databases

Control load distribution Create and test failure scenarios

Training program

• High availability solutions
  • High availability under PostgreSQL.
  • The different types of replication (synchronous, asynchronous, load balancing).
• Le Warm Standby
  • Definition of the concept.
  • Setting up master and slave servers.
  • Implementing replication.
  • Recovery from an incident .
  • Exercise: Implementing a Warm Standby server.
• Asynchronous replication with Slony
  • Concepts.
  • Installing Slony-I.
  • Configuring nodes and server group.
  • Defining replication sets.
  • Initialization.
  • Starting the Slony-I program.
  • Creating the table set.
  • Modifying the schema.
  • Modifying replication sets.
  • Changing provider and disaster recovery.
  • Exercise: Setting up an asynchronous replication solution with Slony-I tool.
• The connection manager: PgPool
  • Installing PgPool.
  • Installing the system database.
  • Installing the administration tool.
  • Configuration ( pgpool.conf).
  • Use cases.
  • Starting PgPool.
  • Exercise: Setting up a load balancing solution with PgPool .
• Strategic choices
  • Elements to take into account when defining the architecture.
  • Best Practices.