Re: Is Table created in all the nodes if the default consistency level used

2015-03-16 Thread Saladi Naidu
There are 3 different things we are talking here 1. SimpleStrategy vs. NetworkTopology matter when you have single DC vs. Multiple DC's2. In both cases you can specific replication factor, obviously in SimpleStratgey case you dont mention DC whereas in NetworkTopology, you can mentione mutiple

Re: nodetool help

2015-03-16 Thread Ali Akhtar
Yes, absolutely. I thought he was looking for an install.sh type of script. I did say a fresh server ;) On Tue, Mar 17, 2015 at 1:52 AM, Jonathan Haddad j...@jonhaddad.com wrote: Be careful w/ that script if you're looking to upgrade, it nukes your data directory. sudo rm -rf

Run Mixed Workload using two instances on one node

2015-03-16 Thread Anuj Wadehra
Hi, We are trying to Decouple our Reporting DB from OLTP. Need urgent help on the feasibility of proposed solution for PRODUCTION. Use Case: Currently, our OLTP and Reporting application and DB are same. Some CF are used for both OLTP and Reporting while others are solely used for

Re: Deleted snapshot files filling up /var/lib/cassandra

2015-03-16 Thread Ben Bromhead
If you are running a sequential repair (or have previously run a sequential repair that is still running) Cassandra will still have the file descriptors open for files in the snapshot it is using for the repair operation. From the http://www.datastax.com/dev/blog/repair-in-cassandra *Cassandra

Re: [RELEASE] Apache Cassandra 2.0.13 released

2015-03-16 Thread jean paul
Hello, Please, i have a cluster of 10 nodes, so i have to download the last version of cassandra and install it on each node, that's it ? Thanks a lot. Best Regards. 2015-03-16 16:39 GMT+01:00 Jake Luciani j...@apache.org: Apache Cassandra is a fully distributed database. It is the right

Re: [RELEASE] Apache Cassandra 2.0.13 released

2015-03-16 Thread Michael Shuler
2.0.13 is the latest release in the 2.0 branch. There is also the 2.1 branch, which is currently at 2.1.3, and 2.1.4 is under development. This is all listed on http://cassandra.apache.org/download/ and this question may be best suited for the user mailing list :) -- Michael On 03/16/2015

[RELEASE] Apache Cassandra 2.0.13 released

2015-03-16 Thread Jake Luciani
Apache Cassandra is a fully distributed database. It is the right choice when you need scalability and high availability without compromising performance. http://cassandra.apache.org/ Downloads of source and binary distributions are listed in our download section:

Re: Is Table created in all the nodes if the default consistency level used

2015-03-16 Thread Eric Stevens
Cassandra is used in a message process system. The table will be created at a fixed time each day. Make sure you're keeping the total number of tables which exist at any given time to a reasonable limit. There is a fixed memory cost for each table, and if you have too many tables you will

Re: [RELEASE] Apache Cassandra 2.0.13 released

2015-03-16 Thread jean paul
OK. I have tens of nodes in my cluster. i'd like to get the states of these nodes(alive, not etc ..). (it is just a first step to test cassandra) So, i have downloaded the latest release. *First terminal: * ../apache-cassandra-2.1.3/bin$ ./cassandra -f . INFO 17:16:54 Starting

Re: [RELEASE] Apache Cassandra 2.0.13 released

2015-03-16 Thread Redmumba
You should probably make a new thread for this. This is an announcement for a new Cassandra release. On Mon, Mar 16, 2015 at 10:34 AM, jean paul researche...@gmail.com wrote: OK. I have tens of nodes in my cluster. i'd like to get the states of these nodes(alive, not etc ..). (it is just a

Re: Run Mixed Workload using two instances on one node

2015-03-16 Thread Ali Akhtar
I don't think its recommended to have two instances on the same node. Have you considered using something like elasticsearch for the reports? Its designed for that sort of thing. On Mar 17, 2015 8:07 AM, Anuj Wadehra anujw_2...@yahoo.co.in wrote: Hi, We are trying to Decouple our Reporting

Re: Is Table created in all the nodes if the default consistency level used

2015-03-16 Thread daemeon reiydelle
If I am following your thread correctly, I think you might be confusing the creeation of a table with the recording of the definition + storage for the table allocated. When you define the table, based on your config, the existence of the table is recorded in the master node(s). But tables are

Re: Run Mixed Workload using two instances on one node

2015-03-16 Thread Anuj Wadehra
I understand that 2 instances on one node looks a weird solution. But can have dedicated reporting nodes for big customers but not for small customers. My questions would be:1. What is the technical reasoning? What problems you foresee  if we use 2 C* instances on one node in production? We

Deleted snapshot files filling up /var/lib/cassandra

2015-03-16 Thread David Wahler
We have a 16-node, globally-distributed cluster. running Cassandra 2.0.12. We're using the Datastax packages on CentOS 6.5. Even though the total amount of data on each server is only a few hundred MB (as measured by both du and the load metric), we're seeing a problem where the disk usage is

Re: Deleted snapshot files filling up /var/lib/cassandra

2015-03-16 Thread David Wahler
On Mon, Mar 16, 2015 at 5:28 PM, Jan cne...@yahoo.com wrote: David; all the packaged installations use the /var/lib/cassandra directory. Could you check your yaml config files and see if you are using this default directory for backups May want to change it to a location with more disk

Re: Begginer with cassandra Apache - Gossip

2015-03-16 Thread Akhil Mehra
Hi Jean, I see you are getting a lot of help on other threads. Can you please elaborate a bit more on the problem you are trying to solve. Would nodetool status help (http://www.datastax.com/documentation/cassandra/2.0/cassandra/tools/toolsStatus.html

Re: nodetool help

2015-03-16 Thread Jonathan Haddad
Be careful w/ that script if you're looking to upgrade, it nukes your data directory. sudo rm -rf /var/lib/cassandra/data/system/* On Mon, Mar 16, 2015 at 1:41 PM, Ali Akhtar ali.rac...@gmail.com wrote: https://gist.github.com/aliakhtar/3649e412787034156cbb Best run from a fresh ubuntu

Re: Deleted snapshot files filling up /var/lib/cassandra

2015-03-16 Thread Ben Bromhead
Cassandra will by default snapshot your data directory on the following events: - TRUNCATE and DROP schema events - when you run nodetool repair - when you run nodetool snapshot Snapshots are just hardlinks to existing SSTables so the only disk space they take up is for files that have

Re: Deleted snapshot files filling up /var/lib/cassandra

2015-03-16 Thread David Wahler
On Mon, Mar 16, 2015 at 6:12 PM, Ben Bromhead b...@instaclustr.com wrote: Cassandra will by default snapshot your data directory on the following events: TRUNCATE and DROP schema events when you run nodetool repair when you run nodetool snapshot Snapshots are just hardlinks to existing

Re: nodetool help

2015-03-16 Thread Ali Akhtar
https://gist.github.com/aliakhtar/3649e412787034156cbb Best run from a fresh ubuntu server. On Tue, Mar 17, 2015 at 12:50 AM, jean paul researche...@gmail.com wrote: i find this solution:

Re: DataStax Enterprise Amazon AMI Launch Error

2015-03-16 Thread Vanessa Gligor
I have used m3.medium and m3.large On Sat, Mar 14, 2015 at 2:36 AM, Patrick McFadin pmcfa...@gmail.com wrote: What size of instance are you using? It looks like you aren't at to get resources set up in time. On Thursday, March 12, 2015, Vanessa Gligor vanessagli...@gmail.com wrote: When

Re: Is Table created in all the nodes if the default consistency level used

2015-03-16 Thread daemeon reiydelle
If you want to guarantee that the data is written to all nodes before the code returns, then yes you have to use consistency all. Otherwise there is a small risk of outdated data being served if a node goes offline longer than hints timeouts. Somewhat looser options that can assure multiple

Re: Is Table created in all the nodes if the default consistency level used

2015-03-16 Thread 鄢来琼
Cassandra is used in a message process system. The table will be created at a fixed time each day. We want the table can be created before the message arrived. So I want to guarantee table is created in all the nodes. Peter 发件人: 鄢来琼 发送时间: 2015年3月16日 15:14 收件人: user@cassandra.apache.org 主题: Re:

Re: Is Table created in all the nodes if the default consistency level used

2015-03-16 Thread 鄢来琼
Hi Daemeon, Yes, I use “NetworkTopologyStrategy” strategy for “Table_test”, but “System keyspace” is Cassandra internal keyspace, its strategy is localStrategy. So my question is how to guarantee “Table_test” is created in all the nodes before any R/W opertions? Thanks. Peter 发件人: daemeon

Writing to multiple tables

2015-03-16 Thread Viswanathan Ramachandran
Hi, Are Cassandra Batch statements http://www.datastax.com/documentation/cql/3.1/cql/cql_reference/batch_r.html the recommended way for updating same information in multiple tables? For example if I have the following tables: person_by_dob person_by_ssn person_by_lastname Then

Re: nodetool help

2015-03-16 Thread jean paul
./nodetool help gossipinfo NAME nodetool gossipinfo - Shows the gossip information for the cluster SYNOPSIS nodetool [(-h host | --host host)] [(-p port | --port port)] [(-pw password | --password password)] [(-pwf passwordFilePath | --password-file

Re: [RELEASE] Apache Cassandra 2.0.13 released

2015-03-16 Thread jean paul
i restart the system and it displays: INFO 17:16:54 Starting listening for CQL clients on localhost/127.0.0.1:9042... INFO 17:16:54 Binding thrift service to localhost/127.0.0.1:9160 INFO 17:16:54 Listening for thrift clients... !!! perharps i have to kill the process on the port 9160 when i

Re: nodetool help

2015-03-16 Thread jean paul
i can test './cqlsh' command but not with nodetool ! /Bureau/apache-cassandra-2.0.13/bin# ./cqlsh Connected to Test Cluster at localhost:9160. [cqlsh 4.1.1 | Cassandra 2.0.13 | CQL spec 3.1.1 | Thrift protocol 19.39.0] Use HELP for help. cqlsh cqlsh cqlsh exit /Bureau/apache-cassandra-2.0.13/bin#

Re: Begginer with cassandra Apache - Gossip

2015-03-16 Thread jean paul
Hello :) Thanks a lot for you help :) Please, i have another question about gossip and failure detection. i'd like to test step by step all components in cassandra. i'd like to test first of all gossip protocol https://wiki.apache.org/cassandra/ArchitectureGossip and the failure detection I

Re: Writing to multiple tables

2015-03-16 Thread Robert Coli
On Mon, Mar 16, 2015 at 12:13 PM, Viswanathan Ramachandran vish.ramachand...@gmail.com wrote: Is BATCH the recommended way of updating all three tables at one go so that the information between the three tables is consistent ? As a general statement : If you are looking to update multiple

Re: Writing to multiple tables

2015-03-16 Thread DuyHai Doan
Is BATCH the recommended way of updating all three tables at one go so that the information between the three tables is consistent ? If you're thinking about atomicity, no it's not atomic. Indeed with logged batches, what you gain is automatic retry done for you by the coordinator in case of

Re: nodetool help

2015-03-16 Thread jean paul
i find this solution: http://www.liquidweb.com/kb/error-failed-to-connect-to-127-0-0-17199-connection-refused-cassandra-solved/ but i haven't this file at all !! /etc/cassandra/default.conf/cassandra-env.sh please, i have a dought about how to install cassandra.. i have only downloaded the