logstash - mysql - elasticsearch 연동
ELK/logstash2019. 1. 6. 14:04
input {
jdbc {
jdbc_driver_library => "C:\Users\junhyeon.kim\Desktop\jar_data\mysql-connector-java-5.1.47\mysql-connector-java-5.1.47-bin.jar"
jdbc_driver_class => "com.mysql.jdbc.Driver"
jdbc_connection_string => "jdbc:mysql://localhost:3306/s20190106"
jdbc_user => "root"
jdbc_password => "1234"
schedule => "* * * * *"
statement => "SELECT * FROM t where nu >:sql_last_value"
use_column_value => true
tracking_column => "nu"
}
}
filter {
mutate {
remove_field => ["@version", "@timestamp"]
}
}
output {
elasticsearch {
hosts => "localhost"
index => "test"
}
}
'ELK > logstash' 카테고리의 다른 글
logstash file json absolute path (0) | 2020.06.17 |
---|---|
logstash input-plugin (elasticsearch) (0) | 2020.05.12 |
logstash plugin install (0) | 2020.04.15 |
logstash + app-search (0) | 2019.12.10 |
logstash + python (0) | 2019.01.12 |