[Bucardo-general] Master-Master->slave working?

[Michelle Sullivan]

Greg Sabino Mullane wrote:
>> Where aumaster and usmaster are in sync, and backup_server is not...
>>
>> To get them in sync I sent the following to the auserver:
>>
>> delete from audit where pk = 114761246;
>> delete from evid2raw where rawid = 1 and evidid = 1;
>> delete from rawevidence where rawid = 1;
>> delete from nets2evid where evidid = 1 and netid = 1;
>> delete from networks where netid = 1;
>>
>>
>> My intention is to re-insert them if the deletion put the DBs back in
>> sync.....
>>     
>
> Not exactly sure what you mean by "back in sync", but a simple update 
> should do the trick as well. In other words:
>
> UPDATE audit SET pk=pk WHERE pk = 11476246;
>
> should kick off Bucardo, sync the row to the other side (usmaster 
> in this case), and from there push it on over to the backup_server 
> (once the recent fixes to Bucardo.pm are applied and makedelta 
> starts working).
>
>   
Rather than an update I just deleted the rows that were in the 2 masters
and not the backup slave using the 5 deletes above as a single
transaction.  The intention was to re-add the rows above immediately
after and all 3 DBs would have been identical.

Michelle