Firing Triggers on tables within a Multi-Master environment

MySQL & MariaDB Percona XtraDB Cluster 5.x
1

Hello,

I am considering adding triggers (onInsert, onUpdate, onDelete) on certain transactional tables which are central to our database schema. I would would like to offload Reporting elements to another Reports table which is basically a large join of these tables. This is would be similar to a Materialized View in Oracle or PostgreSQL.

How do triggers work when firing (or Not) within a replicated Multi-Master environment?

Thanks,
Derek

2

“With statement-based replication, triggers executed on the master also execute on the slave. With row-based replication, triggers executed on the master do not execute on the slave. Instead, the row changes on the master resulting from trigger execution are replicated and applied on the slave.”

[URL]https://dev.mysql.com/doc/refman/5.7/en/replication-features-triggers.html[/URL]