[Bucardo-general] Replicate different Database on the same server using Bucardo

akp geek akpgeek at gmail.com
Tue Feb 23 15:46:37 UTC 2010

Thanks Joshua. I would like to follow the same concept as you mentioned
which would be a very clean approach. However the problem that I might run
into is , if there is any DDL change happens on Test , then chances are that
the bucardo_ctl process would abort and it happend for us.

In that case the replication process for the other database where no changes
have been made is also being effected.

That was root cause for posting  my question.  Appreciate your thoughts on
the question


On Tue, Feb 23, 2010 at 10:25 AM, Joshua Tolley <josh at endpoint.com> wrote:

> On Tue, Feb 23, 2010 at 09:24:30AM -0500, akp geek wrote:
> >      You'll also, of course, need the bucardo schema in each database
> >      you're replicating, and to specify distinct pidfile directories (and
> >      probably also distinct log file locations, too -- unless you want
> half
> >      your log traffic to be noise relative to what you're looking for at
> >      any one time) for each MCP you have running.  I'm having trouble
> >      remembering how to specify different log files offhand, though.
>  Greg?
> >       Joshua?  Beuller?
> I'd install bucardo twice, in two different directories, to make sure
> things
> stayed separate.
> >      All that said, I don't think you strictly need separate MCPs running
> >      to replicate multiple databases.  You should be able to coordinate
> all
> >      that with separate entries in the bucardo.db table, and distinct
> goats
> >      and herds appropriately associated with them.
> >
> >      What's the recommended practice for this kind of scenario?
> Here's the key, I'd say. You don't need multiple instances of Bucardo just
> to
> replicate two separate databases. Simply add the new source and destination
> databases to your existing bucardo setup (e.g. bucardo_ctl add db ...), add
> the objects you want to replicate, and add another sync.
> --
> Josh Tolley  josh at endpoint.com  801-987-0252
> End Point Corporation
> http://www.endpoint.com
> Version: GnuPG v1.4.9 (GNU/Linux)
> fagAnjpkjhLjMXfb1+k6mmTkfYOGePrd
> =lI6d
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20100223/7cbc2dbe/attachment.html 

More information about the Bucardo-general mailing list