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 vote126 views1 answer
Import sql file in mysql linux
SQL
0 vote175 views1 answer
Sql server size of every table in a db
SQL
0 vote179 views1 answer
How to query without duplicate rows in sql
SQL
0 vote168 views1 answer
Sql server delete records with specific date
SQL
0 vote221 views1 answer
Hibernate dialect property xml for mysql 8
SQL
2 votes176 views1 answer
Mysql select default if null
SQL
1 vote173 views1 answer
Postgresql escape single quote
SQL
0 vote187 views1 answer
Acutal month year
SQL
0 vote183 views1 answer
Normalization in database
SQL
1 vote179 views1 answer
Base64 encode sql server
SQL