[Bucardo-general] bucardo - replication small clarification

akp geek akpgeek at gmail.com
Wed Jan 13 17:48:10 UTC 2010


Thanks Greg .

On Wed, Jan 13, 2010 at 10:19 AM, Greg Sabino Mullane <greg at endpoint.com>wrote:

>  >                 I have set up Bucardo for the replication. for the
> tables
> > with primary keys , it works fine. We have some tables where we don't
> have
> > keys. For those tables without keys, I am planning to set up the full
> copy.
> > Will Bucardo do a full copy every time a change is noticed in the master.
> or
> > will there be any other way of handling the scenario
>
> A fullcopy sync will only run each time if the sync-level ping is set to
> true, or if a table's ping is set to true. You can set it up to do the
> fullcopy anytime something changes by using ping, but many people prefer
> to do external manual kicks (e.g. by cronjob) to prevent copying large
> number of rows all the time.
>
> If the tables are small, you can probably just set the sync to ping. If
> larger, consider adding a primary key to the tables and switching to
> pushdelta, or only copying them at certain intervals by cron-driven kicks.
>
>
> --
> Greg Sabino Mullane greg at endpoint.com
> End Point Corporation
> PGP Key: 0x14964AC8
>
>
> _______________________________________________
> Bucardo-general mailing list
> Bucardo-general at bucardo.org
> https://mail.endcrypt.com/mailman/listinfo/bucardo-general
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20100113/1bb2384a/attachment.html 


More information about the Bucardo-general mailing list