Not seeing changes after connection on replicated mysql db

eos's profile image eos posted 10 years ago in General Permalink
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's profile image ansgar posted 10 years ago Permalink
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.