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

Hi Daemeon, Thanks for your response. Yes, exactly, your answer clear my doubt. My question is time of table created on data nodes. According to your answer, the table’s meta data is recorded on master node(s), then table will be created on data node(s) when R/W operation is executed. So there

Re: Run Mixed Workload using two instances on one node

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 hav

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

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 a

Re: Run Mixed Workload using two instances on one node

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" wrote: > > > Hi, > > We are trying to Decouple our Reporting DB from OLTP. Ne

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

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 o

Run Mixed Workload using two instances on one node

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 Reporting

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

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 1

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

On Mon, Mar 16, 2015 at 6:12 PM, Ben Bromhead 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 SSTables so the

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

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 s

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

On Mon, Mar 16, 2015 at 5:28 PM, Jan 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 space. We're

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

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 space.  hope this helpsJan/  On Monday, March 16, 2015 2:5

Deleted snapshot files filling up /var/lib/cassandra

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 st

Re: nodetool help

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 wrote: > Be careful w/ that script if you're looking to upgrade, it nukes your data > directory. > > sudo rm -rf /var/lib/cassandra/data/system

Re: nodetool help

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 wrote: > https://gist.github.com/aliakhtar/3649e412787034156cbb > > Best run from a fresh ubuntu server. > > On Tue, Mar

Re: Begginer with cassandra Apache - Gossip

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

https://gist.github.com/aliakhtar/3649e412787034156cbb Best run from a fresh ubuntu server. On Tue, Mar 17, 2015 at 12:50 AM, jean paul wrote: > 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

Re: nodetool help

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 paquet

Re: Writing to multiple tables

"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: Writing to multiple tables

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 multip

Writing to multiple tables

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 addition/modifi

Re: nodetool help

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/bi

Re: [RELEASE] Apache Cassandra 2.0.13 released

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

Re: nodetool help

./nodetool help gossipinfo NAME nodetool gossipinfo - Shows the gossip information for the cluster SYNOPSIS nodetool [(-h | --host )] [(-p | --port )] [(-pw | --password )] [(-pwf | --password-file )] [(-u | --username )] gossipi

Quorum issues during rolling upgrade

We are upgrading from DSE 3.2 (C*1.2) to 4.5(C*2.0.11) in 6 node cluster with replication factor =3. App uses CL quorum. Testing the rolling upgrade in 6 node cluster by upgrading one node at a time. During the upgrade, we have test script that is tyring to simulate prod load to write/read data w

Re: [RELEASE] Apache Cassandra 2.0.13 released

I have done the same test again but i have errors with the two versions 2.1.3 and 2.0.13 :~/Bureau/apache-cassandra-*2.1.3*/bin$ ./cassandra -f CompilerOracle: inline org/apache/cassandra/db/AbstractNativeCell.compareTo (Lorg/apache/cassandra/db/composites/Composite;)I CompilerOracle: inline org/a

Re: nodetool help

(bounced as a new message) On 03/16/2015 12:34 PM, jean paul wrote: > ./nodetool gossipinfo -h localhost -p 9042 > nodetool: Found unexpected parameters: [-h, localhost] > See 'nodetool help' or 'nodetool help '. > > Have you an idea please about the last message ? Did you follow the suggestion

Re: [RELEASE] Apache Cassandra 2.0.13 released

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 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 first step to test ca

Re: [RELEASE] Apache Cassandra 2.0.13 released

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 liste

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

> 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 pr

Re: [RELEASE] Apache Cassandra 2.0.13 released

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 11

Re: [RELEASE] Apache Cassandra 2.0.13 released

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 : > Apache Cassandra is a fully distributed database. It is the right choice > when you

[RELEASE] Apache Cassandra 2.0.13 released

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: http://cassandra.apache.org/d

Re: Begginer with cassandra Apache - Gossip

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 have

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

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: Is

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

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 re