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 vote351 views1 answer
Get initials name in sql
SQL
3 votes376 views3 answers
Create table in SQL Server
SQL
0 vote366 views1 answer
How to find the most occuring in SQL
SQL
0 vote352 views1 answer
T sql dynamic top n query
SQL
0 vote324 views1 answer
Insufficient memory to excute the sql query
SQL
10 votes360 views2 answers
Mysql drop database if exists
SQL
2 votes313 views1 answer
Username sql
SQL
2 votes330 views4 answers
How to find 2nd highest salary in mysql
SQL
1 vote323 views1 answer
Neo4j display all nodes and relationships
SQL
92 votes620 views6 answers
Substring
SQL