All geek questions in one place

Logstash INPUT MySQL

Unable to find input plugin for relational databases in Logstash documentation.

What is the best approach for importing data from a single relational database table using logstash? Is connecting Elastic Search directly to the database using JDBC?

+4
source share
3 answers

You will need to use JDBC River ( https://github.com/jprante/elasticsearch-river-jdbc ) to load JDBC data into elastic search (or write your own code for this).

, Logstash JIRA-, JDBC, : https://logstash.jira.com/browse/LOGSTASH-1764

+7

this

WIP: ,

Logstash.

. - Apache 2.0, , , , .

Logstash . asciidoc , asciidoc, html. .

+3

There is still no Logstash API for reading SQL.

According to my recommendation, you can write a program / script, such as JAVA / python, to read the logs from the sql database and write to the file. Then use the logstash file API to read from the file. A tutorial has appeared on the Logstash website. It is easy to find out. Good luck

+2
source

Source: https://habr.com/ru/post/1539426/

More articles:


All Articles