Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.5.13
-
None
-
bitnami/mariadb Helm Chart on Kubernetes running on Linux
Description
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
|
Attachments
Issue Links
- duplicates
-
MDEV-27047 replication does not remove affected queries from query cache
- Closed