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 vote124 views1 answer
Postgresql delete multiple rows
SQL
0 vote133 views1 answer
Select last N rows mysql
SQL
1 vote277 views2 answers
Sql unique rows
SQL
7 votes221 views2 answers
Mysql default value
SQL
0 vote156 views5 answers
Right join
SQL
7 votes127 views2 answers
What is sql clause
SQL
0 vote116 views1 answer
Sql get month and year from date
SQL
8 votes151 views2 answers
How to fetch data from database without last column
SQL
0 vote144 views1 answer
Sql query to find percentage of null values in a table
SQL
0 vote191 views1 answer
Mysql get nested records
SQL