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

5 votes113 views3 answers
Postgres show databases
SQL
0 vote109 views1 answer
Select from another database
SQL
0 vote139 views1 answer
Sql quary stuf
SQL
6 votes121 views2 answers
Mysql 1 day ago
SQL
2 votes127 views1 answer
Sql count having
SQL
2 votes106 views1 answer
Convert series number to date in sql
SQL
3 votes117 views1 answer
Sql case update
SQL
21 votes122 views6 answers
Update sql
SQL
0 vote116 views1 answer
SQL isnumeric DB2
SQL
0 vote120 views1 answer
Get last updated row sql server
SQL