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 vote273 views1 answer
Codigo crear tablas sql server
SQL
10 votes259 views4 answers
Primary key sql
SQL
0 vote221 views1 answer
Sqlalchemy filter relationship
SQL
8 votes284 views10 answers
Sql
SQL
2 votes267 views3 answers
Mysql list tables by size
SQL
1 vote266 views1 answer
Convert rows to string sql server
SQL
0 vote308 views1 answer
Declare or use variable in snowflake
SQL
8 votes417 views4 answers
Convert date to dd/mm/yyyy sql
SQL
13 votes278 views3 answers
Sql select from multiple tables without join
SQL
0 vote313 views1 answer
Get initial in sql
SQL