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 vote170 views2 answers
Postgres copy table from one schema to another
SQL
6 votes123 views2 answers
Spring data jpa application.properties mysql
SQL
1 vote187 views4 answers
Aggregate function in sql
SQL
2 votes172 views3 answers
Postgresql reset auto increment
SQL
0 vote163 views1 answer
Sql show all users
SQL
53 votes534 views6 answers
Sql server alter column
SQL
7 votes168 views2 answers
What is sql clause
SQL
65 votes527 views6 answers
Sql add column to table
SQL
16 votes170 views3 answers
Tsql rename column name
SQL
3 votes188 views1 answer
What is having
SQL