Mailing-List: contact dev-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cassandra.apache.org
Date: Fri, 15 Jul 2016 08:10:11 +0000 (UTC)
From: Romain Hardouin <romainh_ml@yahoo.fr.INVALID>
Reply-To: Romain Hardouin <romainh_ml@yahoo.fr>
To: "dev@cassandra.apache.org" <dev@cassandra.apache.org>
Message-ID: <939571086.5374129.1468570211288.JavaMail.yahoo@mail.yahoo.com>
In-Reply-To: <CAE1LR7_Crq+YAzTQo7u6VYUvt9TL5u++TV8Fjb2S4P49FZn8AQ@mail.gmail.com>
References: <CAE1LR7_Crq+YAzTQo7u6VYUvt9TL5u++TV8Fjb2S4P49FZn8AQ@mail.gmail.com>
Subject: Re: Support Multi-Tenant in Cassandra
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_5374128_1529339468.1468570211284"
archived-at: Fri, 15 Jul 2016 08:10:24 -0000

------=_Part_5374128_1529339468.1468570211284
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

I don't use C* in such a context but out of curiosity did you set the=C2=A0=
request_scheduler to RoundRobin or did you implement your own scheduler?=20
Romain
    Le Vendredi 15 juillet 2016 8h39, jason zhao yang <zhaoyangsingapore@gm=
ail.com> a =C3=A9crit :
=20

 Hi,

May I ask is there any plan of extending functionalities related to
Multi-Tenant?

Our current approach is to define an extra PartitionKey called "tenant_id".
In my use cases, all tenants will have the same table schemas.

* For security isolation: we customized GRANT statement to be able to
restrict user query based on the "tenant_id" partition.

* For getting all data of single tenant, we customized SELECT statement to
support allow filtering on "tenant_id" partition key.

* For server resource isolation, I have no idea how to.

* For per-tenant backup restore, I was trying a
tenant_base_compaction_strategy to split sstables based on tenant_id. it
turned out to be very inefficient.

What's community's opinion about submitting those patches to Cassandra? It
will be great if you guys can share the ideal Multi-Tenant architecture for
Cassandra?

jasonstack


------=_Part_5374128_1529339468.1468570211284--