PGCon2008 - Final - we hope

PGCon 2008
The PostgreSQL Conference

Greg Sabino Mullane
Day Talks - second day (2008-05-23)
Room B
Start time 16:00
Duration 01:00
ID 93
Event type lecture
Track Horizontal Scaling
Language en


The open source multi-master replication system

Learn the strengths and weaknesses of Bucardo, an asynchronous multi-master replication system, and see a demo of it in action.

Bucardo is a new multi-master and master-slave asynchronous replication system for Postgres. It uses Perl, PlPgsql, and PlPerlu to get the job done, and has many other features that can make moving your data around from one server to another a lot easier.

We'll look at quick look at the problems involved with replication in general, and then look at how Bucardo approaches them, both in normal master to multiple slaves configuration, and in the master to master configuration. We'll examine the many custom hooks that Bucardo allows you to write an insert into any point in the configuration. Bucardo spurred the development of a helper module, DBIx::Safe, which prevents said hooks from doing things they should not, while still having deep access to the databases.