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

2 votes291 views1 answer
Datetrunc
SQL
0 vote273 views1 answer
Can we rollback data that are deleted using DELETE
SQL
0 vote276 views3 answers
Mysql delete if not in another table
SQL
0 vote273 views1 answer
Show table structure mysql console
SQL
1 vote293 views1 answer
Oracle previous year
SQL
8 votes281 views2 answers
Grant all privileges database postgres to user
SQL
0 vote287 views1 answer
Sql comand for removing data from table
SQL
3 votes309 views1 answer
Sql calculate working days between two dates excluding weekends and holidays
SQL
4 votes265 views1 answer
Select nls_date_format
SQL
1 vote290 views4 answers
Psql: error: FATAL: database "odoo" does not exist
SQL