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

8 votes138 views3 answers
Duplicate entry
SQL
-2 votes155 views1 answer
Remove root password mysql
SQL
-1 vote145 views2 answers
REMOVE DATE FROM DATE TIME SQL SERVER
SQL
0 vote172 views1 answer
Connect laravel to mysql on mac
SQL
11 votes147 views2 answers
Mysql set safe mode off
SQL
0 vote143 views1 answer
Caused by: java.lang.RuntimeException: Unable to obtain credentials to communicate with the Cloud SQL API
SQL
10 votes162 views2 answers
Sql pagination offset
SQL
0 vote145 views1 answer
How to select only id where is not in column mysql
SQL
18 votes175 views2 answers
Find all tables containing column with specified name - MS SQL Server
SQL
0 vote146 views1 answer
Sql query for getting data with join and count
SQL