PGCon2008 - Final - we hope
PGCon 2008
The PostgreSQL Conference
| Speakers | |
|---|---|
|
Greg Sabino Mullane |
| Schedule | |
|---|---|
| Day | Talks - second day (2008-05-23) |
| Room | B |
| Start time | 16:00 |
| Duration | 01:00 |
| Info | |
| ID | 93 |
| Event type | lecture |
| Track | Horizontal Scaling |
| Language | en |
| Feedback | |
|---|---|
|
Did you attend this event? Give Feedback |
Bucardo
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.