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

3 votes259 views1 answer
Select count from table mysql
SQL
10 votes298 views4 answers
Sql server pagination
SQL
1 vote270 views1 answer
Psql connect
SQL
0 vote266 views1 answer
How to search query in python3 sqlite3
SQL
0 vote236 views2 answers
Change database postgres
SQL
3 votes242 views1 answer
Index using in query plsql
SQL
15 votes266 views4 answers
Export mysql db using command line
SQL
1 vote293 views2 answers
How to install mysql workbench in ubuntu 20.04
SQL
0 vote259 views1 answer
SQL Server INSERT INTO SELECT By Complete Examples - NAYCode.com
SQL
3 votes235 views1 answer
Sql cast to integer
SQL