- Original Message -
> From: "Dan Nelson"
>
> I doubt that mysql calls anything other than gethostbyname() or
> getaddrinfo(), so your behaviour is probably dependant on whatever OS
> you are running and how often its local resolver re-checks resolv.conf.
> Usually that's only once when a
In the last episode (May 19), Johan De Meersman said:
> I use DNS names instead of IPs in mysql grants. Yes, I'm aware of the
> performance impact, that's not an issue.
>
> I just found out through failing logins that a server was still connecting
> to an old DNS server, and properly updated the r
- Original Message -
> From: "Claudio Nanni"
> Consider also the DNS TTL.
That should be irrelevant when changing DNS servers :-)
> If you flush hosts in MySQL it'll ask again the OS to resolve a name
> , but if that is still in the DNS cache it could return that 'old'
> value instead
Johan,
Consider also the DNS TTL.
If you flush hosts in MySQL it'll ask again the OS to resolve a name , but
if that is still in the DNS cache it could return that 'old' value instead
of querying the newly updated NS.
I'm not sure thou, may be test by restarting the name server cache
deamon */et
Just encountered an interesting issue.
I use DNS names instead of IPs in mysql grants. Yes, I'm aware of the
performance impact, that's not an issue.
I just found out through failing logins that a server was still connecting to
an old DNS server, and properly updated the resolv.conf. Commandl
