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 vote387 views3 answers
How to assign custom id in mysql
SQL
11 votes402 views2 answers
Mysql disable safe mode
SQL
0 vote357 views1 answer
Having trouble running COUNT in my INSERT INTO statement
SQL
1 vote358 views1 answer
Tsql find foreign key references
SQL
5 votes317 views1 answer
Postgres upsert
SQL
11 votes358 views2 answers
Turn off safe mode mysql
SQL
11 votes344 views1 answer
How to get ddl for materialized view
SQL
3 votes352 views1 answer
Ssh check mysql version
SQL
1 vote356 views1 answer
Mysql monthname
SQL
0 vote410 views2 answers
How to drop mili second in sql
SQL