Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Not seeing changes after connection on replicated mysql db

eos's profile image eos posted 9 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 9 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.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.