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

3 votes60 views4 answers
Show columns from table
SQL
4 votes108 views2 answers
DB::transaction
SQL
4 votes115 views1 answer
W3schools create table
SQL
0 vote116 views1 answer
Mysql url data type
SQL
0 vote110 views2 answers
Faster mysql imports
SQL
0 vote108 views2 answers
Postgresql get long running queries
SQL
0 vote107 views1 answer
Get role postgres
SQL
0 vote96 views1 answer
Job for mysql.service failed because the control process exited with error code.
SQL
0 vote112 views1 answer
List in one column mysql
SQL
0 vote96 views1 answer
Postgresql copy backup table
SQL