• Startsiden
  • Kurs
  • PostgreSQL Administration Workshop - High Availability Architecture

PostgreSQL Administration Workshop - High Availability Architecture

This intensive two-day course provides a masterclass in PostgreSQL High Availability and Scalability. Participants will journey through the foundational mechanics of Physical Replication and Connection Pooling, before mastering the industry's leading orchestration frameworks: Patroni and Pacemaker.

By combining theoretical architectural knowledge with practical failover scenarios and traffic management via HAProxy, this training equips database administrators with the tools to design, deploy, and maintain resilient, self-healing database clusters in production environments.

The lab activities will be on the 3 virtual machines on Oracle VirtualBox Manager. The guest operating system on these virtual machines is Oracle Linux.

Course Objectives

After completing this course, participants will be able to:

  • Configure and manage Palo Alto Networks next-generation firewalls
  • Understand the architecture and core components of Palo Alto firewall platforms
  • Implement security policies to control network traffic between security zones
  • Configure and manage NAT policies
  • Use App-ID to identify and control applications on the network
  • Monitor network activity and analyze firewall logs and reports
  • Implement threat prevention features to block malicious traffic
  • Manage firewall configurations and administrator access

Target Audience

  • Database Administrators.

Prerequisites

Delegates attending this training should have attended the “PostgreSQL Administration Workshop” course, or have equivalent experience.

About the instructor Cuneyt Yilmaz

Cuneyt is working as senior instructor and consultant with specialty in Analytics, Business Intelligence, Data Management and Performance Tuning. He is a certified trainer for Microsoft and Oracle, and he also delivers training on MongoDB and PostgreSQL.

Cuneyt is based in Istanbul but has been working with customers in 35 countries across the Nordics and EMEA over the last 15 years. He combines top technology skills with his kindness and strong pedagogical skills. We dare to say, nobody leaves Cuneyt`s classroom disappointed! 

Module 1: Replication Overview

  • Replication Overview
  • Replication Slots
  • Switchover
  • Failover

Module 2: The Role of pgBouncer

  • Installation & Configuration
  • Connection Management
  • Failover Tests

Module 3: Using Patroni as the Cluster Manager

  • Overview of Cluster Manager
  • The Benefit of Patroni
  • Etcd as a Distributed Content Store (DCS)
  • Installation and Configuration
  • Switchover-Failover Tests

Module 4: HAProxy Overview

  • High Availability using HAProxy
  • Health Checking Methods
  • Traffic Direction
  • Switchover-Failover Tests

Module 5: Using Pacemaker as the Cluster Manager

  • Pacemaker Overview
  • Pros and Cons of Pacemaker
  • High Level steps of implementation of Pacemaker

Practical information

Duration: 2 days
Price: 16 500 NOK
Language: English
Format: Available as open enrollment or private company training

FAQ

Hvor lenge varer kurset?
Kurset varer i fem dager.

Hvordan gjennomføres kurset?
Kurset gjennomføres som instruktørledet undervisning med praktiske lab-øvelser der deltakerne konfigurerer og administrerer Palo Alto Networks-brannmurer.

Hvem passer kurset for?
Kurset passer for sikkerhetsingeniører, systemadministratorer og andre som arbeider med drift og administrasjon av nettverkssikkerhet.

Hva lærer jeg i løpet av kurset?
Du lærer hvordan du konfigurerer og administrerer Palo Alto Networks next-generation firewalls, inkludert sikkerhetspolicyer, NAT-policyer, applikasjonskontroll og overvåking av nettverkstrafikk.

Relevant courses

Other subject areas