Page 1 of 1
Connecting & gateway is gone..
Posted: Sun 14 Nov 2004 21:07
Hi, I setup most networks the same, as far as I know i'm correct in this. I assign each PC a IP in the range of 192.168.1.*, mask 255.255.255.0 .The ADSL router is also one of these IP's (For example 192.168.1.100) and the mysql linux server is another IP in the same range (For example 192.168.1.200). All PC's i set the DNS's to the ones the provider has, and as gateway the IP of the router. When I load my application it connects extremly fast, but it the router is down (disconnected) it takes about a minute, is this a normal behaviour, or something wrong in my settings because it looks like it first trys to find the server trought the ASDL Router, and afterwards locally, while the IP is a local range ?
Re: Connecting & gateway is gone..
Posted: Mon 15 Nov 2004 15:43
Usually MySQL quickly determines that the server to which to connect
is inaccessible. Suppose, you should ask this question to developers of MySQL Server or gurus in Windows Sockets.
Posted: Mon 15 Nov 2004 20:55
When u shot down the gateway you also disable dns lookups which slow down the process.
you can read how mysql use dns and how to disable dns lookups.
Posted: Wed 17 Nov 2004 23:21
Hi Adem, this seems to be the problem i'm having.. Tomorrow I'll try this out.