http://www.datastax.com/support-forums/topic/solr-for-multi-tenant-webapp Software, Support, and Training for Apache Cassandra en-US Tue, 18 Jun 2013 06:32:19 +0000 http://bbpress.org/?v=1.0.3 q http://www.datastax.com/support-forums/search.php http://www.datastax.com/support-forums/topic/solr-for-multi-tenant-webapp#post-7970 Thu, 13 Dec 2012 20:41:22 +0000 hliu 7970@http://www.datastax.com/support-forums/ <p>Jack,</p> <p>Could you please elaborate more on the number of column families? What are the possible impact from having a large number of column families? performance? Would adding more nodes help? Thanks! </p> http://www.datastax.com/support-forums/topic/solr-for-multi-tenant-webapp#post-7962 Wed, 12 Dec 2012 21:35:53 +0000 Jack Krupansky 7962@http://www.datastax.com/support-forums/ <p>Prepending the UUID with the tenant ID is a good approach. I would recommend a delimiter other than colon to avoid problems with how queries are parsed. A hyphen or underscore would be good choices.</p> <p>If you are searching with CQL, you will have to use the full unique key for each row, but if you are using the Solr HTTP interface, you can add a "filter query" like &amp;fq=id:tenantid-* which would filter out all rows but those for that tenantid.</p> <p>Also, for multitenant, make sure that the tenants have to access Solr through an app that you provide that has a REST API which assures that they cannot override that filter query.</p> <p>One Solr core could support millions of rows/documents. Whether that is enough for your app is up to you.</p> <p>Finally, you get one core per column family, so you can create multiple column familiies, as long as the number of them is relatively small, like dozens or low 100's, but not thousands or more.</p> <p>You could also do a hybrid and support some number of tenants per column family and then have multiple column families as well. </p> http://www.datastax.com/support-forums/topic/solr-for-multi-tenant-webapp#post-7886 Fri, 07 Dec 2012 09:08:13 +0000 anonymous 7886@http://www.datastax.com/support-forums/ <p>I am implementing text search using DSE Solr. Our multi-tenant architecture is to use the one CF by prepending the tenantid to the rowid which is an UUID. So the rowid looks like tenantid:UUID. So when create a SOLR core to this CF, it gets all tenants information. How do i define the core to look for only rowids starting with the tenantid i am searching? Will single core be sufficient or do i need to use multiple cores to address multi-tenancy? if multiple cores how would i define the schema.xml?</p> <p>Thanks </p>