MySQL Forums
Forum List  »  Triggers

cluster trigger Does not work
Posted by: peng wang
Date: April 09, 2019 02:36AM

galera cluster configuration

/etc/my.cnf.d/server.cnf
[galera]
wsrep_on=ON
wsrep_provider=/usr/lib64/galera/libgalera_smm.so
wsrep_cluster_address="gcomm://192.168.1.132(node1),192.168.1.161(node2),192.168.1.116(node3)"
binlog_format=row
wsrep_cluster_name=DaCluster
wsrep_node_name=DaClusterNode192.168.1.161
wsrep_node_address=192.168.1.161
replicate_wild_ignore_table=da_production.%
replicate_ignore_db="da_production"
replicate_wild_ignore_table=l3.%
replicate_ignore_db="l3"
default_storage_engine=InnoDB
innodb_autoinc_lock_mode=2

The same trigger on each node

question is:
When the db of node1 is updated, the trigger is triggered, but the triggers of the other two nodes are not triggered.

Is cluster synchronization, sql is not used, so there is not triggered, or what settings need to be triggered by cluster to triggered?

please help me!

Options: ReplyQuote


Subject
Views
Written By
Posted
cluster trigger Does not work
326
April 09, 2019 02:36AM
190
April 09, 2019 06:56PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.