Re: [EXTERNAL] Re: Cluster size "limit"

Instaclustr's done some analysis around "optimal" number of vnodes to use - https://www.instaclustr.com/cassandra-vnodes-how-many-should-i-use/ I might be able to provide more details if you're interested. As, Sean said, you can create the new DC with different number of vnodes. Kind Regards, *Gr

Adding New Column with Default Value

Hi , Can anyone suggest a best possible way, how we can add a new column to the existing table with default value ? *Column family Size :* 60 Million single partition records. Thanks, Bharath Kumar B

Re: [EXTERNAL] Re: Migrate large volume of data from one table to another table within the same cluster when COPY is not an option.

Hi Leena, as already suggested in my previous email, you could use Apache Spark and Cassandra Spark connector (1). I have checked TTLs and I believe you should especially read this section (2) about TTLs. Seems like thats what you need to do, ttls per row. The workflow would be that you read from

RE: update manually rows in cassandra

Update json data with the correct value from file. Thanks Natarajan Sundaramoorthy PaaS Engineering and Automation Desk - 763-744-1854 Email - natarajan_sundaramoor...@optum.com [cid:image001.jpg@01D03C99.02523830] From: Dieudonné Madishon NGAYA [m

Re: update manually rows in cassandra

Hi , In your case, do you want to insert json file data into cassandra ? Best regards _ [image: https://www.facebook.com/DMN-BigData-371074727032197/?modal=admin_todo_tour]

Experimental results: everything we thought we knew about thread-pools is wrong

Howdy, As a followup to my earlier thread I wanted to share some of our experimental data using an auto-tuning agent to find optimal thread pool settings for C*. The results surprised me. It invalidated a lot of previous thinking about tuning C* and calls into question some of the decisions that w

update manually rows in cassandra

Something got goofed up in database. Data is in json format. We have data in some file have to match the data in file and update the database. Can you please tell how to do it? New to cassandra. Thanks This e-mail, including attachments, may include confidential and/or proprietary information,

Re: Audit in C*

Yes.we are using it and it is very helpful to u so far...! On Wed, Mar 13, 2019 at 11:38 AM Rahul Singh wrote: > Which version are you referring to? > > On Wed, Mar 13, 2019 at 10:28 AM Nitan Kainth > wrote: > >> Hi, >> >> Anybody have used auditing to find out failed login attempts, or >> unau

Re: Audit in C*

Which version are you referring to? On Wed, Mar 13, 2019 at 10:28 AM Nitan Kainth wrote: > Hi, > > Anybody have used auditing to find out failed login attempts, or > unauthorized access tries. > > I found ecAudit by Ericsson, is it free to use? Has anybody tried it? > > Ref: https://github.com/E

RE: [EXTERNAL] Re: Cluster size "limit"

Rebuild the DCs with a new number of vnodes… I have done it. Sean From: Ahmed Eljami Sent: Wednesday, March 13, 2019 2:09 PM To: user@cassandra.apache.org Subject: Re: [EXTERNAL] Re: Cluster size "limit" Is not possible with an existing cluster! Le mer. 13 mars 2019 à 18:39, Durity, Sean R mai

Re: [EXTERNAL] Re: Cluster size "limit"

Is not possible with an existing cluster! Le mer. 13 mars 2019 à 18:39, Durity, Sean R a écrit : > If you can change to 8 vnodes, it will be much better for repairs and > other kinds of streaming operations. The old advice of 256 per node is now > not very helpful. > > > > Sean > > > > *From:* A

RE: [EXTERNAL] Re: Cluster size "limit"

If you can change to 8 vnodes, it will be much better for repairs and other kinds of streaming operations. The old advice of 256 per node is now not very helpful. Sean From: Ahmed Eljami Sent: Wednesday, March 13, 2019 1:27 PM To: user@cassandra.apache.org Subject: [EXTERNAL] Re: Cluster size

Re: Cluster size "limit"

Yes, 256 vnodes Le mer. 13 mars 2019 à 17:31, Jeff Jirsa a écrit : > Do you use vnodes? How many vnodes per machine? > > -- > Jeff Jirsa > > > On Mar 13, 2019, at 3:58 PM, Ahmed Eljami wrote: > > Hi, > > We are planning to add a third datacenter to our cluster (already has 2 > datacenter, every

Re: Cluster size "limit"

Do you use vnodes? How many vnodes per machine? -- Jeff Jirsa > On Mar 13, 2019, at 3:58 PM, Ahmed Eljami wrote: > > Hi, > > We are planning to add a third datacenter to our cluster (already has 2 > datacenter, every datcenter has 50 nodes, so 100 nodes in total). > > My fear is that an i

Re: Cluster size "limit"

Hi Ahmed Eljami, Problem is not only number of nodes. what is your capacity per node ? recommandations from Datastax is keeping data per node near or below 1 TB. Exceeding this value has the following effects: - .Extremely long times (days) for bootstrapping new nodes. - .Impacts maintenan

Cluster size "limit"

Hi, We are planning to add a third datacenter to our cluster (already has 2 datacenter, every datcenter has 50 nodes, so 100 nodes in total). My fear is that an important number of nodes per cluster (> 100) could cause a lot of problems like gossip duration, maintenance (repair...)... I know tha

Audit in C*

Hi, Anybody have used auditing to find out failed login attempts, or unauthorized access tries. I found ecAudit by Ericsson, is it free to use? Has anybody tried it? Ref: https://github.com/Ericsson/ecaudit

Re: [EXTERNAL] Re: Migrate large volume of data from one table to another table within the same cluster when COPY is not an option.

Understand, 2nd table would be a better approach. So what would be the best way to copy 70M rows from current table to the 2nd table with ttl set on each record as the first table? From: Durity, Sean R Sent: Wednesday, March 13, 2019 8:17 AM To: user@cassandra.a

RE: [EXTERNAL] Re: Migrate large volume of data from one table to another table within the same cluster when COPY is not an option.

Correct, there is no current flag. I think there SHOULD be one. From: Dieudonné Madishon NGAYA Sent: Tuesday, March 12, 2019 7:17 PM To: user@cassandra.apache.org Subject: [EXTERNAL] Re: Migrate large volume of data from one table to another table within the same cluster when COPY is not an opt