River - Mysql to elasticsearch


(mohit.Kumar) #1

Hi folks,
I am trying create river for mysql to elasticsearch. I have successfully
created that but data is not mapping dynamically. when I restart the
elasticsearch then the changes in data visible.
for - example :-
step 1 : In mysql database table "tbl_test" has 3 row and 3 column.
step 2 : when i start the Elastic search I got 3 document.
step 3 : now i add 2 rows in tbl_test (total 5 rows and 3column.)
step 4 : elasticsearch it is showing only 3 documents. but when I restart
elasticsearch it is showing all documents that is 5 documents.

Below is my the query :
{
"type": "jdbc",
"jdbc": {
"driver": "com.mysql.jdbc.Driver",
"url": "jdbc:mysql://localhost:3306/test",
"user": "root",
"password": "admin",
"sql": "select * from tbl_test",
"index": "mySql_index",
"type": "mySql_indext",
"bulk_size": "100",
"bulk_timeout": "10ms",
"strategy": "simple"
}
}

Question:
how can I achieve this dynamically.

I am using Elasticsearch version 0.90.7 and river-jdbc ( version - 2.3.1 )

thanks in advance...!!!

Regrads
Mohit Kumar Yadav
(MCA/BBA)

--
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+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAK6eDKfnHYyeWh_JzW7WQ2iQfBvymkQJpT_FKatT2ytMsrw%3Dcw%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.


(David Pilato) #2

Have a look at https://github.com/jprante/elasticsearch-river-jdbc/wiki/Strategies#simple-strategy
the poll time value can be adjusted to the interval how often data should be fetched.

HTH

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

Le 18 déc. 2013 à 07:35, Mohit Kumar Yadav mohit.kumar.ngi@gmail.com a écrit :

Hi folks,
I am trying create river for mysql to elasticsearch. I have successfully created that but data is not mapping dynamically. when I restart the elasticsearch then the changes in data visible.
for - example :-
step 1 : In mysql database table "tbl_test" has 3 row and 3 column.
step 2 : when i start the Elastic search I got 3 document.
step 3 : now i add 2 rows in tbl_test (total 5 rows and 3column.)
step 4 : elasticsearch it is showing only 3 documents. but when I restart elasticsearch it is showing all documents that is 5 documents.

Below is my the query :
{
"type": "jdbc",
"jdbc": {
"driver": "com.mysql.jdbc.Driver",
"url": "jdbc:mysql://localhost:3306/test",
"user": "root",
"password": "admin",
"sql": "select * from tbl_test",
"index": "mySql_index",
"type": "mySql_indext",
"bulk_size": "100",
"bulk_timeout": "10ms",
"strategy": "simple"
}
}

Question:
how can I achieve this dynamically.

I am using Elasticsearch version 0.90.7 and river-jdbc ( version - 2.3.1 )

thanks in advance...!!!

Regrads
Mohit Kumar Yadav
(MCA/BBA)

--
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+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAK6eDKfnHYyeWh_JzW7WQ2iQfBvymkQJpT_FKatT2ytMsrw%3Dcw%40mail.gmail.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
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+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/67D07329-5944-49DE-9C8A-B3624F42DE12%40pilato.fr.
For more options, visit https://groups.google.com/groups/opt_out.


(system) #3