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

Not seeing changes after connection on replicated mysql db

User, date Message
Written by eos
3 months ago
Category: General
14 posts since Thu, 16 Feb 12
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.
Written by ansgar
3 months ago
4940 posts since Fri, 07 Apr 06
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.