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. Commandline host lookups then returned
correct results.
However, even after repeated flush hosts commands, the MySQL kept returning wrong results.
Only after a full restart did it pick itself up and start doing proper lookups. I strongly
suspect that this is due to it internally caching the nameserver, too, and not refreshing
that along with the host cache on a flush hosts command.
Can anyone confirm this is the case, and wether or not a bug has been logged about it? I
can't seem to find one.
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
