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

1 vote219 views1 answer
Add many column to sap iq table
SQL
0 vote195 views1 answer
Pl/sql loop example
SQL
2 votes220 views1 answer
Db.relationship sqlalchemy flask
SQL
1 vote218 views2 answers
Sql insert timestamp
SQL
25 votes225 views1 answer
How to update an attribute in MySQL
SQL
0 vote215 views1 answer
Show mysql account privilleges
SQL
0 vote194 views1 answer
How to connect to mysql in ef 6
SQL
0 vote201 views3 answers
Mysqli count down
SQL
0 vote209 views1 answer
Reindex mssql table
SQL
0 vote221 views1 answer
Insert or update sql firebird
SQL