Mailing-List: contact solr-user-help@lucene.apache.org; run by ezmlm
Precedence: bulk
Reply-To: solr-user@lucene.apache.org
Received-SPF: pass (athena.apache.org: domain of shalinmangar@gmail.com
 designates 209.85.221.177 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type;
        b=C71md6tw0a2cY3qf519a7VYMxxWqMUlTF0X0ExlRkdNdRKK2NOHDWUSyUONK3Y8E+i
         /LkR8auF5eeJRmlpeBkOfmxZ6FEupoeVmv9Y6yEx1ZOkfn9x4L5VpzWDWEipfdm0YgDN
         5lGRF8whV7Ixgpt6XhzU0cljnqKI7pjbuooWE=
MIME-Version: 1.0
In-Reply-To: <o2q6d2470be1004242353le5e52655n6568494ffd74fe7f@mail.gmail.com>
References: <o2q6d2470be1004242353le5e52655n6568494ffd74fe7f@mail.gmail.com>
Date: Sun, 25 Apr 2010 17:19:49 +0530
Message-ID: <o2l69de18141004250449u5c257f15o6dc5e6b3daa3dd3e@mail.gmail.com>
Subject: Re: How to setup search engine for B2B web app
From: Shalin Shekhar Mangar <shalinmangar@gmail.com>
To: solr-user@lucene.apache.org
Content-Type: multipart/alternative; boundary=0016361e898cf2480e04850e4131

--0016361e898cf2480e04850e4131
Content-Type: text/plain; charset=UTF-8

Hi Bill,

On Sun, Apr 25, 2010 at 12:23 PM, Bill Paetzke <billpaetzke@gmail.com>wrote:

> *Given:*
>
>   - 1 database per client (business customer)
>   - 5000 clients
>   - Clients have between 2 to 2000 users (avg is ~100 users/client)
>   - 100k to 10 million records per database
>   - Users need to search those records often (it's the best way to navigate
>   their data)
>
> *The Question:*
>
> How would you setup Solr (or Lucene) search so that each client can only
> search within its database?
>
> How would you setup the index(es)?
>

I'd look at setting up multiple cores for each client. You may need to setup
slaves as well depending on search traffic.


> Where do you store the index(es)?
>

Setting up 5K cores on one box will not work. So you will need to partition
the clients into multiple boxes each having a subset of cores.


> Would you need to add a filter to all search queries?
>

Nope, but you will need to send the query to the correct host (perhaps a
mapping DB will help)


> If a client cancelled, how would you delete their (part of the) index?
> (this
> may be trivial--not sure yet)
>
>
With different cores for each client, this'd be pretty easy.

-- 
Regards,
Shalin Shekhar Mangar.

--0016361e898cf2480e04850e4131--