docker run --rm -it -v ~/settings/logstash.yml:/usr/share/logstash/config/logstash.yml docker.elastic.co/logstash/logstash:7.8.1

 

 

 

input {

  jdbc {

    jdbc_driver_library => "oracle-connector-java-5.1.36-bin.jar"

    jdbc_driver_class => "com.oracle.Driver"

    jdbc_connection_string => "jdbc:mysql://localhost:3306/mydb"

    jdbc_user => "mysql"

    parameters => { "favorite_artist" => "Beethoven" }

    schedule => "* * * * *"

    statement => "SELECT * from songs where artist = :favorite_artist"

  }

}