i'm getting following error intermittently when making call asp.net mvc web application using dapper query mysql.
unable connect of specified mysql hosts.
the exception only occurs when web app published azure. has worked 100% of time when run code locally. i've deployed code second azure website, , exception there, again intermittently.
the mysql database running on azure vm (ubuntu). server has r scripts access database, being run @ set interval. i've had no connectivity issue these either. .net code that's struggling.
i've scoured web, don't feel i've turned of value. of links have pointed connection string problem, since works intermittently doesn't seem fit problem. links have referenced dns issues, i'm getting same problem when use ip address instead of machine name dns server.
i'm sure need track down more information, i'm not sure be. first foray using mysql db in fashion, , i'm not familiar config options or log files on side of things. feel azure websites database interactions too.
what can try next?
just drive home point error being intermittent, here's screenshot runscope job that's hitting page (thus triggering mysql query) every 5 minutes:
i able fix (or perhaps "circumvent") problem adding --skip-host-cache flag our mysql configuration file. still don't understand root of problem is, haven't had issues mysql connectivity azure website since adding that.
