Re: loading big amount of data to Cassandra

2019-08-02 Thread Ayub M
Dimo, how do you generate sstables? Do you mean load data locally on a cassandra node and use sstableloader? On Fri, Aug 2, 2019, 5:48 PM Dimo Velev wrote: > Hi, > > Batches will actually slow down the process because they mean a different > thing in C* - as you read they are just grouping chang

Re: loading big amount of data to Cassandra

2019-08-02 Thread Dimo Velev
Hi, Batches will actually slow down the process because they mean a different thing in C* - as you read they are just grouping changes together that you want executed atomically. Cassandra does not really have indices so that is different than a relational DB. However, after writing stuff to

Re: What happened about one node in cluster is down?

2019-08-02 Thread Martin Xue
Thank you Jeff, appreciated. Regards Martin On Fri, Aug 2, 2019 at 10:52 PM Jeff Jirsa wrote: > > > > On Aug 2, 2019, at 5:47 AM, Oleksandr Shulgin < > oleksandr.shul...@zalando.de> wrote: > > > 3. what is the best strategy under this senario? >> >> Go to RF=3 or read and write at quorum so you

Re: loading big amount of data to Cassandra

2019-08-02 Thread Jeff Jirsa
CQLSSTableWriter On Fri, Aug 2, 2019 at 9:59 AM wrote: > Hi, > > I need to upload to Cassandra about 7 billions of records. What is the > best setup of Cassandra for this task? Will usage of batch speeds up the > upload (I've read somewhere that batch in Cassandra is dedicated to > atomicity n

loading big amount of data to Cassandra

2019-08-02 Thread pat
Hi, I need to upload to Cassandra about 7 billions of records. What is the best setup of Cassandra for this task? Will usage of batch speeds up the upload (I've read somewhere that batch in Cassandra is dedicated to atomicity not to speeding up communication)? How Cassandra internally works r

Re: What happened about one node in cluster is down?

2019-08-02 Thread Jeff Jirsa
On Aug 2, 2019, at 5:47 AM, Oleksandr Shulgin wrote: >> > 3. what is the best strategy under this senario? >> >> Go to RF=3 or read and write at quorum so you’re doing 3/4 instead of 2/2 > > Jeff, did you mean "2/3 vs. 2/2"? > No but my wording was poor Moving to RF=3 would be local quo

Re: What happened about one node in cluster is down?

2019-08-02 Thread Oleksandr Shulgin
> > > 3. what is the best strategy under this senario? > > Go to RF=3 or read and write at quorum so you’re doing 3/4 instead of 2/2 Jeff, did you mean "2/3 vs. 2/2"? -Alex

Re: What happened about one node in cluster is down?

2019-08-02 Thread Jeff Jirsa
> On Aug 2, 2019, at 12:21 AM, Martin Xue wrote: > > Hello, > > I am currently running into a production issue, and seek help from the > community to help. > > Can anyone help with the following question regarding the Cassandra down node > inside cluster? > > Case: > Cassandra 3.0.14 > 3

What happened about one node in cluster is down?

2019-08-02 Thread Martin Xue
Hello, I am currently running into a production issue, and seek help from the community to help. Can anyone help with the following question regarding the Cassandra down node inside cluster? Case: Cassandra 3.0.14 3 nodes (A, B, C) in DC1, 3 nodes (D, E, F) in DC2 forming one cluster keyspace_m