Logstash updating data


#1

Hello, It's my logstash config file
> input {

            jdbc {
                    jdbc_connection_string => "jdbc:mysql://localhost:3306/ejabberd"
                    jdbc_user => "ejabber"
                    jdbc_password => "password"
                    jdbc_driver_library => "mysql-connector-java-5.1.39-bin.jar"
                    jdbc_driver_class => "com.mysql.jdbc.Driver"
                    statement => "SELECT * FROM ejabberd.archive"
                 }
         }
    output {
    #       stdout { codec => json_lines }
            elasticsearch {
                    index => "messages"
                    hosts => ["localhost:9200"]
    }
    }

Im getting data from mysql, but when im put new record to db, elasticsearch can't see my newest records. Data are update only then im' restart logstash. How can i get live updated records from logstash? Thank you


(Fabian Geiger) #2

Never used jdbc input plugin, but i think you have to use a scheduler. Here is a hint in documentation:

There is no schedule by default. If no schedule is given, then the statement is run
exactly once.
https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html#plugins-inputs-jdbc-schedule


(system) #3

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.