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 vote199 views1 answer
Last 24 HOUR data in mysql
SQL
3 votes188 views5 answers
Import MySQLdb as Database ModuleNotFoundError: No module named 'MySQLdb'
SQL
2 votes199 views1 answer
Install postgresql centos 5
SQL
2 votes176 views1 answer
Change primary key sql
SQL
0 vote175 views1 answer
Mysql 1 hour ago
SQL
4 votes178 views2 answers
Sqlalchemy_database_uri for mysql
SQL
0 vote340 views1 answer
The differnece between to values in sql
SQL
15 votes183 views2 answers
Select Options
SQL
2 votes205 views1 answer
Cannot return non-composite value from function that returns composite type
SQL
0 vote182 views1 answer
Mysql to get column name in database
SQL