Running triggers on the slave for Row-based events
You are viewing an old version of this article. View
the current version here.
When one is using replication, they normally do not need to care about triggers. Triggers' actions are propagated to the slave:
- When one uses statement-based replication, binary log will contains SQL statements. Slave server(s) execute the SQL statements. Triggers are run on the master and on each slave, independently.
- When one uses row-based replication, binary log will contain row changes, it will have both the changes made by the statement itself, and the changes made by the triggers that were invoked by the statement.
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.