Re: can't connect to remote mysql db at a particular time period

Thanks for your reply.

This is the error I am getting:
ERROR 2003 (HY000): Can't connect to MySQL server on 'domain name' (110)

I tried doing the telnet on the mysql port and it's also not working. Giving me connection timeout.

I have two slaves on remote servers which are working fine during that period of time.

I am running Ubuntu Linux on Microsoft Azure machine. I checked the firewall is not configured to reject connections at any period of time.

On Tuesday, June 2, 2015 at 6:41:43 PM UTC+5:30, Jerry Stuckle wrote:
> On 6/2/2015 4:51 AM, anuj.ism_at_gmail.com wrote:
> > Hi everyone,
> >
> > I am facing a strange issue.
> > I am making a remote connection to mysql and it starts getting dropped at a particular time.
> > i have checked processlist and it is fine. there are no processes which are blocking on mysql server and I can make connection locally. Remotely I can't connect to mysql in that specific time period.
> > I have increased the backlog also to 2000 but still the problem happens even when there are not that many connections on mysql server at that particular period.
> > Please help what could be the cause of this issue.
> >
> > Thanks,
> > Anuj
> >
>
> Impossible to tell from the information you've provided.
>
> For instance - what happens when you try to connect during those times?
> How are you trying to connect? What error messages do you get? What
> happens if you try to telnet to the MySQL port from a remote location?
>
> How is MySQL configured? How many remote connections do you have during
> the failure?
>
> What operating system are you running? How is your firewall configured
> (is it configured to reject connections during certain times)?
>
> This is just the beginning of the questions I would ask if it were my
> system having this problem. You really need to dig in further to see
> locate the cause of the failure. It could be the server itself, MySQL,
> the network or even your remote machine. Or it could be a configuration
> issue anywhere along the way.
>
>
> --
> ==================
> Remove the "x" from my email address
> Jerry Stuckle
> jstucklex_at_attglobal.net
> ==================
Received on Wed Jun 03 2015 - 09:03:16 CEST