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 vote325 views1 answer
SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
SQL
15 votes274 views4 answers
Mysql export database command line
SQL
1 vote256 views1 answer
How to select department from table
SQL
1 vote305 views2 answers
How to install mysql workbench in ubuntu 20.04
SQL
0 vote265 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL
0 vote275 views1 answer
Helptext in sql
SQL
2 votes253 views2 answers
Postgres set user as superuser
SQL
1 vote261 views1 answer
Psql datetime grather than
SQL
0 vote266 views1 answer
Show database not empty tables postgres
SQL
0 vote258 views1 answer
Kill thread
SQL