Logtash mysql cofiguration file

input {
  jdbc {
    jdbc_driver_library => "mysql-connector-java-5.1.36-bin.jar"
    jdbc_driver_class => "com.mysql.jdbc.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"
  }
}

Source: elastic.co

Similar codes

0 vote276 views1 answer
Postgres call view
SQL
0 vote274 views1 answer
Sql select min row
SQL
0 vote306 views4 answers
Restart MySQL
SQL
0 vote298 views1 answer
What does leave do in mysql
SQL
6 votes283 views2 answers
Drop foreign key
SQL
0 vote287 views1 answer
Sql values not in another table
SQL
0 vote304 views1 answer
Mysql listing get a particu particular user firsdt
SQL
0 vote292 views1 answer
How to add unique key constraint in mysql
SQL
0 vote279 views1 answer
Sql transact create cursor with dynamic tables
SQL
0 vote282 views1 answer
How to use lower case in mysql
SQL