mysql cache issue

Question

1. The database mysql, the persistence layer uses mybatis
2. Now I have configured two data sources A and B, but there are two data sources, but in fact the two data sources are configured with the same database
3. Now I write a record through data source A, but it cannot be queried through data source B. I have to wait for a long time before it can be queried.
I guess it may be a cache problem. The query_cache of msyql has also been removed, and it still remains. It doesn't work. What else may cause this problem? Can anyone give me some solutions?

Answer 1

First confirm whether mysql has this data after writing. Because of this architecture, it is not only a problem of mysql cache, but also cache in the mybatis layer.