Es pulls mysql incremental update code _ MySQL

Elasticsearch pulls mysql incremental update code based on open-source plug-ins. See http://my.oschina.net/qiangzigege/blog/220224 for details

~~~~~~

Objective: to implement incremental update

Principle

1) This task is deleted after the first full update is completed.

2) release the incremental update task.

~~~~~~~~~

The incremental update task template is as follows:

Curl-XPUT 'IP: 9200/_ river/my_jdbc_river/_ meta'-d' {"type": "jdbc", "jdbc": {"url": "jdbc: mysql: // IP: 3306/fastooth "," user ":" dewmobile "," password ":" dewmobile "," SQL ": "select * from users where updated_at between UNIX_TIMESTAMP (now () * 1000-60000 86400000 and UNIX_TIMESTAMP (now () * 1000 or created_at between UNIX_TIMESTAMP (now ()) * 1000-60000 86400000 and UNIX_TIMESTAMP (now () * 1000 "," schedule ":" 0 0-59 0-23 * *? "," Index ":" ccc "," type ":" ddd "}}'