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 vote198 views1 answer
Add colum date in sql
SQL
0 vote223 views1 answer
How to alter length character varying postgres
SQL
5 votes201 views1 answer
Invalid column name sql
SQL
0 vote267 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL
1 vote206 views3 answers
Psql: error: FATAL: role "postgres" does not exist
SQL
0 vote193 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL
2 votes203 views2 answers
Useradd postgres
SQL
5 votes199 views2 answers
Copy data from one database to another
SQL
1 vote284 views3 answers
Date_add mysql
SQL
5 votes250 views1 answer
Ora-00054 resource busy and acquire with nowait
SQL