主要是配置,配置要配对,
input {
jdbc {
jdbc_driver_library => "F:\\logstash-6.2.4\\logstash-6.2.4\\mysql\\mysql-connector-java-8.0.18.jar"
jdbc_driver_class => "com.mysql.jdbc.Driver"
jdbc_connection_string => "jdbc:mysql://localhost:3306/cms?allowMultiQueries=true&allowPublicKeyRetrieval=true&useSSL=false&characterEncoding=utf8&serverTimezone=GMT"
jdbc_user => "root"
jdbc_password => "123"
schedule => "* * * * *"
clean_run => true
statement => "SELECT * FROM jotter_article WHERE article_date>= :sql_last_value AND article_date < NOW() order by article_date desc"
}
}
output {
elasticsearch {
hosts => ["127.0.0.1:9200"]
index => "jotter_article"
document_id => "%{id}"
}
}
我当时是忘了加上jdbc:mysql,调了半小时没解决我的天