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 vote125 views1 answer
Get duplicate entry sql
SQL
0 vote135 views1 answer
Postgres grep entire database
SQL
0 vote139 views1 answer
Import sql inside hide sql
SQL
0 vote130 views1 answer
T sql return on letters only
SQL
0 vote127 views1 answer
Sqlalchemy one column of two has to be not null
SQL
0 vote144 views1 answer
Sql_inner_join
SQL
0 vote127 views1 answer
Delete a record from a table sqlite3
SQL
0 vote116 views1 answer
What is the essence of SQL?
SQL
0 vote118 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
5 votes121 views3 answers
Mysql check if null or empty string
SQL