lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ketan Thanki <ktha...@asite.com>
Subject RE: How to routing document for send to particular shard range
Date Thu, 16 Nov 2017 06:20:41 GMT
Hi,

Can  someone please let me for my below mentions use-case.

Regards,
Ketan

-----Original Message-----
From: Ketan Thanki 
Sent: Wednesday, November 15, 2017 3:42 PM
To: 'solr-user@lucene.apache.org'
Subject: RE: How to routing document for send to particular shard range

Thanks Erik,

I have re-mentions it as some required details are missing in my mail. Using CloudSolrClient
my test case as below.
I have used routing key as projectId/2!documentId
 
1: Detail of Insert Document in SolrIndex Document Size: 919551 Document Batch Size for insert:
5000 documents in each thread Total thread to Index: 184 (thread pool size 5) With Routing:
251835 millisecond taken to index documents in index (Data index in 1 shard) Without Routing:
325108 millisecond taken to index documents in index (Data index in 4 shard)

2: Detail of search document/Retrieve from SolrIndex Document Size: 919551 Document Batch
Size for retrieve: 10000 (per query 10000 document id used for search) Total thread to Search:
93 (thread pool size 3) Total Queries call: 93 With Routing: 94562 millisecond taken to search
documents from index (Data in 1 shard) Without Routing: 234242 millisecond taken to search
documents From index (Data in 4 shard)

Retrieval query with parameter used fq & fl also.
 
So above shows my one model data which belongs to one project (also project is consisting
of many models).
While refer above use-case my data in single shard which gives improvements with routing facility.
but when considering the production environment  If I have 800M documents (it may be more)
in each of my 4 shard and considering above case so what would be better from below.
- to distribute project data in two shard
- to distribute project data in single shard

is there any documents limit for shard? And if my document  grow more than above mentions
so is it causes any issue?

Please do needful.

Regards,
Ketan







 

-----Original Message-----
From: Erick Erickson [mailto:erickerickson@gmail.com]
Sent: Tuesday, November 14, 2017 9:33 PM
To: solr-user
Subject: Re: How to routing document for send to particular shard range

These numbers aren't very useful. inserting how much data? Querying how much data? What kinds
of queries? Are you indexing in batches or one document at a time? Are you using SolrJ and
CloudSolrClient?

94 seconds to do _what_? Execute 1,000 queries? Fetch all the documents from the shard? Execute
one query?

What is "a huge amount of data"? I've seen 300M documents fit on one shard. I've seen people
claim 1M documents is "huge".

Details matter. You might review:

https://wiki.apache.org/solr/UsingMailingLists

1:inserting data in 4 shard without document routing  time taken ( in
millisecond)  =325108
Inserting data in 1 shard with document routing time time taken ( in
millisecond)  =251835

2: retrieving data from 4 shard without document routing time taken( in millisecond)  = 234242
And retrieving data from 1 shard with document routing time taken ( in millisecond)= 94562

Best,
Erick

On Tue, Nov 14, 2017 at 6:50 AM, Ketan Thanki <kthanki@asite.com> wrote:
> Thanks Amrit ,
>
> Actually we have huge amount of data so that's why thinking to index data into particular
shard accept it's looks difficult but need to achieve the performance using document routing
for huge data.
>
> With configuration of  4 shard and 4 replica  is it better to distribute the one project
data in multiple shard or in one shard which one is  feasible using document routing because
needs the best performance while insertion & retrieval of document. And there would be
the multiple projects of client which has huge amount of data.
>
> I also taken the reading with 4 shard and 4 replica where without routing data are distribute
among all 4 shard  and with routing its distributes in 1 shard because of used 1 bit of shard
key like projectId/1!DocumentId.my reading looks as below.
> 1:inserting data in 4 shard without document routing  time taken ( in
> millisecond)  =325108 Inserting data in 1 shard with document routing 
> time time taken ( in millisecond)  =251835
>
> 2: retrieving data from 4 shard without document routing time taken( 
> in millisecond)  = 234242 And retrieving data from 1 shard with 
> document routing time taken ( in millisecond)= 94562
>
> As per above reading getting  performance in local  while data in 1 shard but in production
there will be huge data so is it need to distribute in 2 shard or in 1 shard which one is
feasible for achieve better performance.
>
>
> Regards,
> Ketan
>
> -----Original Message-----
> From: Amrit Sarkar [mailto:sarkaramrit2@gmail.com]
> Sent: Monday, November 13, 2017 8:52 PM
> To: solr-user@lucene.apache.org
> Subject: Re: How to routing document for send to particular shard 
> range
>
> Surely someone else can chim in;
>
> but when you say: "so regarding to it we need to index the particular
>> client data into particular shard so if its  manageable than we will 
>> improve the performance as we need"
>
>
> You can / should create different collections for different client data, so that you
can for surely improve performance as per need. There are multiple configurations which drives
indexing and querying capabilities and incorporating everything in single collection will
hinder that flexibility.
> Also if you need to add new client in future, you don't need to think about sharding
again, add new collection and tweak its configuration as per need.
>
> Still if you need to use compositeKey to acheive your use-case, I am not sure how to
do that honestly. Since shards are predefined when collection will be created. You cannot
add more shards and such. You can only split a shard, which will divide the index and hence
the hash range. I will strongly recommend you to reconsider your SolrCloud design technique
for your use-case.
>
> Amrit Sarkar
> Search Engineer
> Lucidworks, Inc.
> 415-589-9269
> www.lucidworks.com
> Twitter http://twitter.com/lucidworks
> LinkedIn: https://www.linkedin.com/in/sarkaramrit2
> Medium: https://medium.com/@sarkaramrit2
>
> On Mon, Nov 13, 2017 at 7:31 PM, Ketan Thanki <kthanki@asite.com> wrote:
>
>>
>> Thanks Amrit,
>>
>> My requirement to achieve best performance while using document 
>> routing facility in solr so regarding to it we need to index the 
>> particular client data into particular shard so if its  manageable 
>> than we will improve the performance as we need.
>>
>> Please do needful.
>>
>>
>> Regards,
>>
>>
>> -----Original Message-----
>> From: Amrit Sarkar [mailto:sarkaramrit2@gmail.com]
>> Sent: Friday, November 10, 2017 5:34 PM
>> To: solr-user@lucene.apache.org
>> Subject: Re: How to routing document for send to particular shard 
>> range
>>
>> Ketan,
>>
>> here I have also created new field 'core' which value is any shard 
>> where I
>> > need to send documents and on retrieval use '_route_'  parameter 
>> > with mentioning the particular shard. But issue facing still my 
>> > clusterstate.json showing the "router":{"name":"compositeId"} is it 
>> > means my settings not impacted? or its default.
>>
>>
>> Only answering this query, as Erick has already mentioned in the 
>> above comment. You need to RECREATE the collection passinfg the 
>> "route.field" in the "create collection" api parameters as 
>> "route.field" is collection-specific property maintained at zookeeper 
>> (state.json / clusterstate.json).
>>
>> https://lucene.apache.org/solr/guide/6_6/collections-
>> api.html#CollectionsAPI-create
>>
>> I highly recommend not to alter core.properties manually when dealing 
>> with SolrCloud and instead relying on SolrCloud APIs to make necessary change.
>>
>> Amrit Sarkar
>> Search Engineer
>> Lucidworks, Inc.
>> 415-589-9269
>> www.lucidworks.com
>> Twitter http://twitter.com/lucidworks
>> LinkedIn: https://www.linkedin.com/in/sarkaramrit2
>> Medium: https://medium.com/@sarkaramrit2
>>
>> On Fri, Nov 10, 2017 at 5:23 PM, Ketan Thanki <kthanki@asite.com> wrote:
>>
>> > Hi Erik,
>> >
>> > My requirement to index the documents of particular organization to 
>> > specific shard. Also I have made changes in core.properties as 
>> > menions below.
>> >
>> > Model Collection:
>> > name=model
>> > shard=shard1
>> > collection=model
>> > router.name=implicit
>> > router.field=core
>> > shards=shard1,shard2
>> >
>> > Workset Collection:
>> > name=workset
>> > shard=shard1
>> > collection=workset
>> > router.name=implicit
>> > router.field=core
>> > shards=shard1,shard2
>> >
>> > here I have also created new field 'core' which value is any shard 
>> > where I need to send documents and on retrieval use '_route_'
>> > parameter with mentioning the particular shard. But issue facing 
>> > still my clusterstate.json showing the 
>> > "router":{"name":"compositeId"} is it means my settings not impacted? or its
default.
>> >
>> > Please do needful.
>> >
>> > Regards,
>> >
>> > -----Original Message-----
>> > From: Erick Erickson [mailto:erickerickson@gmail.com]
>> > Sent: Friday, November 10, 2017 12:06 PM
>> > To: solr-user
>> > Subject: Re: How to routing document for send to particular shard 
>> > range
>> >
>> > You cannot just make configuration changes, whether you use 
>> > implicit or compositeId is defined when you _create_ the collection 
>> > and cannot be changed later.
>> >
>> > You need to create a new collection and specify 
>> > router.name=implicit when you create it. Then you can route documents as you
desire.
>> >
>> > I would caution against this though. If you use implicit routing 
>> > _you_ have to insure balancing. For instance, you could have
>> > 10,000,000 documents for "Org1" and 15 for "Org2", resulting in 
>> > hugely unbalanced
>> shards.
>> >
>> > Implicit routing is particularly useful for time-series indexing, 
>> > where you, say, index a day's worth of documents to each shard. It 
>> > may be appropriate in your case, but so far you haven't told us 
>> > _why_ you think routing docs to particular shards is desirable.
>> >
>> > Best,
>> > Erick
>> >
>> > On Thu, Nov 9, 2017 at 10:27 PM, Ketan Thanki <kthanki@asite.com> wrote:
>> > > Thanks Amrit,
>> > >
>> > > For suggesting me the approach.
>> > >
>> > > I have got some understanding regarding to it and i need to 
>> > > implement
>> > implicit routing for specific shard based. I have try by make 
>> > changes on core.properties. but it can't work So can you please let 
>> > me for the configuration changes needed. Is it need to create extra 
>> > field for document to rout?
>> > >
>> > > I have below configuration Collection created manually:
>> > > 1: Workset with 4 shard and 4 replica
>> > > 2: Model with 4 shard and 4 replica
>> > >
>> > >
>> > > For e.g Core.properties for 1 shard :
>> > > Workset Colection:
>> > > name=workset
>> > > shard=shard1
>> > > collection=workset
>> > >
>> > > Model Collection:
>> > > name=model
>> > > shard=shard1
>> > > collection=model
>> > >
>> > >
>> > > So can u please let me the changes needed in configuration for 
>> > > the
>> > implicit routing.
>> > >
>> > > Please do needful.
>> > >
>> > > Regards,
>> > >
>> > >
>> > > -----Original Message-----
>> > > From: Amrit Sarkar [mailto:sarkaramrit2@gmail.com]
>> > > Sent: Wednesday, November 08, 2017 12:36 PM
>> > > To: solr-user@lucene.apache.org
>> > > Subject: Re: How to routing document for send to particular shard 
>> > > range
>> > >
>> > > Ketan,
>> > >
>> > > If you know defined indexing architecture; isn't it better to use
>> > "implicit" router by writing logic on your own end.
>> > >
>> > > If the document is of "Org1", send the document with extra param*
>> > > "_route_:shard1"* and likewise.
>> > >
>> > > Snippet from official doc:
>> > > https://lucene.apache.org/solr/guide/6_6/shards-and-indexing-data
>> > > -
>> > > in -s
>> > > olrcloud.html#ShardsandIndexingDatainSolrCloud-DocumentRouting
>> > > :
>> > >
>> > > If you created the collection and defined the "implicit" router 
>> > > at the time
>> > >> of creation, you can additionally define a router.field 
>> > >> parameter to use a field from each document to identify a shard 
>> > >> where the document belongs. If the field specified is missing in 
>> > >> the document, however, the document will be rejected. You could 
>> > >> also use the _route_ parameter to name a specific shard.
>> > >
>> > >
>> > >
>> > > Amrit Sarkar
>> > > Search Engineer
>> > > Lucidworks, Inc.
>> > > 415-589-9269
>> > > www.lucidworks.com
>> > > Twitter http://twitter.com/lucidworks
>> > > LinkedIn: https://www.linkedin.com/in/sarkaramrit2
>> > > Medium: https://medium.com/@sarkaramrit2
>> > >
>> > > On Wed, Nov 8, 2017 at 11:15 AM, Ketan Thanki <kthanki@asite.com>
>> wrote:
>> > >
>> > >> Hi,
>> > >>
>> > >> I have requirement now quite different as I need to set routing 
>> > >> key hash for document which confirm it to send to particular 
>> > >> shard as its
>> > range.
>> > >>
>> > >> I have solrcloud configuration with 4 shard  & 4 replica with 
>> > >> below shard range.
>> > >> shard1: 80000000-bfffffff
>> > >> shard2: c0000000-ffffffff
>> > >> shard3: 0-3fffffff
>> > >> shard4: 40000000-7fffffff
>> > >>
>> > >> e.g: below show the project  works in organization which is my 
>> > >> routing
>> > key.
>> > >> Org1= works for project1,project2 Org2=works for project3 
>> > >> Org3=works for project4
>> > >> Org4=project5
>> > >>
>> > >> So as mentions above I want to index org1 to shard1,org2 to
>> > >> shard2,org3 to
>> > >> shard3,org4 to shard4 meanwhile send it to particular shard.
>> > >> How could I manage compositeId routing to do this.
>> > >>
>> > >> Regards,
>> > >> Ketan.
>> > >> Please cast a vote for Asite in the 2017 Construction Computing
>> Awards:
>> > >> Click here to
>> > >> Vote<http://caddealer.com/concompawards/index.php?page=
>> > >> cca2017vote>
>> > >>
>> > >> [CC Award Winners!]
>> > >>
>> > >>
>> >
>>
Mime
View raw message