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

Firing Triggers on tables within a Multi-Master environment

DereksurfsDereksurfs EntrantCurrent User Role Novice

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?



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.