Ok, thank you all for your opinions. Seems that I can continue without any extra db-model headaches ;-)
2012/2/27 Sanjay Sharma <sanjay.sha...@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.ha...@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 <ro...@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. >
