content_image/799479.jpg content_image/799480.jpg
actually executed on the replica under row-based replication. This is because, if both the source and the replica applied the changes from the source and, in addition, the trigger causing these changes were applied on the replica, the changes would in effect be applied twice on the replica, leading to different data on the source and the replica. 

In most cases, the outcome is the same for both row-based and statement-based replication. However, if you use different triggers on the source and replica, you cannot use row-based replication. (This is because the row-based format replicates the changes made by triggers executing on the source to the replicas, rather than the statements that caused the triggers to execute, and the corresponding triggers on the replica are not executed.) Instead, any statements causing such triggers to be executed must be replicated using statement-based replication. 

## A.6 MySQL 8.0 FAQ: Views 

For more information, see Section 17.5.1.36, “Replication and Triggers” . 

<img src='content_image/799479.jpg'>

## A.7 MySQL 8.0 FAQ: INFORMATION_SCHEMA 

<img src='content_image/799480.jpg'>

