mysql同步数据到elasticsearch用什么工具？

Question

在github上看到有:
1、elasticsearch-jdbc
2、python-mysql-replication
3、go-mysql-elasticsearch
另外还有：
4、mysqlbinlog

用哪个比较好？

Answer 1

Logstash’s jdbc plug-in
However, it does not support deletion and update

So the best way is to write your own script to CRUD according to the mysql log

If the amount of data is small, just write mysql and es directly and synchronously when writing data