Changing jdbc river mysql credentials


#1

Hi All,

I am using Elastic Search 1.4.2 on Production server and I am extracting data from mysql to ES using jdbc river.

curl -XPUT '10.XXX.XXX.XX:9200/_river/url_jdbc_river/_meta' -d '{
"type" : "jdbc",
"jdbc" : {
"strategy": "simple",
"autocommit": true,
"driver" : "com.mysql.jdbc.Driver",
"url" : "jdbc:mysql://10.XXX.XXX.XX:3306/DomainDB",
"user" : "sohil",
"password" : "XXX",
"sql" : [ 
{
"statement" : "select id as \"id\", pid as \"pid\" ,s_id as \"sid\" ,domain_name as \"domain\"  from domaintable"
}
],
"maxbulkactions":5000,
"maxconcurrrentbulkactions":1,
"index" : "urls",
"type" : "url",
"type_mapping": {"urls" : {"properties" : {"id":{"type":"long","store":"yes"},"domain":{"type":"string","store":"yes","index":"notanalyzed"},"pid":{"type":"long","store":"yes"},"sid":{"type":"long","store":"yes"}}}}
}

}'

Now I want to update mysql credentials of jdbc river.
Is there a ways using which I can update mysql credentials without affecting data of Elastic Search?.


#2

Can anyone please assist me here?


(David Pilato) #3

try to remove the river and create it again with new credentials.
I guess this could work.

Note that _river endpoint has been removed in elasticsearch 2.0.0.


(system) #4