The makedelta process is used by Bucardo to add entries to the bucardo_delta table and the bucardo_track table as replication is happening. This is needed if the updates made by a sync need to be read at a later time by a different sync. For example, if you had a pushdelta sync “alpha” replicating rows from database A to database B, and another pushdelta sync replicating rows from database B to database C, you would need to turn on makedelta for sync “alpha”, so that the rows copied from A to B are able to be picked up as changed rows for the B to C sync.
There are four columns that control the use of makedelta:
swap syncs require both source and target makedelta settings, at either the goat or sync level.
The easiest way to enable makedelta is to simply set it as needed at the sync level. In the example above, you would do:
bucardo update sync alpha target_makedelta=1
However, if you have many syncs using the same tables, it’s easiest to leave the sync level as null, and update the tables:
bucardo update table <table1> target_makedelta=1
End Point Dev offers professional support for Bucardo, as well as specializing in developing, designing, and marketing effective websites. Since 1995, our diverse team of developers has shown that End Point can handle your organization’s greatest web and database challenges.