Not the answer you need?
Register and ask your own question!

Trigger replication issue (trigger loop)

naNonaNo EntrantCurrent User Role Beginner
I encountered a strange behaviour today when setting up a cluster, starting with 2 nodes, that triggers started replicating in a loop and would continue to do so. So the trigger sets of once and then triggers the trigger again for whatever reason. This is not happening on a single server and starts as soon as I add a node to the cluster and will skyrocket once I add another node. Are there any known issues with triggers? AFAIK they should not be replicated at all, or at least be flagged to not execute on the other nodes again. What am I missing here?

Is there anyone who knows what could be happening? It was planed to use the cluster for 9 to 10 nodes and the trigger problem killed the whole project for now.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.