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

Not seeing changes after connection on replicated mysql db

eos posted 1 year 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 12 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.