Competitors to Bucardo version 1
Last time I described the design and major functions of Bucardo version 1 in detail. A natural question to ask about Bucardo 1 is, why didn’t I use something else already out there? And that’s a very good question.
I had no desire to create a new replication system and work out the inevitable kinks that would come with that. However, nothing then available met our needs, and today still nothing I’m familiar with quite would. So writing something new was necessary. Writing an asynchronous multimaster replications system for Postgres was not trivial, but turned out to be easier than I had expected thanks to Postgres itself—with the caveats noted in the last post.
But, back to the landscape. What follows is a survey of the Postgres replication landscape as it looked in mid-2002 when I first needed multimaster replication for PostgreSQL 7.2.
PostgreSQL Replicator is probably the most similar project to Bucardo 1. It was released in 2001 and does not appear to have had any updates since October 2001. I don’t recall why I didn’t use this, but from reviewing the documentation I suspect it was because it hadn’t been updated for PostgreSQL 7.2, it used PL/Tcl, and required a daemon to run on every node. But the asynchronous store-and-forward approach, the use of triggers and data storage tables is similar to Bucardo 1.
I don’t remember whether this was around in 2002, but it’s part of PostgreSQL contrib now. It is master/slave replication only.
I don’t think Slony-I existed in 2002—version 1.0 was released in 2004. But in any case, it only does master/slave replication.
There has been no code released from this project and the website is now gone.
Master/slave replication, abandoned in favor of Slony-I. Website is now gone.
This was a research project that worked with PostgreSQL 6.4. Some Postgres-R design documents were published. An effort to port it to PostgreSQL 7.2 (the pgreplication project) did not appear to have gotten very far. In 2008 it seems to have been partially revived. I don’t know what the current status is.
This didn’t exist in 2002. I’m not sure where it’s at now. I believe it uses synchronous replication.
This isn’t the kind of “replication” I wanted; it’s database load balancing and multiplexing. The pgpool listener is a single point of failure, and all databases must be accessible or data will be lost on a database server that is down.
Master/slave replication for backup purposes.
This didn’t exist in 2002. It is only master/slave replication. It began as proprietary software but I believe is open source now.
EnterpriseDB Replication Server
A proprietary offering that came out in 2005 or 2006, for master/slave replication only. Has apparently been replaced by Slony, or perhaps was always rebranded Slony.
An rsync-like tool for comparing databases. Didn’t exist in 2002. Probably much better than Bucardo 1’s compare operation.
Kind of like pgpool, more of a connection pooler. Hasn’t been updated since 2002.
“Database Replication based on Group Communication.” Links to this project were defunct.
DBI-Link isn’t about replication.
I assembled this list some time back and have made some updates to it. I’m sure there are more to consider today. Please comment if you have any corrections or additions.