incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "R. Verlangen" <ro...@us2.nl>
Subject Re: Combining Cassandra with some SQL language
Date Mon, 27 Feb 2012 07:52:50 GMT
Ok, thank you all for your opinions. Seems that I can continue without any
extra db-model headaches ;-)

2012/2/27 Sanjay Sharma <sanjay.sharma@impetus.co.in>

>  Kundera (https://github.com/impetus-opensource/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.
>
>
>
>
>
> Regards,
>
> Sanjay
>
> *From:* Adam Haney [mailto:adam.haney@retickr.com]
> *Sent:* Sunday, February 26, 2012 7:51 PM
> *To:* user@cassandra.apache.org
> *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 <robin@us2.nl> 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
>
>
>
> ------------------------------
>
> Impetus’ Head of Innovation labs, Vineet Tyagi will be presenting on ‘Big
> Data Big Costs?’ at the Strata Conference, CA (Feb 28 - Mar 1)
> http://bit.ly/bSMWd7.
>
> Listen to our webcast ‘Hybrid Approach to Extend Web Apps to Tablets &
> Smartphones’ available at http://bit.ly/yQC1oD.
>
>
> 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.
>

Mime
View raw message