Overview
Over the past few days we have been working with a number of
customers on the best way to handle Triggers within their MySQL
environment when combined with Tungsten Replicator. We looked at
situations where Tungsten Replicator was either part of a
Tungsten Clustering installation or a standalone replication
pipeline.
This blog dives head first into the minefield of Triggers and
Replication.
Summary and Recommendations
The conclusion was that there is no easy one-answer-fits-all
solution – It really depends on the complexity of your
environment and the amount of flexibility you have in being able
to adjust. Our top level summary and recommendations are as
follows:
If using Tungsten Clustering and you need to use Triggers:
[Read more]