TR

Scaling and High Availability Course for PostgreSQL

Course Audience

PG203
2 DAYS

System administrators who manage a PostgreSQL database service and aim to scale this service across multiple servers, enhance its backup capabilities, and ensure its continuous service in case of disasters.

Course Prerequsities

Informations that required by participants before course:

  • Participants who will join this course should also have joined PG202, PG101, PG201 courses before or mastered related subjects of these courses.

Course Goals

  • Learning scaling and high availability options applicable to the PostgreSQL service
  • Setting up streaming replication in PostgreSQL and configuring a standby server
  • Installing PgPool to set up connection pooling and distributing read queries

Course Subjects

  • Replication Concepts and High Availability Options
  • Streaming Replication
  • Hot Standby
  • Synchronous Replication
  • Connection Pooling
  • Sharding
  • Failover
  • Data Loss
  • Cluster Management