Shulou(Shulou.com)05/31 Report--

The main content of this article is "how to achieve the incremental update of mysql", interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Now let the editor take you to learn "how to achieve the incremental update of mysql"!

Objective: to achieve incremental updates

Principle

1) the first full update. After the update, delete the task.

2) publish incremental update tasks.

~

The template for the incremental update task 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": "00-59 0-23 * *?", "index": "ccc", "type": "ddd"}'. I believe you have a deeper understanding of "how to achieve the incremental update of mysql", so you might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.