[Bucardo-general] Replicate different Database on the same server using Bucardo
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
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
> > 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.
> > Joshua? Beuller?
> I'd install bucardo twice, in two different directories, to make sure
> 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
> > that with separate entries in the bucardo.db table, and distinct
> > 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
> 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
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.9 (GNU/Linux)
> -----END PGP SIGNATURE-----
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Bucardo-general