cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sanjay Sharma <>
Subject RE: Combining Cassandra with some SQL language
Date Mon, 27 Feb 2012 06:57:51 GMT
Kundera ( an open source APL Java ORM allows
polyglot persistence between  RDBMS and NoSQL databases such as Cassandra, MongoDB, HBase
etc. transparently to the business logic developer.

A note of caution- this does not mean that Cassandra data modeling can be bypassed- NoSQL
entities still need to be modeled in such a way so as to best use Cassandra capabilities.
Kundera can also take care of relationship between the entities in RDBMS.  Transactions management
is still pending however.

From: Adam Haney []
Sent: Sunday, February 26, 2012 7:51 PM
Subject: Re: Combining Cassandra with some SQL language

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 <<>>
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

What do you think of this?
With kind regards,
Robin Verlangen


Impetus' Head of Innovation labs, Vineet Tyagi will be presenting on 'Big Data Big Costs?'
at the Strata Conference, CA (Feb 28 - Mar 1)

Listen to our webcast 'Hybrid Approach to Extend Web Apps to Tablets & Smartphones' available

NOTE: This message may contain information that is confidential, proprietary, privileged or
otherwise protected by law. The message is intended solely for the named addressee. If received
in error, please destroy and notify the sender. Any use of this email is prohibited when received
in error. Impetus does not represent, warrant and/or guarantee, that the integrity of this
communication has been maintained nor that the communication is free of errors, virus, interception
or interference.

View raw message