Bucardo

Bucardo 是一个PostgreSQL的异步同步工具，它支持任意方式的主从同步，multi-master或者multi-slave等。新版Bucardo可将数据同步到其他存储系统，如MongoDB。

安装

安装 DBIx::Safe、DBD:Pg、Test::Simple

yum install perl-DBIx-Safe or
apt-get install libdbix-safe-perl
apt-get install libtest-simple-perl // install Test::Simple
install DBD:Pg
export POSTGRES_LIB="/usr/local/pgsql/lib -lssl -lcrypto"
tar xvfz dbix_safe.tar.gz
cd DBIx-Safe-1.2.5
perl Makefile.PL
make
make test
make install

安装Bucardo

tar xvfz Bucardo-4.4.8.tar.gz
cd Bucardo-4.4.8
取得最新包：git clone git://bucardo.org/bucardo.git
INSTALL_BUCARDODIR=/tmp/bucardotest perl Makefile.PL
perl Makefile.PL
make
make install

创建Bucardo数据库

bucardo_ctl install
bucardo_ctl add database <dbname>
bucardo_ctl start

直接/usr/local/pgsql/bin/psql -e < bucardo.schema

PgSQL to MongoDB

MongoDB replication from Postgres using Bucardo

链接

• Bucardo官网