开发笔记:Logstash安装和使用

#将键盘内容输出到控制台
logstash -e ‘input { stdin { } } output { stdout {}}‘

input{
jdbc {
jdbc_driver_library => "D:downloadlogstash-5.6.8mysqletcmysql-connector-java-5.1.47.jar"
jdbc_driver_class => "com.mysql.jdbc.Driver"
jdbc_connection_string => "jdbc:mysql://127.0.0.1:3306/tensquare_article?useUnicode=true&characterEncoding=UTF8"
jdbc_user => "root"
jdbc_password => "1234"
jdbc_paging_enabled => "true"
jdbc_page_size => "50"
jdbc_default_timezone =>"Asia/Shanghai"
#都为*每分钟都执行
schedule => "* * * * *"
statement => "SELECT id,title,content,state FROM tb_article"
use_column_value => true
tracking_column => "updatetime"
}
}
output{
elasticsearch {
hosts => "127.0.0.1:9200"
index => "tensquare"
document_id => "%{id}"
document_type => "article"
}
stdout {
#以json格式输出
codec => json_lines
}
}

logstash -f ../mysqletc/mysql.conf