Yes, you can set up the JDBC plugin with a 'schedule' parameter so that it is started every minute.
See the doc at https://github.com/jprante/elasticsearch-river-jdbc Note, if you delete rows in DB, this is not per se detected by JDBC plugin. There is no synchronization between DB rows and JSON docs. You can only work with documents from the rows that your SQL statement discovers. JSON doc deletions require some additional effort. Jörg On Wed, Jan 21, 2015 at 4:56 PM, Abid Hussain <[email protected]> wrote: > Hi all, > > I'm trying to figure out how to configure jdbc river in production > environment. > > We want to index a DB with appr. 10% write queries and 90% read queries > and need to keep ES index in sync with DB. > > So I wonder how two configure river to keep Index in near-realtime Sync > with DB. > > I'm thinking about pulling the DB changes every minute. Is jdbc-river > capable of updating it's already indexed data and is this a good strategy? > > Regards, > > Abid > > -- > You received this message because you are subscribed to the Google Groups > "elasticsearch" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/elasticsearch/99857c16-1ba3-4267-94c8-7538971f366b%40googlegroups.com > <https://groups.google.com/d/msgid/elasticsearch/99857c16-1ba3-4267-94c8-7538971f366b%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAKdsXoGXpv-28GuNLR86YW79rC%2BUjqx%3DwYsCGEpEbn8ZOgAFsA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
