Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-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 3744799C0 for ; Sun, 26 Feb 2012 14:21:42 +0000 (UTC) Received: (qmail 67326 invoked by uid 500); 26 Feb 2012 14:21:39 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 67288 invoked by uid 500); 26 Feb 2012 14:21:39 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 67247 invoked by uid 99); 26 Feb 2012 14:21:38 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 26 Feb 2012 14:21:38 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_NEUTRAL,TO_NO_BRKTS_PCNT X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: local policy) Received: from [74.125.82.42] (HELO mail-ww0-f42.google.com) (74.125.82.42) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 26 Feb 2012 14:21:32 +0000 Received: by wgbdt10 with SMTP id dt10so706346wgb.1 for ; Sun, 26 Feb 2012 06:21:11 -0800 (PST) Received-SPF: pass (google.com: domain of adam.haney@retickr.com designates 10.180.101.200 as permitted sender) client-ip=10.180.101.200; Authentication-Results: mr.google.com; spf=pass (google.com: domain of adam.haney@retickr.com designates 10.180.101.200 as permitted sender) smtp.mail=adam.haney@retickr.com Received: from mr.google.com ([10.180.101.200]) by 10.180.101.200 with SMTP id fi8mr19966595wib.20.1330266071840 (num_hops = 1); Sun, 26 Feb 2012 06:21:11 -0800 (PST) MIME-Version: 1.0 Received: by 10.180.101.200 with SMTP id fi8mr15942111wib.20.1330266071695; Sun, 26 Feb 2012 06:21:11 -0800 (PST) Received: by 10.216.48.132 with HTTP; Sun, 26 Feb 2012 06:21:11 -0800 (PST) In-Reply-To: References: Date: Sun, 26 Feb 2012 09:21:11 -0500 Message-ID: Subject: Re: Combining Cassandra with some SQL language From: Adam Haney To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=f46d044280b6a9001e04b9deb408 X-Gm-Message-State: ALoCoQl/85PEfXWi7UqcxDPMID6X9uPDxUz3iUH8J15i93xObyAcI5jWtioqPMmN0tGFIWnlSU4C X-Virus-Checked: Checked by ClamAV on apache.org --f46d044280b6a9001e04b9deb408 Content-Type: text/plain; charset=ISO-8859-1 I've been using a combination of MySQL and Cassandra for about a year now on a project that now serves about 20k users. We use Cassandra for storing large entities and MySQL to store meta data that allows us to do better ad hoc querying. It's worked quite well for us. During this time we have also been able to migrate some of our tables in MySQL to Cassandra if MySQL performance / capacity became a problem. This may seem obvious but if you're planning on creating a data model that spans multiple databases make sure you encapsulate the logic to read/write/delete information in a good data model library and only use that library to access your data. This is good practice anyway but when you add the extra complication of multiple databases that may reference one another it's an absolute must. On Sun, Feb 26, 2012 at 8:06 AM, R. Verlangen wrote: > Hi there, > > I'm currently busy with the technical design of a new project. Of course > it will depend on your needs, but is it weird to combine Cassandra with a > SQL language like MySQL? > > In my usecase it would be nice because we have some tables/CF's with lots > and lots of data that does not really have to be consistent 100%, but also > have some data that should be always consistent. > > What do you think of this? > > With kind regards, > Robin Verlangen > --f46d044280b6a9001e04b9deb408 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable I've been using a combination of MySQL and Cassandra for about a year n= ow on a project that now serves about 20k users. We use Cassandra for stori= ng large entities and MySQL to store meta data that allows us to do better = ad hoc querying. It's worked quite well for us. During this time we hav= e also been able to migrate some of our tables in MySQL to Cassandra if MyS= QL performance / capacity became a problem. This may seem obvious but if yo= u're planning on creating a data model that spans multiple databases ma= ke sure you encapsulate the logic to read/write/delete information in a goo= d data model library and only use that library to access your data. This is= good practice anyway but when you add the extra complication of multiple d= atabases that may reference one another it's an absolute must.

On Sun, Feb 26, 2012 at 8:06 AM, R. Verlange= n <robin@us2.nl>= ; wrote:
Hi there,

I'm currently busy with the technical desi= gn of a new project. Of course it will depend on your needs, but is it weir= d to combine Cassandra with a SQL language like MySQL?

In my usecase it would be nice because we have some tables/CF's wi= th lots and lots of data that does not really have to be consistent 100%, b= ut also have some data that should be always consistent.

What do you think of this?

With kind regards,<= /div>
Robin Verlangen

--f46d044280b6a9001e04b9deb408--