title: Automatically syncing ElasticSearch with SQL
body: <p>I've ran this query and it worked well.</p>
  
  <pre><code>curl -XPUT 'localhost:9200/_river/my_jdbc_river/_meta' -d '{
      "type" : "jdbc",
      "jdbc" : {
          "url" : "jdbc:mysql://localhost:3306/test",
          "user" : "myaccount",
          "password" : "myaccount",
          "sql" : "select * from orders"
      }
  }'
  </code></pre>
  
  <p>Everything seems to be indexed. However, when I changed a data from the Orders Table, the changes did not reflect the document in ElasticSearch. Is it possible to automatically sync updated/changed data? </p>