Skip to content

Instantly share code, notes, and snippets.

@lachlanagnew
Created March 28, 2019 03:48
Show Gist options
  • Save lachlanagnew/0b687c5bf3577d548c907ddee165aee0 to your computer and use it in GitHub Desktop.
Save lachlanagnew/0b687c5bf3577d548c907ddee165aee0 to your computer and use it in GitHub Desktop.
input {
jdbc {
jdbc_driver_library => "/opt/mysql-connector-java-5.1.47/mysql-connector-java-5.1.47-bin.jar"
jdbc_driver_class => "com.mysql.jdbc.Driver"
jdbc_user => "dbuser"
jdbc_password => "dbuserpwd"
jdbc_connection_string => "jdbc:mysql://mysql-db:3306/boilerplate_db?zeroDateTimeBehavior=convertToNull"
schedule => "*/10 * * * * *"
statement => "SELECT Users.id, Users.username FROM Users"
}
}
output {
elasticsearch {
"hosts" => "elasticsearch:9200"
"index" => "example"
"document_type" => "users"
"document_id" => "%{id}"
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment