Bucardo: More than Just Multi-Master

Talk Type: 
45 Minute Talk
Track: 
Administration
Track: 
Emerging technologies
Track: 
Migration
Track: 
Replication/HA
Technical Level: 
Intermediate
License: 
BSD

While Bucardo is often known for being one of the few multi-master replication systems available for PostgreSQL, there are also many other uses for it as a general tool for:

* multi-master configuration
* live/minimal downtime database upgrades
* live/minimal server migrations
* data aggregator

Features of Bucardo will be examined, as well as an architectural overview. We will also review its real-life use in a live migration from an existing multi-node Slony/PostgreSQL 8.2 cluster in one data center to a PostgreSQL 9.0/Hot Standby cluster in another with minutes of downtime. Comparisons will be made between Bucardo's approach and Slony's, and brief coverage of the options these differences open up will be made.

No existing familiarity with Bucardo is necessary, but knowledge of various existing replication systems and concepts will be a plus.

We will also cover the upcoming Bucardo 5.