Cassandra add a node and remove a node

2014-11-30 Thread Neha Trivedi
Hi, I need to Add new Node and remove existing node. Should I first remove the node and then add a new node or Add new node and then remove existing node. Which practice is better and things I need to take care? regards Neha

Re: Cassandra add a node and remove a node

2014-12-01 Thread Neha Trivedi
No the old node is not defective. We Just want to separate out that Server for testing. And add a new node. (Present cluster has two Nodes and RF=2) thanks On Tue, Dec 2, 2014 at 12:04 AM, Robert Coli rc...@eventbrite.com wrote: On Sun, Nov 30, 2014 at 10:15 PM, Neha Trivedi nehajtriv

Re: Cassandra add a node and remove a node

2014-12-02 Thread Neha Trivedi
Thanks Jens and Robert !!! On Wed, Dec 3, 2014 at 2:20 AM, Robert Coli rc...@eventbrite.com wrote: On Mon, Dec 1, 2014 at 7:10 PM, Neha Trivedi nehajtriv...@gmail.com wrote: No the old node is not defective. We Just want to separate out that Server for testing. And add a new node. (Present

Cassandra Maintenance Best practices

2014-12-09 Thread Neha Trivedi
Hi, We have Two Node Cluster Configuration in production with RF=2. Which means that the data is written in both the clusters and it's running for about a month now and has good amount of data. Questions? 1. What are the best practices for maintenance? 2. Is OPScenter required to be installed or

Re: Cassandra Maintenance Best practices

2014-12-15 Thread Neha Trivedi
at 7:19:32 PM Neha Trivedi nehajtriv...@gmail.com wrote: Hi, We have Two Node Cluster Configuration in production with RF=2. Which means that the data is written in both the clusters and it's running for about a month now and has good amount of data. Questions? 1. What are the best

Re: Cassandra Maintenance Best practices

2014-12-16 Thread Neha Trivedi
recommend at least RF=3 because if you lose 1 server, you're on the edge of data loss. On Tue Dec 09 2014 at 7:19:32 PM Neha Trivedi nehajtriv...@gmail.com wrote: Hi, We have Two Node Cluster Configuration in production with RF=2. Which means that the data is written in both the clusters

Re: Cassandra Maintenance Best practices

2014-12-16 Thread Neha Trivedi
of the time under server stress, so in practice that reduced consistency is the effective consistency I'm asking for from my writes and reads. On Tue, Dec 16, 2014 at 10:50 AM, Neha Trivedi nehajtriv...@gmail.com wrote: Hi Jonathan,QUORUM = (sum_of_replication_factors / 2) + 1, For us

Re: Cassandra Maintenance Best practices

2014-12-16 Thread Neha Trivedi
existing nodes to a lower number like 50 or 25. On Tue, Dec 16, 2014 at 11:10 AM, Neha Trivedi nehajtriv...@gmail.com wrote: Thanks Ryan. So, as Jonathan recommended, we should have RF=3 with Three nodes. So Quorum = 2 so, CL= 2 (or I need the CL to be set to two) and I will not need

Re: Stable cassandra build for production usage

2015-01-01 Thread Neha Trivedi
Use 2.0.11 for production On Wed, Dec 31, 2014 at 11:50 PM, Robert Coli rc...@eventbrite.com wrote: On Wed, Dec 31, 2014 at 8:38 AM, Ajay ajay.ga...@gmail.com wrote: For my research and learning I am using Cassandra 2.1.2. But I see couple of mail threads going on issues in 2.1.2. So what is

Fwd: ReadTimeoutException in Cassandra 2.0.11

2015-01-21 Thread Neha Trivedi
Hello All, I am trying to process 200MB file. I am getting following Error. We are using (apache-cassandra-2.0.3.jar) com.datastax.driver.core. exceptions.ReadTimeoutException: Cassandra timeout during read query at consistency ONE (1 responses were required but only 0 replica responded) 1. Is it

Re: Fwd: ReadTimeoutException in Cassandra 2.0.11

2015-01-22 Thread Neha Trivedi
Hello Everyone, Thanks very much for the input. Here is my System info. 1. I have single node cluster. (For testing) 2. I have 4GB Memory on the Server and trying to process 200B. ( 1GB is allocated to Tomcat7, 1 GB to Cassandra and 1 GB to ActiveMQ. Also nltk Server is running) 3. We are using

Re: Fwd: ReadTimeoutException in Cassandra 2.0.11

2015-01-23 Thread Neha Trivedi
enough memory that virtual memory on the host becomes a factor. There's a lot of good information on both the Apache Cassandra site and on Planet Cassandra about performance and tuning if you want to know more. Hope that helps, Steve On Thu, Jan 22, 2015 at 7:28 PM, Neha Trivedi nehajtriv

Re: Cassandra nodes in VirtualBox

2015-01-05 Thread Neha Trivedi
Hi Ajay, 1. you should have at least 2 Seed nodes as it will help, Node1 (only one seed node) is down. 2. Check you should be using internal ip address in listen_address and rpc_address. On Mon, Jan 5, 2015 at 2:07 PM, Ajay ajay.ga...@gmail.com wrote: Hi, I did the Cassandra cluster set up

Re: COPY command to export a table to CSV file

2015-04-20 Thread Neha Trivedi
technology and transactional backbone of choice for the worlds most innovative companies such as Netflix, Adobe, Intuit, and eBay. On Mon, Apr 20, 2015 at 12:31 PM, Neha Trivedi nehajtriv...@gmail.com wrote: Does the nproc,nofile,memlock settings in /etc/security/limits.d/cassandra.conf are set

Re: COPY command to export a table to CSV file

2015-04-20 Thread Neha Trivedi
in /etc/security/limits.d/cassandra.conf are set to optimum value ? What is the consistency level ? Best Regardds, Kiran.M.K. On Mon, Apr 20, 2015 at 11:55 AM, Neha Trivedi nehajtriv...@gmail.com wrote: hi, What is the count of records in the column-family ? We have about 38,000

Re: COPY command to export a table to CSV file

2015-04-20 Thread Neha Trivedi
...@gmail.com wrote: Hi, Thanks for the info, Does the nproc,nofile,memlock settings in /etc/security/limits.d/cassandra.conf are set to optimum value ? What is the consistency level ? Best Regardds, Kiran.M.K. On Mon, Apr 20, 2015 at 11:55 AM, Neha Trivedi nehajtriv...@gmail.com wrote: hi

COPY command to export a table to CSV file

2015-04-19 Thread Neha Trivedi
Hello all, We are getting the OutOfMemoryError on one of the Node and the Node is down, when we run the export command to get all the data from a table. Regards Neha ERROR [ReadStage:532074] 2015-04-09 01:04:00,603 CassandraDaemon.java (line 199) Exception in thread

Re: COPY command to export a table to CSV file

2015-04-20 Thread Neha Trivedi
coolkiran2...@gmail.com wrote: Seems like the is related to JAVA HEAP Memory. What is the count of records in the column-family ? What is the Cassandra Version ? Best Regards, Kiran.M.K. On Mon, Apr 20, 2015 at 11:08 AM, Neha Trivedi nehajtriv...@gmail.com wrote: Hello all, We

Re: Best Practice to add a node in a Cluster

2015-04-28 Thread Neha Trivedi
for which they are no longer responsible). The data responsibility hasn't changed for any node, all nodes are still responsible for all data. On Mon, Apr 27, 2015 at 9:19 PM, Neha Trivedi nehajtriv...@gmail.com wrote: Thans Arun ! On Tue, Apr 28, 2015 at 9:44 AM, arun sirimalla arunsi

Data Modeling for 2.1 Cassandra

2015-04-30 Thread Neha Trivedi
Helle all, I was wondering which data model of the Three describe below better in terms of performance. Seems 3 is good. *#1. log with 3 Index* CREATE TABLE log ( id int PRIMARY KEY, first_name settext, last_name settext, dob set text ); CREATE INDEX

Re: Best Practice to add a node in a Cluster

2015-04-27 Thread Neha Trivedi
replication factor because of this characteristic. Make sure your new node is not in its own seeds list, or it will not bootstrap (it will come online immediately and start serving requests). On Mon, Apr 27, 2015 at 8:46 AM, Neha Trivedi nehajtriv...@gmail.com wrote: Hi We have a 2 Cluster

Re: Best Practice to add a node in a Cluster

2015-04-27 Thread Neha Trivedi
repair is an expensive process (Utilizes high CPU). On Mon, Apr 27, 2015 at 8:36 PM, Neha Trivedi nehajtriv...@gmail.com wrote: Thanks Eric and Matt :) !! Yes the purpose is to improve reliability. Right now, from our driver we are querying using degradePolicy for reliability

Best Practice to add a node in a Cluster

2015-04-27 Thread Neha Trivedi
Hi We have a 2 Cluster Node with RF=2. We are planing to add a new node. Should we change RF to 3 in the schema? OR Just added a new node with the same RF=2? Any other Best Practice that we need to take care? Thanks regards Neha

Re: Error while adding a new node.

2015-07-01 Thread Neha Trivedi
? On Wed, Jul 1, 2015 at 8:08 PM, Neha Trivedi nehajtriv...@gmail.com wrote: Hey.. nodetool compactionstats pending tasks: 0 no pending tasks. Dont have opscenter. how do I monitor sstables? On Wed, Jul 1, 2015 at 4:28 PM, Alain RODRIGUEZ arodr...@gmail.com wrote: You also might want

Re: Error while adding a new node.

2015-07-01 Thread Neha Trivedi
). Also you can monitor the number of sstables. C*heers Alain 2015-07-01 11:53 GMT+02:00 Neha Trivedi nehajtriv...@gmail.com: Thanks I will checkout. I increased the ulimit to 10, but I am getting the same error, but after a while. regards Neha On Wed, Jul 1, 2015 at 2:22 PM, Alain

Re: Error while adding a new node.

2015-07-01 Thread Neha Trivedi
/cassandra/2.0/cassandra/install/installRecommendSettings.html#reference_ds_sxl_gf3_2k__user-resource-limits C*heers, Alain 2015-07-01 7:33 GMT+02:00 Neha Trivedi nehajtriv...@gmail.com: Arun, I am logging on to Server as root and running (sudo service cassandra start) regards Neha On Wed

Re: Error while adding a new node.

2015-06-30 Thread Neha Trivedi
. On Jun 30, 2015, at 21:16, Neha Trivedi nehajtriv...@gmail.com wrote: Hello, I have a 4 node cluster with SimpleSnitch. Cassandra : Cassandra 2.1.3 I am trying to add a new node (cassandra 2.1.7) and I get the following error. ERROR [STREAM-IN-] 2015-06-30 05:13:48,516

Re: Error while adding a new node.

2015-07-02 Thread Neha Trivedi
any help? On Thu, Jul 2, 2015 at 6:18 AM, Neha Trivedi nehajtriv...@gmail.com wrote: also: root@cas03:~# sudo service cassandra start root@cas03:~# lsof -n | grep java | wc -l 5315 root@cas03:~# lsof -n | grep java | wc -l 977317 root@cas03:~# lsof -n | grep java | wc -l 880240 root

Re: [MASSMAIL]Re: Error while adding a new node.

2015-07-02 Thread Neha Trivedi
@pythian | Twitter: cjrolo | Linkedin: *linkedin.com/in/carlosjuzarterolo http://linkedin.com/in/carlosjuzarterolo* Mobile: +31 6 159 61 814 | Tel: +1 613 565 8696 x1649 www.pythian.com On Thu, Jul 2, 2015 at 11:40 AM, Neha Trivedi nehajtriv...@gmail.com wrote: any help? On Thu, Jul 2

Error while adding a new node.

2015-06-30 Thread Neha Trivedi
Hello, I have a 4 node cluster with SimpleSnitch. Cassandra : Cassandra 2.1.3 I am trying to add a new node (cassandra 2.1.7) and I get the following error. ERROR [STREAM-IN-] 2015-06-30 05:13:48,516 JVMStabilityInspector.java:94 - JVM state determined to be unstable. Exiting forcefully due

Re: Error while adding a new node.

2015-06-30 Thread Neha Trivedi
Arun, I am logging on to Server as root and running (sudo service cassandra start) regards Neha On Wed, Jul 1, 2015 at 11:00 AM, Neha Trivedi nehajtriv...@gmail.com wrote: Thanks Arun ! I will try and get back ! On Wed, Jul 1, 2015 at 10:32 AM, Arun arunsi...@gmail.com wrote: Looks like

Re: Error while adding a new node.

2015-07-01 Thread Neha Trivedi
also: root@cas03:~# sudo service cassandra start root@cas03:~# lsof -n | grep java | wc -l 5315 root@cas03:~# lsof -n | grep java | wc -l 977317 root@cas03:~# lsof -n | grep java | wc -l 880240 root@cas03:~# lsof -n | grep java | wc -l 882402 On Wed, Jul 1, 2015 at 6:31 PM, Neha Trivedi

Re: Adding New Nodes/Data Center to an existing Cluster.

2015-08-31 Thread Neha Trivedi
Hi, Can you specify which version of Cassandra you are using? Can you provide the Error Stack ? regards Neha On Tue, Sep 1, 2015 at 2:56 AM, Sebastian Estevez < sebastian.este...@datastax.com> wrote: > or https://issues.apache.org/jira/browse/CASSANDRA-8611 perhaps > > All the best, > > >

Re: Adding New Nodes/Data Center to an existing Cluster.

2015-09-01 Thread Neha Trivedi
>>> Hi Sachin, >>> >>> You are speaking about a repair, when the proper command to do this is >>> "rebuild" ? >>> >>> Did you tried adding your DC this way: >>> http://docs.datastax.com/en/cassandra/2.1/cassandra/operations/ops_add_dc_to_clust