Devart Forums

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 ?

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.

When u shot down the gateway you also disable dns lookups which slow down the process.
here http://dev.mysql.com/doc/mysql/en/DNS.html you can read how mysql use dns and how to disable dns lookups.

Adem.

Hi Adem, this seems to be the problem i'm having.. Tomorrow I'll try this out.