ElasticSearch这个可以实时的从mysql数据源中更新数据吗?

Question

ElasticSearch这个可以实时的从mysql数据源中更新数据吗?
网络找了些资料都是介绍建索引,搜索之类.对于数据源的更新介绍的不多.有没有文档专门介绍或者教程什么的?

Answer 1

https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html
logstash-input-jdbc 可以定期拉数据：
input {
jdbc {

jdbc_driver_library => "mysql-connector-java-5.1.36-bin.jar"
jdbc_driver_class => "com.mysql.jdbc.Driver"
jdbc_connection_string => "jdbc:mysql://localhost:3306/mydb"
jdbc_user => "mysql"
parameters => { "favorite_artist" => "Beethoven" }
schedule => "* * * * *"
statement => "SELECT * from songs where artist = :favorite_artist"

}
}

Answer 2

https://github.com/jprante/elasticsearch-river-jdbc#time-based-selecting