Big databases, many servers, data center or cloud - it's all here!
summary
Leboncoin describes running PostgreSQL at web scale across hundreds of databases and about 2,000 VMs (20 Gbps peak, ~2,600 TPS) and a cloud migration completed in ~18 months with no downtime. The operational stack includes Collins/NetBox for bare metal, Terraform for cloud, Puppet/Ansible for configuration, pgwatch2 for monitoring, and barman/wal-e (encrypted to S3) for backups; they discuss logical replication, PITR, multi‑AZ RDS failover, schema migration automation, and retention-tested backup policies for a dataset that includes ~300 million images.
AI-written summary · about
chapters (8)
- 0:00Introduction
- 3:12Infrastructure evolution
- 10:19Cloud migration
- 16:49Availability and replication
- 22:43Backups and restore
- 32:54Monitoring and alerts
- 36:27Data flow and microservices
- 41:45Incident management
related talks
36mPostgres at any Scale
54mBreakout Session
43mPostgreSQL in the cloud: Theory and Practice
20mBuild Your Business Based On PostgreSQL Databases
13mBuilding reliable infrastructure with Postgres
59mLarge Scale MySQL Migration to PostgreSQL
49mPractical Guide to Migrating +100 Large PostgreSQL to the Cloud
36mBest Practices in PostgreSQL Tuning: Navigating Key Performance Bottlenecks in the Cloud