Yes, I would say Bucardo is designed specifically for this scenario in mind far
more so than most replication systems.
-- Alex
--
Sent from my Samsung mobile, and thus lacking in the refinement one might
expect from a proper keyboard.
Alex Balashov - Principal
Evariste Systems LLC
235 E Ponce de Leon Ave
Suite 106
Decatur, GA 30030
Tel: +1-678-954-0670
Web: http://www.evaristesys.com/Martin Bramwell <[email protected]>
wrote:Hi
I found Bucardo earlier today by googling "Postgres bidirectional replication",
and I'd like to ask if it is suited to a situation I have in mind.
I live in a developing country where Internet connectivity to the rest of the
world is not 100% reliable; its more like 98%. I am preparing a start-up
import/export company here with Magento and OpenERP (that use PostgreSQL on the
back-end, of course). They have small sales teams and customers here, in the
USA and in Southeast Asia.
My idea for ensuring continuous data access for all three teams is to run two
server machines: one in their head-office here and the other as a rented VPS
overseas. I'd run Bucardo "somewhere" to keep the two databases synchronized.
Since, I pretty much count on losing connection between the two machines for
two or three hours every week, I wonder how Bucardo would handle such
behavior. Especially, we experience what I'd call "sputtering" connections; a
few packets get through every minute or so, for prolonged periods)
In general terms my questions might be:
1) Is there a maximum downtime between master servers beyond which Bucardo will
croak?
2) Does Bucardo handle "sputtering" replication gracefully?
Sincere regards,
Hasan
_______________________________________________
Bucardo-general mailing list
[email protected]
https://mail.endcrypt.com/mailman/listinfo/bucardo-general
