Logstash INPUT MySQL [英] Logstash INPUT MySQL

问题描述

在Logstash文档中找不到关系数据库的任何输入插件。

Can't find any input plugin for Relational Databases in Logstash Documentation.

使用logstash从一个关系数据库表导入数据的最佳方法是什么？使用JDBC将Elastic Search直接连接到数据库？

What is the best approach to import data from one Relational Database Table with logstash? Is to connect Elastic Search directly to the database using JDBC?

推荐答案

您需要使用JDBC River（ https://github.com/jprante/elasticsearch-river-jdbc ）将JDBC数据加载到弹性搜索（或自己编写）

You'll need to use JDBC River (https://github.com/jprante/elasticsearch-river-jdbc) for loading JDBC data into elastic search (or write your own code to do it).

看起来有几个JIRA打开请求在Logstash中加载JDBC，但它们没有工作：https://logstash.jira.com/browse/LOGSTASH-1764

It looks like there are several JIRAs open requesting JDBC loading in Logstash, but they haven't been worked: https://logstash.jira.com/browse/LOGSTASH-1764

这篇关于Logstash INPUT MySQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！