logstash-output-jdbc遇到connection is not available,request time out after 10000ms的问题解决

上一篇logstash-output-jdbc使用中提到“运行bin/logstash -f test.conf时可能提示注册插件失败”，通过分析详细的错误日志，发现其赫然写着“connection is not available,request time out after 10000ms”，原来是mysql连接的问题，插件注册失败只是表象。

由于没有在logstash所在的机器A安装mysql，而是通过mysql connector 的jar包（logstash conf文件里指定了jar报路径），所以没有办法测试A到数据库机器B的连接是否成功，尝试过增加mysql connection_timeout的时间到300s，发现错误还是request time out after 10000ms，说明jar里有自己的时间设置。

百度良久，最后在mysql的my.ini文件（默认C:\PragramData\MySQL\MySQLServer 5.7目录下）中增加skip-name-resolve，重启mysql服务后，问题解决。原因是

MySQL处理用户连接时进行如下过程来验证用户的合法性（参考http://www.cnblogs.com/timeship/archive/2013/02/28/2937730.html）：

When a new client connects to mysqld, mysqld spawns a new thread to handle the request. This thread first checks whether the host name is in the host name cache. If not, the thread attempts to resolve the host name: 
The thread takes the IP address and resolves it to a host name (using gethostbyaddr()). It then takes that host name and resolves it back to the IP address (using gethostbyname()) and compares to ensure it is the original IP address.

转载于:https://www.cnblogs.com/ttssrs/p/6677451.html