Logstash updating data

[gnievoj]

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 (Fabian Geiger)]

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.
Jdbc input plugin | Logstash Reference [8.11] | Elastic