Hi ,
You cna use JDBC river to bridge ES and DB -
https://github.com/jprante/elasticsearch-river-jdbc
Only data inside the DB would flow to ES.

Thanks
          Vineeth

On Fri, Dec 19, 2014 at 10:43 PM, teseter <iamrav...@gmail.com> wrote:

> Hi
>
>  To fasten the search operations we are planning to use Elastic search for
> transactional data. Data has to be fed into Elastic search from DB. The
> main problem which we are foreseeing is to keep the data in synch between
> ES and DB as the transactional data can be updated. We are looking for ways
> to update the ES index after the transaction data is updated successfully
> to avoid showing the stale data from ES.
>
> We are looking for different solution options to achieve the same. if
> anybody has worked on similar requirement please do let us know.
>
> We are using Oracle DB? Should we use Oracle AQ on the database side or
> some Java JMS Q to update Elastic search index.
>
> Also we want to know when we update ES index will all the shards
> automatically get updated?
>
>
>
>  --
> 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 elasticsearch+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/elasticsearch/b63b2347-700b-4bc0-a5a8-09a8c3b4681e%40googlegroups.com
> <https://groups.google.com/d/msgid/elasticsearch/b63b2347-700b-4bc0-a5a8-09a8c3b4681e%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 elasticsearch+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/elasticsearch/CAGdPd5%3DgJ5xjKNgaVt3vU6RYfasBE5JMi0OJeWHzBPjdtpuQRA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to