Re: auto_bootstrap for seed node

We followed this https://docs.datastax.com/en/cassandra/2.1/cassandra/operations/ops_add_dc_to_cluster_t.html, but it does not mention that change bootstrap for seed nodes after the rebuild. Thanks, Peng Xiao -- Original -- From: "Ali

Re: auto_bootstrap for seed node

You might want to follow DataStax docs on this one: For adding a DC to an existing cluster: https://docs.datastax.com/en/dse/5.1/dse-admin/datastax_enterprise/operations/opsAddDCToCluster.html For adding a new node to an existing cluster:

auto_bootstrap for seed node

Dear All, For adding a new DC ,we need to set auto_bootstrap: false and then run the rebuild,finally we need to change auto_bootstrap: true,but for seed nodes,it seems that we still need to keep bootstrap false? Could anyone please confirm? Thanks, Peng Xiao

Re: 答复: 答复: A node down every day in a 6 nodes cluster

java.lang.OutOfMemoryError: Java heap space You’re oom’ ing -- Jeff Jirsa > On Mar 27, 2018, at 6:45 PM, Xiangfei Ni wrote: > > Hi Jeff, > Today another node was shutdown,I have attached the exception log > file,could you please help to analyze?Thanks. > >

答复: 答复: A node down every day in a 6 nodes cluster

Another thins is that I have removed the index which has the wide partition rt_ac_stat.idx_rt_ac_stat_prot_verrt_ac_stat.idx_rt_ac_stat_prot_ver as you pointed out. Best Regards, 倪项菲/ David Ni 中移德电网络科技有限公司 Virtue Intelligent Network Ltd, co. Add: 2003,20F No.35 Luojia creative city,Luoyu

答复: 答复: A node down every day in a 6 nodes cluster

Hi Jeff, Today another node was shutdown,I have attached the exception log file,could you please help to analyze?Thanks. Best Regards, 倪项菲/ David Ni 中移德电网络科技有限公司 Virtue Intelligent Network Ltd, co. Add: 2003,20F No.35 Luojia creative city,Luoyu Road,Wuhan,HuBei Mob: +86 13797007811|Tel: +

Re: Apache Cassandra start up script

Hi Anumod Echoing what Christophe said, you should also mention what OS you are using, so that we would be able to help you get to the solution. Cheers, Alex. On Wed, 28 Mar 2018 at 11:05 Christophe Schmitz wrote: > Hi Anumod, > > When you install Cassandra using

Re: Execute an external program

CDC may also work for newer versions, but it’ll happen after the mutation is applied -- Jeff Jirsa > On Mar 27, 2018, at 5:31 PM, Christophe Schmitz > wrote: > > Hi Earl, > > You probably want to check Cassandra triggers: >

Re: Apache Cassandra start up script

Hi Anumod, When you install Cassandra using the tarball install, you will not get a service file installed. It becomes your responsability to write one (or to take one from the internet). When you install Cassandra using a package (.deb, .rpm..), the installer should also install the service

Re: Execute an external program

Hi Earl, You probably want to check Cassandra triggers: http://cassandra.apache.org/doc/latest/cql/triggers.html You can write arbitrary code that is called for the DML against your table. Cheers, Christophe On 28 March 2018 at 10:58, Earl Lapus wrote: > Hi All, > > I

Apache Cassandra start up script

Hi All , I’ve installed Apache Cassandra( Tarball install ).. But there is no way to see the Cassandra status / stop option . Anyone has the Apache Cassandra start / stop script for Cassandra 3.12 Can some one help on this ? Thanks, Anumod Mob-718-844-3841 PA,USA Sent from my iPhone

Execute an external program

Hi All, I may be over the edge here, but is there a way to execute an external program if a new row is added or if an existing row is updated on a table? Cheers, Earl -- There are seven words in this sentence.

Re: high latency on one node after replacement

thanks for pointing that out, i just found it too :) i overlooked this On Tue, Mar 27, 2018 at 3:44 PM, Voytek Jarnot wrote: > Have you ruled out EBS snapshot initialization issues ( > https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/ebs-initialize.html)? > > On Tue,

Re: high latency on one node after replacement

Have you ruled out EBS snapshot initialization issues ( https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/ebs-initialize.html)? On Tue, Mar 27, 2018 at 2:24 PM, Mike Torra wrote: > Hi There - > > I have noticed an issue where I consistently see high p999 read latency on

Re: high latency on one node after replacement

Hi Mike, Unlike normal EBS volumes for which you don't need to pre-warm, I think you need to pre-Warm your EBS volume restored from a snapshot Have a look at this AWS doc https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/ebs-initialize.html It says that: However, storage blocks on volumes that

high latency on one node after replacement

Hi There - I have noticed an issue where I consistently see high p999 read latency on a node for a few hours after replacing the node. Before replacing the node, the p999 read latency is ~30ms, but after it increases to 1-5s. I am running C* 3.11.2 in EC2. I am testing out using EBS snapshots of

Re: Can "data_file_directories" make use of multiple disks?

In Cassandra 3.2 and later, data is partitioned by token range, which should give you even distribution of data. If you're going to go into 3.x, please use the latest 3.11, which at this time is 3.11.2. On Tue, Mar 27, 2018 at 8:05 AM Venkata Hari Krishna Nukala <

RE: RE: 答复: A node down every day in a 6 nodes cluster

It may be that the wife partition is bombarded more than other partitions. What’s your RF on that keyspace? If if it’s greater than 1 I’d expect other nodes to get the same type of load. -- Rahul Singh rahul.si...@anant.us Anant Corporation On Mar 27, 2018, 5:56 AM -0700, Kenneth Brotman

Re: Can "data_file_directories" make use of multiple disks?

Yes you can have multiple entries from multiple disks. No guarantee as I can see of even distribution. If you want even distribution there are better mechanisms for this at the filesystem later. -- Rahul Singh rahul.si...@anant.us Anant Corporation On Mar 27, 2018, 8:05 AM -0700, Venkata Hari

Can "data_file_directories" make use of multiple disks?

Hi, I am trying to replace machines having HDD with little powerful machines having SSD in production. The data present in each node is around 300gb. But the newer machines have 2 X 200GB SSDs instead of a single disk. "data_file_directories" looks like a multi-valued config which I can use. Am

RE: RE: 答复: A node down every day in a 6 nodes cluster

First, anything Jeff Jirsa says is likely very accurate, like it being a really good idea to also get off the version you’re on and onto a version that fixes some of the known problems of the version you’re one. Replacing a running node:

Re:RE: 答复: A node down every day in a 6 nodes cluster

Thanks,Kenneth,this is production database,and it is one of three seed nodes,do you have doc for replacing a seed node? 发自我的小米手机 在 Kenneth Brotman ，2018年3月27日 下午7:45写道： David, Can you replace the misbehaving node to see if that resolves the problem? Kenneth

RE: 答复: A node down every day in a 6 nodes cluster

David, Can you replace the misbehaving node to see if that resolves the problem? Kenneth Brotman From: Xiangfei Ni [mailto:xiangfei...@cm-dt.com] Sent: Tuesday, March 27, 2018 3:27 AM To: Jeff Jirsa Cc: user@cassandra.apache.org Subject: 答复: 答复: A node down every day in a 6 nodes

答复: 答复: A node down every day in a 6 nodes cluster

Thanks Jeff, So your suggestion is to first resolve the data model issue which cause wide partition,right? Best Regards, 倪项菲/ David Ni 中移德电网络科技有限公司 Virtue Intelligent Network Ltd, co. Add: 2003,20F No.35 Luojia creative city,Luoyu Road,Wuhan,HuBei Mob: +86 13797007811|Tel: + 86 27

答复: 答复: A node down every day in a 6 nodes cluster

Hi Jeff, This is very strange that the table info that the max partition is 129557750(123M): [cid:image001.png@01D3C5E0.0A9F8910] But why the index max partition is nearly 2G, Table (index): rt_ac_stat.idx_rt_ac_stat_prot_verrt_ac_stat.idx_rt_ac_stat_prot_ver