James Coleman: PostgreSQL at Scale: Database Schema Changes Without Downtime Planet PostgreSQL

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.Several years ago we published a blog post detailing some of the things we had learned about how to safely run DDL (data definition language) operations…

External feed Read More at the Source: https://postgr.es/p/4kZ