Re: Bootstraping a Node With a Newer Version

touching the data directory which is on a different vg? Shalom Sagges DBA T: +972-74-700-4035 <http://www.linkedin.com/company/164748> <http://twitter.com/liveperson> <http://www.facebook.com/LivePersonInc> We Create Meaningful Connections <https://liveperson.docsend.com/view/8

Re: sstablesplit - status

. Also, you can always play with the compaction threshold to suit your needs. Shalom Sagges DBA T: +972-74-700-4035 <http://www.linkedin.com/company/164748> <http://twitter.com/liveperson> <http://www.facebook.com/LivePersonInc> We Create Meaningful Connections <https://livepe

Re: Bootstraping a Node With a Newer Version

riendly) or perform the backup recommendations shown on the Centos page (which sounds extremely agonizing as well). What do you think? Thanks! Shalom Sagges DBA T: +972-74-700-4035 <http://www.linkedin.com/company/164748> <http://twitter.com/liveperson> <http://www.facebook.com/Li

Bootstraping a Node With a Newer Version

the server with the new kernel, can I first install the upgraded Cassandra version and then bootstrap it to the cluster? Since there's already no data on the node, I wish to skip the agonizing sstable upgrade process. Does anyone know if this is doable? Thanks! Shalom Sagges DBA T: +972-74-700-4035

Re: A Single Dropped Node Fails Entire Read Queries

Upgrading to 3.0.12 solved the issue. Thanks a lot for the help Joel! Shalom Sagges DBA T: +972-74-700-4035 <http://www.linkedin.com/company/164748> <http://twitter.com/liveperson> <http://www.facebook.com/LivePersonInc> We Create Meaningful Connections <https://livepe

Re: A Single Dropped Node Fails Entire Read Queries

Thanks a lot Joel! I'll go ahead and upgrade. Thanks again! Shalom Sagges DBA T: +972-74-700-4035 <http://www.linkedin.com/company/164748> <http://twitter.com/liveperson> <http://www.facebook.com/LivePersonInc> We Create Meaningful Connections <https://liveperson.doc

Re: A Single Dropped Node Fails Entire Read Queries

ed. Could this be a bug in 3.0.9? Or some sort of misconfiguration I missed? Thanks! Shalom Sagges DBA T: +972-74-700-4035 <http://www.linkedin.com/company/164748> <http://twitter.com/liveperson> <http://www.facebook.com/LivePersonInc> We Create Meaningful Connections <http

Re: A Single Dropped Node Fails Entire Read Queries

Hi Michael, If a node suddenly fails, and there are other replicas that can still satisfy the consistency level, shouldn't the request succeed regardless of the failed node? Thanks! Shalom Sagges DBA T: +972-74-700-4035 <http://www.linkedin.com/company/164748> <http://twitter.com/l

Re: A Single Dropped Node Fails Entire Read Queries

Hi daniel, I don't think that's a network issue, because ~10 seconds after the node stopped, the queries were successful again without any timeout issues. Thanks! Shalom Sagges DBA T: +972-74-700-4035 <http://www.linkedin.com/company/164748> <http://twitter.com/livepers

Re: A Single Dropped Node Fails Entire Read Queries

or of 3 you can loose one node and still satisfy the > query. > Ryan Svihla <r...@foundev.pro> schrieb am Do. 9. März 2017 um 18:09: > >> whats your keyspace replication settings and what's your query? >> >> On Thu, Mar 9, 2017 at 9:32 AM, Shalom Sagges <shal..

A Single Dropped Node Fails Entire Read Queries

Hi Cassandra Users, I hope someone could help me understand the following scenario: Version: 3.0.9 3 nodes per DC 3 DCs in the cluster. Consistency Local_Quorum. I did a small resiliency test and dropped a node to check the availability of the data. What I assumed would happen is nothing at

Re: RemoveNode CPU Spike Question

slowly enabled autocompaction (a few minutes between each enable) on the nodes one by one. This helped with the CPU increase you've mentioned. Shalom Sagges DBA T: +972-74-700-4035 <http://www.linkedin.com/company/164748> <http://twitter.com/liveperson> <http://www.facebook.com/Li

Re: WriteTimeoutException When only One Node is Down

? Or is there something I'm missing... Thanks! Shalom Sagges DBA T: +972-74-700-4035 <http://www.linkedin.com/company/164748> <http://twitter.com/liveperson> <http://www.facebook.com/LivePersonInc> We Create Meaningful Connections <https://liveperson.docsend.com/view/8iiswfp> On Fri, Jan 1

WriteTimeoutException When only One Node is Down

Any ideas? I'm quite at a loss here. Thanks! Shalom Sagges DBA T: +972-74-700-4035 <http://www.linkedin.com/company/164748> <http://twitter.com/liveperson> <http://www.facebook.com/LivePersonInc> We Create Meaningful Connections -- This message may contain confidential a

Re: Openstack and Cassandra

Thanks for the info Romain, Can you tell me please what are the implications of not using CPU Pinning? Shalom Sagges DBA T: +972-74-700-4035 <http://www.linkedin.com/company/164748> <http://twitter.com/liveperson> <http://www.facebook.com/LivePersonInc> We Create Meaningful

Re: Openstack and Cassandra

;-) ) Regarding Trove, I doubt we'll use it in Production any time soon. Thanks again! Shalom Sagges DBA T: +972-74-700-4035 <http://www.linkedin.com/company/164748> <http://twitter.com/liveperson> <http://www.facebook.com/LivePersonInc> We Create Meaningful

Re: Openstack and Cassandra

Thanks for the info Aaron! I will test it in hope there will be no issues. If no issues will occur, this could actually be a good idea and would save a lot of resources. Have a great day! Shalom Sagges DBA T: +972-74-700-4035 <http://www.linkedin.com/company/164748> <http://tw

Re: Openstack and Cassandra

Thanks Vladimir! I guess I'll just have to deploy and continue from there. Shalom Sagges DBA T: +972-74-700-4035 <http://www.linkedin.com/company/164748> <http://twitter.com/liveperson> <http://www.facebook.com/LivePersonInc> We Create Meaningful Connections <https://l

Openstack and Cassandra

machine that divide their capacity to various instances (not only Cassandra), will this affect performance, especially when the commitlog directory will probably reside with the data directory? I'm at a loss here and don't have any answers for that matter. Can anyone assist please? Thanks! Shalom

Re: About Tombstones and TTLs

Thanks a lot Alain!! This really cleared a lot of things for me. Thanks again! Shalom Sagges DBA T: +972-74-700-4035 <http://www.linkedin.com/company/164748> <http://twitter.com/liveperson> <http://www.facebook.com/LivePersonInc> We Create Meaningful Connections On Mon,

Re: About Tombstones and TTLs

, but use updates as well, do I need gc_grace_seconds to be bigger than 0? Thanks! Shalom Sagges DBA T: +972-74-700-4035 <http://www.linkedin.com/company/164748> <http://twitter.com/liveperson> <http://www.facebook.com/LivePersonInc> We Create Meaningful Connections On Mon,

About Tombstones and TTLs

ce_seconds to be bigger than 0? Sorry for all those questions, I'm just really confused from all the TTL/tombstones subject (still a newbie). Thanks a lot! Shalom Sagges DBA T: +972-74-700-4035 <http://www.linkedin.com/company/164748> <http://twitter.com/liveperson> <http://www.faceb

Imprecise Repair

17 but saw it was fixed on 2.0.9. The version I'm using is 2.0.14. Any ideas? Thanks! Shalom Sagges DBA T: +972-74-700-4035 <http://www.linkedin.com/company/164748> <http://twitter.com/liveperson> <http://www.facebook.com/LivePersonInc> We Create Meaningful Connections <https://e

Re: Cassandra 2.x Stability

Thanks a lot Kai! Shalom Sagges DBA T: +972-74-700-4035 <http://www.linkedin.com/company/164748> <http://twitter.com/liveperson> <http://www.facebook.com/LivePersonInc> We Create Meaningful Connections <https://engage.liveperson.com/idc-mobile-first-consumer/?ut

Re: Cassandra 2.x Stability

Hey Kai, Thanks for the info. Can you please elaborate on the reasons you'd pick 2.2.6 over 3.0? Shalom Sagges DBA T: +972-74-700-4035 <http://www.linkedin.com/company/164748> <http://twitter.com/liveperson> <http://www.facebook.com/LivePersonInc> We Create Meaningful

Cassandra 2.x Stability

the storage modifications (please correct me if I'm wrong). So my question is, if I need a 2.x version (can't upgrade to 3 due to client considerations), which one should I choose, 2.1.x or 2.2.x? (I'm don't require any new features available in 2.2). Thanks! Shalom Sagges DBA T: +972-74-700-4035 <h

Re: Cassandra Upgrade

Thanks for the info Kurt, I guess I'd go with the normal upgrade procedure then. Thanks again for the help everyone. Shalom Sagges DBA T: +972-74-700-4035 <http://www.linkedin.com/company/164748> <http://twitter.com/liveperson> <http://www.facebook.com/LivePersonInc> We

Re: Cassandra Upgrade

not install everything anew? By the way, if I do take the longer way and add a new 2.2.8 node to the cluster, do I still need to perform upgradesstables on the new node? Shalom Sagges DBA T: +972-74-700-4035 <http://www.linkedin.com/company/164748> <http://twitter.com/livepers

Cassandra Upgrade

. Is this possible? Thanks! Shalom Sagges DBA T: +972-74-700-4035 <http://www.linkedin.com/company/164748> <http://twitter.com/liveperson> <http://www.facebook.com/LivePersonInc> We Create Meaningful Connections <https://engage.liveperson.com/idc-mobile-first-consumer/?ut

Max Capacity per Node

Hi Everyone, I have a 24 node cluster (12 in each DC) with a capacity of 3.3 TB per node for the data directory. I'd like to increase the capacity per node. Can anyone tell what is the maximum recommended capacity a node can use? The disks we use are HDD, not SSD. Thanks! Shalom Sagges DBA T

Re: OperationTimedOutException (NoHostAvailableException)

Do you get this error on specific column families or on all of the environment? Shalom Sagges DBA T: +972-74-700-4035 <http://www.linkedin.com/company/164748> <http://twitter.com/liveperson> <http://www.facebook.com/LivePersonInc> We Create Meaningful Connections <https://

Re: How to Choose a Version for Upgrade

Thanks Vladimir! Shalom Sagges DBA T: +972-74-700-4035 <http://www.linkedin.com/company/164748> <http://twitter.com/liveperson> <http://www.facebook.com/LivePersonInc> We Create Meaningful Connections <https://engage.liveperson.com/idc-mobile-first-consumer/?utm_medium=email

How to Choose a Version for Upgrade

Hi Everyone, I was wondering how to choose the proper, most stable Cassandra version for a Production environment. Should I follow the version that's used in Datastax Enterprise (in this case 3.0.10) or is there a better way of figuring this out? Thanks! Shalom Sagges DBA T: +972-74-700-4035

Re: data not replicated on new node

. https://docs.datastax.com/en/upgrade/doc/upgrade/cassandra/upgrdCassandra.html Hope this helps. Shalom Sagges DBA T: +972-74-700-4035 <http://www.linkedin.com/company/164748> <http://twitter.com/liveperson> <http://www.facebook.com/LivePersonInc> We Create Meaningful

Re: data not replicated on new node

I believe the logs should show you what the issue is. Also, can the node "talk" with the others? (i.e. telnet to the other nodes on port 7000). Shalom Sagges DBA T: +972-74-700-4035 <http://www.linkedin.com/company/164748> <http://twitter.com/liveperson> <http://www.f

Re: Is Centos 7 Supported for Version 3.0

Thanks Vladimir! Shalom Sagges DBA T: +972-74-700-4035 <http://www.linkedin.com/company/164748> <http://twitter.com/liveperson> <http://www.facebook.com/LivePersonInc> We Create Meaningful Connections <https://engage.liveperson.com/idc-mobile-first-consumer/?utm_medium=email

Is Centos 7 Supported for Version 3.0

Hi Guys, A simple question for which I couldn't find an answer in the docs. Is Centos 7 supported on DataStax Community Edition v3.0.9? Thanks! Shalom Sagges DBA T: +972-74-700-4035 <http://www.linkedin.com/company/164748> <http://twitter.com/liveperson> <http://www.facebook.co

WriteTimeoutExceptions from Storm Topology

onses.java:58) at com.datastax.driver.core.Responses$Error$1.decode(Responses.java:38) at com.datastax.driver.core.Message$ProtocolDecoder.decode(Message.java:168) at org.jboss.netty.handler.codec.oneone.OneToOneDecoder.handleUpstream(OneToOneDecoder.java:66) ... 21 more Shalom Sagg

Re: Some questions to updating and tombstone

Hi Fabrice, Just a small (out of the topic) question I couldn't find an answer to. What is a slice in Cassandra? (e.g. Maximum tombstones per slice) Thanks! Shalom Sagges DBA T: +972-74-700-4035 <http://www.linkedin.com/company/164748> <http://twitter.com/liveperson> <http://w

Re: Can a Select Count(*) Affect Writes in Cassandra?

the query in the code, thought it would be nice to limit the query results to 560,000,000. Perhaps the ridiculously high limit might have caused this? Thanks! Shalom Sagges DBA T: +972-74-700-4035 <http://www.linkedin.com/company/164748> <http://twitter.com/liveperson> <http://www.f

Re: Can a Select Count(*) Affect Writes in Cassandra?

Yes, I know it's obsolete, but unfortunately this takes time. We're in the process of upgrading to 2.2.8 and 3.0.9 in our clusters. Thanks! Shalom Sagges DBA T: +972-74-700-4035 <http://www.linkedin.com/company/164748> <http://twitter.com/liveperson> <http://www.facebook.com/Li

Re: Can a Select Count(*) Affect Writes in Cassandra?

Thanks for the quick reply Vladimir. Is it really possible that ~12,500 writes per second (per node in a 12 nodes DC) are caused by memory flushes? Shalom Sagges DBA T: +972-74-700-4035 <http://www.linkedin.com/company/164748> <http://twitter.com/liveperson> <http://w

Can a Select Count(*) Affect Writes in Cassandra?

particular table. Can anyone explain this behavior? Why would a Select query significantly increase write count in Cassandra? Thanks! Shalom Sagges <http://www.linkedin.com/company/164748> <http://twitter.com/liveperson> <http://www.facebook.com/LivePersonInc> We Create M

<    1   2