Advertisement
Guest User

Untitled

a guest
May 4th, 2017
131
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.78 KB | None | 0 0
  1. jdbc {
  2. # remember create tunnel first:
  3. # ssh -i /root/.ssh/key -L 127.0.0.1:3307:127.0.0.1:3306 root@<ip> -N
  4. jdbc_connection_string => "jdbc:mysql://localhost:3307/db"
  5. jdbc_user => "user"
  6. jdbc_password => "password"
  7. # just testing if has anything to do with :sql_last_value not being update ok.
  8. jdbc_fetch_size => 1000
  9. schedule => "*/1 * * * *"
  10. jdbc_validate_connection => true
  11. jdbc_driver_library => "/usr/share/java/mysql.jar"
  12. jdbc_driver_class => "com.mysql.jdbc.Driver"
  13. statement => "SELECT foo FROM bar WHERE my_id > :sql_last_value"
  14. use_column_value => true
  15. tracking_column => my_id
  16. last_run_metadata_path => "/opt/logstash-jdbc-last-run/mytype"
  17. type => "mytype"
  18. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement