When running Primary-Secondary-Secondary setup DML operations on Primary do not trigger query caches on Secondaries to be invalidated when binary log is in ROW format.

Reproduce as follows (given a table ):

On Primary:

insert into test values (123);

select * from test; #=> gives 123

On Secondaries:

select * from test; => gives nothing

select * from test where 1=1; # or select SQL_NO_CACHE * from test; => gives 123

Excerpt from my.cnf for Primary and Secondaries:

binlog_format=row

query_cache_type=1

query_cache_limit=4M

query_cache_size=256M