DBReplicator speed/scalability

Hello,

I'm thinking about integrating DBReplicator in my Java (Swing -> RMI -> Hibernate) application. We use PostgreSQL as the main database, but that could change anytime if we use DBReplicator.

But my concern is about speed, scalability and Network traffic, basically. How does DBReplicator compares to Bucardo, for instance, in this subject?

Oh, and one other thing: I read somewhere that in DBReplicator a subscriber can subscribe to one publisher per time. Is this true? Isn't it possible to have this structure:
Site 1 - pushes to Site 2, 3 and 4 when data changes are comitted
Site 2 - pushes to Site 1, 3 and 4 when data changes are comitted
Site 3 - pushes to Site 1, 2 and 4 when data changes are comitted
Site 4 - pushes to Site 1, 2 and 3 when data changes are comitted
?

Thanks in advance,
Renato Atilio.

Sure thing

create 3 subs in each Site. such as Site1_sub_Site2_pub,Site1_sub_Site3_pub,Site1_sub_Site4_pub and etc.

Powered by Drupal - Theme by Danger4k