[Bucardo-general] trigger on slave table for Burcardo

[akp geek]

thanks for providing me some direction. I will custom code per our
requirements.

Regards

On Wed, Feb 23, 2011 at 1:15 AM, Rosser Schwarz <rosser.schwarz at gmail.com>wrote:

> On Tue, Feb 22, 2011 at 2:45 PM, akp geek <akpgeek at gmail.com> wrote:
> > Is it possible to have a trigger on the
> > slave at all? or if it is possible is there any special instructions to
> be
> > followed?
>
> Bucardo disables triggers and rules on tables during replication.
> This is usually the Right Thing for a number of reasons, but leave it
> to the internets to find someone with a use-case where it's not
> quite...
>
> Is Bucardo the only thing writing to the table on which you've put the
> trigger?  If so, you might be able to get the desired result by
> writing a customcode that performs the modifications on the new table.
>  There's some documentation on the wiki you can look at, though it's
> pretty sparse.  The gist of it is that you can define a Perl sub
> that's executed at some (specified) point in the context of a
> replication event. Being a custom Perl sub, you can do pretty much
> whatever you want in it, including modify or perform additional
> operations with the row(s) being replicated.
>
> I haven't personally used customcodes but they've been used quite
> successfully in environments I've worked in, so I think that's
> probably your first bet. Unfortunately, I can't speak any more
> specifically than that.
>
> Can someone with more direct experience or knowledge chime in and
> elaborate?
>
> Thanks.
>
> rls
>
> --
> :wq
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20110223/12b3f3e8/attachment.html