New to elasticsearch


(Billy Newman) #1

I am currently looking into elasticsearch to index a few things. All of
my data is stored in either a MySql or Oracle database. This brings up 2
questions to get started:

  1. is there a way that I can take certain data from my database and index
    it?
  2. how do I keep the elasticsearch index up to date when new data is added
    to my db? I know this might seem like a strange question so let me clarify
    a little. I understand that when I want to add new data to the index I can
    just post documents which is fine. So I can post data to the index every
    time something is saved/updated/deleted to my database. However what do I
    do when I need to patch the data in my database? Do I need to essentially
    patch the elasticsearch index as well as my database.

Thanks so much (in advance) for getting me started.

Billy

--


(David Pilato) #2

1/ you have the nice JDBC river plugin from Jorg Prante : https://github.com/jprante/elasticsearch-river-jdbc

2/ same answer.

But, you have to keep in mind that NoSQL search is very different from RDBMS SQL queries.
You have to think your search as "global document indexing process" and forget Join queries...

HTH

--
David :wink:
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 22 sept. 2012 à 16:09, Billy Newman newmanw10@gmail.com a écrit :

I am currently looking into elasticsearch to index a few things. All of my data is stored in either a MySql or Oracle database. This brings up 2 questions to get started:

  1. is there a way that I can take certain data from my database and index it?
  2. how do I keep the elasticsearch index up to date when new data is added to my db? I know this might seem like a strange question so let me clarify a little. I understand that when I want to add new data to the index I can just post documents which is fine. So I can post data to the index every time something is saved/updated/deleted to my database. However what do I do when I need to patch the data in my database? Do I need to essentially patch the elasticsearch index as well as my database.

Thanks so much (in advance) for getting me started.

Billy

--


(system) #3