distal-attribute
distal-attribute
distal-attribute
distal-attribute

Not seeing changes after connection on replicated mysql db

eos posted 7 months ago in General
Here is a weird one. If I connect to any normal mysql db, heidisql works well.

If I connect to a DB which is a read only async replication slave, i can see everything up to the point at which I connected. I have to disconnect and reconnect every time I want to query new data which was put in the db by the sync process.

Is this not odd? Probably not a HS specific problem, but just hoping someone has seen something similar & knows a workaround.

I have an app which looks at the same DB, and pools its connections, and this app is not seeing this issue.
ansgar posted 7 months ago
There is probably some kind of snapshot-per-session activate d on the server. I have no clue if such a feature exists in mysql.

Please login to leave a reply, or register at first.