PostgreSQL at Scale: Database Schema Changes Without Downtime

PostgreSQL at Scale: Database Schema Changes Without Downtime

摘要

Braintree Payments uses PostgreSQL as its primary datastore. We rely heavily on the data safety and consistency guarantees a traditional relational database offers us, but these guarantees come with certain operational difficulties. To make things even more interesting, we allow zero scheduled functional downtime for our main payments processing services.