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 vote201 views1 answer
Oracle webcenter content search enginer
SQL
16 votes184 views2 answers
Add column to all tables after first column mysql
SQL
1 vote154 views1 answer
Foreign key in oracle sql developer
SQL
1 vote190 views1 answer
Table infromation in sql server
SQL
-1 vote184 views1 answer
Convert google analytics dathourminute to time stamp? sql
SQL
0 vote175 views1 answer
Show all mongodb
SQL
0 vote191 views1 answer
Oracle to_number
SQL
1 vote186 views1 answer
Raw query must include primary key
SQL
10 votes179 views1 answer
Oracle all_dependencies
SQL
0 vote204 views1 answer
Check if mysql db is used
SQL