Command Palette

Search for a command to run...

Hectal

Part 1

Databases in Production: PostgreSQL

What a DevOps or platform engineer must know about the database behind almost every app: architecture, connections, performance, replication, failover, and safe schema changes.

You don't need to be a DBA, but you will be paged when the database is slow, full, or failing over. PostgreSQL is the most common open-source relational database and the default on RDS and Aurora, so it's the one this course uses. The ideas (WAL, MVCC, pooling, replication lag, expand/contract migrations) carry over to MySQL and most other databases.

0/3 · 0%
  1. 1.1

    PostgreSQL Essentials for DevOps

    Beginner

    How Postgres is put together (processes, memory, WAL, MVCC), connecting and managing roles safely, the config files you'll touch, and where SQL vs NoSQL fits.

    45 min · 4 lab steps · 2 drills

  2. 1.2

    Connections, Pooling, and Query Performance

    Intermediate

    Why 'too many connections' happens, PgBouncer and RDS Proxy, reading EXPLAIN ANALYZE, indexes that help (and hurt), pg_stat_statements, and lock contention.

    55 min · 5 lab steps · 2 drills

  3. 1.3

    Replication, Failover, Upgrades, and Zero-Downtime Migrations

    Advanced

    Streaming replication and lag, read replicas vs high availability, Patroni and RDS Multi-AZ failover, major version upgrades, and the expand/contract pattern for schema changes.

    60 min · 4 lab steps · 2 drills