Building Enterprise Grade PostgreSQL using Percona distribution for PostgreSQL
summary
Percona Distribution bundles community Postgres (11 and 12) with tested tooling so you get point‑in‑time recovery and incremental, encrypted backups via PGBackRest to S3, automatic failover using Patroni + etcd for automatic failover with HAProxy routing, connection pooling that dramatically reduces connection overhead with pgBouncer for pooling, and online table rebuilds with PG_repack for online rebuild. Audit/logging uses PG Audit and PG Badger, monitoring uses PMM Query Analytics, and these components are deployed in production by customers and report reliable, measurable improvements.
AI-written summary · about
chapters (12)
- 0:00Introduction
- 1:48Whats included in Percona
- 2:59Myths about PostgreSQL
- 4:34Enterprise Grade PostgreSQL Features
- 6:22Security and PostgreSQL
- 9:13Backup strategy
- 11:15Connection pooling
- 14:48Automatic failover
- 16:20Percona architecture
- 17:39PostgreSQL extensions
- 23:37Detailed logging of activity
- 25:15Monitoring
related talks
13mBuilding reliable infrastructure with Postgres
15mPercona Database Distributions - An Overview
02mPostgreSQL Core Distribution 13
57mReliability features in Postgres Pro
38mWhat we built with Open Source
30mComposing a Multi Database DBaaS from Open Source Kubernetes Operators
02mPercona Enterprise Platform
54mLessons from two decades of hacking the proprietary value into open so