同步mysqlelastic search我知道有一个工具叫elasticsearch-jdbc，也看了官方文档，根据官方文档写了个测试（命令见最下），但是不能实时同步，它会隔差不多1分钟左右再更新。不知道是什么地方出问题了。还请路过大神不吝赐教！命令：{"type" : "jdbc","jdbc" : {"url" : "jdbc:mysql://xxx.xxx.xxx.xxx:3306/world","user" : "root","password" : "xxxxxx","schedule":"*/5 * * * * ?","locale" : "en_us","sql" : [{"statement":"select \"world\" as _index, \"city\" as _type, id as _id, name as \"name\", countrycode as \"countrycode\", district as \"district\", population as \"population\" from city where \"mytimestamp\" > ?","parameter": [ "$metrics.lastexecutionstart" ]},{"statement" : "delete from city where \"_job\" = ?","parameter" : [ "$job" ]}],"statefile":"statefile.json","elasticsearch" : {"cluster" : "my_cluster_name1","host" : "localhost","port" : 9300},"index" : "world","type" : "city","index_settings" : {"index" : {"number_of_shards" : 1}}}}
Elastic Search 与 mysql数据库实时同步的问题
•
👁 2人浏览过