Running a web application that is used by people from all over the world means that you cannot afford any downtime.
However, the codebase and the database schema constantly evolves, while at the same time hardware failures may happen.
The talk will try to present ways that we, at transifex.net, use to deal with the following two issues:
- schema changes
- hardware failures
in order to achieve 100% uptime.
The talk will discuss tools that PostgreSQL provides, like functions and triggers, and how they can be used to deal with schema changes and how to setup streaming replication for fail-over.