Re: Limit on having number of nodes in C* cluster

Probably decreasing tokens number can help to mange big cluster? Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Mon, 21 Aug 2017 19:38:37 -0400 Eduard Tudenhoefner eduard.tudenhoef...@datastax.com wrote We've been doing successful testing

Re: Limit on having number of nodes in C* cluster

Actually there are clusters of thousandths nodes: Some of the largest production deployments include Apple's, with over 75,000 nodes storing over 10 PB of data Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Mon, 21 Aug 2017 08:35:37 -0400 techpyaasa

SASI index returns no results

zero rows. Any thoughts? Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting

Re: Help in c* Data modelling

Hi, unfortunately ORDER BY is supported for clustering columns only... Winguzone - Cloud Cassandra Hosting On Sun, 23 Jul 2017 12:49:36 -0400 techpyaasa . techpya...@gmail.com wrote Hi Varun, Thanks a lot for your reply. In this case if I want to update

Re: secondary index use case

Hi, You didn't mention your C* version, but starting from 3.4 SASI indexes are available. You can try it with SPARSE option, as uuid corresponds to only one row. Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Thu, 20 Jul 2017 05:21:31 -0400 Micha mich

Re: Stable cassandra version with frozen UDTs

So according to what Michael wrote 3.11.x will be stable branch now. You can stick to it or revert to 3.0.x (latest is 3.0.14), if you don't need 3.x features. Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Mon, 26 Jun 2017 13:51:32 -0400 Ali Akhtar

Re: Stable cassandra version with frozen UDTs

Is that version going to be stable for production? Well, 1M$ question )). There is a lot of discussion on this topic. In terms of tick-tock releases odd releases (e.g. 3.11) are bug fixes. But I guess latest 3.0.x (3.0.14 now) should more stable. Best regards, Vladimir Yudovin, Winguzone

Re: Question: Behavior of inserting a list multiple times with same timestamp

be you should file JIRA about this. Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Tue, 20 Jun 2017 10:19:08 -0400 Thakrar, Jayesh jthak...@conversantmedia.com wrote Ok, tried the test again, w/o the TIMESTAMP, and got the expected behavior

Re: Stable cassandra version with frozen UDTs

Latest comment in this JIRA is "I've committed to 3.11". 3.11 change log also contains "* Fix validation of non-frozen UDT cells (CASSANDRA-12916)" (merged from 3.10) So try version 3.11 Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On

Re: Secondary Index

Hi, beyond scope of your question (as you use 2.1.17) but starting from v3.4 SASI is avaialble, doc is about DSE, but is applicable for free version as well. Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Mon, 19 Jun 2017 14:00:40 -0400 techpyaasa

Re: Count limit

Hi, Some body told because the count return 1 row result He is right Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Wed, 21 Jun 2017 02:43:32 -0400 web master socketman2...@gmail.com wrote According to http://www.maigfrga.ntweb.co/counting

Re: Pagination

Hi, can this https://docs.datastax.com/en/developer/java-driver/2.1/manual/paging/ help you? Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Wed, 21 Jun 2017 02:44:17 -0400 web master socketman2...@gmail.com wrote I am migrating from MySql

Re: Write / read cost of *QUORUM

Hi, yes, you are write. Actually write with QUORUM will cause to coordinator to wait for reply from other nodes, but I guess it's negligible. Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Sun, 18 Jun 2017 10:07:06 -0400 Jan Algermissen algermissen1

Re: Decommissioned nodes show as DOWN in Cassandra version 3.10

ml Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Mon, 12 Jun 2017 15:15:33 -0400 pabbireddy avinash pabbireddyavin...@gmail.com wrote Hi In the Cassandra version 3.10, after we decommission a node or datacenter, we observe the decommissioned no

Re: Data in multi disks is not evenly distributed

Hi, Do your disks have the same size? AFAK Cassandra distributes data with proportion to disk size, i.e. keeps the same percent of busy space. Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Wed, 07 Jun 2017 06:15:48 -0400 Xihui He xihu...@gmail.com

Re: certificate pinning feature

Hi, Cassandra uses standard Java API for SSL security, so in general Java options are available. Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Fri, 09 Jun 2017 10:13:27 -0400 Victor Ashik ash...@microsoft.com.INVALID wrote Hello

Re: Replicated data size

Hi Vasu, I'm not sure Cassandra can pro, but actually all volume of data inserted in on dc should go to other DC. You can check network traffic with any available tools. Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Sat, 10 Jun 2017 14:18:17 -0400 vasu

Re: Convert single node C* to cluster (rebalancing problem)

Did you run "nodetool cleanup" on first node after second was bootstrapped? It should clean rows not belonging to node after tokens changed. Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Wed, 31 May 2017 03:55:54 -0400 Junaid Nasir jna...@an10

Re: Amazon linux upgrade

Hi, actually each Linux with appropriate Java version (Java 8 for Cassandra 3) should be suitable (unless you would like to install with deb/rpm and not just tarball) Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Mon, 15 May 2017 14:34:56 -0400 Nitan

Re: Will query on PK read entire partition?

regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Fri, 21 Apr 2017 07:56:08 -0400 Alain RODRIGUEZ arodr...@gmail.com wrote Hi Oskar, My guess (wait for confirmation maybe): When you read from a primary key + specific clustering key or (range of clustering keys

Re: Cassandra Cluster Doubts

options a) - "establish network communication forthe entire cluster" Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Fri, 21 Apr 2017 15:42:17 -0400 Luis Miguel arb...@hotmail.com wrote Hi Michael! Thanks for your answer I feared that was

Re: Can we get username and timestamp in cqlsh_history?

Hi anuja, I don't thinks there is a way to do this without creating custom Cassandra build. There is mutations logs and somewhere on list was thread about parsing them, but I'm not sure it's what you need. Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting

Re: nodes are always out of sync

Hi, did you try to read data with consistency ALL immediately after write with consistency ONE? Does it succeed? Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Thu, 30 Mar 2017 04:22:28 -0400 Roland Otta roland.o...@willhaben.at wrote hi

Re: Weird error: InvalidQueryException: unconfigured table table2

Just wish that an error like: "Table x not found in keyspace y" You are welcome to open JIRA with type Improvement. Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Sun, 26 Mar 2017 13:31:33 -0400 S G sg.online.em...@gmail.com wrote T

Re: Altering of types is not allowed

As error message said "Altering of types is not allowed" is not allowed in Cassandra. It's NO Sql, but still not schemaless database. Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Wed, 22 Mar 2017 18:57:18 -0400 Ryan Flynn ry...@splunk.

Re: Using datastax driver, how can I read a non-primitive column as a JSON string?

Hi, why not used SELECT JSON * FROM as described here https://www.datastax.com/dev/blog/whats-new-in-cassandra-2-2-json-support ? Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Thu, 23 Mar 2017 13:08:30 -0400 S G sg.online.em...@gmail.com wrote

Re: Changed node ID?

Hi, Why did the host ID change? probably this node data folder (at least system keyspace) was erased. Or nodes changed their IP, do you use dynamic IPs? Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Mon, 06 Mar 2017 22:44:50 -0500 Joe Olson technol

Re: Limit on number of keyspaces/tables

>From source code and measurement. Try to create a lot of tables with small write to each of them and monitor Java heap. Each table takes some more then 1M. Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Sun, 05 Mar 2017 14:40:42 -0500 benjamin roth

Re: Limit on number of keyspaces/tables

Hi, there is no such hard limit, but each table consume at least 1M memory, so 1000 tables takes at least 1G. Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Sun, 05 Mar 2017 05:57:48 -0500 Lata Kannan lata.kan...@oracle.com wrote Hi I just

Re: Backups eating up disk space

Yes, you can. It's just hardlinks to tables files, so if some file is still active it will remain intact. Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Mon, 27 Feb 2017 09:27:50 -0500 Kunal Gangakhedkar kgangakhed...@gmail.com wrote Hi all

Re: Which compaction strategy when modeling a dumb set

Do you also store events in Cassandra? If yes, why not to add "processed" flag to existing table(s), and fetch non-processed events with single SELECT? Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Fri, 24 Feb 2017 06:24:09 -0500 Vincent Ri

Re: Not timing out some queries (Java driver)

What is replication factor? Why not use CONSISTENCY QUORUM? It's faster and safe enough. Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Thu, 22 Dec 2016 10:14:14 -0500 Ali Akhtar ali.rac...@gmail.com wrote Is it possible to provide these options

Re: Openstack and Cassandra

Hi Shalom, I don't see any reason why it wouldn't work, but obviously, any resource sharing affects performance. You can expect less degradation with SSD disks, I guess. Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Wed, 21 Dec 2016 13:31:22 -0500

Re: Cqlsh timeout and schema refresh exceptions

Regarding schema agreement - try to increase time between CF creation. Also stress-tool waits for schema, look on its code, probably it uses some methods to ensure schema distribution. Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Mon, 19 Dec 2016 14:35

Re: Cqlsh timeout and schema refresh exceptions

me to the this 1MB per CF thingy, it would be great. Look at http://www.mail-archive.com/user@cassandra.apache.org/msg46359.html, CASSANDRA-5935, CASSANDRA-2252 In source look at SlabAllocator.REGION_SIZE definition. Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting

Re: Cqlsh timeout and schema refresh exceptions

. Make test on one-two node cluster. Question: What is the effect of below exception? Is keyspaces created despite exception or no? Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Mon, 19 Dec 2016 10:24:20 -0500 Saumitra S saumitra.srivast...@gmail.com

Re: Cassandra: maximum size of collection list type

of data. Never insert more than 64K items in a collection. If you insert more than 64K items into a collection, only 64K of them will be queryable, resulting in data loss. Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Thu, 01 Dec 2016 12:17:23 -0500

Re: Cassandra 2.x Stability

You should also consider end of support term, as Cassandra page says: Apache Cassandra 2.2 is supported until November 2016. Apache Cassandra 2.1 is supported until November 2016 with critical fixes only So 2.1 actually don't get any fixes, even critical. Best regards, Vladimir Yudovin

Re: Java GC pauses, reality check

Hi Ahmed, obviously, 20-30 sec. pause is unacceptable. I suppose check the following: - disable swapping completely - check Java version, v8. is desirable (depending on Cassandra version) - use multiprocessor machine (it allows concurrent GC) Best regards, Vladimir Yudovin, Winguzone

Re: generate different sizes of request from single client

You can use cassandra stress-tool. It has options to set different load patterns. Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Thu, 24 Nov 2016 13:27:59 -0500Vikas Jaiman er.vikasjai...@gmail.com wrote Hi all, I want to generate two different

Re: OperationTimedOutException (NoHostAvailableException)

rpc_address: 0.0.0.0 , broadcast_address: 1.2.3.4 Did you try set rpc_address to node IP and not to 0.0.0.0 ? Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Thu, 24 Nov 2016 04:50:08 -0500Jeff Jirsa jeff.ji...@crowdstrike.com wrote Did you

Re: how to effectively drop table

Actually you shouldn't drop tables prior to dropping keyspace. Just drop keyspace with all its tables. Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Thu, 24 Nov 2016 05:38:36 -0500joseph gao gaojf.bok...@gmail.com wrote Hi，Vladimir, I have

Re: how to effectively drop table

Hi, Is DROP whole keyspace an option? Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Thu, 24 Nov 2016 03:00:40 -0500joseph gao gaojf.bok...@gmail.com wrote Hi, all I've had a very bad system design before. This caused about 1 tables

Re: Row and column level tombstones

; INSERT INTO ks.tb (id) VALUES ( 0); SELECT * FROM ks.tb ; id | str +-- 0 | null (1 rows) Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Wed, 23 Nov 2016 11:59:51 -0500Andrew Cooper andrew.coo...@nisc.coop wrote What would

RE: Cassandra Config as per server hardware for heavy write

Try to build cluster with .withPoolingOptions Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Wed, 23 Nov 2016 05:57:58 -0500Abhishek Kumar Maheshwari abhishek.maheshw...@timesinternet.in wrote Yes, i also try with async mode but I got max speed

RE: Cassandra Config as per server hardware for heavy write

session.execute is coming from Session session = cluster.connect(); I guess? So actually all threads work with the same TCP connection. It's worth to try async API with Connection Pool. Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Wed, 23 Nov 2016 04

RE: Cassandra Config as per server hardware for heavy write

connection pool (with TokenAwarePolicy each) and then pass each item to separate thread. Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Wed, 23 Nov 2016 04:23:13 -0500Abhishek Kumar Maheshwari abhishek.maheshw...@timesinternet.in wrote Hi Siddharth

RE: Cassandra Config as per server hardware for heavy write

So do you see speed write saturation at this number of thread? Does doubling to 200 bring increase? Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting, Zero production time On Wed, 23 Nov 2016 03:31:32 -0500Abhishek Kumar Maheshwari abhishek.maheshw

RE: Cassandra Config as per server hardware for heavy write

I have 1Cr records in my Java ArrayList and yes I am writing in sync mode. Is your Java program single threaded? Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting, Zero production time On Wed, 23 Nov 2016 03:09:29 -0500Abhishek Kumar Maheshwari abhishek.maheshw

Re: How to Choose a Version for Upgrade

Hi Shalom, there are a lot of discussion on this topic, but it seems that for know we can call 3.0.xx line as most stable. If you don't need specific feature from 3.x line take 3.0.10. Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Wed, 23 Nov 2016 03

Re: single instance failover

this situation, may be with some sort of file locking. multinode Cassandra for Node B is not free Sure, but besides higher reliability you also get increase in read queries speed (with consistency ONE). Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting, Zero production time

Re: single instance failover

. Is there any guidance on single instance failover? I never saw one, the main Casandra idea that you build multinode cluster. Any specific reason why can't you use two nodes as single cluster? Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting, zero production time

RE: cassandra documentation (Multiple datacenter write requests) question

Is Apache Cassandra community can update this documentation ? I don't think so, it's hosted on DataStax website and it's not public Wiki. Anyway you know what is right quorum calculation formula is ))). Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your

Re: Cassandra Encryption

if I use the same certificate how does it helps? This certificate will be recognized by all existing nodes, and no restart will be needed. Or, as Nate suggested, you can use trusted root certificate to issue nodes' certificates. Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud

Re: Cassandra Encryption

Hi Jai, so do you generate separate certificate for each node? Why not use one certificate for all nodes? Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Mon, 21 Nov 2016 17:25:11 -0500Jai Bheemsen Rao Dhanwada jaibheem

Re: NoHostAvailableException

Hi, as I mentioned about rpc_address: 0.0.0.0 YAML says it is allowed to specify 0.0.0.0 ... but that will break clients that rely on node auto-discovery. Try set rpc_address: external_ip Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes

Re: NoHostAvailableException

to listen for clients on rpc_port: 9160 So probably rpc_address: 0.0.0.0 is a problem. Also do you have native port 9042 open in firewall (if there is one). Can you connect to cluster with cqlsh? Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster

Re: NoHostAvailableException

Not broadcast_address, but broadcast_rpc_address (you gave this example:rpc_address: 0.0.0.0 , broadcast_rpc_address: 1.2.3.4) Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Mon, 21 Nov 2016 08:14:38 -0500techpyaasa

Re: Out of memory and/or OOM kill on a cluster

Did you try any value in the range 8-20 (e.g. 60-70% of physical memory). Also how many tables do you have across all keyspaces? Each table can consume minimum 1M of Java heap. Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes

Re: NoHostAvailableException

Try to set broadcast_rpc_address on each node to its real external IP address. Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Mon, 21 Nov 2016 05:47:00 -0500techpyaasa . techpya...@gmail.com wrote Following exception

Re: data not replicated on new node

try SELECT for some undoubtedly old data with consistency ALL It's worth to turn trace on for this query. Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Mon, 21 Nov 2016 02:05:35 -0500Vladimir Yudovin vla...@winguzone.com

Re: data not replicated on new node

with data, then added third. When did you change replication factor for existing keyspace? Or it was created with factor three? Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Mon, 21 Nov 2016 01:28:54 -0500Shalom Sagges shal...@live

Re: Is Centos 7 Supported for Version 3.0

Hi, Centos 7 has Java 8 available, so there shouldn't be any problem to run Casandra. Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Sun, 20 Nov 2016 11:14:07 -0500Shalom Sagges shal...@liveperson.com wrote Hi Guys

Re: [RELEASE] Apache Cassandra 3.0.10 released

My question was about a different option named "offheap_objects". Sorry. Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Thu, 17 Nov 2016 07:56:10 -0500Oleksandr Shulgin oleksandr.shul...@zalando.de wrote O

Re: [RELEASE] Apache Cassandra 3.0.10 released

release, see https://issues.apache.org/jira/browse/CASSANDRA-9472 for details on Cassandra start. Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Thu, 17 Nov 2016 06:02:15 -0500Oleksandr Shulgin oleksandr.shul...@zalando.de

Re: Some questions to updating and tombstone

Hi Boying, UPDATE write new value with new time stamp. Old value is not tombstone, but remains until compaction. gc_grace_period is not related to this. Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Mon, 14 Nov 2016 03:02

Re: Consistency when adding data to collections concurrently?

, adding an element at a particular position results in greater latency than appending or prefixing an element to a list. Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Sat, 12 Nov 2016 07:57:36 -0500Ali Akhtar ali.rac...@gmail.com

Re: Consistency when adding data to collections concurrently?

, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Sat, 12 Nov 2016 05:34:24 -0500Ali Akhtar ali.rac...@gmail.com wrote I have a table where each record contains a liststring of labels. I have an endpoint which responds to new labels

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

) are caused by memory flushes? Shalom Sagges DBA T: +972-74-700-4035 We Create Meaningful Connections On Thu, Nov 10, 2016 at 11:02 AM, Vladimir Yudovin vla...@winguzone.com wrote: This message may contain confidential and/or privileged information

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

Hi Shalom, so not sure, but probably excessive memory consumption by this SELECT causes C* to flush tables to free memory. Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Thu, 10 Nov 2016 03:36:59 -0500Shalom Sagges shal

Re: 答复: 答复: A difficult data model with C*

Do you mean the oldest one should be removed when a new play is added? Sure. As you described the issue "the last ten items may be adequate for the business" Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Wed, 09 N

Re: Log traces of debug logs

Hi, you can change log level with nodetool setlogginglevel command Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Wed, 09 Nov 2016 10:17:37 -0500Benjamin Roth benjamin.r...@jaumo.com wrote Hi! Is there a way

Re: Having Counters in a Collection, like a map<int, counter>?

s it will be changed, if not - created set to initial value. Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Wed, 09 Nov 2016 07:52:29 -0500Ali Akhtar ali.rac...@gmail.com wrote The only issue with the last 2 soluti

Re: Having Counters in a Collection, like a map<int, counter>?

ire creating 1 table per type of mapint, counter that i need? But you don't need to create separate table per each counter, just use one row per counter: CREATE TABLE cnt (id int PRIMARY KEY , value counter); Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch you

Re: 答复: A difficult data model with C*

(user_name text PRIMARY KEY, play_list LISTfrozenplay); You can easily retrieve play list for specific user by his ID. Instead of LIST you can use MAP, I don't think that for ten entries it matters. Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster

Re: A difficult data model with C*

entry: UPDATE recent SET review = review - [(1234,12345)] WHERE user_name='some user' AND video_id='great video'; Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Mon, 07 Nov 2016 21:54:08 -0500ben ben diamond@outlook.com

Re: Improving performance where a lot of updates and deletes are required?

Yes, as doc says "Expired data is marked with a tombstone" but you save communication with host and processing of DELETE operator. Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Tue, 08 Nov 2016 09:32:16 -0500

Re: Designing a table in cassandra

own table for each device can be quite heavy solution. Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Sun, 06 Nov 2016 19:23:20 -0500sat sathish.al...@gmail.com wrote Hi, We are new to Cassandra. For our POC, we

Re: Improving performance where a lot of updates and deletes are required?

The deletes will be done at a scheduled time, probably at the end of the day, each day. Probably you can use TTL? http://docs.datastax.com/en/cql/3.1/cql/cql_using/use_expire_c.html Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes

Re: store individual inventory items in a table, how to assign them correctly

Hi, can you elaborate a little your data model? Would you like to create 100 rows for each product and then remove one row and add this row to customer? Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Mon, 07 Nov 2016 14:51

Re: operation and maintenance tools

For memory usage you can use small command line tool https://github.com/patric-r/jvmtop Also there are number of GUI tools that connect to JMX port, like jvisualvm Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Mon, 07 Nov

Re: Cassandra on Cloud platforms experience

locations) with relative low latency 1-1.5 ms. or purchase another VLAN in different pod for $25 per month in the same DC. We provide Cassandra cluster on all provider in many worldwide locations. Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes

Re: failing bootstraps with OOM

Hi, probably you can try to start new node with auto_bootstrap: false and then repair keypaces or even tables one by one with nodetool repair Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Wed, 02 Nov 2016 10:35:45

Re: commit log on NFS volume

Hi, it's not only performance issue. In case of network problem writer tread can be blocked, also in case of failure loss of data can occur. Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Tue, 01 Nov 2016 14:10:10 -0400John

Re: Specifying multiple conditions for lightweight conditions?

= '2013-01-01 00:00:00+0200' WHERE id = '1' IF last_due_at '2013-01-01 00:00:00+0200' Sure, it's less effective then OR condition. Probably you can use IF NOT EXISTS in first request (depending on your application logic), may be it will be slightly faster (not sure). Best regards, Vladimir

Re: Securing a Cassandra 2.2.6 Cluster

, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Sun, 30 Oct 2016 15:37:50 -0400Raimund Klein chessra...@gmail.com wrote Hi guys, Thank you for your responses. Let me try to address them: I just tried cqlsh directly with the IP, no change

Re: Securing a Cassandra 2.2.6 Cluster

Both nodes can be seeds. Probably I misunderstood Raimund as setting each node as the only seed. If he set both IP on both nodes it's OK. Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Sun, 30 Oct 2016 14:48:00 -0400Jonathan

Re: Securing a Cassandra 2.2.6 Cluster

sh refuses to connect Can you please give output of nodetool status and netstat -lptn | grep java Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Sun, 30 Oct 2016 14:11:55 -0400Raimund Klein chessra...@gmail.com wrote H

Re: how to get the size of the particular partition key belonging to an sstable ??

Hi, size of a particular partition key Can you please elucidate this? Key can be just number, or string, or several values. Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Thu, 27 Oct 2016 11:45:47 -0400Pranay akula

Re: Re : Generic keystore when enabling SSL

either add nodes certificate to their truststore or disable validation (each Cassandra driver does this in its own way). Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Thu, 27 Oct 2016 16:45:48 -0400Jacob Shadix jacobsha...@gmail.com

Re: High Usage of Survivor Space

Hi, did this high memory usage caused the problems? OOM crashes, GC pauses? Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Wed, 26 Oct 2016 21:51:26 -0400Daniel Kleviansky dan...@kleviansky.com wrote Before anyone

Re: Error creating pool to /IP_ADDRESS33:9042 (Proving Cassandra's NO SINGLE point of failure)

Probably used Python driver can't restart failed operation with connection to other node. Do you provide all three IPs to Python driver for connecting? Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Mon, 24 Oct 2016 07:48:05

Re: time series data model

(or opposite, heading.speed) and save column storage overhead. Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Thu, 20 Oct 2016 03:29:16 -0400wxn...@zjqunshuo.com wrote Hi All, I'm trying to migrate my time series data

Re: How to insert "Empty" timeuuid by Cql

Hi, what does it exactly mean 'empty timeuuid'? UUID takes 16 bytes for storage, so it should be either null, or some value. Do you mean 'zero' UUID? Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Wed, 19 Oct 2016 09:16:29

Re: quick question

com/dev/blog/dynamic-snitching-in-cassandra-past-present-and-future Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra Launch your cluster in minutes. On Wed, 19 Oct 2016 06:14:27 -0400Kant Kodali k...@peernova.com wrote can Cassandra cluster direct or load bal

Re: Adding disk capacity to a running node

pulled from under our feet without warning. Yes, in case of planned event. But in case of some hardware failure it can happen. And it shouldn't be some catastrophe affecting the whole availability zone. Just failure of singe blade. Best regards, Vladimir Yudovin, Winguzone - Hosted

Re: Adding disk capacity to a running node

But after such restart node should be joined to cluster again and restore data, right? Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra on Azure and SoftLayer. Launch your cluster in minutes. On Mon, 17 Oct 2016 14:55:49 -0400Jonathan Haddad j...@jonhaddad.com

Re: Adding disk capacity to a running node

It's extremely unreliable to use ephemeral (local) disks. Even if you don't stop instance by yourself, it can be restarted on different server in case of some hardware failure or AWS initiated update. So all node data will be lost. Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud

Re: Cassandra installation best practices

Hi, you can take a look on http://docs.datastax.com/en/landing_page/doc/landing_page/recommendedSettingsLinux.html Regarding file system type I guess ext4 is good enough. (Though RedHat now use XFS as default FS). Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra

Re: Adding disk capacity to a running node

Yes, Cassandra should keep percent of disk usage equal for all disk. Compaction process and SSTable flushes will use new disk to distribute both new and existing data. Best regards, Vladimir Yudovin, Winguzone - Hosted Cloud Cassandra on Azure and SoftLayer. Launch your cluster in minutes

  1   2   >