使用Bucardo从PostgreSQL同步数据到MongoDB
Bucardo 是一个PostgreSQL的异步同步工具,它支持任意方式的主从同步,multi-master或者multi-slave等。而最近Bucardo的一个版本中将数据同步到其他存储系统。比如下面这个同步到MongoDB的例子,其使用也非常简单,下面是截取的部分代码,更具体的安装测试全教程请点下面来源。
来源地址:MongoDB replication from Postgres using Bucardo
.....
$- bucardo add sync mongotest herd=therd dbs=tgroup ping=false
- Added sync "mongotest"
- $ bucardo start
- Checking for existing processes
- Starting Bucardo
- $ pgbench -t 10000 btest1
- starting vacuum...end.
- transaction type: TPC-B (sort of)
- number of transactions actually processed: 10000/10000
- ...
- tps = 503.300595 (excluding connections establishing)
- $ pgbench -t 10000 btest2
- number of transactions actually processed: 10000/10000
- ...
- tps = 408.059368 (excluding connections establishing)
- $ bucardo kick mongotest
- .....
复制代码 |