[Bucardo-general] Swap replication latency
Joshua Tolley
josh at endpoint.com
Wed May 4 22:26:50 UTC 2011
On Wed, May 04, 2011 at 12:34:35PM -0400, Alex Balashov wrote:
> How does Bucardo deal with this? I am realising just now that it may
> not. Let's say I have table 'evariste_trans_events' on which a trigger
> cascade operates to turn it into single 'evariste_trans' rows. The
> normal way this happens on the source database is that the application
> inserts rows into 'evariste_trans_events', and triggers machine that data
> into the appropriate representation in 'evariste_trans' as needed. Most
> of the time, 'evariste_trans' will be UPDATE'd based on subsequent
> 'evariste_trans_events', although the initial event will cause an INSERT.
Bucardo puts triggers on all replicated tables. When your application's
triggers run and modify a replicated table, the bucardo triggers run and tag
those rows for replication. On the slave, Bucardo disables application
triggers, so it can replicate data from the master and not have your
application's triggers getting in the way.
--
Josh Tolley josh at endpoint.com 801-987-0252
End Point Corporation http://www.endpoint.com
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: Digital signature
Url : https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20110504/115cb7f8/attachment.bin
More information about the Bucardo-general
mailing list