[Bucardo-general] Question about makedelta and star replication

[Rodrigo Gonzalez]

Greg Sabino Mullane escribió:
> On Tue, 01 Apr 2008 22:44:02 -0300
> Rodrigo Gonzalez <rjgonzale at gmail.com> wrote:
>
>   
>> I need to use makedelta to handle star replication
>>
>> Consider this
>>
>> DB1
>> DB2
>> DB3
>>
>> Each one has a table called test
>>
>> Now I have a goat for each DB including test table with makedelta = TRUE
>> I have 2 syncs with DB1 as commong point
>> DB2 <-> DB1
>> DB1 <-> DB3
>>
>> Both with makedelta = TRUE
>>
>> That works with checktime = 00:00:01 to make it check each second cause 
>> if updating from DB3, DB2 "wait" check time to be updated.
>>
>> Now my 2 questions:
>>
>> 1 - which makedelta are required and why?
>> 2 - is checktime required or something in my configuration is wrong?
>>     
>
> 1) You should only need a makedelta on the goat for DB1. If a new row
> comes from DB2, we need to make sure that DB3 thinks it is new as well.
>   
Ok, I will test that, I've added another node using the same and worked 
fine, I will let you know id having makedelta only at DB1 works. What 
about makedelta at sync table?
> 2) Checktime is not required, per se, but you'll need some way to tell the
> other sync that it needs to run. This can be done with a customcode on
> both sides that calls the other sync by issuing a NOTIFY.
>   
I am not a perl programmer so maybe checktime is better for me (I dont 
know how to make customcode for bucardo)
> 3) I really need to work on the Bucardo documentation...
>   
Maybe a wiki? I can add my own experience with star replication, of 
course someone with english knowledge should check my experience

Thank you for bucardo, really this is what I was expecting to be able to 
use PgSQL (you cant imagine how hard is having MySQL with ring 
replication in real world)

Rodrigo

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3245 bytes
Desc: S/MIME Cryptographic Signature
Url : https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20080402/267cfdd5/attachment.bin