Return-Path: X-Original-To: apmail-hbase-user-archive@www.apache.org Delivered-To: apmail-hbase-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id DAF8D69FD for ; Thu, 16 Jun 2011 18:08:32 +0000 (UTC) Received: (qmail 24345 invoked by uid 500); 16 Jun 2011 18:08:31 -0000 Delivered-To: apmail-hbase-user-archive@hbase.apache.org Received: (qmail 24321 invoked by uid 500); 16 Jun 2011 18:08:31 -0000 Mailing-List: contact user-help@hbase.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hbase.apache.org Delivered-To: mailing list user@hbase.apache.org Received: (qmail 24313 invoked by uid 99); 16 Jun 2011 18:08:31 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 16 Jun 2011 18:08:31 +0000 X-ASF-Spam-Status: No, hits=0.7 required=5.0 tests=RCVD_IN_DNSWL_NONE,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [98.139.52.208] (HELO nm11.bullet.mail.ac4.yahoo.com) (98.139.52.208) by apache.org (qpsmtpd/0.29) with SMTP; Thu, 16 Jun 2011 18:08:22 +0000 Received: from [98.139.52.189] by nm11.bullet.mail.ac4.yahoo.com with NNFMP; 16 Jun 2011 18:08:00 -0000 Received: from [98.139.52.154] by tm2.bullet.mail.ac4.yahoo.com with NNFMP; 16 Jun 2011 18:08:00 -0000 Received: from [127.0.0.1] by omp1037.mail.ac4.yahoo.com with NNFMP; 16 Jun 2011 18:08:00 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 922771.11632.bm@omp1037.mail.ac4.yahoo.com Received: (qmail 6280 invoked by uid 60001); 16 Jun 2011 18:08:00 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1308247680; bh=uEDFbgjcbJ9ABbEEgDVPjE5w054TvUsnniYLvy4bQzI=; h=Message-ID:X-YMail-OSG:Received:X-RocketYMMF:X-Mailer:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=3gT+FBbPexm3TZY0Np3mwTyZmnw1G4pREqlCOzTbk7RQvESRqIJK22uubK8gTatZYR7kLYAp9NId+21XX+RavtLzEyqiLnTBH6J6Eq79QFruy06UixoilC1Kdn5JMn99+H3N36PRO+pswX53GUWsjg7B0xWpoZ+qZ34ImfCmjPQ= Message-ID: <770786.6071.qm@web65514.mail.ac4.yahoo.com> X-YMail-OSG: O4LAjJQVM1kda_Itx6wobzgag5o8IbpK3ZLYelN4Vym4WOQ CbU7SxH8JGFe7Mi0qoHzm_yQMYGKEQC5BV8x3PtG465FPk6fe6xLD67294K3 z_vINnLn34J9hvmd.cq8ykwu0kXwF7biLJSePFORab9tQCyB.R013KjwDSI4 Alw5MAZWz3cU8.l7EBpPjdLXcrHnEcVqjZBesoa.sYEA3NAPumBmT6kH4Akj ThFISjfGzSlAoRRQn6sev75.hnMa3wogs.wL3lVH9oqnLE2xM9DHkLNDdIN3 1qUGz8.lMelFOeNV3na6xzUMYMGQpEb4QcHyDt1ni7EBhTLgk8KrF2EEVC6p .oLDjx_nd7tPVJ4SKmjGj9m6u2oebcjJ8lxwiMNlH1ob.x4ggINAb5P6uX5h xFEm6x9X9qNTA Received: from [69.231.27.174] by web65514.mail.ac4.yahoo.com via HTTP; Thu, 16 Jun 2011 11:08:00 PDT X-RocketYMMF: apurtell X-Mailer: YahooMailClassic/14.0.1 YahooMailWebService/0.8.111.304355 Date: Thu, 16 Jun 2011 11:08:00 -0700 (PDT) From: Andrew Purtell Reply-To: apurtell@apache.org Subject: Re: any multitenancy suggestions for HBase? To: user@hbase.apache.org, billgraham@gmail.com In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable > Since there are no HBase ACLs =0A=0AThis is true only until HBASE-3025 is= ready and goes in, post 0.92. It may not be of immediate help now but yes = HBase will have ACLs. They are on the roadmap.=0A=0ABest regards,=0A=0A = - Andy=0A=0AProblems worthy of attack prove their worth by hitting back. - = Piet Hein (via Tom White)=0A=0A=0A--- On Tue, 6/14/11, Barney Frank wrote:=0A=0A> From: Barney Frank =0A> Subject: Re: any multitenancy suggestions for HBase?=0A> To: user@hb= ase.apache.org, billgraham@gmail.com=0A> Date: Tuesday, June 14, 2011, 5:04= AM=0A> Our implementation supports multiple=0A> customers that share the s= ame tables=0A> and column families.=A0 We use the customerId as the=0A> fir= st token of the Row Id=0A> i.e. "CUST123|someOtherRowQualifier".=A0 For all= =0A> customer queries, we add=0A> their customerId as the row prefix and, o= f course, ensure=0A> that they are=0A> authorized within our app.=0A> =0A> = On Mon, Jun 13, 2011 at 5:31 PM, Bill Graham =0A> wro= te:=0A> =0A> > Hello there,=0A> >=0A> > We have a number of different group= s within our=0A> organization who will soon=0A> > be working within the sam= e HBase cluster and we're=0A> trying to set up some=0A> > best practices to= keep thinks organized. Since there=0A> are no HBase ACLs=A0 and=0A> > no c= oncept of multiple databases in the cluster, we're=0A> looking to propose a= =0A> > simple convention that will hopefully keep people from=0A> stepping = on each=0A> > others toes (or worse!).=0A> >=0A> > Does anyone have any bes= t/worst practices they're=0A> willing to share w.r.t.=0A> > thing likes tab= le/column naming schemes in a=0A> multitenant environment? For=0A> > table = names for example, is there anything better than=0A> a basic=0A> > dot-deli= mited=0A> > naming convention with the group name as the first=0A> token?= =0A> >=0A> > Also, I assume there's no performance cost with using=0A> long= table names like=0A> > there is with long CF:col names. Please let me know= if=0A> that's not the case.=0A> >=0A> > thanks,=0A> > Bill=0A> >=0A>