[Bucardo-general] Is Bucardo appropriate for this situation....

[Alex Balashov]

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 <martinhbramwell at yahoo.com> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20120715/bac1ab25/attachment.html>