Recently I wrote about one advantage of MySQL statement-based replication. In the comments of that post Andrew Moore pointed out that I can set
slave_exec_mode=IDEMPOTENT on my replicas in order to get similar behavior in row-based replication. Thanks Andrew!
Now I'm going to highlight an advantage of row-based replication in MySQL. Again this is not one of the advantages documented in the manual, but it's one that I think is important.
Here it is:
- Row-based replication does not write to the binary log if you execute a statement that doesn't change any data.
- Statement-based replication writes all successful