You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Chandana Tummala <Ch...@wipro.com> on 2013/05/01 10:42:50 UTC
HOW TO SET CONSISTENCY LEVEL FOR
Hi All,
Hi All,
We have a requirement to load approximately 10 million records, each record
with approximately 100 columns daily and automatically . We are planning to
use the Bulk-loader program to convert the data into SSTables and then load
them using SSTABLELOADER.
Everything is working fine when all nodes are up and running and the
performance is very good. However, when a node is down, the streaming fails
and the operation stops. We have to run the SSTABLELOADER with option 'I' to
exclude the node that is down. I was wondering if we can enforce Consistency
level of 'ANY' with SSTABLELOADER as well.
i have tried with -i option but the progarm is automatic so finding a
failure node and running again may decrease the performance .
can any one suggest the best approach for the bulk loader program without
failing even one node is down.
Environment:
Cassandra 1.1.9.1 provided as part of DSE 3.0
8 Nodes
Replication Factor – 3
Consistency Level – ANY
Regards,
Praveen
--
View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/HOW-TO-SET-CONSISTENCY-LEVEL-FOR-tp7587567.html
Sent from the cassandra-user@incubator.apache.org mailing list archive at Nabble.com.
Re: HOW TO SET CONSISTENCY LEVEL FOR
Posted by Tyler Hobbs <ty...@datastax.com>.
sstableloader directly streams sstables to the correct replica nodes. It
doesn't go through the normal coordinated write process, so consistency
levels do not apply.
On Wed, May 1, 2013 at 3:42 AM, Chandana Tummala <Chandana.tummala@wipro.com
> wrote:
> Hi All,
>
> Hi All,
>
> We have a requirement to load approximately 10 million records, each record
> with approximately 100 columns daily and automatically . We are planning
> to
> use the Bulk-loader program to convert the data into SSTables and then load
> them using SSTABLELOADER.
>
> Everything is working fine when all nodes are up and running and the
> performance is very good. However, when a node is down, the streaming fails
> and the operation stops. We have to run the SSTABLELOADER with option 'I'
> to
> exclude the node that is down. I was wondering if we can enforce
> Consistency
> level of 'ANY' with SSTABLELOADER as well.
>
> i have tried with -i option but the progarm is automatic so finding a
> failure node and running again may decrease the performance .
>
>
> can any one suggest the best approach for the bulk loader program without
> failing even one node is down.
>
>
> Environment:
>
> Cassandra 1.1.9.1 provided as part of DSE 3.0
> 8 Nodes
> Replication Factor – 3
> Consistency Level – ANY
>
> Regards,
> Praveen
>
>
>
> --
> View this message in context:
> http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/HOW-TO-SET-CONSISTENCY-LEVEL-FOR-tp7587567.html
> Sent from the cassandra-user@incubator.apache.org mailing list archive at
> Nabble.com.
>
--
Tyler Hobbs
DataStax <http://datastax.com/>