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

Michelle Sullivan michelle at sorbs.net
Wed Jun 23 02:30:37 UTC 2010

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.


More information about the Bucardo-general mailing list