PGCon2015 - final
PGCon 2015
The PostgreSQL Conference
| Speakers | |
|---|---|
|
Jose Luis Tallon |
| Schedule | |
|---|---|
| Day | Tutorials & Unconference - Day 2 - Wednesday - 2015-06-17 |
| Room | DMS 1140 |
| Start time | 09:00 |
| Duration | 03:00 |
| Info | |
| ID | 867 |
| Event type | Workshop |
| Track | Tutorial |
| Language used for presentation | English |
Business Continuity, High Availability and Disaster Recovery
Blueprints, validated architectures and implementation tips for HA / DR / BC
Having run Postgres reliably for years does not automatically exempt anyone from eventually having some data loss incident.
Even when PostgreSQL is one of the more robust and resilient databases, disaster can still strike. When ensuring that some incident will not kill the business is your responsibility, preparation is key.
This tutorial covers Business Continuity topics, focusing on the techniques needed to achieve adequate availability (HA) as well as prepare for disaster recovery (DR) should something happened to your database. We will describe the evolution from a stand-alone database to a fully replicated, distributed setup as well as several specific techniques to increase recoverability using some features from PostgreSQL 9.4. Backup and recovery techniques will be reviewed and evaluated in terms of RPO/RTO objectives and the associated tradeoffs.
The session will close with an open scenario/interactive round of questions where specific use cases will be analyzed and solutions will be suggested.