Regards, Aditya. I´m agree with Jack here. In our tests here with read and writes in Cassandra (version 2.1.5), we played with several CL, and QUORUM is the best for us.

On 25/06/15 08:14, Jack Krupansky wrote:
Hinted handoff - which is what provides eventual consistency - can time out and be discarded/lost if the cluster is under heavy load or encounters poor network connectivity or nodes are down for too long, which is what requires running repair. That's why quorum is the recommended cl for both write and read for true consistency.

-- Jack Krupansky

On Thu, Jun 25, 2015 at 7:51 AM, Alain RODRIGUEZ <arodr...@gmail.com <mailto:arodr...@gmail.com>> wrote:

    Excepted if the node failed to take the write and you have no
    Hinted Handoff (or for some reason they also failed).

    Have you tried at QUORUM or even ALL, this would force a
    synchronous read repair. You can also try to repair directly.

    Hope this will help,

    C*heers,

    Alain

    2015-06-25 13:34 GMT+02:00 Aditya Shetty
    <aditya.she...@snapdeal.com <mailto:aditya.she...@snapdeal.com>>:

        I am using consistency one for both. However, the writes had
        happened a few days before, so it does not look like an issue
        of eventual consistency.

        On Thu, Jun 25, 2015 at 3:59 PM, Perica Milošević
        <perica.milose...@gmail.com
        <mailto:perica.milose...@gmail.com>> wrote:

            Which ConsistencyLevel do you use for writing and reading
            of the data?

            Cheers,
            Perica


            On Thu, Jun 25, 2015 at 12:12 PM, Aditya Shetty
            <aditya.she...@snapdeal.com
            <mailto:aditya.she...@snapdeal.com>> wrote:

                Hi

                I have a 3 node cassandra cluster with a replication
                factor of 2. I have a basic column family which I am
                reading by primary key. Here is the CF structure:

                CREATE TABLE reviews_platform.object_stats (

                    object_owner_id int,

                    object_type int,

                    object_id text,

                    num_of_reviews int,    PRIMARY KEY
                ((object_owner_id, object_type), object_id)

                );

                However, when I query this column family by primary
                key, I sometimes get no records, even though the
                record exists. The same query after some time gives a
                proper response.

                /Query:
                select * from reviews_platform.object_stats where
                object_id = '674813358269'
                and object_type = 0
                and object_owner_id = 0;
                /
                Note that I am querying using the java driver.

--
                        
                Aditya Shetty
                *Lead Engineer*
                        

                        
                *M*: +91 7022423545 <tel:%2B91%207022423545>, *T*: 080
                46603000 *EXT*: 4417
                2^nd FLOOR, WEST WING,

                SALARPURIA SUPREME, MARATHAHALLI, BENGALURU


                        
                        
                Download Our App
                A
                
<https://play.google.com/store/apps/details?id=com.snapdeal.main&utm_source=mobileAppLp&utm_campaign=android>
                        
                        A
                
<https://itunes.apple.com/in/app/snapdeal-mobile-shopping/id721124909?ls=1&mt=8&utm_source=mobileAppLp&utm_campaign=ios>
                        
                        W
                
<http://www.windowsphone.com/en-in/store/app/snapdeal/ee17fccf-40d0-4a59-80a3-04da47a5553f>






--
                
        Aditya Shetty
        *Lead Engineer*
                

                
        *M*: +91 7022423545 <tel:%2B91%207022423545>, *T*: 080
        46603000 *EXT*: 4417
        2^nd FLOOR, WEST WING,

        SALARPURIA SUPREME, MARATHAHALLI, BENGALURU


                
                
        Download Our App
        A
        
<https://play.google.com/store/apps/details?id=com.snapdeal.main&utm_source=mobileAppLp&utm_campaign=android>
                
                A
        
<https://itunes.apple.com/in/app/snapdeal-mobile-shopping/id721124909?ls=1&mt=8&utm_source=mobileAppLp&utm_campaign=ios>
                
                W
        
<http://www.windowsphone.com/en-in/store/app/snapdeal/ee17fccf-40d0-4a59-80a3-04da47a5553f>





--
Marcos Ortiz <http://about.me/marcosortiz>, Sr. Product Manager (Data Infrastructure) at UCI
@marcosluis2186 <http://twitter.com/marcosluis2186>

Reply via email to