Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- jdbc {
- # remember create tunnel first:
- # ssh -i /root/.ssh/key -L 127.0.0.1:3307:127.0.0.1:3306 root@<ip> -N
- jdbc_connection_string => "jdbc:mysql://localhost:3307/db"
- jdbc_user => "user"
- jdbc_password => "password"
- # just testing if has anything to do with :sql_last_value not being update ok.
- jdbc_fetch_size => 1000
- schedule => "*/1 * * * *"
- jdbc_validate_connection => true
- jdbc_driver_library => "/usr/share/java/mysql.jar"
- jdbc_driver_class => "com.mysql.jdbc.Driver"
- statement => "SELECT foo FROM bar WHERE my_id > :sql_last_value"
- use_column_value => true
- tracking_column => my_id
- last_run_metadata_path => "/opt/logstash-jdbc-last-run/mytype"
- type => "mytype"
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement