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 t

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 techp

SASI index returns no results

or some error message, but not to silently return 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 . wrote Hi Varun, Thanks a lot for your reply. In this case if I want to update status(st

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

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 A

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

strange, may 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 exp

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

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

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 My

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

Re: Decommissioned nodes show as DOWN in Cassandra version 3.10

te.html 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 decommiss

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.

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

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...@an

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 clusterin

Re: Cassandra Cluster Doubts

Michael's 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 yo

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 Hostin

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

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

Re: Weird error: InvalidQueryException: unconfigured table table2

>Wish the error message a little more helpful. Actually "unconfigured" means "not existed", "not created". Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Fri, 24 Mar 2017 21:39:45 -0400 S G <sg.online.em...@gmail.com&g

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...@

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>

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

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

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

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 Ris

Re: Reminder: don't listen on public addresses

I would add: use SSL and internode certificate authentication (password for CQL goes withou saying, of course). Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Fri, 20 Jan 2017 14:14:56 -0500 Richard L. Burton III <mrbur...@gmail.com> wrote

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 th

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

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

f you can also point 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 Cas

Re: Cqlsh timeout and schema refresh exceptions

usage. 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...@g

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 Yu

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

>doesn't has any option for mixed request size As a workaround you can run two parallel tests with its own size each. Best regards, Vladimir Yudovin, Winguzone - Cloud Cassandra Hosting On Thu, 24 Nov 2016 16:54:08 -0500 Vikas Jaiman <er.vikasjai...@gmail.com> wro

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 genera

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

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,

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

Re: Row and column level tombstones

q'); DELETE from ks.tb WHERE id =0; 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

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

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 20

RE: Cassandra Config as per server hardware for heavy write

o create 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

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.mahe

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

Re: single instance failover

so prevent 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, Ze

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

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 Cassan

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

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

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 in

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. On

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 exc

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...@wi

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

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

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

Re: [RELEASE] Apache Cassandra 3.0.10 released

ced in a future 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...

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?

ent. Consequently, 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 -0500Al

Re: Consistency when adding data to collections concurrently?

rds, 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 list<string> of labels. I have an endpoint which

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

2 nodes DC) 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

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

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, 0

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

Re: Having Counters in a Collection, like a map?

5 exists 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

Re: Having Counters in a Collection, like a map?

s in c* which doesn't require creating 1 table per type of map<int, 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, W

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

E recent (user_name text PRIMARY KEY, play_list LIST<frozen<play>>); 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 Cassand

Re: A difficult data model with C*

x27;some user' AND video_id='great video'; or by value, if you know the oldest 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 C

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

ating 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

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 minu

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

e same region (some 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

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

Re: Specifying multiple conditions for lightweight conditions?

E project SET last_due_at = '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 w

Re: Securing a Cassandra 2.2.6 Cluster

gards, 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

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

Re: Securing a Cassandra 2.2.6 Cluster

sees both of them cqlsh 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...

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 ak

Re: Re : Generic keystore when enabling SSL

nts should 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

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

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:

Re: time series data model

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 -0400<wxn...@zjqunshuo.com> wrote Hi All, I'm trying to migrate my time

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,

Re: quick question

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

Re: Adding disk capacity to a running node

;ve never had an instance 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,

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.

  1   2   >