Bucardo: More than Just Multi-Master
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.