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 F26F77588 for ; Tue, 27 Dec 2011 14:50:54 +0000 (UTC) Received: (qmail 6582 invoked by uid 500); 27 Dec 2011 14:50:52 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 6552 invoked by uid 500); 27 Dec 2011 14:50:52 -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 6544 invoked by uid 99); 27 Dec 2011 14:50:52 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 27 Dec 2011 14:50:52 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: local policy) Received: from [209.85.220.172] (HELO mail-vx0-f172.google.com) (209.85.220.172) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 27 Dec 2011 14:50:46 +0000 Received: by vcbfk13 with SMTP id fk13so9853699vcb.31 for ; Tue, 27 Dec 2011 06:50:25 -0800 (PST) MIME-Version: 1.0 Received: by 10.220.224.194 with SMTP id ip2mr16316270vcb.41.1324997424223; Tue, 27 Dec 2011 06:50:24 -0800 (PST) Received: by 10.52.88.49 with HTTP; Tue, 27 Dec 2011 06:50:24 -0800 (PST) In-Reply-To: <4EF9D8CE.8080409@sendmail.cz> References: <20111226183846.GA28107@aintsys.com> <4EF9D8CE.8080409@sendmail.cz> Date: Tue, 27 Dec 2011 15:50:24 +0100 Message-ID: Subject: Re: Newbie question about writer/reader consistency From: "R. Verlangen" To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=14dae9cdc345cc94f904b514006f X-Virus-Checked: Checked by ClamAV on apache.org --14dae9cdc345cc94f904b514006f Content-Type: text/plain; charset=ISO-8859-1 You might consider a hybrid solution with a transactional db for all data that should be ACID complient and Cassandra for the huge amounts of data you want to store. 2011/12/27 Radim Kolar > > makes me feel disappointed about consistency in Cassandra, but I wonder is >> there is a way to work around it. >> > cassandra is not suitable for this kind of programs. CouchDB is slightly > better, it has transactions but no locking and i am not sure if transaction > isolation is supported now. mongodb has some kind of atomic operations - > http://www.mongodb.org/**display/DOCS/Atomic+Operations but no locking or rollbacks either. > > Standard RDBMS like DB2 and Oracle are best for your kind of applications, > they can scale well too. In DB2 you can choose between shared disk and > shared nothing cluster architecture. > --14dae9cdc345cc94f904b514006f Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable You might consider a hybrid solution with a transactional db for all data t= hat should be ACID complient and Cassandra for the huge amounts of data you= want to store.

2011/12/27 Radim Kolar <hsn@sendmail.cz&= gt;

makes me feel disappointed about consistency in Cassandra, but I wonder is<= br> there is a way to work around it.
cassandra is not suitable for this kind of programs. CouchDB is slightly be= tter, it has transactions but no locking and i am not sure if transaction i= solation is supported now. mongodb has some kind of atomic operations - http://www.mongodb.org/display/DOCS/Atomic+Operations =A0b= ut no locking or rollbacks either.

Standard RDBMS like DB2 and Oracle are best for your kind of applications, = they can scale well too. In DB2 you can choose between shared disk and shar= ed nothing cluster architecture.

--14dae9cdc345cc94f904b514006f--